SD Enterprise Structure
One Company can have multipleĀ Company Code. One Company Code assigned to only one Company. The relationship between Company and Company Code is One-to-Many. One Company Code can have multiple Sales Organization. One Sales Organization assigned to only one Company
JDBC Adapter – SourceDB Send Table to XML format and Receive to TargetDB
The objective is to transfer table SINGER from SOURCE_DB to XML row, XML SQL, then to TARGET_DB, using SAP PI JDBC sender and receiver adapter. The JDBC driver is SQLite that deployed in previous post. STEP 1: From “SOURCE_DB” to
JDBC Adapter – Deploy SQLite JDBC Drivers in PI 7.31 using JSPM
Steps I went through, the PI server is dual-stack PI 7.31: 1) Check what JDBC drivers installed. 1a) Check path “\usr\sap\<SID>\DVEBMGS00\j2ee\cluster\bin\ext\com.sap.aii.adapter.lib\lib”, found default “com.sap.aii.adapter.lib_api.jar” only. 2) Download JDBC drivers. I’m using sqlite JDBC driver, from https://bitbucket.org/xerial/sqlite-jdbc/downloads. The latest available driver
Table Relationship among NAST, CMFP, EDIDS and ARFSSTATE(SM58)
Explain it graphically, useful to mass find idoc number from document number or output records: Keep on posting š
Convert Two Flat Recordset to One Nested Recordset Using createMultipleContextCopies
The objective is to convert 2 different recordsets(SINGER and SONG) under same message, to single nested recordset (SONG nested under SINGER). The message type: The mapping: For node SINGER, SINGERID and FULLNAME, is direct one-to-one mapping. For node SONG and
File Adapter – Sender – Convert Multiple Fixed Length Structure to XML Using Key Field Name
This example convert 2 different recordsets inside single file to xml. First recordset is “SINGER”, second recordset is “SONG”. First column is 1 character length. It is a key column to identify different recordset. “A” from first half mean SINGER,
File Adapter – Sender – Convert Single Fixed Length Structure to XML
Previous example tested the CSV file with delimiter, now look at fixed-length file. The objective is to convert fixed-length file to xml representation. ABB, FULLNAME, GENDER and COUNTRY, each is with length 5,20,7,10 respectively. Example: The target message type
File Adapter – Sender – Content Conversion to Convert CSV file to XML
The objective is to convert csv file to xml representation. Example: The target message type is 2 columns that repeatable at node row. Document Name is the target message type. Document Namespace should be the namespace of the message type.
UDFNodePool – contextHasOneOfSuchValues
contextHasOneOfSuchValues will produces a single “true” if the first argument (a context queue) contains one of the values passed as a constant in the second argument (separated by a semicolon); otherwise “false”. Source message type and target message type: Source