This
document contains the following tables: |
|
|
|
|
|
|
|
|
|
|
Header (Siebel to SAP) |
|
|
|
Credit Card (Siebel to SAP) |
|
|
|
Lines (Siebel to SAP) |
|
|
|
Pricing Conditions (Siebel to
SAP) |
|
|
|
Schedule Line Item (Siebel to
SAP) |
|
|
|
Header (Updates from SAP
to Siebel) |
|
|
|
|
|
Entity |
Value |
Comments |
|
|
Integration
Objects: |
SAP 46C Order |
Used for Query function
in siebel Adapter |
|
|
Order - Create SAP
46C Order (BAPI Input) |
|
|
|
Order - Create SAP
46C Order (BAPI Output) |
|
|
|
Transaction
Description: |
Creates SAP Order from Siebel Order |
|
|
Workflow: |
Order - Create SAP 46C Order |
|
|
|
Business Service
(Name): |
Order - SAP 46C Maps |
As shown in Tools |
|
|
Business Service
(Display Name): |
Order - SAP 46C Maps |
As shown in Client |
|
|
Map
Function(s): |
CreateSAP46COrder_SiebelToBAPI |
This map in turn calls
CreateSimulateSAP4xOrder_SiebelToBAPI which is common for both Create and
Simulate functions |
CreateSAP46COrder_BAPIToSiebel |
|
|
SAP Interface: |
BAPI_SALESORDER_CREATEFROMDAT2 |
|
|
Siebel View: |
Orders | Sales Orders | Line Items(SAP) |
|
|
SAP Screen: |
Logistics | Sales/distribution | Sales | Order |
Display (VA01/02/03) |
|
|
|
|
|
|
|
Header (Siebel to SAP) |
|
|
Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP BAPI |
|
SAP User Interface |
|
Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/
Lookup |
Screen |
Field |
Comments |
N/A |
N/A |
N/A |
N/A |
N/A |
N/A |
ORDER_HEADER_IN |
DOC_NUMBER |
|
Overview |
Sales |
Standard Order |
Sales Document |
Order Entry - SAP 4x order Form Applet |
Order
# |
Order
Entry - Orders |
Integration
Id |
S_ORDER |
INTEGRATION_ID |
ORDER_HEADER_IN |
DOC_NUMBER |
Raise
EAI Error if Integration Id == "" or NULL |
|
|
This
validation already exists in 7.0.X mappings. Please use same validation logic
and code. |
Order Entry - Order Form Applet (Sales) |
*Order
Type |
Order
Entry - Orders |
Order
Type |
S_ORDER.ORDER_TYPE_ID
--> S_ORDER_TYPE |
NAME |
ORDER_HEADER_IN |
DOC_TYPE |
This
is defined in the Integration Administration | EAI Value Maps view under "SAP DOC Types". |
Header
| Sales |
Order
type |
As
an example, the default mapping specifies Siebel Sales Orders are created as
standard orders ("TA" order types) in SAP. Siebel LOVs may be
extended as necessary. Only Siebel Sales Orders to SAP Standard orders are
supported in the standard product. |
|
|
Order
Entry - Orders |
Currency
Code |
|
|
ORDER_HEADER_IN |
CURRENCY |
This
is defined in the Integration Administration | EAI Value Maps view under "SAP Currency Code". |
Overview
| Sales |
Net
Value/Currency |
Document
Currency for SAP |
Part of Organization SAP Sales Area View |
Part
of "Sales Area" |
Order
Entry - Orders |
SAP
Sales Organization (MO) |
S_ORDER.ACCNT_ID
-> S_ORG_EXT.BU_ID --> S_ORG_EXT |
SALES_ORG_CD |
ORDER_HEADER_IN |
SALES_ORG |
|
Overview
| Sales |
Sales
org. |
SAP
sales areas (combinations of Sales Organizations, Distribution Channels and
Divisions are declared in the Integration Administration | SAP Administration
I Organization SAP Sales Area view. |
Part of Organization SAP Sales Area View |
Part
of "Sales Area" |
Order
Entry - Orders |
SAP
Distribution Channel (MO) |
S_ORDER.ACCNT_ID
-> S_ORG_EXT.BU_ID --> S_ORG_EXT |
DIST_CHANNEL_CD |
ORDER_HEADER_IN |
DISTR_CHAN |
|
Overview
| Sales |
Distr.
Chl |
SAP
sales areas (combinations of Sales Organizations, Distribution Channels and
Divisions are declared in the Integration Administration | SAP Administration
I Organization SAP Sales Area view. |
Part of Organization SAP Sales Area View |
Part
of "Sales Area" |
Order
Entry - Orders |
SAP
Division (MO) |
S_ORDER.ACCNT_ID
-> S_ORG_EXT |
DIVN_CD |
ORDER_HEADER_IN |
DIVISION |
|
Overview
| Sales |
Division |
SAP
sales areas (combinations of Sales Organizations, Distribution Channels and
Divisions are declared in the Integration Administration | SAP Administration
I Organization SAP Sales Area view. |
Order Entry - Order Form Applet (Sales) |
Requested
Date |
Order
Entry - Orders |
Requested
Ship Date |
S_ORDER |
REQ_SHIP_DT |
ORDER_HEADER_IN |
REQ_DATE_H |
|
Overview
| Sales |
Req.deliv
date |
If
the Requested Ship Date is null, then Siebel Order Date goes into the SAP
field. |
|
|
N/A |
'1' |
N/A |
N/A |
ORDER_HEADER_IN |
DATE_TYPE |
|
N/A |
N/A |
|
Order Entry - SAP 4x order Form Applet |
Company Order # |
Order Entry -
Orders |
Account
Order Number |
S_ORDER |
ACCNT_ORDER_NUM |
ORDER_HEADER_IN |
PURCH_NO |
|
Overview
| Sales |
Purch.order
no |
If
the Account Number is equal to NULL, then this field is set to Order Number
on the Siebel side. |
Order Entry - SAP 4x order Form Applet |
Pricing Date: |
Order
Entry - Orders |
Pricing
Date |
S_ORDER |
PRICING_DT |
ORDER_HEADER_IN |
PRICE_DATE |
|
Overview
| Sales |
Pricing
Date |
|
Order Entry - Order List Applet (Sales) |
Order
Date |
Order
Entry - Orders |
Order
Date |
S_ORDER |
ORDER_DT |
ORDER_HEADER_IN |
PURCH_DATE |
|
Overview
| Sales |
Purchase
Order Date |
|
Order Entry - Order List Applet (Sales) |
*Order
# |
Order
Entry - Orders |
Order
Number |
S_ORDER |
ORDER_NUM |
ORDER_HEADER_IN |
REF_1 |
|
Header
| Purchase Order Data |
Your
reference |
|
Order Entry - Order Form Applet (Sales) |
Contact Last Name |
Order Entry -
Orders |
Contact
First Name||Contact Last Name |
S_ORDER.CON_ID
-> S_CONTACT |
FST_NAME
|| LAST_NAME |
ORDER_HEADER_IN |
NAME |
|
Header
| Purchase Order Data |
Name |
This
value is mapped only if the Contact Id is not NULL. |
|
|
Order
Entry - Orders |
Contact
Work Phone # |
S_ORDER.CON_ID
-> S_CONTACT |
WORK_PH_NUM |
ORDER_HEADER_IN |
TELEPHONE |
|
Header
| Purchase Order Data |
Telephone |
|
|
|
Order
Entry - Orders |
Freight
Terms |
S_ORDER |
FRGHT_TERM_CD |
ORDER_HEADER_IN |
INCOTERMS1 |
This
is defined in the Integration Administration | EAI Value Maps view under "SAP Incoterms". |
Header
| Billing Data |
Incoterms |
As
an example, the default mapping specifies that freight term = "Free of
Charge" in Siebel maps to freight term = "FCA"in SAP. Siebel
LOVs may be extended as necessary. |
|
|
Order
Entry - Orders |
Freight
Terms Info |
S_ORDER |
FRGHT_TERMS_INFO |
ORDER_HEADER_IN |
INCOTERMS2 |
|
Header
| Billing Data |
Incoterms |
|
|
|
Order
Entry - Orders |
Payment
Term |
S_ORDER.PAYMENT_TERM_ID
-> S_PAYMENT_TERM |
NAME |
ORDER_HEADER_IN |
PMNTTRMS |
This
is defined in the Integration Administration | EAI Value Maps view under "SAP Payment Terms". |
Header
| Billing Data |
Payment
terms |
These
are typically one to one mappings. Siebel LOVs may be extended to match SAP
Payment terms for a specific SAP implementation. |
Order Entry - SAP 4x order Form Applet |
Partial
Ship |
Order
Entry - Orders |
Partial
Ship |
S_ORDER |
ALW_PART_SHIP_FLG |
ORDER_HEADER_IN |
COMPL_DLV |
|
Header
| Shipping |
Complete
Delivery |
If
Partial Ship in Siebel is <> 'Y', then put 'X' in the SAP field.
Otherwise leave it NULL. |
|
|
Partners (Siebel to SAP) |
|
|
|
|
|
|
|
|
|
|
|
|
Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP BAPI |
|
SAP User Interface |
|
Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/
Lookup |
Screen |
Field |
Comments |
N/A |
N/A |
N/A |
'AG' |
N/A |
'AG' |
ORDER_PARTNERS |
PARTN_ROLE |
|
Header |
Partner |
Partner Function |
|
Order Entry - SAP 4x order Form Applet |
Account |
Order Entry -
Orders |
Account
Integration Id |
S_ORDER.ACCNT_ID
-> S_ORG_EXT |
INTEGRATION_ID |
ORDER_PARTNERS |
PARTN_NUMB |
|
Header
| Partner |
Name |
The
SAP customer number of the corresponding Siebel Account is passed to SAP to
indicate the Sold-To partner. Siebel maybe configured to present the user
with a picklist consisting only of accounts with SAP customer numbers during
order creation. |
N/A |
N/A |
N/A |
'WE' |
N/A |
N/A |
ORDER_PARTNERS |
PARTN_ROLE |
|
Header
| Partner |
Partner
Function |
|
Order Entry - SAP 4x order Form Applet |
Part
of 'Ship To Account Location:' field |
Order
Entry - Orders |
Ship
To Account Integration Id |
S_ORDER.SHIP_OU_ID
-> S_ORG_EXT |
INTEGRATION_ID |
ORDER_PARTNERS |
PARTN_NUMB |
|
Header
| Partner |
Name |
The
SAP customer number of the corresponding Siebel Account is passed to SAP to
indicate the Ship-To partner. Siebel
may be modified so that values are not passed for this parameter. SAP
defaults will be used in that case. |
N/A |
N/A |
N/A |
'RE' |
N/A |
N/A |
ORDER_PARTNERS |
PARTN_ROLE |
|
Header
| Partner |
Partner
Function |
|
Order Entry - SAP 4x order Form Applet |
Part
of 'Bill To Account Location:' field |
Order
Entry - Orders |
Bill
To Account Integration Id |
S_ORDER.BL_OU_ID
-> S_ORG_EXT |
INTEGRATION_ID |
ORDER_PARTNERS |
PARTN_NUMB |
|
Header
| Partner |
Name |
The
SAP customer number of the corresponding Siebel Account is passed to SAP to
indicate the Bill-To partner. Siebel may be modified so that values are not
passed for this parameter. SAP defaults will be used in that case. . |
N/A |
N/A |
N/A |
'RG' |
N/A |
N/A |
ORDER_PARTNERS |
PARTN_ROLE |
|
Header
| Partner |
Partner
Function |
|
|
|
Order
Entry - Orders |
Primary
Payer Account Integration Id |
S_ORDER.BL_OU_ID
-> S_ORG_EXT |
INTEGRATION_ID |
ORDER_PARTNERS |
PARTN_NUMB |
if
(Primary Payer Account Integration Id = null) then PARTN_NUMB = Account
Integration Id) |
Header
| Partner |
Name |
The
SAP customer number of the corresponding Siebel Account is passed to SAP to
indicate the Bill-To partner. Siebel may be modified so that values are not
passed for this parameter. SAP defaults will be used in that case. But if
Credit Card Interface is used then Payer Information becomes mandatory and
Sold to Party becomes default Payer if no Payer is specified. |
|
Credit Card (Siebel to SAP) |
|
|
|
|
|
|
|
|
|
|
|
|
Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP BAPI |
|
SAP User Interface |
|
Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/
Lookup |
Screen |
Field |
Comments |
Payment
Detail - Credit Card |
Credit Card # |
Payments |
Account Number |
S_SRC_PAYMENT |
CC_NUM |
ORDER_CCARD |
CC_NUMBER |
|
Header |
Payment Cards |
Card Number |
|
Payment Detail - Credit Card |
Expiration Month
+ Expiration Year |
Payments |
Function(GetDaysInAMonth)
+ Expiration Month + Expiration Year |
S_SRC_PAYMENT |
CRDT_CRD_EXP_MO_CD
+ CRDT_CRD_EXP_YR_CD |
ORDER_CCARD |
CC_VALID_T |
|
Header
| Payment Cards |
Valid
To |
Please
refer to 7.5 mappings for this. Actually mappings are valid for entire Credit
card component. No Change required. |
Payment Detail - Credit Card |
Payment Type |
Payments |
Payment Type |
S_SRC_PAYMENT |
TYPE_CD |
ORDER_CCARD |
CC_TYPE |
This
is defined in the Integration Administration | EAI Value Maps view under "SAP Credit Card Type" |
Header
| Payment Cards |
Type |
|
Payment Detail - Credit Card |
Credit Card
Holder |
Payments |
Card Holder |
S_SRC_PAYMENT |
CC_HOLDER_NAME |
ORDER_CCARD |
CC_NAME |
|
Header
| Payment Cards |
CardHolder |
|
|
Lines (Siebel to SAP) |
|
Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP BAPI |
|
SAP User Interface |
|
Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/
Lookup |
Screen |
Field |
Comments |
Order
Entry - SAP 4x Line Item List Applet (Sales) |
Line # |
Order Entry -
Line Items |
Line Number |
S_ORDER_ITEM |
LN_NUM |
ORDER_ITEMS_IN |
ITM_NUMBER |
|
Overview |
Sales |
Item |
|
|
|
|
|
|
|
ORDER_ITEMS_IN |
HG_LV_ITEM |
|
|
|
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
Product |
Order
Entry - Line Items |
Product
Integration Id |
S_ORDER_ITEM.PROD_ID
-> S_PROD_INT |
INTEGRATION_ID |
ORDER_ITEMS_IN |
MATERIAL |
|
Overview
| Sales |
Material |
The
SAP material number of the corresponding Siebel Product is passed to SAP. |
Order Entry - SAP 4x Line Item List Applet (Sales) |
Partial
Ship (Check Box) |
Order
Entry - Line Items |
Partial
Ship |
S_ORDER_ITEM |
ALW_PART_SHIP_FLG |
ORDER_ITEMS_IN |
PART_DLV |
|
Item
| Shipping |
Part.dlv./Item |
If
Siebel Partial Ship <> 'Y' then PART_DLV = 'C' otherwise PART_DLV = 'D' |
Order Entry - SAP 4x Line Item List Applet (Sales) |
Unit
of Measure |
Order
Entry - Line Items |
Product
Unit of Measure |
S_ORDER_ITEM.PROD_ID
--> S_PROD_INT |
UOM_CD |
ORDER_ITEMS_IN |
SALES_UNIT |
This
is defined in the Integration Administration | EAI Value Maps view under "SAP Unit of Measure". |
Overview
| Sales |
UoM |
EAI
Value Maps may be extended to match SAP UoMs for a specific SAP
implementation. |
Order Entry - SAP 4x Line Item List Applet (Sales) |
Delivering
Plant |
Order
Entry - Line Items |
Source
Inventory Location |
S_ORDER_ITEM.SRC_INVLOC_ID
--> S_INVLOC |
NAME |
ORDER_ITEMS_IN |
PLANT |
|
Item
| Item Details |
Plant |
Maintained
in Integration Administration --> SAP Administration --> Organization
Plant View |
|
|
Order
Entry - Line Items |
Description |
S_ORDER_ITEM |
DESC_TEXT |
ORDER_ITEMS_IN |
SHORT_TEXT |
|
Overview
| Sales |
Description |
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
Req Del Date |
Order Entry -
Line Items |
Due
Date |
S_ORDER_ITEM |
REQ_SHIP_DT |
ORDER_ITEMS_IN |
REQ_DATE |
|
Item
| Item Overview |
Req.
Deliv. date |
|
N/A |
N/A |
N/A |
'1' |
N/A |
N/A |
ORDER_ITEMS_IN |
DATE_TYPE |
|
N/A |
N/A |
|
|
Pricing Conditions (Siebel to SAP) |
|
Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP BAPI |
|
SAP User Interface |
|
Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/
Lookup |
Screen |
Field |
Comments |
Order
Entry - SAP 4x Line Item List Applet (Sales) |
Line # |
Order Entry -
Line Items |
Line Number |
S_ORDER_ITEM |
LN_NUM |
ORDER_CONDITIONS_IN |
ITM_NUMBER |
|
|
|
|
|
|
|
"PN00"
/ ''PR00' |
|
|
ORDER_CONDITIONS_IN |
COND_TYPE |
|
|
|
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
Net
Price |
Order
Entry - Line Items |
Item
Price |
N/A |
Calculated
Field |
ORDER_CONDITIONS_IN |
COND_VALUE |
|
|
|
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
Line
# |
Order
Entry - Line Items |
Line
Number |
S_ORDER_ITEM |
LN_NUM |
ORDER_CONDITIONS_IN |
ITM_NUMBER |
|
|
|
|
|
|
|
"KF00" |
|
|
ORDER_CONDITIONS_IN |
COND_TYPE |
|
|
|
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
|
Order
Entry - Line Items |
Freight
Amount |
S_ORDER_ITEM |
FRGHT_AMT |
ORDER_CONDITIONS_IN |
COND_VALUE |
|
|
|
|
|
Schedule Line Item (Siebel to SAP) |
|
Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP BAPI |
|
SAP User Interface |
|
Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/
Lookup |
Screen |
Field |
Comments |
Order
Entry - SAP 4x Line Item List Applet (Sales) |
Line # |
Order Entry -
Line Items |
Line Number |
S_ORDER_ITEM |
LN_NUM |
ORDER_SCHEDULES_IN |
SCHED_LINE |
|
|
|
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
Qty
Requested |
Order
Entry - Line Items |
Quantity
Requested |
S_ORDER_ITEM |
QTY_REQ |
ORDER_SCHEDULES_IN |
REQ_QTY |
|
Item
| Schedule Lines I Schedule Line Data |
Schedule
Line Number |
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
Line
# |
Order
Entry - Line Items |
Line
Number |
S_ORDER_ITEM |
LN_NUM |
ORDER_SCHEDULES_IN |
ITM_NUMBER |
|
Item
| Schedule Lines I Schedule Line Data |
Schedule
Line Number |
|
Order Entry - SAP 4x Line Item List Applet (Sales) |
Req Del Date |
Order Entry -
Line Items |
Due
Date |
S_ORDER_ITEM |
REQ_SHIP_DT |
ORDER_SCHEDULES_IN |
REQ_DATE |
|
Item
| Schedule Lines I Schedule Line Data |
Confirmed
Quantity |
|
|
|
|
|
|
|
Header (Updates from SAP to Siebel) |
|
|
|
|
|
|
|
|
|
|
|
|
Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP BAPI |
|
SAP User Interface |
|
Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/
Lookup |
Screen |
Field |
Comments |
Order
Entry - SAP 4x order Form Applet |
Order Number |
Order Entry -
Orders |
Integration Id |
S_ORDER |
INTEGRATION_ID |
Export
Parameters |
SALESDOCUMENT |
|
Overview |
Sales |
Standard Order |
|
|
|
Order
Entry - Orders |
Back
Office Process Status |
S_ORDER |
EAI_EXPRT_STAT_CD |
N/A |
"Created
in Back Office"/"Error on Creating" |
|
N/A |
N/A |
|
Order Entry - SAP 4x order Form Applet |
Message(SAP) |
Order
Entry - Orders |
Back
Office Error Text |
S_ORDER |
EAI_ERROR_TEXT |
RETURN |
MESSAGE |
|
N/A |
N/A |
Determined
in Run time by SAP BAPI |
Order Entry - SAP 4x order Form Applet |
Credit
Status |
Order
Entry - Orders |
Credit
Status |
S_ORDER |
CRDT_CHK_PASSD_FLG |
RETURN |
RETURN-CODE =
"V1154" or "V1038" |
|
Header
Status | Status |
Credit
Status |
Determined
in Run time by SAP |
Order Entry - SAP 4x order Form Applet |
Submit
Date |
Order
Entry - Line Items |
EAI
Sync Date |
S_ORDER_ITEM |
EAI_SYNC_DT |
N/A |
TimeStamp |
|
N/A |
N/A |
|
Order Entry - SAP 4x order Form Applet |
Status
As Of |
Order
Entry - Line Items |
As
Of Date |
S_ORDER_ITEM |
STATUS_DT |
N/A |
TimeStamp |
|
N/A |
N/A |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|