|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Integration Objects: |
SAP 4x Order |
|
|
|
|
Order - Get Detailed List
SAP 46C Order (BAPI Input) |
|
|
|
|
Order - Get Detailed List
SAP 46C Order (BAPI Output) |
|
|
Transaction Description: |
Updates Siebel Order with SAP Order
Information |
|
|
Workflow: |
|
Order - Get Detailed List
SAP 46C Order |
|
|
SAP Interface: |
BAPISDORDER_GETDETAILEDLIST |
|
|
Integration Point: |
Get Status |
|
|
Siebel View: |
Orders | All Sales Orders | Line
Items(SAP) |
|
|
|
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 |
|
|
Order Entry -
SAP 4x order Form Applet |
Order # |
Order Entry -
Orders |
Integration Id |
S_ORDER |
INTEGRATION_ID |
SALES_DOCUMENTS |
VBELN |
|
Order Header |
Business Data |
Order number |
|
|
|
|
|
|
|
|
|
Import
Parameters |
I_MEMORY_READ |
set to 'A' |
|
|
Default
values for BAPI to be set to get required output |
|
|
|
|
|
|
|
|
Import
Parameters |
I_BAPI_VIEW-HEADER |
set to 'X' |
|
|
Default
values for BAPI to be set to get required output |
|
|
|
|
|
|
|
|
Import
Parameters |
I_BAPI_VIEW-FLOW |
set to 'X' |
|
|
Default
values for BAPI to be set to get required output |
|
|
|
|
|
|
|
|
Import
Parameters |
I_BAPI_VIEW-ITEM |
set to 'X' |
|
|
Default
values for BAPI to be set to get required output |
|
|
|
|
|
|
|
|
Import
Parameters |
I_BAPI_VIEW-SDSCHEDULE |
set to 'X' |
|
|
Default
values for BAPI to be set to get required output |
|
|
|
|
|
|
|
|
Import
Parameters |
I_BAPI_VIEW-STATUS_H |
set to 'X' |
|
|
Default
values for BAPI to be set to get required output |
|
|
|
|
|
|
|
|
Import
Parameters |
I_BAPI_VIEW-STATUS_I |
set to 'X' |
|
|
Default
values for BAPI to be set to get required output |
|
|
HEADER (Updates from SAP to Siebel) |
|
|
Output maps
(SAP to Siebel) |
|
|
Siebel Client UI |
Siebel Object Manager |
Siebel Schema |
SAP Interface |
|
SAPGUI |
|
|
|
Applet |
Field |
Business Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/ Lookup |
Screen |
Field |
Comments |
|
|
Order Entry - Order Form Applet
(Sales) |
Requested Date |
Order Entry -
Orders |
Requested Ship
Date |
S_ORDER |
REQ_SHIP_DT |
ORDER_HEADERS_OUT |
REQ_DATE_H |
|
Overview |
Single-line entry |
Req. deliv date |
|
|
|
Order Entry -
Order Form Applet (Sales) |
Order
Number |
Order
Entry - Orders |
Order
Number |
S_ORDER |
ORDER_NUM |
ORDER_HEADERS_OUT |
PURCH_NO |
|
Overview
| Single-line entry |
Purchase order
no. |
|
|
|
|
|
Order
Entry - Orders |
Currency
Code |
S_ORDER |
CURCY_CD |
ORDER_HEADERS_OUT |
CURRENCY |
This
is defined in the Integration Administration | EAI Value Maps view under "SAP Currency Code". |
Overview
| Single-line entry |
Currency for Net
value |
|
|
|
Order Entry -
SAP 4x order Form Applet |
Order
# |
Order
Entry - Orders |
Integration
Id |
S_ORDER |
INTEGRATION_ID |
ORDER_HEADERS_OUT |
DOC_NUMBER |
|
Order
Header | Business Data |
Order number |
|
|
|
Order Entry -
SAP 4x order Form Applet |
Company
Order # |
Order
Entry - Orders |
Account
Order Number |
S_ORDER |
ACCNT_ORDER_NUM |
ORDER_HEADERS_OUT |
PURCH_NO |
|
Overview
| Single-line entry |
Purch Order No. |
|
|
|
|
|
Order
Entry - Orders |
Delivery
Status |
S_ORDER |
DLVRY_STATUS_CD |
ORDER_STATUSHEADERS_OUT |
DELIV_STAT |
|
|
|
|
|
|
Order Entry -
Order Form Applet (Sales) |
*Status |
Order
Entry - Orders |
Status |
S_ORDER |
STATUS_CD |
ORDER_STATUSHEADERS_OUT |
PRC_STAT_H |
|
Order
Header | Status |
Completeness |
|
|
|
Order Entry -
SAP 4x order Form Applet |
Delivery
Block |
Order
Entry - Orders |
Delivery
Block |
S_ORDER |
DLV_BLOCK |
ORDER_HEADERS_OUT |
DLV_BLOCK |
|
Overview
| Shipping |
Delivery block |
|
|
|
Lines (Insert,
Update, Delete from SAP to Siebel) |
|
|
Siebel Client UI |
Siebel Object Manager |
Siebel Schema |
SAP Interface |
|
SAPGUI |
|
|
|
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_OUT |
ITM_NUMBER |
|
Overview |
Single-line entry |
Item |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Qty
Requested |
Order
Entry - Line Items |
Quantity
Requested |
S_ORDER_ITEM |
QTY_REQ |
ORDER_ITEMS_OUT |
REQ_QTY |
|
Overview
| Single-line entry |
Order
quantity |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Discount
Price |
Order
Entry - Line Items |
Unit
Price |
S_ORDER_ITEM |
UNIT_PRI |
ORDER_CONDITIONS_OUT |
COND_VALUE
or CONDVALUE/REQ_QTY |
if
COND_TYPE = PN00 or PR00 |
Item
| Conditions |
Cond.
Value |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Freight(SAP) |
Order
Entry - Line Items |
Freight
Amount |
S_ORDER_ITEM |
FRGHT_AMT |
ORDER_CONDITIONS_OUT |
COND_VALUE |
if COND_TYPE = KF00 |
Item
| Conditions |
Cond.
Value |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Tax |
Order
Entry - Line Items |
Tax
Amount |
S_ORDER_ITEM |
TAX_AMT |
ORDER_CONDITIONS_OUT |
COND_VALUE |
if
COND_TYPE = UTXJ |
Item
| Conditions |
Cond.
Value |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Net
Price |
Order
Entry - Line Items |
Adjusted
List Price |
S_ORDER_ITEM |
ADJ_UNIT_PRI |
ORDER_CONDITIONS_OUT |
COND_VALUE
or CONDVALUE/REQ_QTY |
if
COND_TYPE = PN00 or PR00 |
Item
| Conditions |
Cond.
Value |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Qty
Shipped |
Order
Entry - Line Items |
Quantity
Shipped |
S_ORDER_ITEM |
QTY_SHIPPED |
ORDER_ITEMS_OUT |
REF_QTY |
|
Item
| Schedule Line | Quantities/dates | Sales Detail |
Delivered
qty |
This
is the quantity that the delivery is created for. It is not necessarily the
quantity shipped in SAP. This information is not available in the standard
BAPI. |
|
|
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 |
REQ_DATE |
|
Item
| Schedule Line | Quantities/dates |
Quantities/dates
- Date type |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Delivery
Status |
Order
Entry - Line Items |
Delivery
Status |
S_ORDER_ITEM |
DLVRY_STATUS_CD |
ORDER_STATUSITEMS_OUT |
DLV_STAT_I |
|
|
|
|
|
|
|
|
Order
Entry - Line Items |
Product
Unit of Measure |
S_ORDER_ITEM.PROD_ID
-> S_PROD_INT |
UOM_CD |
ORDER_ITEMS_OUT |
SALES_UNIT |
|
|
|
This
will help validate only. If UOM doesn't match the transformation will error
out |
|
|
|
|
Order
Entry - Line Items |
Description |
S_ORDER_ITEM |
DESC_TEXT |
ORDER_ITEMS_OUT |
SHORT_TEXT |
|
Overview
| Single-line entry |
Description |
|
|
|
Order Entry -
SAP 4x Line Item List Applet (Sales) |
Back
Office Net Value |
Order
Entry - Line Items |
Base
Price |
S_ORDER_ITEM |
NET_VALUE |
ORDER_ITEMS_OUT |
NET_VALUE |
SAP 4x Unit Net Price = ( NET_VALUE ) / ( QTY_REQ ) |
Item
| Pricing |
Net
value |
|
|
|
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 |
NAME |
ORDER_ITEMS_OUT |
MATERIAL |
|
Overview
| Single-line entry |
Material |
|
|
|
Order Entry - SAP
4x Line Item List Applet (Sales) |
Back
Office Net Value |
Order
Entry - Line Items |
SAP
4x Unit Net Price |
S_ORDER_ITEM |
NET_VALUE |
STATUSINFO |
NET_VALUE |
SAP 4x Unit Net Price = ( NET_VALUE ) / ( QTY_REQ ) |
Item
| Pricing |
Net
value |
|
|
|
SCHEDULE LINE ITEM (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 |
|
|
|
|
|
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_SCHEDULES_OUT |
ORDER_HEADERS_OUT-DOC_NUMBER+(-)+ORDER_ITEMS_OUT-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_SCHEDULES_OUT |
ORDER_HEADERS_OUT-DOC_NUMBER+(-)+ORDER_ITEMS_OUT-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_SCHEDULES_OUT |
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_SCHEDULES_OUT |
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_SCHEDULES_OUT |
DLV_DATE |
|
Item
| Schedule Lines I Schedule Line Data |
Required
Delivery Date |
|
|
|
Delivery Item (Insert, Update, Delete from SAP to Siebel) |
|
|
Siebel Client UI |
Siebel Object Manager |
Siebel Schema |
SAP Interface |
|
SAPGUI |
|
|
|
Applet |
Field |
Business Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/ Lookup |
Screen |
Field |
Comments |
|
|
Order Entry - SAP 4x Delivery
Status List Applet |
Line # |
Order Entry -
Line Item Actions |
Line Item Action
Number |
S_ORDPART_MVMT |
PART_MVMT_NUM |
ORDER_FLOWS_OUT |
SUBSSDDOC +
SUBSITDOC |
|
Environment |
Document flow | View | Items | Display document |
Delivery || Item |
|
|
|
Order Entry -
SAP 4x Delivery Status List Applet |
Delivered
Qty |
Order
Entry - Line Item Actions |
Confirmed
Qty |
S_ORDPART_MVMT |
QTY |
ORDER_FLOWS_OUT |
REF_QTY |
|
Environment
| Document flow | View | Items | Display document |
Delivery
quantity |
This
is the quantity that the delivery is created for. It is not necessarily the
quantity shipped. Quantity shipped is reflected by status of the delivery in
SAP. This information is not available in the standard BAPI. |
|
|
Order Entry -
SAP 4x Delivery Status List Applet |
Delivery
No-Delivery Item # |
Order
Entry - Line Item Actions |
Integration
Id |
S_ORDPART_MVMT |
INTEGRATION_ID |
ORDER_FLOWS_OUT |
SUBSSDDOC
+ SUBSITDOC |
|
Environment
| Document flow | View | Items | Display document |
Goods
issue date |
This value is taken
from the delivery document. |
|
|
Order Entry -
SAP 4x Delivery Status List Applet |
Confirmed
Date |
Order
Entry - Line Item Actions |
Planned
Start Date |
S_ORDPART_MVMT |
ACTL_START_DT |
ORDER_FLOWS_OUT |
CREAT_DATE |
|
Environment
| Document flow | View | Items | Display document |
Goods
issue date |
This value is taken
from the delivery document. |
|
|
N/A |
N/A |
Order
Entry - Line Item Actions |
Line
Item Action Type |
S_ORDPART_MVMT.PART_MVMT_TYPE_ID
-> S_PART_MVMTTYPE |
NAME |
ORDER_FLOWS_OUT |
if
(PREDITDOC == ORDER_ITEMS_OUT-ITM_NUMBER && DOCCATEGOR == 'J")
then ''Delivery' |
|
N/A |
N/A |
|
|
|
|
Shipment Item (Insert, Update, Delete from SAP to Siebel) |
|
|
Siebel Client UI |
Siebel Object Manager |
Siebel Schema |
SAP Interface |
|
SAPGUI |
|
|
|
Applet |
Field |
Business Component |
Field |
Table |
Column |
Parameter |
Field |
Transformation/ Lookup |
Screen |
Field |
Comments |
|
|
Order Entry - SAP 4x Delivery
Status List Applet |
Line # |
Order Entry -
Line Item Actions |
Line Item Action
Number |
S_ORDPART_MVMT |
PART_MVMT_NUM |
ORDER_FLOWS_OUT |
SUBSSDDOC +
SUBSITDOC |
|
Environment |
Document flow | View | Items | Display document |
Delivery || Item |
|
|
|
Order Entry -
SAP 4x Delivery Status List Applet |
Delivered
Qty |
Order
Entry - Line Item Actions |
Confirmed
Qty |
S_ORDPART_MVMT |
QTY |
ORDER_FLOWS_OUT |
REF_QTY |
|
Environment
| Document flow | View | Items | Display document |
Delivery
quantity |
This
is the quantity that the delivery is created for. It is not necessarily the
quantity shipped. Quantity shipped is reflected by status of the delivery in
SAP. This information is not available in the standard BAPI. |
|
|
Order Entry -
SAP 4x Delivery Status List Applet |
Delivery
No-Delivery Item # |
Order
Entry - Line Item Actions |
Integration
Id |
S_ORDPART_MVMT |
INTEGRATION_ID |
ORDER_FLOWS_OUT |
SUBSSDDOC
+ SUBSITDOC |
|
Environment
| Document flow | View | Items | Display document |
Goods
issue date |
This value is taken
from the delivery document. |
|
|
Order Entry -
SAP 4x Delivery Status List Applet |
Confirmed
Date |
Order
Entry - Line Item Actions |
Planned
Start Date |
S_ORDPART_MVMT |
ACTL_START_DT |
ORDER_FLOWS_OUT |
CREAT_DATE |
|
Environment
| Document flow | View | Items | Display document |
Goods
issue date |
This value is taken
from the delivery document. |
|
|
N/A |
N/A |
Order
Entry - Line Item Actions |
Line
Item Action Type |
S_ORDPART_MVMT.PART_MVMT_TYPE_ID
-> S_PART_MVMTTYPE |
NAME |
ORDER_FLOWS_OUT |
if
(PREDITDOC == ORDER_ITEMS_OUT-ITM_NUMBER && DOCCATEGOR == 'R")
then ''Ship' else (don't go into the loop) |
|
N/A |
N/A |
We
need to add this value in LOV if we want to support both delivery and
Shipment document information |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|