Order Create Mappings sheet
This sheet contains the following tables:
	Header (Siebel to SAP)
	Partners (Siebel to SAP)
	Credit Card (Siebel to SAP)
	Lines (Siebel to SAP)
	Header (Updates from SAP to Siebel)
	Line Item (Updates from SAP  to Siebel)
	Schedule Line Item (Updates from SAP to Siebel)
Integration Objects:		SAP 4x Order			Used for Query function in siebel Adapter
		SAP 4x Order(Sync)			Used for Synchronizing SAP Output to Siebel
		SAP 4x Order - Create SAP Order (BAPI Input)
		SAP 4x Order - Create SAP Order (BAPI Output)
Transaction Description:		Creates SAP Order from Siebel Order
Workflow:		Order - Create SAP 4x Order
Business Service (Name):		Order - SAP 4x Maps			As shown in Tools
Business Service (Display Name):		SAP 4x Mapping - Order			As shown in Client
Map Functions:		CreateSAP4xOrder_SiebelToBAPI			This map in turn calls CreateSimulateSAP4xOrder_SiebelToBAPI which is common for both Create and Simulate functions.
		CreateSAP4xOrder_SiebelToBAPI
SAP Interface:		BAPI_SALESORDER_CREATEFROMDAT1
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		Transformation / Lookup	SAP User Interface
Applet	Field	Business Component	Field	Table	Column	Parameter	Field		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 - Order Form Applet (Sales)	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	N/A	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	N/A	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	N/A	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 Ship:	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 the 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	Account 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)	First Name||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.
Shows in Contacts view	Work Phone	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 - Order Terms Form Applet (Sales)	Shipping Terms:	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 - Order Terms Form Applet (Sales)	Shipping Info:	Order Entry - Orders	Freight Terms Info	S_ORDER	FRGHT_TERMS_INFO	ORDER_HEADER_IN	INCOTERMS2		Header | Billing Data	Incoterms
Order Entry - Order Terms Form Applet (Sales)	Payment Terms:	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.
N/A	N/A	N/A	'HB00'	N/A	N/A	ORDER_HEADER_IN	CD_TYPE1	Header freight is updated only if Siebel is pricing Master.	Header | Conditions	HB00	SAP Condition Type for Header Value of Freight
Order Entry - Order Terms Form Applet (Sales)	Shipping Charges:	Order Entry - Orders	Freight	S_ORDER	FRGHT_AMT	ORDER_HEADER_IN	CD_VALUE1	Header freight is updated only if Siebel is pricing Master.	Header | Conditions	Condition Value	Header Freight Value in Siebel Order
N/A	N/A	N/A	'1'	N/A	N/A	ORDER_HEADER_IN	CD_P_UNT1		Header | Conditions	by
Partners (Siebel to SAP)
Siebel Client		Siebel Object Manager		Siebel Schema		SAP BAPI		Transformation / Lookup	SAP User Interface
Applet	Field	Business Component	Field	Table	Column	Parameter	Field		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	Part of 'Site:' field	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
Integration Administration --> SAP Administration -->  SAP Account Sales Area View	Payer	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		Transformation / Lookup	SAP User Interface
Applet	Field	Business Component	Field	Table	Column	Parameter	Field		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
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		Transformation / Lookup	SAP User Interface
Applet	Field	Business Component	Field	Table	Column	Parameter	Field		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 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)	Qty Req	Order Entry - Line Items	Quantity Requested	S_ORDER_ITEM	QTY_REQ	ORDER_ITEMS_IN	REQ_QTY		Overview | Sales	Order quantity
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)	U/M	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 Item List Applet (Sales)	Comments	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
N/A	N/A	N/A	"PN00" / ''PB00'	N/A	N/A	ORDER_ITEMS_IN	COND_TYPE		Item | Conditions	CnTy	If Siebel is Pricing Master then PN00 with Siebel Calculated price is sent to SAP otherwise PB00 without any value, in this Case SAP calculates Price.
Order Entry - SAP 4x Line Item List Applet (Sales)	Net Price	Order Entry - Line Items	Item Price	N/A	N/A	ORDER_ITEMS_IN	CD_VALUE2		Item | Conditions	Cond. Value	In case Siebel is Priceing Master Net Price Value is sent to SAP otherwise SAP Calculates its own price.
N/A	N/A	N/A	'1'	N/A	N/A	ORDER_ITEMS_IN	COND_P_UNT		Item | Conditions	by
Header (Updates from SAP to Siebel)
Siebel Client		Siebel Object Manager		Siebel Schema		SAP BAPI		Transformation / Lookup	SAP User Interface
Applet	Field	Business Component	Field	Table	Column	Parameter	Field		Screen	Field	Comments
Order Entry - SAP 4x order Form Applet	Order Number	Order Entry - Orders	Integration Id	S_ORDER	INTEGRATION_ID	SALESDOCUMENT	BAPIVBELN-VBELN		Overview | Sales	Standard Order
Order Entry - SAP 4x order Form Applet	Billing Block:	Order Entry - Orders	Billing Block	S_ORDER	BLOCK_BL_CD	Export Parameters	BILLING_PARTY-BILL_BLOCK		Overview | Sales	Billing Block
Order Entry - SAP 4x order Form Applet	Delivery Block:	Order Entry - Orders	Delivery Block	S_ORDER	BLOCK_DLVRY_CD	Export Parameters	SHIP_TO_PARTY-DLV_BLOCK		Overview | Sales	Delivery Block
Order Entry - Oracle 11i Order Form Applet	Synchronization Status	Order Entry - Orders	Back Office Process Status	S_ORDER	CRDT_CHK_PASSD_FLG	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	CRDT_CHK_PASSD_FLG	Export Parameters	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	Export Parameters	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
Line Item (Updates from SAP  to Siebel)
Siebel Client		Siebel Object Manager		Siebel Schema		SAP BAPI		Transformation / Lookup	SAP User Interface
Applet	Field	Business Component	Field	Table	Column	Parameter	Field		Screen	Field	Comments
N/A	N/A	Order Entry - Line Items	SAP 4x Net Price	S_ORDER_ITEM	NET_PRI	ORDER_ITEMS_OUT	NET_VALUE		Item | Conditions	CnTy
Order Entry - SAP 4x Line Item List Applet (Sales)	Start Price	Order Entry - Line Items	Adjusted List Price	S_ORDER_ITEM	ADJ_UNIT_PRI	ORDER_ITEMS_OUT	(NET_VALUE) / (REQ_QTY)		Item | Conditions	CnTy
Order Entry - SAP 4x Line Item List Applet (Sales)	Freight (SAP)	Order Entry - Line Items	Freight Amount	S_ORDER_ITEM	FRGHT_AMT	ORDER_ITEMS_OUT	SUBTOTAL_4		Item | Conditions	CnTy
Order Entry - SAP 4x Line Item List Applet (Sales)	Tax	Order Entry - Line Items	Tax Amount	S_ORDER_ITEM	TAX_AMT	ORDER_ITEMS_OUT	SUBTOTAL_5		Item | Conditions	CnTy
N/A	N/A	Order Entry - Line Items	Integration Id	S_ORDER_ITEM	INTEGRATION_ID	ORDER_ITEMS_OUT	SALESDOCUMENT - ITM_NUMBER		Overview | Sales	Item
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_OUT	DLV_DATE		Item | Schedule Lines	Deliv. Date
Order Entry - SAP 4x Line Item List Applet (Sales)	Line #	Order Entry - Line Items	Line Number	S_ORDER_ITEM	LN_NUM	ORDER_ITEMS_OUT	ITM_NUMBER		Overview | Sales	Item
Order Entry - SAP 4x Line Item List Applet (Sales)	Qty Req	Order Entry - Line Items	Quantity Requested	S_ORDER_ITEM	QTY_REQ	ORDER_ITEMS_OUT	REQ_QTY		Overview | Sales	Order Qty
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_OUT	MATERIAL		Overview | Sales	Material	Product Integration Id for selected Product is sent to SAP
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_OUT	PLANT		Item | Shipping	Plant
Schedule Line Item (Updates from SAP to Siebel)
Siebel Client		Siebel Object Manager		Siebel Schema		SAP BAPI		Transformation / Lookup	SAP User Interface
Applet	Field	Business Component	Field	Table	Column	Parameter	Field		Screen	Field	Comments
N/A	N/A	Order Entry - Line Item Actions	Line Item Action Type	S_ORDPART_MVMT.PART_MVMT_TYPE_ID --> S_PARTMVMT_TYPE	NAME	N/A	'Schedule'	("LookupValue", "SAP_SO_PART_MOVEMENT_TYPE", "Schedule")	N/A	N/A	Part of Search Specification for this Applet
Order Entry - SAP 4x Schedule Line List Applet	Schedule Line #	Order Entry - Line Item Actions	Line Item Action Number	S_ORDPART_MVMT	PART_MVMT_NUM	ORDER_SCHEDULE_EX	SALESDOCUMENT-ITM_NUMBER-SCHED_LINE		Item | Schedule Lines I Schedule Line Data	Schedule Line Number
N/A	N/A	Order Entry - Line Item Actions	Integration Id	S_ORDPART_MVMT	INTEGRATION_ID	ORDER_SCHEDULE_EX	SALESDOCUMENT-ITM_NUMBER-SCHED_LINE		Item | Schedule Lines I Schedule Line Data	Schedule Line Number
Order Entry - SAP 4x Schedule Line List Applet	Confirmed Qty	Order Entry - Line Item Actions	Confirmed Qty	S_ORDPART_MVMT	CONFIRMED_QTY	ORDER_SCHEDULE_EX	CONFIR_QTY		Item | Schedule Lines I Schedule Line Data	Confirmed Quantity
Order Entry - SAP 4x Schedule Line List Applet	Confirmed Date	Order Entry - Line Item Actions	Actual Start Date	S_ORDPART_MVMT	ACTL_START_DT	ORDER_SCHEDULE_EX	REQ_DATE		Item | Schedule Lines I Schedule Line Data	Confirmed Date
Order Entry - SAP 4x Schedule Line List Applet	Required Delivery Date	Order Entry - Line Item Actions	Planned Start Date	S_ORDPART_MVMT	PLAN_START_DT	ORDER_ITEMS_OUT	DLV_DATE		Item | Schedule Lines I Schedule Line Data	Required Delivery Date