Order Validate 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) |
|
|
|
|
|
|
|
|
Credit
Card (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 -
Simulate SAP Order (BAPI Input) |
|
|
|
|
|
|
SAP 4x Order -
Simulate SAP Order (BAPI Output) |
|
|
|
|
|
Transaction
Description: |
Validates Siebel
Order from SAP |
Mainly looks for
Pricing, ATP, Delivery, Billing, and Credit Blocks if any. |
|
|
|
|
Workflow: |
Order - Simulate
SAP 4x Order |
|
|
|
|
|
Business
Service (Name): |
Order - SAP 4x
Maps |
|
|
|
|
|
Business
Service (Display Name): |
SAP 4x Mapping -
Order |
|
|
|
|
|
Map Functions: |
SimulateSAP4xOrder_SiebelToBAPI |
|
|
|
|
|
|
SimulateSAP4xOrder_BAPIToSiebel |
This map in turn
calls CreateSimulateSAP4xOrder_SiebelToBAPI which is common for both Create
and Simulate functions. |
|
|
|
|
SAP Interface: |
BAPI_SALESORDER_Simulate |
|
|
|
|
|
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 |
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 - SAP 4x order Form Applet |
Credit Status: |
Order Entry - Orders |
Credit Status |
S_ORDER |
CRDT_CHK_PASSD_FLG |
Export Parameters |
RETURN-ID = "V1"
&& RETURN-NUMBER = 154 |
|
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Credit Card
(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 |
Payment
Detail - Credit Card |
Card Number |
Payments |
Account Number |
S_SRC_PAYMENT |
CC_NUMBER |
ORDER_CCARD_EX |
CC_NUMBER |
|
Overview | Sales |
Payment Card |
|
Payment
Detail - Credit Card |
Expiration Month +
Expiration Year |
Payments |
Expiration Month +
Expiration Year |
S_SRC_PAYMENT |
CRDT_CRD_EXP_MO_CD +
CRDT_CRD_EXP_YR_CD |
ORDER_CCARD_EX |
CC_VALID_T |
|
Header | Payment Cards |
Valid To |
|
Payment
Detail - Credit Card |
Transaction Amount |
Payments |
Transaction Amount |
S_SRC_PAYMENT |
CRDT_CRD_TXN_AMT |
ORDER_CCARD_EX |
AUTHAMOUNT |
|
Header | Payment Cards |
Authorized amt |
|
Payment
Detail - Credit Card |
Authorization Date |
Payments |
Authorization Date |
S_SRC_PAYMENT |
PERFORM_DT |
ORDER_CCARD_EX |
AUTH_DATE |
|
Header | Payment Cards |
Next Date |
|
Payment
Detail - Credit Card |
Authorization Code |
Payments |
Authorization Code |
S_SRC_PAYMENT |
CRDT_CRD_APPR_CD |
ORDER_CCARD_EX |
CC_AUTTH_NO |
|
Header | Payment Cards |
Auth No. |
|
Payment
Detail - Credit Card |
Payment Method |
Payments |
Payment Method |
S_SRC_PAYMENT |
PAY_TYPE_CD |
N/A |
N/A |
TheApplication().InvokeMethod
("LookupValue", "PAYMENT_METHOD_CODE", "Credit
Card"); |
N/A |
N/A |
Required field in Payment
Bus Comp |
Payment
Detail - Credit Card |
Payment Type |
Payments |
Payment Type |
S_SRC_PAYMENT |
TYPE_CD |
ORDER_CCARD_EX |
CC_TYPE |
|
Header | Payment Cards |
Type |
|
Payment
List Applet |
Transaction Message |
Payments |
Transaction Message |
S_SRC_PAYMENT |
TXN_RETURN_CODE |
ORDER_CCARD_EX |
CC_REACT_T |
|
Header | Payment Cards |
Status |
|
N/A |
N/A |
Payments |
Expiration Date |
S_SRC_PAYMENT |
CC_EXP_DT |
ORDER_CCARD_EX |
CC_VALID_T |
|
Header | Payment Cards |
Valid To |
|
Payment
Detail - Credit Card |
Payment Status |
Payments |
Payment Status |
S_SRC_PAYMENT |
PAY_STAT_CD |
ORDER_CCARD_EX |
CC_STAT_EX + CC_REACT |
Pls refer comments for
logic of arriving at Siebel Payment Status field value. You may want to
modify it based on your implementation |
Header | Payment Cards |
Response |
if(CC_STAT_EX =
"C") {if(CC_REACT = "A") {"Payment Status" =
"Authorized"} else {"Payment Status" =
"Declined"}} else {"Payment Status" = "AVS
Failed"} |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
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 |
|
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) |
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) |
Part of 'Product' Pick List |
Order Entry - Line Items |
Product Integration Id |
S_ORDER_ITEM.PROD_ID -->
S_PROD_INT |
INTEGRATION_ID |
ORDER_ITEMS_OUT |
MATERIAL |
|
Overview | Sales |
Material |
|
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 |
|
'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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|