Example 4 (SAP Library - CRM Integration Services)

Example 4

Aim

To fill the segment field "SFAKNA1" of the segment mapped to the table "SMOIHPA" for the BDoc type "". The source table from which the field will be filled is "SMOKNA1" and the source field in that table is "SFAKNA1". The R/3 (or CRM) Key fields of the table "SMOVBAK" are "KUNNR" and "SOURCE". This field will be used to filter the table to get to the appropriate value. This field is to be fetched only when the destination segment mapped to the table "SMOIHPA" (DEST_TABLE)’s field "TPLNR" has the value equal to "CAP" or "CON" when the source table "SMOKNA1" ‘s field "SOURCE" has the value "CAP" or "CON", respectively.

Note that DEST_TABLE "SMOIPHA" is the table mapped to the child segment and that SRC_TABLE "SMOKNA1" is the table mapped to the parent segment of DEST_TABLE ’s segment. Hence, the table mapped to child segment "SMOIHPA" does not contain "SOURCE" field or any corresponding field.

Table 1

Field Name	Field Value
SRNO	1
TRANS ID	D5D73401C5E711D2AD3D00105AC69204
DEST TABLE	SMOIHPA
DEST FIELD	SFAKNA1
SRC TABLE	SMOKNA1
SRC FIELD	SFAKNA1
CONC PFLDS	KUNNR
CONC PDEST	PARNR
FETCHOPT	A
DEST COND	TPLNR = 'CAP'
SRC COND	SOURCE = 'CAP'
INACTIVE

Table 2

Field Name	Field Value
SRNO	2
TRANS ID	D5D73401C5E711D2AD3D00105AC69204
DEST TABLE	SMOIHPA
DEST FIELD	SFAKNA1
SRC TABLE	SMOKNA1
SRC FIELD	SFAKNA1
CONC PFLDS	KUNNR
CONC PDEST	PARNR
FETCHOPT	A
DEST COND	TPLNR = 'CON'
SRC COND	SOURCE = 'CON'
INACTIVE

Features of the above entries

Entry 1 has SR_NO ‘1’ and entry 2 has SR_NO ‘2’. Hence, the entry 1 will be processed before entry 2. This implies that DEST_FIELD "SMOKNA1" of entry 1 will be filled before DEST_FIELD "SMOKNA1" of entry 2.

SRC_COND of entry 1 "SOURCE = ‘CAP’", effectively means that only those CDB entries the SRC_FIELD – "SOURCE" in the SRC_TABLE - "SMOKNA1" with value "CAP" will be selected. DEST_COND of entry 1 "TPLNR = ‘CAP’", effectively means that rows of segment data with the segment field mapped to TPLNR with segment field value ‘CAP’ will only be filled.

SRC_COND of entry 2 "SOURCE = ‘CON’", effectively means that only those CDB entries with the SRC_FIELD – "SOURCE" in the SRC_TABLE - "SMOKNA1" with value "CON" will be selected. DEST_COND of entry 2 "TPLNR = ‘CON’", effectively means that rows of segment data with the segment field mapped to TPLNR with segment field value ‘CON’ will only be filled.

In this case, the R/3 (or CRM) keys of SRC_TABLE - "SMOKNA1" are "KUNNR" and "SOURCE" and the corresponding fields of DEST_TABLE - "SMOIHPA" are "TPLNR" and "SOURCE".

Note that, here, DEST_COND is given, and it is required for search in key table. This is a case of fetching child MSA keys in the parent segment. Note that, the DEST_TABLE - "SMOIHPA" (table mapped to parent segment) does not have one R/3 (or CRM) key of SRC_TABLE – "SMOKNA1", namely "SOURCE". Hence, SRC_COND has an R/3(or CRM) key "SOURCE" and its filter value "CAP" and both CONC_PFLDS and CONC_PDEST do not have "SOURCE" included as an R/3 (or CRM) Key.