[SAP EAI] SAP PI Main Table Info

SAP PI Tables 또는 SAP XI 테이블에는 SAP Process Integration에서 고려해야 할 가장 중요한 테이블입니다.

 

SAP PI (ABAP) schema Tables

 - ABAP Stack의 SAP PI Message Table 입니다.

 - SAP PI 테이블은 일반적으로 SX* 또는 SW*로 시작한합니다.

 

SAP PI ABAP 스키마 데이터베이스 트랜잭션 코드의 기본 목록은 다음과 같습니다.

Table Name	Info
SXMSPMASTXI	Messages – Master
SXMSPHIST	XI Messages – Master History table
SXMSPEMAS	Integration Engine: Enhanced Message Queue (Master)
SXMSPFADDRESS	Addresses Master
SXMSPVERS	Integration Engine: Message Version
SXMSPERROR	XML Message Broker: Message Queue (Incorrect Entries)
SXMSCLUP	Cluster – Compressed Message Payload Property
SXMSCLUR	Cluster – Compressed Message Payload Resource (attachments)

SAP PI Mapping 관련 Table

“In a message mapping, you assign a source and a target message type (according to the source and target operation of the operation mapping the message mapping is assigned to).

 

Using a graphical editor, you can define the mapping between the source and target message type.”

참조: help.sap.com/viewer/bbd7c67c5eb14835843976b790024ec6/7.31.25/en-US/126000fa78414534816e251ca53a1702.html

 

SAP PI의 주요 Message Mapping 관련 테이블의 목록은 다음과 같습니다.

Table Name	Info
SMPPMAP3	Mapping Runtime: Mapping
SMPPREL3	Mapping Runtime: Mapping Relation
SMPPSPLIT	XI Mapping: Merge and Split

SAP PI Performance를 위한 Table

 - SAP PI 성능을 모니터링하기 위해 모든 통합 엔진 헤더 및 데이터는 ABAP Stack의 아래와 같은 PI Table에 저장됩니다.

Table Name	Info
SXMSPFRAWH	Integration Engine – Header Table for Raw Data for Performance Evaluation
SXMSPFRAWD	Integration Engine: Data Table for Raw Data for Performance

참조: help.sap.com/SAPHELP_NWPI71/helpdata/en/9e/6921e784677d4591053564a8b95e7d/content.htm?no_cache=true

SAP PI : ccBPM / BPE tables

- ccBPM은 Cross-Component Business Process Management의 약자입니다.

 

“Cross-component Business Process Management (ccBPM) contains functions for enhanced service orchestration that are based on integration processes.

An integration process is composed of a specific flow of steps – including the sending and receiving of messages – during which the status of the process is persisted on the Integration Server.” 

참조: help.sap.com/saphelp_nw73/helpdata/en/a5/c38ddac2374cb5ae3d56478a1d4a7b/content.htm?no_cache=true

- BPE는 Business Process Engine의 약자입니다.

 

“The Business Process Engine (BPE) processes integration processes at runtime. Since the BPE uses functions of the Workflow Engine and generates workflows from integration processes at runtime, you must customize the Workflow Engine automatically by using transaction SWF_XI_CUSTOMIZING before you can use the BPE.”

참조: help.sap.com/saphelp_nwpi71/helpdata/en/2d/da3142680d5c33e10000000a155106/content.htm?no_cache=true

 

SAP Process Integration의 ccBPM 및 BPE에 대한 기본 테이블 목록입니다.

Table Name	Info
SWFRXIHDRXI	Adapter: Header Data for a Message Object
SWFRXICNT	XI Adapter: XML Container for a Message Object
SWFRXIPRC	XI-Adapter: Process-Dependent Message Data

SAP PI 용 IDoc Table

- SAP PI의 모든 IDoc 어댑터 승인은 다음 테이블에서 관리됩니다.

Table Name	Info
IDXNOALE	suppress IDoc Adapter acknowledgments

 - SAP PI의 Idoc Adapter Acknowledgment에 대한 정보입니다.

 1) Configuring Acknowledgments for a Receiver IDoc Adapter (AAE)

참조: help.sap.com/saphelp_nw73/helpdata/en/4c/c1717b38b2413e82e79a1c638eb72f/content.htm?no_cache=true

 2) Configuring Acknowledgments for a Sender IDoc Adapter (AAE)

참조: help.sap.com/saphelp_nw73/helpdata/en/bc/0341dd385945d49eb809c084cf3dea/content.htm?no_cache=true

SAP PI Alert Framework Tables

- SAP PI의 Alert Framework 사용하는 테이블 목록입니다.

Table Name	Info
SXMSALERTLOGGER	XI alerts log
SXMSALERTRULES	XI alerts rules

SAP NetWeaver PI / PO에 대한 추가 자료

- SAP Process Integration: 이전 버전은 XI로 불리웠고, 그 이후 버전은 Process Orchestration의 약자인 PO로 불리고 있다.

 

- www.amazon.com/SAP-Certified-Development-Associate-Integration/dp/1512221503/ref=as_li_bk_tl/%20tag=sab12500-20&linkId=58fb90031702c7f71ed7b74492aa83f8&linkCode=ktl
SAP Process Orchestration: The Comprehensive Guide (First Edition) (SAP PRESS)
- www.amazon.com/SAP-Process-Orchestration-Generation-Integration/dp/1493210181/ref=as_li_bk_tl/%20tag=sab12500-20&linkId=5268693ce90c5f93dd0ee519456935a7&linkCode=ktl
Mastering IDoc Business Scenarios with SAP NetWeaver PI
- www.amazon.com/Mastering-IDoc-Business-Scenarios-NetWeaver/dp/1592292887/ref=as_li_ss_tl?ie=UTF8&qid=1481645063&sr=8-8&keywords=SAP+PI&linkCode=sl1&tag=sap4tech-20&linkId=4d7db2f9198e798d0486bf20beef36fb
Practical Guide to SAP NetWeaver PI - Development (English) 2번째 에디션
- www.amazon.com/Practical-Guide-SAP-NetWeaver-Development/dp/1592293344/ref=as_li_ss_tl?ie=UTF8&qid=1481645103&sr=8-1&keywords=SAP+netweaver+PI&linkCode=sl1&tag=sap4tech-20&linkId=202a4c778615d7dff196f2528340ac53

SAP XI 테이블 목록
- wiki.scn.sap.com/wiki/display/XI/XI+Tables?original_fqdn=wiki.sdn.sap.com

참조: sap4tech.net/sap-pi-tables/

SAP PI Tables (Process Integration Tables) - SAP XI Tables