| Order Get Status Mappings sheet |
|
|
|
|
|
|
|
|
|
|
|
|
| This sheet contains the following tables: |
|
|
|
|
|
|
|
|
|
|
Header
(Siebel to SAP) |
|
|
|
|
|
|
|
|
Header
(Updates from SAP to Siebel) |
|
|
|
|
|
|
|
|
Lines
(Insert, Update, Delete from SAP to Siebel) |
|
|
|
|
|
|
|
|
Delivery
Item (Insert, Update, Delete from SAP to Siebel) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Integration
Objects: |
SAP 4x Order(Get
Status) |
|
|
|
|
|
|
|
SAP 4x Order -
Get Status SAP Order (BAPI Input) |
|
|
|
|
|
|
|
SAP 4x Order -
Get Status SAP Order (BAPI Output) |
|
|
|
|
|
|
| Transaction
Description: |
Updates an Order
with the latest SAP information |
|
|
|
|
|
|
| Workflow: |
Order - Get SAP
4x Order Status |
|
|
|
|
|
|
| SAP Interface: |
BAPI_SALESORDER_GETSTATUS |
|
|
|
|
|
|
| Integration
Point: |
SEBL_ORDER_GET_SAP_STATUS |
|
|
|
|
|
|
| Siebel View: |
Orders > All
Sales Orders > Line Items(SAP) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 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 |
| Order
Entry - SAP 4x order Form Applet |
Order #: |
Order Entry - Orders |
Integration Id |
S_ORDER |
INTEGRATION_ID |
SALESDOCUMENT |
BAPIVBELN-VBELN |
|
Order Header | Business
Data |
Order number |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Header
(Updates from SAP to Siebel) |
|
|
|
|
|
|
|
|
|
|
|
|
| Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP Interface |
Transformation /
Lookup |
SAP User Interface |
|
| Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
|
Screen |
Field |
Comments |
| Order
Entry - Order Form Applet (Sales) |
Requested Ship: |
Order Entry - Orders |
Requested Ship Date |
S_ORDER |
REQ_SHIP_DT |
STATUSINFO |
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 |
STATUSINFO |
PURCH_NO |
|
Overview | Single-line
entry |
Purchase order no. |
|
| Order
Entry - Order Form Applet (Sales) |
Currency: |
Order Entry - Orders |
Currency Code |
S_ORDER |
CURCY_CD |
STATUSINFO |
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 |
STATUSINFO |
DOC_NUMBER |
|
Order Header | Business
Data |
Order number |
|
| Order
Entry - SAP 4x order Form Applet |
Account Order # |
Order Entry - Orders |
Account Order Number |
S_ORDER |
ACCNT_ORDER_NUM |
STATUSINFO |
PURCH_NO |
|
Overview | Single-line
entry |
Purch Order No. |
|
| Order
Entry - Order Form Applet (Sales) |
Status |
Order Entry - Orders |
Status |
S_ORDER |
STATUS_CD |
STATUSINFO |
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 |
STATUSINFO |
DLV_BLOCK |
|
Overview | Shipping |
Delivery block |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Lines (Insert,
Update, Delete from SAP to Siebel) |
|
|
|
|
|
|
|
|
|
|
|
|
| Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP Interface |
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 |
STATUSINFO |
ITM_NUMBER |
|
Overview |
Single-line entry |
Item |
|
| Order Entry - SAP 4x Line Item List Applet (Sales) |
Qty Req |
Order Entry - Line Items |
Quantity Requested |
S_ORDER_ITEM |
QTY_REQ |
STATUSINFO |
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 |
STATUSINFO |
(NET_VALUE) / (REQ_QTY) |
|
Item | Conditions |
Cond. Value |
|
| Order Entry - SAP 4x Line Item List Applet (Sales) |
Start Price |
Order Entry - Line Items |
Adjusted List Price |
S_ORDER_ITEM |
ADJ_UNIT_PRI |
STATUSINFO |
(NET_VALUE) / (REQ_QTY) |
|
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 |
STATUSINFO |
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 |
STATUSINFO |
REQ_DATE |
|
Item | Schedule Line | Quantities/dates |
Quantities/dates - Date type |
|
| Order Entry - SAP 4x Line Item List Applet (Sales) |
Comments |
Order Entry - Line Items |
Description |
S_ORDER_ITEM |
DESC_TEXT |
STATUSINFO |
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 |
STATUSINFO |
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 |
S_ORDER_ITEM.PROD_ID -> S_PROD_INT |
NAME |
STATUSINFO |
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 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Delivery Item
(Insert, Update, Delete from SAP to Siebel) |
|
|
|
|
|
|
|
|
|
|
|
|
| Siebel Client |
Siebel Object Manager |
Siebel Schema |
SAP Interface |
Transformation /
Lookup |
SAP User Interface |
|
| Applet |
Field |
Business
Component |
Field |
Table |
Column |
Parameter |
Field |
|
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 |
STATUSINFO |
DELIV_NUMB || DELIV_ITEM |
|
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 |
STATUSINFO |
DLV_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 |
STATUSINFO |
DELIV_NUMB || DELIV_ITEM |
|
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 |
STATUSINFO |
DELIV_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 |
N/A |
'Delivery' |
|
N/A |
N/A |
|
|
|
|
|
|
|
|
|
|
|
|
|