bluetelligence.de/wp …bluetelligence.de/.../downloads/2014/07/scenario-en.docx · web viewthis...
TRANSCRIPT
System: BW4
Scenario: SC_PUR_V2 - SC_PUR_V2
Table of contents1 Introduction.................................................................................................................................................12 Integration................................................................................................................................................... 23 Responsibilities..........................................................................................................................................24 ENTITY_LIST1.............................................................................................................................................25 VSD_M001 - MultiProvider Purchasing....................................................................................................36 Documentation of Entities.........................................................................................................................3
6.1 Reporting - Queries.....................................................................................................................................36.1.1 VSD_M001_Q0001 - Average delivery time - vendors.....................................................................................3
6.1.2 VSD_M001_Q0003 - Fulfillment rate - deliveries.............................................................................................3
6.1.3 VSD_M001_Q0004 - Values: Purchase order - delivery - invoice....................................................................4
6.1.4 VSD_M001_Q0011 - Purchase order quantities..............................................................................................46.2 Reporting - Restr. Key Figures....................................................................................................................4
6.2.1 VSD_M001_RK0001 - Average delivery time DACH.......................................................................................46.3 Reporting - Calc. Key Figures.....................................................................................................................4
6.3.1 VSD_M001_CKF0001 - Fulfillment rate - deliveries.........................................................................................4
6.3.2 VSD_M001_CKF0003 - Invoiced quantity as proportion of ordered quantity...................................................4
6.3.3 VSD_M001_CKF0004 - Average delivery time................................................................................................4
6.3.4 VSD_M001_CKF0005 - Average weighted delivery time.................................................................................5
6.3.5 VSD_M001_CKF0011 - Difference between PO quantity and returned quantity..............................................5
6.3.6 VSD_M001_CKF0013 - GR quantity as proportion of ordered quantity...........................................................5
6.3.7 VSD_M001_CKF0017 - Total items to be delivered.........................................................................................5
6.3.8 VSD_M001_CKF0018 - Deliveries as proportion of aggregate items...............................................................56.4 InfoProvider - Virtualization Layer...............................................................................................................6
6.4.1 VSD_M001 - MultiProvider Purchasing............................................................................................................66.5 InfoProvider - Reporting Layer..................................................................................................................39
6.5.1 RPU_C001 - Purchasing Data.......................................................................................................................39
6.5.2 RSD_C001 - Service Level: Order Items.......................................................................................................52
6.5.3 RSD_C002 - Service Level: Orders...............................................................................................................646.6 INFOPROVIDER_H..................................................................................................................................71
6.6.1 HPUR_O01 - Purchase Order Items (Harmonization)....................................................................................71
6.6.2 HSD_O001 - Order Items (Harmonization)....................................................................................................82
6.6.3 HSD_O003 - Orders......................................................................................................................................926.7 INFOPROVIDER_A...................................................................................................................................97
6.7.1 APUR_O01 - Purchase Order Items (Acquisition)..........................................................................................97
6.7.2 ASD_O001 - Order Items (Acquisition)........................................................................................................1067 Roles and Authorizations......................................................................................................................114
7.1 ZBI:DP_PUR_ACCESS/001 - DP - Purchase Access.......................................................................1147.1.1 Technical Documentation..................................................................................................................................114
1 IntroductionThe primary objective of the e-procurement is the reduction of process costs by reducing the processing and throughput times. Only secondarily reducing procurement costs through demand pooling and supplier segmentation is sought.
The reduction of process costs for e-procurement is carried out primarily through the provision of a compliant with general internal company policies merchandise catalog, from which all legitimate need carrier may operate. Thus, the procurement inherent in tasks such as search, initiation, negotiation and order processing, especially for items with high order frequency can be drastically reduced.
System: BW4
2 IntegrationThis information flow is ensured in the SAP system by the fact that the shopping is integrated into the overall system and having transitions to a variety of other SAP modules such as to :
Controlling ( CO)The interface to the cost accounting system ( controlling) can be seen especially in orders for supplies or services because they are directly attributable to a cost center or an order.
Financial Accounting (FI )Together with the Finance maintains the purchasing data of vendor defined in the system. For each vendor, a so-called vendor master record is maintained which contains both accounting data as well as for purchase information . The vendor master record is in financial accounting , the account of the vendor dar. In the assignment of orders for the purchase can also specify which general ledger accounts to be debited in Financial Accounting .
Sales and Distribution ( SD)As part of the disposition may be a need that has arisen from the sale , to theShopping can be transferred. Furthermore, the demand can be directly assigned to the sales order is already in the collection of the purchase requisition .
3 ResponsibilitiesFaculty:Nils Meyer [email protected] +49 611 1476400
IT:Torsten Schmidt [email protected] +49 611 1476400
4 ENTITY_LIST1Icon Type Technical Name Description long - De Changed
DateLast Changed By
MPRO VSD_M001 MultiProvider Beschaffung 18.12.2013 BLUETELL
CUBE RPU_C001 Einkaufsdaten 13.09.2013 BLUETELL
CUBE RPU_C004 Einkaufsdaten 20.08.2013 BLUETELL
CUBE RSD_C001 Servicegrad Auftragspositionen 20.08.2013 BLUETELL
CUBE RSD_C002 Servicegrad Aufträge 20.08.2013 BLUETELL
CUBE RSD_C003 Servicegrad Aufträge 20.08.2013 BLUETELL
ODSO HPUR_O01 Bestellpositionen 20.08.2013 BLUETELL
ODSO HSD_O001 Auftragspositionen 20.08.2013 BLUETELL
ODSO HSD_O003 Aufträge (Harm. Layer) 20.08.2013 BLUETELL
ODSO HSD_O004 HSD_O004 20.08.2013 BLUETELL
ODSO APUR_O01 Bestellpositionen (Aquisition Layer)
20.08.2013 BLUETELL
ODSO ASD_O001 Auftragspositionen (Aquisition Layer)
20.08.2013 BLUETELL
ODSO ASD_O003 Aufträge (Acquisition Layer) 20.08.2013 BLUETELL
ODSO ASD_O004 ASD_O004 20.08.2013 BLUETELL
System: BW4
5 VSD_M001 - MultiProvider Purchasing
6 Documentation of Entities
6.1 Reporting - Queries
6.1.1 VSD_M001_Q0001 - Average delivery time - vendors
6.1.1.1 Comment
6.1.1.1.1 ObjectiveThis Query allows to display a vendor's average delivery time. In the process, the material and the plant can be included in the analysis. In this way, you can obtain answers to the questions such as the following: "Who can deliver the material the fastest?" "Do a vendor's delivery times vary for different plants?" "How do certain vendor's delivery times compare with those of others?"
6.1.2 VSD_M001_Q0003 - Fulfillment rate - deliveries
6.1.2.1 Comment
6.1.2.1.1 ObjectiveThis Query allows to identify discrepancies between quantities of materials ordered and the quantities delivered.
3
System: BW4
6.1.3 VSD_M001_Q0004 - Values: Purchase order - delivery - invoice
6.1.3.1 Comment
6.1.3.1.1 ObjectiveWith this Query you can find information about the purchase order process. You can check how much of the material has already been delivered and which you have received invoices for, and/or how much of the material is still to be delivered and billed.
6.1.4 VSD_M001_Q0011 - Purchase order quantities
6.2 Reporting - Restr. Key Figures
6.2.1 VSD_M001_RK0001 - Average delivery time DACH
6.2.1.1 Technical Documentation
VSD_M001_RK0001 - Average delivery time DACHSystem: BW4 Timestamp of documentation: 11.04.2014 10:53:25
VSD_M001 MultiProvider Procurement
6.3 Reporting - Calc. Key Figures
6.3.1 VSD_M001_CKF0001 - Fulfillment rate - deliveries
6.3.1.1 Technical Documentation
VSD_M001_CKF0001 - Fulfillment rate - deliveriesSystem: BW4 Timestamp of documentation: 11.04.2014 10:53:29
VSD_M001 MultiProvider Procurement
6.3.2 VSD_M001_CKF0003 - Invoiced quantity as proportion of ordered quantity
6.3.2.1 Technical Documentation
VSD_M001_CKF0003 - Invoiced quantity as proportion of ordered quantitySystem: BW4 Timestamp of documentation: 11.04.2014 10:53:30
VSD_M001 MultiProvider Procurement
6.3.3 VSD_M001_CKF0004 - Average delivery time
6.3.3.1 Comment
6.3.3.1.1 ObjectiveIndicates the average number of days that elapse between placement of order and the receipt of the ordered goods.
6.3.3.2 Technical Documentation
VSD_M001_CKF0004 - Average delivery timeSystem: BW4 Timestamp of documentation: 11.04.2014 10:53:31
VSD_M001 MultiProvider Procurement
4
System: BW4
VSD_M001_CKF0004 - Average delivery time
6.3.4 VSD_M001_CKF0005 - Average weighted delivery time
6.3.4.1 Comment
6.3.4.1.1 ObjectiveIndicates the average number of days that elapse between placement of order and the receipt of the ordered goods, taking the GR quantity into account.
6.3.4.2 Technical Documentation
VSD_M001_CKF0005 - Average weighted delivery timeSystem: BW4 Timestamp of documentation: 11.04.2014 10:53:32
VSD_M001 MultiProvider Procurement
6.3.5 VSD_M001_CKF0011 - Difference between PO quantity and returned quantity
6.3.5.1 Technical Documentation
VSD_M001_CKF0011 - Difference between PO quantity and returned quantitySystem: BW4 Timestamp of documentation: 11.04.2014 10:53:33
VSD_M001 MultiProvider Procurement
6.3.6 VSD_M001_CKF0013 - GR quantity as proportion of ordered quantity
6.3.6.1 Technical Documentation
VSD_M001_CKF0013 - GR quantity as proportion of ordered quantitySystem: BW4 Timestamp of documentation: 11.04.2014 10:53:34
VSD_M001 MultiProvider Procurement
6.3.7 VSD_M001_CKF0017 - Total items to be delivered
6.3.7.1 Technical Documentation
VSD_M001_CKF0017 - Total items to be deliveredSystem: BW4 Timestamp of documentation: 11.04.2014 10:53:35
VSD_M001 MultiProvider Procurement
6.3.8 VSD_M001_CKF0018 - Deliveries as proportion of aggregate items
6.3.8.1 Technical Documentation
VSD_M001_CKF0018 - Deliveries as proportion of aggregate itemsSystem: BW4 Timestamp of documentation: 11.04.2014 10:53:36
VSD_M001 MultiProvider Procurement
5
System: BW4
6.4 InfoProvider - Virtualization Layer
6.4.1 VSD_M001 - MultiProvider Purchasing
6.4.1.1 Technical Documentation
6.4.1.1.1 General Information
System BW4
InfoProvider VSD_M001, MultiProvider Purchasing
Type MultiProvider
Last changed by USER01
Last change (timestamp) 08.04.2014 07:24:55
Timestamp of documentation 11.04.2014 10:53:51
6.4.1.1.2 Related Reporting Entities
Type Technical Name Description Changed Date Last Changed ByVSD_M001_Q0003 Fulfillment rate deliveries 08.04.2014 USER01
VSD_M001_Q0004 Values - Delivery - Invoice 08.04.2014 USER01
VSD_M001_Q0005 Average delivery time material 08.04.2014 USER01
VSD_M001_Q001 Average delivery time supplier 08.04.2014 USER01
VSD_M001_Q0012 ordering activities 08.04.2014 USER01
VSD_M001_Q0013 Suppliers with respect to comparison shopping values
08.04.2014 USER01
VSD_M001_RK0001 02.03.2014 USER01
VSD_M001_CKF0004 02.03.2014 USER01
6.4.1.1.3 Overview of Data Flow (up to DataSources)
MultiProvider Procurement (VSD_M001) Purchasing data (RPU_C001)
(7.x) Made to order (HPUR_O01)
Startroutine (7.x) Made to order (Aquisition Layer) (APUR_O01)
(7.x) 2LIS_02_ITM/E82CLNT800
(7.x) 2LIS_02_ITM/E81CLNT800
Level of service contract options (RSD_C001) Startroutine (7.x)
Job options (HSD_O001) Startroutine (7.x)
Job options (Aquisition Layer) (ASD_O001) (7.x)
2LIS_13_VDITM/E80CLNT800 (7.x)
2LIS_03_BF/E81CLNT800 Level of service jobs (RSD_C002)
Startroutine (7.x) Orders (HSD_O003)
(7.x) Orders (Aquisition Layer) (ASD_O003)
(7.x) 2LIS_11_VAITM/T90CLNT090
6
System: BW4
6.4.1.1.4 Involved InfoProviders
Type Name DescriptionCUBE RSD_C001 Level of service contract options
CUBE RSD_C002 Level of service jobs
CUBE RPU_C001 Purchasing data
6.4.1.1.5 Active Nav.-Attributes
InfoObject Nav.-Attribut Nav.-Attribut (Descr.) Mapping0COMP_CODE 0COMPANY Company for Company Code 0COMP_CODE__0COMPANY
(RSD_C002)
0SOLD_TO 0ACCNT_GRP Customer Account Group 0SOLD_TO__0ACCNT_GRP (RSD_C002)
6.4.1.1.6 Elements of the Provider
VSD_M001, MultiProvider PurchasingVSD_M001T VSD_M001T Type Length MappingCalendar Day 0CALDAY DATS 8 0CALDAY (RPU_C001)
0CALDAY (RSD_C001)0CALDAY (RSD_C002)
Calendar year/month 0CALMONTH NUMC 6 0CALMONTH (RPU_C001)0CALMONTH (RSD_C001)0CALMONTH (RSD_C002)
Calendar year / week 0CALWEEK NUMC 6 0CALWEEK (RPU_C001)0CALWEEK (RSD_C001)0CALWEEK (RSD_C002)
Fiscal year / period 0FISCPER NUMC 7 0FISCPER (RPU_C001)0FISCPER (RSD_C001)0FISCPER (RSD_C002)
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT (RPU_C001)0FISCVARNT (RSD_C001)0FISCVARNT (RSD_C002)
VSD_M001U VSD_M001UBase Unit of Measure 0BASE_UOM UNIT 3 0BASE_UOM (RPU_C001)
0BASE_UOM (RSD_C001)
Document currency 0DOC_CURRCY CUKY 5 0DOC_CURRCY (RSD_C001)0DOC_CURRCY (RSD_C002)
VSD_M0011 VSD_M0011Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN (RSD_C001)
0DISTR_CHAN (RSD_C002)
Division 0DIVISION CHAR 2 0DIVISION (RSD_C001)0DIVISION (RSD_C002)
Sales Organization 0SALESORG CHAR 4 0SALESORG (RSD_C001)0SALESORG (RSD_C002)
VSD_M0012 VSD_M0012Country Key 0COUNTRY CHAR 3 0COUNTRY (RPU_C001)
VSD_M0013 VSD_M0013Customer Group 1 0CUST_GRP1 CHAR 3 0CUST_GRP1 (RSD_C002)
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO (RSD_C001)0SOLD_TO (RSD_C002)
VSD_M0014 VSD_M0014Company code 0COMP_CODE CHAR 4 0COMP_CODE (RSD_C001)
0COMP_CODE (RSD_C002)
Sales group 0SALES_GRP CHAR 3 0SALES_GRP (RSD_C001)0SALES_GRP (RSD_C002)
7
System: BW4
Sales Office 0SALES_OFF CHAR 4 0SALES_OFF (RSD_C002)
VSD_M0015 VSD_M0015Date on which the record was created
0CREATEDON DATS 8 0CREATEDON (RSD_C001)0CREATEDON (RSD_C002)
Delivery Status 0DLV_STS CHAR 1 0DLV_STS (RSD_C001)0DLV_STS (RSD_C002)
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1 0DLV_STSOI (RSD_C002)
Delivered Complete 0STS_DLV_C CHAR 1 0STS_DLV_C (RSD_C001)0STS_DLV_C (RSD_C002)
Description Key Figures TypeReturns 0DITM_RET INT4 0DITM_RET (RSD_C002)
Perfect Order Fulfillment (Number)
0DLVIPOF INT4 0DLVIPOF (RSD_C002)
Perfect Order Fulfillment (Value)
0DLVVPOF CURR 0DOC_CURRCY
0DLVVPOF (RSD_C002)
Delivery Within 24 Hours 0DLV_24 INT4 0DLV_24 (RSD_C002)
Actual Delivered Value 0DLV_VAL CURR 0DOC_CURRCY
0DLV_VAL (RSD_C002)
Confirmed as Requested 0ICOASREQ INT4 0ICOASREQ (RSD_C001)0ICOASREQ (RSD_C002)
Delivery from Warehouse 0ISHP_STCK INT4 0ISHP_STCK (RSD_C001)0ISHP_STCK (RSD_C002)
Net value of the order in document currency
0NET_VAL_HD CURR 0DOC_CURRCY
0NET_VAL_HD (RSD_C002)
Number of orders 0ORDERS DEC 0ORDERS (RSD_C002)
Requested Delivery Value 0REQU_VAL CURR 0DOC_CURRCY
0REQU_VAL (RSD_C001)0REQU_VAL (RSD_C002)
Value with Delivery Within 24 Hours
0VAL_24 CURR 0DOC_CURRCY
0VAL_24 (RSD_C002)
Value of Returns 0VAL_RET CURR 0DOC_CURRCY
0VAL_RET (RSD_C002)
Number of purchase order items
0PO_ITEMS DEC 0PO_ITEMS (RPU_C001)
Order quantity 0PO_QTY QUAN 0BASE_UOM
0PO_QTY (RPU_C001)0PO_QTY (RSD_C001)
Order quantity (returns) 0PO_QTY_RET QUAN 0BASE_UOM
0PO_QTY_RET (RPU_C001)
Number of quotation items 0QUOT_ITEMS DEC 0QUOT_ITEMS (RPU_C001)
Total delivery time in days 0TOTDELTIME DEC 0TOTDELTIME (RPU_C001)
6.4.1.1.7 InfoCube RSD_C001 - Service Level: Order Items
6.4.1.1.7.1 General Information
System BW4
InfoProvider RSD_C001, Service Level: Order Items
Type InfoCube, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:29:58
Timestamp of documentation 11.04.2014 10:54:03
6.4.1.1.7.2 Buildup InfoProvider/Transform. from Source HSD_O001
Service Level: Order Items (RSD_C001)
Source: Job options (HSD_O001)RSD_C001T RSD_C001T Type Length Source/Value Aggr.Calendar Day 0CALDAY DATS 8 0CREATEDON
8
System: BW4
Calendar year/month 0CALMONTH NUMC 6 0CREATEDON
Calendar year / week 0CALWEEK NUMC 6 0CREATEDON
Fiscal year / period 0FISCPER NUMC 7 0CREATEDON
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
RSD_C001U RSD_C001UBase Unit of Measure 0BASE_UOM UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Local currency 0LOC_CURRCY CUKY 5
RSD_C0011 RSD_C0011Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Delivery Status 0DLV_STS CHAR 1 0DLV_STS
Overall delivery status of the item
0DLV_STSO CHAR 1 0DLV_STSO
Delivered Complete 0STS_DLV_C CHAR 1 RoutineConversion Exit: ALPHASource fields: 0BND_IND, 0DLV_QTY, 0RECORDMODE, 0REQU_QTY, 0SALES_UNIT, 0UPPR_BND
RSD_C0012 RSD_C0012Customer Group 0CUST_GROUP CHAR 2 0CUST_GROUP
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Payer 0PAYER CHAR 10 0PAYER
Ship-To Party 0SHIP_TO CHAR 10 0SHIP_TO
RSD_C0013 RSD_C0013Material 0MATERIAL CHAR 18 0MATERIAL
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Product hierarchy 0PROD_HIER CHAR 18 0PROD_HIER
RSD_C0014 RSD_C0014Company code 0COMP_CODE CHAR 4 0COMP_CODE
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Plant 0PLANT CHAR 4 0PLANT
Shipping point 0SHIP_POINT CHAR 4 0SHIP_POINT
RSD_C0015 RSD_C0015Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales Organization 0SALESORG CHAR 4 0SALESORG
Division 0DIVISION CHAR 2 0DIVISION
RSD_C0016 RSD_C0016Forw.Agent 0FORWAGENT CHAR 10 0FORWAGENT
RSD_C0017 RSD_C0017Batch number 0BATCH CHAR 10 0BATCH
RSD_C0018 RSD_C0018ZDPDOCNUM CHAR 10 ZDPDOCNUM
Key Figures Description Type Unit Source/Value Aggr.Value Confirmed as Requested
0VCOASREQ CURR 0DOC_CURRCY
Value with Delivery from Warehouse
0VSHP_STCK CURR 0DOC_CURRCY
Net value of the order item in document currency
0NET_VALUE CURR 0DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR 0DOC_C
9
System: BW4
URRCY
Net price 0NETPRICE CURR 0LOC_CURRCY
Order quantity 0PO_QTY QUAN 0BASE_UOM
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4
Number of Document Items 0DOC_ITEMS DEC
Confirmed as Requested 0ICOASREQ INT4
Delivery from Warehouse 0ISHP_STCK INT4
6.4.1.1.7.2.1 Look-Ups and calls of subprograms
Look-Ups IOBJ 0COMP_CODE - Company code (Start Routine)
6.4.1.1.7.2.2 Details routines from source: HSD_O001Source: HSD_O001(Job options) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:57:24
Declarations
data lt_comp_code type table of /BI0/PCOMP_CODE.
Declarations, 2nd part... "insert your code here
Start Routine
"Company Codes puffern Select * from /BI0/PCOMP_CODE into table lt_comp_code.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
InfoObject Routines 0STS_DLV_C
DATA: l_bnd_lowr LIKE SOURCE_FIELDS-requ_qty, l_bnd_uppr LIKE SOURCE_FIELDS-requ_qty.
IF SOURCE_FIELDS-recordmode EQ ' ' OR SOURCE_FIELDS-recordmode EQ 'N'. IF SOURCE_FIELDS-bnd_ind EQ 'X'. IF SOURCE_FIELDS-dlv_qty GE SOURCE_FIELDS-requ_qty. RESULT = 'X'. ENDIF. ELSE. l_bnd_uppr = SOURCE_FIELDS-requ_qty * ( 1 + SOURCE_FIELDS-uppr_bnd ). IF SOURCE_FIELDS-dlv_qty GE l_bnd_uppr. RESULT = 'X'. ENDIF. ENDIF. ENDIF.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries... "to cancel the update process* raise exception type CX_RSROUT_ABORT.... "to skip a record* raise exception type CX_RSROUT_SKIP_RECORD.... "to clear target fields* raise exception type CX_RSROUT_SKIP_VAL.
10
System: BW4
6.4.1.1.7.2.3 DTPs of Transformation 'ODSO HSD_O001 -> CUBE RSD_C001'
6.4.1.1.7.2.3.1 DTP HSD_O001 -> RSD_C001
6.4.1.1.7.2.3.1.1 General Information
Parameter ValueTech. Name DTP_DH7RKRRM01HF3YOVL5MS8D6EL
Type Standard (Can Be Scheduled)
Source, Target ODSO HSD_O001 -> CUBE RSD_C001
Last changed by USER01
Date, time 08.04.2014 07:29:57
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.4.1.1.8 InfoCube RSD_C002 - Service Level: Orders
6.4.1.1.8.1 General Information
System BW4
InfoProvider RSD_C002, Service Level: Orders
Type InfoCube, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:27:37
Timestamp of documentation 11.04.2014 10:54:22
6.4.1.1.8.2 Active Nav.-Attributes
InfoObject Nav.-Attribut Nav.-Attribut (Descr.)0COMP_CODE 0COMPANY Company for Company Code
0SOLD_TO 0ACCNT_GRP Customer Account Group
6.4.1.1.8.3 Buildup InfoProvider/Transform. from Source HSD_O003
Service Level: Orders (RSD_C002)
Source: Orders (HSD_O003)RSD_C002T RSD_C002T Type Length Source/Value Aggr.Calendar Day 0CALDAY DATS 8 0CREATEDON
Calendar year/month 0CALMONTH NUMC 6 0CREATEDON
Calendar year / week 0CALWEEK NUMC 6 0CREATEDON
Fiscal year / period 0FISCPER NUMC 7 0CREATEDON
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
RSD_C002U RSD_C002UDocument currency 0DOC_CURRCY CUKY 5
RSD_C0021 RSD_C0021Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Delivery Status 0DLV_STS CHAR 1 0DLV_STS
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1 0DLV_STSOI
Delivered Complete 0STS_DLV_C CHAR 1
RSD_C0022 RSD_C0022Customer Group 1 0CUST_GRP1 CHAR 3
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
RSD_C0023 RSD_C0023
11
System: BW4
Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales Organization 0SALESORG CHAR 4 0SALESORG
Division 0DIVISION CHAR 2 0DIVISION
RSD_C0024 RSD_C0024Company code 0COMP_CODE CHAR 4 0COMP_CODE
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Office 0SALES_OFF CHAR 4 0SALES_OFF
RSD_C0025 RSD_C0025ZDPDOCNUM CHAR 10 ZDPDOCNUM
Key Figures Description Type Unit Source/Value Aggr.Returns 0DITM_RET INT4 0DITM_RET Summ.
Delivery Within 24 Hours 0DLV_24 INT4 0DLV_24 Summ.
Confirmed as Requested 0ICOASREQ INT4 0ICOASREQ Summ.
Delivery from Warehouse 0ISHP_STCK INT4
Value Confirmed as Requested
0VCOASREQ CURR 0DOC_CURRCY
0VCOASREQ [0DOC_CURRCY]
Summ.
Value with Delivery from Warehouse
0VSHP_STCK CURR 0DOC_CURRCY
Number of orders 0ORDERS DEC
Requested Delivery Value 0REQU_VAL CURR 0DOC_CURRCY
0REQU_VAL [0DOC_CURRCY]
Summ.
Perfect Order Fulfillment (Number)
0DLVIPOF INT4
Perfect Order Fulfillment (Value)
0DLVVPOF CURR 0DOC_CURRCY
Value with Delivery Within 24 Hours
0VAL_24 CURR 0DOC_CURRCY
0VAL_24 [0DOC_CURRCY] Summ.
Value of Returns 0VAL_RET CURR 0DOC_CURRCY
0VAL_RET [0DOC_CURRCY] Summ.
Net value of the order in document currency
0NET_VAL_HD CURR 0DOC_CURRCY
0NET_VAL_HD [0DOC_CURRCY]
Summ.
Actual Delivered Value 0DLV_VAL CURR 0DOC_CURRCY
0DLV_VAL [0DOC_CURRCY] Summ.
6.4.1.1.8.3.1 Details routines from source: HSD_O003Source: HSD_O003(Orders) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:58:21
Declarations ... "insert your code here
Declarations, 2nd part... "insert your code here
Start Routine
loop at SOURCE_PACKAGE ASSIGNING <SOURCE_FIELDS>. if <SOURCE_FIELDS>-DOC_CURRCY Ne 'EUR' and <SOURCE_FIELDS>-DIVISION = '1000'. delete SOURCE_PACKAGE. endif. endloop.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.4.1.1.8.3.2 DTPs of Transformation 'ODSO HSD_O003 -> CUBE RSD_C002'
6.4.1.1.8.3.2.1 DTP HSD_O003 -> RSD_C002
12
System: BW4
6.4.1.1.8.3.2.1.1 General Information
Parameter ValueTech. Name DTP_DH7RUYL16SVVULXT1UVIF0SZ1
Type Standard (Can Be Scheduled)
Source, Target ODSO HSD_O003 -> CUBE RSD_C002
Last changed by USER01
Date, time 08.04.2014 07:27:37
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.4.1.1.9 InfoCube RPU_C001 - Purchasing Data
6.4.1.1.9.1 General Information
System BW4
InfoProvider RPU_C001, Purchasing Data
Type InfoCube, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:26:33
Timestamp of documentation 11.04.2014 10:54:36
6.4.1.1.9.2 Buildup InfoProvider/Transform. from Source HPUR_O01
Purchasing Data (RPU_C001)
Source: Made to order (HPUR_O01)RPU_C001T RPU_C001T Type Length Source/Value Aggr.Calendar Day 0CALDAY DATS 8 0CREATEDON
Calendar year/month 0CALMONTH NUMC 6 0CREATEDON
Calendar year 0CALYEAR NUMC 4 0CREATEDON
Calendar year / week 0CALWEEK NUMC 6 0CREATEDON
Fiscal year / period 0FISCPER NUMC 7 0CREATEDON
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
RPU_C001U RPU_C001UBase Unit of Measure 0BASE_UOM UNIT 3
Local currency 0LOC_CURRCY CUKY 5
RPU_C0011 RPU_C0011Country Key 0COUNTRY CHAR 3
Key Figures Description Type Unit Source/Value Aggr.Invoice receipt quantity 0IV_REC_QTY QUAN 0BASE_
UOM
Effective purchase order value 0ORDER_VAL CURR 0LOC_CURRCY
Target delivery quantity 0TAR_DL_QTY QUAN 0BASE_UOM
Order quantity (returns) 0PO_QTY_RET QUAN 0BASE_UOM
Number of contract items 0CONTR_ITEM DEC
Number of scheduling agreement schedule lines
0DEL_SCHEDS DEC
Number of purchase order items
0PO_ITEMS DEC
Order quantity 0PO_QTY QUAN 0BASE_UOM
13
System: BW4
Number of quotation items 0QUOT_ITEMS DEC
Number of request for quotation items
0RFQ_ITEMS DEC
Total delivery time in days 0TOTDELTIME DEC
6.4.1.1.9.2.1 DTPs of Transformation 'ODSO HPUR_O01 -> CUBE RPU_C001'
6.4.1.1.9.2.1.1 DTP HPUR_O01 -> RPU_C001
6.4.1.1.9.2.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4DMYRUHJTYJUKPX2U85ZKX9
Type Standard (Can Be Scheduled)
Source, Target ODSO HPUR_O01 -> CUBE RPU_C001
Last changed by USER01
Date, time 08.04.2014 07:26:33
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.4.1.1.9.2.1.1.2 Filter
Field Description SelectionITEM_DEL Item Deleted <> #
6.4.1.1.10 DSO HSD_O001 - Job options
6.4.1.1.10.1 General Information
System BW4
InfoProvider HSD_O001, Job options
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:57:24
Timestamp of documentation 11.04.2014 10:54:47
6.4.1.1.10.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.4.1.1.10.3 Buildup InfoProvider/Transform. from Source ASD_O001
Job options (HSD_O001)
Source: Job options (Aquisition Layer) (ASD_O001)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Sales document item 0S_ORD_ITEM NUMC 6 0S_ORD_ITEM
Data Fields, CharacteristicsDelivery Status 0DLV_STS CHAR 1 0DLV_STS
Overall delivery status of the item
0DLV_STSO CHAR 1 0DLV_STSO
14
System: BW4
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Material 0MATERIAL CHAR 18 0MATERIAL
Batch number 0BATCH CHAR 10 0BATCH
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Company code 0COMP_CODE CHAR 4 0COMP_CODE
Customer Group 0CUST_GROUP CHAR 2 0CUST_GROUP
Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Organization 0SALESORG CHAR 4 0SALESORG
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Product hierarchy 0PROD_HIER CHAR 18 0PROD_HIER
Plant 0PLANT CHAR 4 0PLANT
Ship-To Party 0SHIP_TO CHAR 10 0SHIP_TO
Shipping point 0SHIP_POINT CHAR 4 0SHIP_POINT
Division 0DIVISION CHAR 2 0DIVISION
Forw.Agent 0FORWAGENT CHAR 10 0FORWAGENT
Payer 0PAYER CHAR 10 0PAYER
Document currency 0DOC_CURRCY CUKY 5 0DOC_CURRCY
Item Deleted 0ITEM_DEL CHAR 1 0ITEM_DEL
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Independent of Delivery Tolerances
0BND_IND CHAR 1 0BND_IND
Sales unit 0SALES_UNIT UNIT 3 0SALES_UNIT
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitTolerance Limit for Under Delivery in %
0LOWR_BND DEC 0LOWR_BND Replace
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC 0UPPR_BND Replace
Net price 0NET_PRICE CURR DOC_CURRCY
0NET_PRICE Replace
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
0NETPR_VKM Replace
Quantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
0QCOASREQ Replace
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
0CONF_QTY Replace
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
0REQU_QTY Replace
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
0DLV_QTY Replace
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
0GIS_QTY Replace
6.4.1.1.10.3.1 Look-Ups and calls of subprograms
Look-Ups IOBJ 0MATERIAL - Material (Start Routine) IOBJ 0CUST_GROUP - Customer Group (Start Routine) DSO ASD_O001 - Job options (Aquisition Layer) (Start Routine)
6.4.1.1.10.3.2 Details routines from source: ASD_O001Source: ASD_O001(Job options (Aquisition Layer)) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:57:24
15
System: BW4
Declarations
DATA lt_material TYPE TABLE OF /bi0/pmaterial. DATA lt_sd TYPE TABLE OF /bic/aasd_o00100. DATA lt_cust TYPE TABLE OF /bi0/pcust_group.
Declarations, 2nd part... "insert your code here
Start Routine
SELECT * FROM /bi0/pmaterial INTO TABLE lt_material.
SELECT * FROM /bi0/pcust_group INTO TABLE lt_cust.
SELECT * FROM /bic/aasd_o00100 INTO TABLE lt_sd.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.4.1.1.10.3.3 DTPs of Transformation 'ODSO ASD_O001 -> ODSO HSD_O001'
6.4.1.1.10.3.3.1 DTP ASD_O001 -> HSD_O001
6.4.1.1.10.3.3.1.1 General Information
Parameter ValueTech. Name DTP_DH7RLNWVJ0KV8NDI9SVUCK1PP
Type Standard (Can Be Scheduled)
Source, Target ODSO ASD_O001 -> ODSO HSD_O001
Last changed by USER01
Date, time 12.03.2014 09:40:55
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.4.1.1.11 DSO HSD_O003 - Orders
6.4.1.1.11.1 General Information
System BW4
InfoProvider HSD_O003, Orders
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:58:21
Timestamp of documentation 11.04.2014 10:54:57
6.4.1.1.11.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.4.1.1.11.3 Buildup InfoProvider/Transform. from Source ASD_O003
Orders (HSD_O003)
16
System: BW4
Source: Orders (Aquisition Layer) (ASD_O003)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Delivery Status 0DLV_STS CHAR 1 0DLV_STS
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Company code 0COMP_CODE CHAR 4 0COMP_CODE
Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Office 0SALES_OFF CHAR 4 0SALES_OFF
Sales Organization 0SALESORG CHAR 4 0SALESORG
Division 0DIVISION CHAR 2 0DIVISION
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1 0DLV_STSOI
Document currency 0DOC_CURRCY CUKY 5 0DOC_CURRCY
Header Deleted 0HEADER_DEL CHAR 1 0HEADER_DEL
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNumber of Document Items 0DOC_ITEMS DEC 0DOC_ITEMS Replace
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4 0CUML_TME Replace
Returns 0DITM_RET INT4 0DITM_RET Replace
Value of Returns 0VAL_RET CURR DOC_CURRCY
0VAL_RET Replace
Confirmed as Requested 0ICOASREQ INT4
Value Confirmed as Requested
0VCOASREQ CURR DOC_CURRCY
Delivery Within 24 Hours 0DLV_24 INT4
Value with Delivery Within 24 Hours
0VAL_24 CURR DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR DOC_CURRCY
0REQU_VAL Replace
Actual Delivered Value 0DLV_VAL CURR DOC_CURRCY
0DLV_VAL Replace
Net value of the order in document currency
0NET_VAL_HD CURR DOC_CURRCY
0NET_VAL_HD Replace
6.4.1.1.12 DSO HPUR_O01 - Made to order
6.4.1.1.12.1 General Information
System BW4
InfoProvider HPUR_O01, Made to order
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:48:17
Timestamp of documentation 11.04.2014 10:55:03
6.4.1.1.12.2 Settings
SIDs Generation upon Activation -
17
System: BW4
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.4.1.1.12.3 Buildup InfoProvider/Transform. from Source APUR_O01
Made to order (HPUR_O01)
Source: Made to order (Aquisition Layer) (APUR_O01)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Purchasing document number 0OI_EBELN CHAR 10 0OI_EBELN
Item number of purchasing document
0OI_EBELP NUMC 5 0OI_EBELP
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Material 0MATERIAL CHAR 18 0MATERIAL
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Plant 0PLANT CHAR 4 0PLANT
Purchasing organization 0PURCH_ORG CHAR 4 0PURCH_ORG
Vendor 0VENDOR CHAR 10 0VENDOR
Local currency 0LOC_CURRCY CUKY 5 0LOC_CURRCY
Base Unit of Measure 0BASE_UOM UNIT 3 0BASE_UOM
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1 0COMPL_DEL
Purchasing Group 0PUR_GROUP CHAR 3 0PUR_GROUP
Storage location 0STOR_LOC CHAR 4 0STOR_LOC
Goods Supplier 0SUPPLIER CHAR 10 0SUPPLIER
Supplying vendor 0SUPPL_VEND CHAR 10 0SUPPL_VEND
Supplying Plant 0SUPP_PLANT CHAR 4 0SUPP_PLANT
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10 0SUP_PLANT
Item Deleted 0ITEM_DEL CHAR 1 0ITEM_DEL
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNet price 0NETPRICE CURR LOC_CU
RRCY0NETPRICE Replace
Price unit 0PRICE_UNIT DEC 0PRICE_UNIT Replace
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC 0UPPR_BND Replace
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC 0LOWR_BND Replace
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
0PQCOASREQ Replace
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
0PCONF_QTY Replace
Actual Delivered Value 0PDLV_VAL CURR LOC_CURRCY
6.4.1.1.12.3.1 Look-Ups and calls of subprograms
Look-Ups
18
System: BW4
TABL tcurr - Umrechnungskurse (Start Routine)
6.4.1.1.12.3.2 Details routines from source: APUR_O01Source: APUR_O01(Made to order (Aquisition Layer)) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:49:12
Declarations
DATA lt_tcurr TYPE TABLE OF tcurr.
Declarations, 2nd part... "insert your code here
Start Routine
SELECT * FROM tcurr INTO TABLE lt_tcurr.
BREAK-POINT.
* Exclude deleted datasets LOOP AT SOURCE_PACKAGE ASSIGNING <source_fields>. IF ( <source_fields>-processkey NE '001' AND <source_fields>-processkey NE '011' AND <source_fields>-processkey NE '021' AND <source_fields>-processkey NE '002' AND <source_fields>-processkey NE '012' AND <source_fields>-processkey NE '022').* see OSS note 636914 ENDIF. ENDLOOP.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.4.1.1.12.3.3 DTPs of Transformation 'ODSO APUR_O01 -> ODSO HPUR_O01'
6.4.1.1.12.3.3.1 DTP APUR_O01 -> HPUR_O01
6.4.1.1.12.3.3.1.1 General Information
Parameter ValueTech. Name DTP_DH4GM0MM62QJ925NINB7BSA7H
Type Standard (Can Be Scheduled)
Source, Target ODSO APUR_O01 -> ODSO HPUR_O01
Last changed by USER01
Date, time 26.02.2014 08:52:35
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.4.1.1.13 DSO ASD_O001 - Job options (Aquisition Layer)
6.4.1.1.13.1 General Information
System BW4
InfoProvider ASD_O001, Job options (Aquisition Layer)
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:44:10
Timestamp of documentation 11.04.2014 10:55:13
6.4.1.1.13.2 Settings
SIDs Generation upon Activation -
19
System: BW4
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.4.1.1.13.3 Buildup InfoProvider/Transform. from Source 2LIS_13_VDITM/E80CLNT800
Job options (Aquisition Layer) (ASD_O001)
Source: Billing Document Item Data (2LIS_13_VDITM/E80CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 VBELN
Sales document item 0S_ORD_ITEM NUMC 6 POSNR
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 AEDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
Batch number 0BATCH CHAR 10
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
20
System: BW4
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.4.1.1.13.3.1 Buildup of DataSource 2LIS_13_VDITM/E80CLNT800
2LIS_13_VDITM, Billing Document Item Data (Source System: E80CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Sales and Distribution Document Number VBELN CHAR 10 ALPHA internal
Item number of the SD document POSNR NUMC 6 internal
Changed On AEDAT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Sales district BZIRK CHAR 6 internal
Billing Type FKART CHAR 4 internal
Billing date for billing index and printout FKDAT DATS 8 internal
Billing category FKTYP CHAR 1 internal
Local Currency HWAER CUKY 5 internal
Customer group KDGRP CHAR 2 internal
Sold-to party KUNAG CHAR 10 ALPHA internal
Payer KUNRG CHAR 10 ALPHA internal
Exchange rate for FI postings KURRF DEC 9,5 EXCRT internal
Exchange Rate Type KURST CHAR 4 internal
Statistics currency STWAE CUKY 5 internal
SD document category VBTYP CHAR 1 internal
Sales Organization VKORG CHAR 4 internal
Distribution Channel VTWEG CHAR 2 internal
SD Document Currency WAERK CUKY 5 internal
Promotion AKTNR CHAR 10 ALPHA internal
Sales Document AUBEL CHAR 10 ALPHA internal
Sales Document Item AUPOS NUMC 6 internal
Rebate basis 1 BONBA CURR 13,2 internal
Volume rebate group BONUS CHAR 2 internal
Gross weight BRGEW QUAN 15,3 internal
Gross value of the billing item in document currency BRTWR CURR 15,2 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
International Article Number (EAN/UPC) EAN11 CHAR 18 EAN11 internal
Date on Which Record Was Created ERDAT DATS 8 internal
Rule in billing plan/invoice plan FAREG CHAR 1 internal
Date on which services rendered FBUDA DATS 8 internal
Actual Invoiced Quantity FKIMG QUAN 13,3 internal
Billing quantity in stockkeeping unit FKLMG QUAN 13,3 internal
Weight Unit GEWEI UNIT 3 CUNIT internal
Sales deal KNUMA_AG CHAR 10 ALPHA internal
Controlling Area KOKRS CHAR 4 internal
21
System: BW4
Cost Center KOSTL CHAR 10 ALPHA internal
Exchange Rate for Price Determination KURSK DEC 9,5 EXCRT internal
Translation Date KURSK_DAT DATS 8 internal
Customer group 1 KVGR1 CHAR 3 internal
Customer group 2 KVGR2 CHAR 3 internal
Customer group 3 KVGR3 CHAR 3 internal
Customer group 4 KVGR4 CHAR 3 internal
Customer group 5 KVGR5 CHAR 3 internal
Subtotal 1 from pricing procedure for condition KZWI1 CURR 13,2 internal
Subtotal 2 from pricing procedure for condition KZWI2 CURR 13,2 internal
Subtotal 3 from pricing procedure for condition KZWI3 CURR 13,2 internal
Subtotal 4 from pricing procedure for condition KZWI4 CURR 13,2 internal
Subtotal 5 from pricing procedure for condition KZWI5 CURR 13,2 internal
Subtotal 6 from pricing procedure for condition KZWI6 CURR 13,2 internal
Storage Location LGORT CHAR 4 internal
Required quantity for mat.management in stockkeeping units LMENG QUAN 13,3 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 MATN1 internal
Material entered MATWA CHAR 18 MATN1 internal
Base Unit of Measure MEINS UNIT 3 CUNIT internal
Material group 1 MVGR1 CHAR 3 internal
Material group 2 MVGR2 CHAR 3 internal
Material group 3 MVGR3 CHAR 3 internal
Material group 4 MVGR4 CHAR 3 internal
Material group 5 MVGR5 CHAR 3 internal
Tax amount in document currency MWSBP CURR 13,2 internal
Net value of the billing item in document currency NETWR CURR 15,2 internal
Net weight NTGEW QUAN 15,3 internal
Bill-to party PKUNRE CHAR 10 ALPHA internal
Ship-to party PKUNWE CHAR 10 ALPHA internal
Item type POSAR CHAR 1 internal
Product hierarchy PRODH CHAR 18 internal
Commission group PROVG CHAR 2 internal
Date for pricing and exchange rate PRSDT DATS 8 internal
Sales document item category PSTYV CHAR 4 internal
Sales employee PVRTNR NUMC 8 internal
Amount eligible for cash discount in document currency SKFBP CURR 13,2 internal
Scale quantity in base unit of measure SMENG QUAN 13,3 internal
Division for order header SPARA CHAR 2 internal
Division SPART CHAR 2 internal
Statistics date STADAT DATS 8 internal
Exchange rate for statistics (Exch.rate at time of creation) STCUR DEC 9,5 EXCRT internal
Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 internal
Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 internal
Date of update for statistics updating VDATU DATS 8 internal
Document number of the reference document VGBEL CHAR 10 ALPHA internal
Item number of the reference item VGPOS NUMC 6 internal
Sales Office VKBUR CHAR 4 internal
Sales Group VKGRP CHAR 3 internal
Volume unit VOLEH UNIT 3 CUNIT internal
Volume VOLUM QUAN 15,3 internal
Sales unit VRKME UNIT 3 CUNIT internal
22
System: BW4
Shipping Point/Receiving Point VSTEL CHAR 4 internal
Cost in document currency WAVWR CURR 13,2 internal
Plant WERKS CHAR 4 internal
Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 ABPSN internal
Number of billing items ANZFKPOS DEC 9 internal
Fiscal Year Variant PERIV CHAR 2 internal
6.4.1.1.13.3.1.1 InfoPackage 2LIS_13_VDITM info package
6.4.1.1.13.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DFULHSVK8SM93DK4KU1FM2RHP
InfoSource
DataSource 2LIS_13_VDITM
Data Type Transaction data
Source System E80CLNT800
Delete content of Data Target -
Last changed by USER04
Date, time 15.08.2013 15:06:29
6.4.1.1.13.3.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.4.1.1.13.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.4.1.1.13.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.4.1.1.13.4 Buildup InfoProvider/Transform. from Source 2LIS_03_BF/E81CLNT800
Job options (Aquisition Layer) (ASD_O001)
Source: Goods Movements From Inventory Management (2LIS_03_BF/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 AKTNR
Sales document item 0S_ORD_ITEM NUMC 6 AUFNR
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BLDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
23
System: BW4
Batch number 0BATCH CHAR 10
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.4.1.1.13.4.1 DTPs of Transformation 'RSDS 2LIS_03_BF/E81CLNT800 -> ODSO ASD_O001'
6.4.1.1.13.4.1.1 DTP 2LIS_03_BF E81CLNT800 -> ASD_O001
6.4.1.1.13.4.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4GMAKVJS9SDBE3L301Q4JHP
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_03_BF E81CLNT800 -> ODSO ASD_O001
Last changed by USER01
Date, time 26.02.2014 08:53:35
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
24
System: BW4
Batch Parameter 3 parallel processes, Job Class 'C'
6.4.1.1.13.4.1.1.2 Filter
Field Description SelectionBLDAT [ ] 20120101 - 99991231
6.4.1.1.13.4.1.1.3 Semantic Groups
Field DescriptionAKTNR
AUFNR
6.4.1.1.13.4.2 Buildup of DataSource 2LIS_03_BF/E81CLNT800
2LIS_03_BF, Goods Movements From Inventory Management (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Promotion AKTNR CHAR 10 internal
Order Number AUFNR CHAR 12 internal
Routing number of operations in the order AUFPL NUMC 10 internal
Valuation Class BKLAS CHAR 4 internal
Document Date in Document BLDAT DATS 8 internal
Delivery costs in local currency BNBTR CURR 15,2 internal
Stock Values in the Logistics Information System BSTAUS CHAR 1 internal
Stock categories in the Logistics Information System BSTTYP CHAR 1 internal
Posting Date in the Document BUDAT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Application Component BWAPPLNM CHAR 30 internal
Movement Type (Inventory Management) BWART CHAR 3 internal
BW: Stock Relevance BWBREL CHAR 1 internal
BW: Unique Identification of Line Item BWCOUNTER NUMC 6 internal
BW: Cost Value in Local Currency BWGEO CURR 19,2 internal
BW: Retail Value in Local Currency BWGVO CURR 19,2 internal
BW: Retail Value with Tax in Local Currency BWGVP CURR 19,2 internal
Valuation Area BWKEY CHAR 4 internal
BW: Quantity in Base Unit of Measure BWMNG QUAN 15,3 internal
Work Breakdown Structure Element (External) BWPSPEX CHAR 24 internal
Valuation Type BWTAR CHAR 10 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
Amount in local currency DMBTR CURR 15,2 internal
Purchasing Document Number EBELN CHAR 10 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
Unit of Entry ERFME UNIT 3 internal
Quantity in Unit of Entry ERFMG QUAN 13,3 internal
Reason for goods movment GRUND NUMC 4 internal
Business Area GSBER CHAR 4 internal
Sales Order Number KDAUF CHAR 10 internal
Delivery Schedule for Sales Order KDEIN NUMC 4 internal
Item Number in Sales Order KDPOS NUMC 6 internal
Controlling Area KOKRS CHAR 4 internal
Cost Center KOSTL CHAR 10 internal
Cost Object KSTRG CHAR 12 internal
Account Number of Customer KUNNR CHAR 10 internal
25
System: BW4
Movement Indicator KZBEW CHAR 1 internal
Valuation of Special Stock KZBWS CHAR 1 internal
Warehouse Number / Warehouse Complex LGNUM CHAR 3 internal
Storage Location LGORT CHAR 4 internal
Storage Bin LGPLA CHAR 10 internal
Storage Type LGTYP CHAR 3 internal
Vendor Account Number LIFNR CHAR 10 internal
Material Number MATNR CHAR 18 internal
Number of Material Document MBLNR CHAR 10 internal
Base Unit of Measure MEINS UNIT 3 internal
Quantity MENGE QUAN 15,3 internal
Material Document Year MJAHR NUMC 4 internal
Network Number for Account Assignment NPLNR CHAR 12 internal
WMS Number of pallets PALAN DEC 11 internal
Profitability Segment Number (CO-PA) PAOBJNR NUMC 10 internal
Profit Center PRCTR CHAR 10 internal
Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 internal
G/L Account Number SAKTO CHAR 10 internal
Debit/Credit Indicator SHKZG CHAR 1 internal
Special Stock Indicator SOBKZ CHAR 1 internal
Receiving/Issuing Plant UMWRK CHAR 4 internal
Local Currency WAERS CUKY 5 internal
Goods Recipient/Ship-To Party WEMPF CHAR 12 internal
Plant WERKS CHAR 4 internal
Item in Material Document ZEILE NUMC 4 internal
Fiscal Year Variant PERIV CHAR 2 internal
Counter for Items NOPOS DEC 3 internal
EA Retail BW Extr. Enhancement: Item Type ITEM_CAT NUMC 2 internal
EA Retail BW Extr. Enhancement: Data Record Type REC_TYPE NUMC 1 internal
Material Category ATTYP CHAR 2 internal
Plant category VLFKZ CHAR 1 internal
Item automatically created SAUTO CHAR 1 internal
Structured material MATST CHAR 18 internal
Value at Sales Prices Including Value-Added Tax VKSTT CURR 13,2 internal
Value at sales prices excluding value-added tax VKSTA CURR 13,2 internal
Indicator: Movement type is stock transfer UMLKZ CHAR 1 internal
Indicator: Return from call RETKZ CHAR 1 internal
Indicator: Movement type is physical inventory INVKZ CHAR 1 internal
Indicator: Movement type is inventory correction KORR CHAR 1 internal
Transfer Posting Material to Material UMMATKZ CHAR 1 internal
Currency Key WAERSST CUKY 5 internal
6.4.1.1.14 DSO ASD_O003 - Orders (Aquisition Layer)
6.4.1.1.14.1 General Information
System BW4
InfoProvider ASD_O003, Orders (Aquisition Layer)
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:55:58
Timestamp of documentation 11.04.2014 10:55:31
26
System: BW4
6.4.1.1.14.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.4.1.1.14.3 Buildup InfoProvider/Transform. from Source 2LIS_11_VAITM/T90CLNT090
Orders (Aquisition Layer) (ASD_O003)
Source: Sales Document Item Data (2LIS_11_VAITM/T90CLNT090)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 VBELN
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 PERIV
Date on which the record was created
0CREATEDON DATS 8 ERDAT
Header Deleted 0HEADER_DEL CHAR 1
Delivery Status 0DLV_STS CHAR 1
Sold-to party 0SOLD_TO CHAR 10 KUNNRConversion Exit: ALPHA
Company code 0COMP_CODE CHAR 4 BUKRS
Distribution Channel 0DISTR_CHAN CHAR 2 VTWEG
Sales group 0SALES_GRP CHAR 3 VKGRP
Sales Office 0SALES_OFF CHAR 4 VKBUR
Sales Organization 0SALESORG CHAR 4 VKORG
Division 0DIVISION CHAR 2 SPART
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1
Document currency 0DOC_CURRCY CUKY 5 WAERK
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNumber of Document Items 0DOC_ITEMS DEC
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4
Returns 0DITM_RET INT4
Value of Returns 0VAL_RET CURR DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR DOC_CURRCY
Actual Delivered Value 0DLV_VAL CURR DOC_CURRCY
Net value of the order in document currency
0NET_VAL_HD CURR DOC_CURRCY
6.4.1.1.14.3.1 Buildup of DataSource 2LIS_11_VAITM/T90CLNT090
2LIS_11_VAITM, Sales Document Item Data (Source System: T90CLNT090)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Sales and Distribution Document Number VBELN CHAR 10 internal
Rejection status for SD item ABSTA CHAR 1 internal
Item number of the SD document POSNR NUMC 6 internal
General Incompletion Status of Item UVALL CHAR 1 internal
27
System: BW4
Item Incompletion Status with Respect to Billing UVFAK CHAR 1 internal
Pricing for item is incomplete UVPRS CHAR 1 internal
Incompletion status of the item with regard to delivery UVVLK CHAR 1 internal
Quotation/Inquiry is valid from ANGDT DATS 8 internal
Sales Document Type AUART CHAR 4 internal
Order reason (reason for the business transaction) AUGRU CHAR 3 internal
Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Billing block in SD document FAKSK CHAR 2 internal
Local Currency HWAER CUKY 5 internal
Sold-to party KUNNR CHAR 10 internal
Exchange Rate Type KURST CHAR 4 internal
Customer group 1 KVGR1 CHAR 3 internal
Customer group 2 KVGR2 CHAR 3 internal
Customer group 3 KVGR3 CHAR 3 internal
Customer group 4 KVGR4 CHAR 3 internal
Customer group 5 KVGR5 CHAR 3 internal
Delivery block (document header) LIFSK CHAR 2 internal
Statistics currency STWAE CUKY 5 internal
SD document category VBTYP CHAR 1 internal
Sales Office VKBUR CHAR 4 internal
Sales Group VKGRP CHAR 3 internal
Sales Organization VKORG CHAR 4 internal
Distribution Channel VTWEG CHAR 2 internal
Reason for rejection of quotations and sales orders ABGRU CHAR 2 internal
Changed On AEDAT DATS 8 internal
Order probability of the item AWAHR NUMC 3 internal
Gross Weight of the Item BRGEW QUAN 15,3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
Credit data exchange rate for requested delivery date CMKUA DEC 9,5 internal
International Article Number (EAN/UPC) EAN11 CHAR 18 internal
Date on Which Record Was Created ERDAT DATS 8 internal
Name of Person who Created the Object ERNAM CHAR 12 internal
Entry time ERZET TIMS 6 internal
Billing block for item FAKSP CHAR 2 internal
Weight Unit GEWEI UNIT 3 internal
Cumulative confirmed quantity in sales unit KBMENG QUAN 15,3 internal
Cumulative confirmed quantity in base unit KLMENG QUAN 15,3 internal
Condition unit KMEIN UNIT 3 internal
Sales deal KNUMA_AG CHAR 10 internal
Condition pricing unit KPEIN DEC 5 internal
Cumulative Order Quantity in Sales Units KWMENG QUAN 15,3 internal
Subtotal 1 from pricing procedure for condition KZWI1 CURR 13,2 internal
Subtotal 2 from pricing procedure for condition KZWI2 CURR 13,2 internal
Subtotal 3 from pricing procedure for condition KZWI3 CURR 13,2 internal
Subtotal 4 from pricing procedure for condition KZWI4 CURR 13,2 internal
Subtotal 5 from pricing procedure for condition KZWI5 CURR 13,2 internal
Subtotal 6 from pricing procedure for condition KZWI6 CURR 13,2 internal
Minimum delivery quantity in delivery note processing LFMNG QUAN 13,3 internal
Storage Location LGORT CHAR 4 internal
28
System: BW4
Cumulative required delivery qty (all dlv-relev.sched.lines) LSMENG QUAN 15,3 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Material entered MATWA CHAR 18 internal
Base Unit of Measure MEINS UNIT 3 internal
Material group 1 MVGR1 CHAR 3 internal
Material group 2 MVGR2 CHAR 3 internal
Material group 3 MVGR3 CHAR 3 internal
Material group 4 MVGR4 CHAR 3 internal
Material group 5 MVGR5 CHAR 3 internal
Tax amount in document currency MWSBP CURR 13,2 internal
Net price NETPR CURR 11,2 internal
Net value of the order item in document currency NETWR CURR 15,2 internal
Net Weight of the Item NTGEW QUAN 15,3 internal
Unloading point of the ship-to party PABLA CHAR 25 internal
Bill-to party PKUNRE CHAR 10 internal
Payer PKUNRG CHAR 10 internal
Ship-to party PKUNWE CHAR 10 internal
Product hierarchy PRODH CHAR 18 internal
Forwarding agent PSPDNR CHAR 10 internal
Sales document item category PSTYV CHAR 4 internal
Sales employee PVRTNR NUMC 8 internal
Route ROUTE CHAR 6 internal
Special Stock Indicator SOBKZ CHAR 1 internal
Division SPART CHAR 2 internal
Statistics date STADAT DATS 8 internal
Exchange rate for statistics (Exch.rate at time of creation) STCUR DEC 9,5 internal
Reason for material substitution SUGRD CHAR 4 internal
Unlimited overdelivery allowed UEBTK CHAR 1 internal
Overdelivery Tolerance Limit UEBTO DEC 3,1 internal
Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 internal
Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 internal
Factor for converting sales units to base units (target qty) UMZIN DEC 5 internal
Factor for converting sales units to base units (target qty) UMZIZ DEC 5 internal
Underdelivery Tolerance Limit UNTTO DEC 3,1 internal
Date of update for statistics updating VDATU DATS 8 internal
Document number of the reference document VGBEL CHAR 10 internal
Item number of the reference item VGPOS NUMC 6 internal
Document category of preceding SD document VGTYP CHAR 1 internal
Volume unit VOLEH UNIT 3 internal
Volume of the item VOLUM QUAN 15,3 internal
Sales unit VRKME UNIT 3 internal
Shipping Point/Receiving Point VSTEL CHAR 4 internal
SD Document Currency WAERK CUKY 5 internal
Cost in document currency WAVWR CURR 13,2 internal
Plant (Own or External) WERKS CHAR 4 internal
Target quantity UoM ZIEME UNIT 3 internal
Target quantity in sales units ZMENG QUAN 13,3 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Sales district BZIRK CHAR 6 internal
Date on which services rendered FBUDA DATS 8 internal
Billing date for billing index and printout FKDAT DATS 8 internal
29
System: BW4
Incoterms (Part 1) INCO1 CHAR 3 internal
Incoterms (Part 2) INCO2 CHAR 28 internal
Customer group KDGRP CHAR 2 internal
Account assignment group for this customer KTGRD CHAR 2 internal
Exchange Rate for Price Determination KURSK DEC 9,5 internal
Translation Date KURSK_DAT DATS 8 internal
Date for pricing and exchange rate PRSDT DATS 8 internal
Promotion WAKTION CHAR 10 internal
Product catalog number WMINR CHAR 10 internal
SD Document Currency WAERK_VBAK CUKY 5 internal
Division for order header SPARA CHAR 2 internal
Sales Document Category of Reference Doc. in Order Header VGTYP_AK CHAR 1 internal
Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 internal
Number of order items ANZAUPO DEC 9 internal
Fiscal Year Variant PERIV CHAR 2 internal
Planning in APO APOPLANNED CHAR 1 internal
BW: Net Price Referring to Sales Quantity for Order Item MCBW_NETPR_AVKM
CURR 11,2 internal
Material Type ZMTART CHAR 4 internal
6.4.1.1.14.3.1.1 InfoPackage test
6.4.1.1.14.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DGNLAWK9O332321ZLXYXE9CJ1
InfoSource
DataSource 2LIS_11_VAITM
Data Type Transaction data
Source System T90CLNT090
Delete content of Data Target -
Last changed by USER03
Date, time 24.12.2013 13:37:56
6.4.1.1.14.3.1.1.2 Selection
Field InfoObject Value from Value toBUKRS 0001
6.4.1.1.14.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.4.1.1.14.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.4.1.1.15 DSO APUR_O01 - Made to order (Aquisition Layer)
6.4.1.1.15.1 General Information
System BW4
InfoProvider APUR_O01, Made to order (Aquisition Layer)
30
System: BW4
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:49:12
Timestamp of documentation 11.04.2014 10:55:41
6.4.1.1.15.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.4.1.1.15.3 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E82CLNT800
Made to order (Aquisition Layer) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E82CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
Purchasing document number 0OI_EBELN CHAR 10 EBELNConversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
31
System: BW4
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
6.4.1.1.15.3.1 Buildup of DataSource 2LIS_02_ITM/E82CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E82CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
Total delivery time in days LFZTA DEC 13 internal
32
System: BW4
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.4.1.1.15.3.1.1 InfoPackage 2LIS_02_ITM_full
6.4.1.1.15.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DEIFPOQJKNBNECI8SA73V7W6L
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
33
System: BW4
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 03:36:37
6.4.1.1.15.3.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.4.1.1.15.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.4.1.1.15.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.4.1.1.15.3.1.2 InfoPackage 2LIS_02_ITM-delta
6.4.1.1.15.3.1.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFVT3ZXJQGZLBEYK2S8XJN1
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 04:39:04
6.4.1.1.15.3.1.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.4.1.1.15.3.1.2.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.4.1.1.15.3.1.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.4.1.1.15.3.1.3 InfoPackage init
6.4.1.1.15.3.1.3.1 General Information
Parameter ValueTech. Name ZPAK_DEVBB7RSZVMT7TQULRDELR0RX
InfoSource
34
System: BW4
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER22
Date, time 18.03.2013 19:37:27
6.4.1.1.15.3.1.3.2 Selection
Field InfoObject Value from Value toNo selections set
6.4.1.1.15.3.1.3.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.4.1.1.15.3.1.3.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.4.1.1.15.4 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E81CLNT800
Made to order (Aquisition Layer) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
Purchasing document number 0OI_EBELN CHAR 10 EBELNConversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
35
System: BW4
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
6.4.1.1.15.4.1 DTPs of Transformation 'RSDS 2LIS_02_ITM/E81CLNT800 -> ODSO APUR_O01'
6.4.1.1.15.4.1.1 DTP 2LIS_02_ITM E81CLNT800 -> APUR_O01
6.4.1.1.15.4.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4DLWV1UQ9YNAKG3DBC6YIST
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_02_ITM E81CLNT800 -> ODSO APUR_O01
Last changed by USER01
Date, time 26.02.2014 00:21:56
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.4.1.1.15.4.1.1.2 Filter
Field Description SelectionBSART [ ] 1000 - 2000
6.4.1.1.15.4.1.1.3 Semantic Groups
Field DescriptionEBELN
EBELP
6.4.1.1.15.4.2 Buildup of DataSource 2LIS_02_ITM/E81CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
36
System: BW4
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
Total delivery time in days LFZTA DEC 13 internal
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
37
System: BW4
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.4.1.1.15.4.2.1 InfoPackage Load Pucahsing data - Full
6.4.1.1.15.4.2.1.1 General Information
Parameter ValueTech. Name ZPAK_DEFLGAMH65T1UU74Z53U156LP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:35:09
6.4.1.1.15.4.2.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.4.1.1.15.4.2.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.4.1.1.15.4.2.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
38
System: BW4
6.4.1.1.15.4.2.2 InfoPackage 2LIS_02_ITM- DELTA
6.4.1.1.15.4.2.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFEG9C8V8VR63JFKF9AE0TP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:25:21
6.4.1.1.15.4.2.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.4.1.1.15.4.2.2.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.4.1.1.15.4.2.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.5 InfoProvider - Reporting Layer
6.5.1 RPU_C001 - Purchasing Data
6.5.1.1 Comment
6.5.1.1.1 ObjectiveWith the data of the InfoCube Purchasing Data, can be carried out analyses of material groups, vendors, and materials. This data enables you to find answers to the following questions, for example: "Which materials and how much of each have been ordered from a certain vendor?" "How many PO items are there for a certain material group?"
To enable the key figures for delivery date and delivery quantity variances to be computed, you must maintain a grid containing windows for on-time delivery performance and quantity reliability in Customizing for the Logistics Information System (LIS) (Logistics Data Warehouse -> Updating -> Updating Control Settings for Purchasing).
6.5.1.1.2 Business AspectsDataSourcesDataSource Description Source System
2LIS_02_ITM Purchasing Data (Item Level) R3PCLNT100
6.5.1.2 Technical Documentation
6.5.1.2.1 General Information
System BW4
39
System: BW4
InfoProvider RPU_C001, Purchasing Data
Type InfoCube, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:26:33
Timestamp of documentation 11.04.2014 10:56:14
6.5.1.2.2 Overview of Data Flow (up to DataSources)
Purchasing data (RPU_C001) (7.x)
Made to order (HPUR_O01) Startroutine (7.x)
Made to order (Aquisition Layer) (APUR_O01) (7.x)
2LIS_02_ITM/E82CLNT800 (7.x)
2LIS_02_ITM/E81CLNT800
6.5.1.2.3 Buildup InfoProvider/Transform. from Source HPUR_O01
Purchasing Data (RPU_C001)
Source: Made to order (HPUR_O01)RPU_C001T RPU_C001T Type Length Source/Value Aggr.Calendar Day 0CALDAY DATS 8 0CREATEDON
Calendar year/month 0CALMONTH NUMC 6 0CREATEDON
Calendar year 0CALYEAR NUMC 4 0CREATEDON
Calendar year / week 0CALWEEK NUMC 6 0CREATEDON
Fiscal year / period 0FISCPER NUMC 7 0CREATEDON
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
RPU_C001U RPU_C001UBase Unit of Measure 0BASE_UOM UNIT 3
Local currency 0LOC_CURRCY CUKY 5
RPU_C0011 RPU_C0011Country Key 0COUNTRY CHAR 3
Key Figures Description Type Unit Source/Value Aggr.Invoice receipt quantity 0IV_REC_QTY QUAN 0BASE_
UOM
Effective purchase order value 0ORDER_VAL CURR 0LOC_CURRCY
Target delivery quantity 0TAR_DL_QTY QUAN 0BASE_UOM
Order quantity (returns) 0PO_QTY_RET QUAN 0BASE_UOM
Number of contract items 0CONTR_ITEM DEC
Number of scheduling agreement schedule lines
0DEL_SCHEDS DEC
Number of purchase order items
0PO_ITEMS DEC
Order quantity 0PO_QTY QUAN 0BASE_UOM
Number of quotation items 0QUOT_ITEMS DEC
Number of request for quotation items
0RFQ_ITEMS DEC
Total delivery time in days 0TOTDELTIME DEC
6.5.1.2.3.1 DTPs of Transformation 'ODSO HPUR_O01 -> CUBE RPU_C001'
40
System: BW4
6.5.1.2.3.1.1 DTP HPUR_O01 -> RPU_C001
6.5.1.2.3.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4DMYRUHJTYJUKPX2U85ZKX9
Type Standard (Can Be Scheduled)
Source, Target ODSO HPUR_O01 -> CUBE RPU_C001
Last changed by USER01
Date, time 08.04.2014 07:26:33
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.5.1.2.3.1.1.2 Filter
Field Description SelectionITEM_DEL Item Deleted <> #
6.5.1.2.4 DSO HPUR_O01 - Made to order
6.5.1.2.4.1 General Information
System BW4
InfoProvider HPUR_O01, Made to order
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:48:17
Timestamp of documentation 11.04.2014 10:56:24
6.5.1.2.4.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.5.1.2.4.3 Buildup InfoProvider/Transform. from Source APUR_O01
Made to order (HPUR_O01)
Source: Made to order (Aquisition Layer) (APUR_O01)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Purchasing document number 0OI_EBELN CHAR 10 0OI_EBELN
Item number of purchasing document
0OI_EBELP NUMC 5 0OI_EBELP
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Material 0MATERIAL CHAR 18 0MATERIAL
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Plant 0PLANT CHAR 4 0PLANT
Purchasing organization 0PURCH_ORG CHAR 4 0PURCH_ORG
Vendor 0VENDOR CHAR 10 0VENDOR
41
System: BW4
Local currency 0LOC_CURRCY CUKY 5 0LOC_CURRCY
Base Unit of Measure 0BASE_UOM UNIT 3 0BASE_UOM
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1 0COMPL_DEL
Purchasing Group 0PUR_GROUP CHAR 3 0PUR_GROUP
Storage location 0STOR_LOC CHAR 4 0STOR_LOC
Goods Supplier 0SUPPLIER CHAR 10 0SUPPLIER
Supplying vendor 0SUPPL_VEND CHAR 10 0SUPPL_VEND
Supplying Plant 0SUPP_PLANT CHAR 4 0SUPP_PLANT
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10 0SUP_PLANT
Item Deleted 0ITEM_DEL CHAR 1 0ITEM_DEL
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNet price 0NETPRICE CURR LOC_CU
RRCY0NETPRICE Replace
Price unit 0PRICE_UNIT DEC 0PRICE_UNIT Replace
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC 0UPPR_BND Replace
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC 0LOWR_BND Replace
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
0PQCOASREQ Replace
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
0PCONF_QTY Replace
Actual Delivered Value 0PDLV_VAL CURR LOC_CURRCY
6.5.1.2.4.3.1 Look-Ups and calls of subprograms
Look-Ups TABL tcurr - Umrechnungskurse (Start Routine)
6.5.1.2.4.3.2 Details routines from source: APUR_O01Source: APUR_O01(Made to order (Aquisition Layer)) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:49:12
Declarations
DATA lt_tcurr TYPE TABLE OF tcurr.
Declarations, 2nd part... "insert your code here
Start Routine
SELECT * FROM tcurr INTO TABLE lt_tcurr.
BREAK-POINT.
* Exclude deleted datasets LOOP AT SOURCE_PACKAGE ASSIGNING <source_fields>. IF ( <source_fields>-processkey NE '001' AND <source_fields>-processkey NE '011' AND <source_fields>-processkey NE '021' AND <source_fields>-processkey NE '002' AND <source_fields>-processkey NE '012' AND <source_fields>-processkey NE '022').* see OSS note 636914 ENDIF. ENDLOOP.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"
42
System: BW4
*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.5.1.2.4.3.3 DTPs of Transformation 'ODSO APUR_O01 -> ODSO HPUR_O01'
6.5.1.2.4.3.3.1 DTP APUR_O01 -> HPUR_O01
6.5.1.2.4.3.3.1.1 General Information
Parameter ValueTech. Name DTP_DH4GM0MM62QJ925NINB7BSA7H
Type Standard (Can Be Scheduled)
Source, Target ODSO APUR_O01 -> ODSO HPUR_O01
Last changed by USER01
Date, time 26.02.2014 08:52:35
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.5.1.2.5 DSO APUR_O01 - Made to order (Aquisition Layer)
6.5.1.2.5.1 General Information
System BW4
InfoProvider APUR_O01, Made to order (Aquisition Layer)
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:49:12
Timestamp of documentation 11.04.2014 10:56:34
6.5.1.2.5.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.5.1.2.5.3 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E82CLNT800
Made to order (Aquisition Layer) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E82CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
Purchasing document number 0OI_EBELN CHAR 10 EBELNConversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
43
System: BW4
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
6.5.1.2.5.3.1 Buildup of DataSource 2LIS_02_ITM/E82CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E82CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
44
System: BW4
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
Total delivery time in days LFZTA DEC 13 internal
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
45
System: BW4
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.5.1.2.5.3.1.1 InfoPackage 2LIS_02_ITM_full
6.5.1.2.5.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DEIFPOQJKNBNECI8SA73V7W6L
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 03:36:37
6.5.1.2.5.3.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.5.1.2.5.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.5.1.2.5.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.5.1.2.5.3.1.2 InfoPackage 2LIS_02_ITM-delta
6.5.1.2.5.3.1.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFVT3ZXJQGZLBEYK2S8XJN1
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 04:39:04
46
System: BW4
6.5.1.2.5.3.1.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.5.1.2.5.3.1.2.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.5.1.2.5.3.1.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.5.1.2.5.3.1.3 InfoPackage init
6.5.1.2.5.3.1.3.1 General Information
Parameter ValueTech. Name ZPAK_DEVBB7RSZVMT7TQULRDELR0RX
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER22
Date, time 18.03.2013 19:37:27
6.5.1.2.5.3.1.3.2 Selection
Field InfoObject Value from Value toNo selections set
6.5.1.2.5.3.1.3.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.5.1.2.5.3.1.3.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.5.1.2.5.4 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E81CLNT800
Made to order (Aquisition Layer) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
Purchasing document number 0OI_EBELN CHAR 10 EBELNConversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, Characteristics
47
System: BW4
Fiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
6.5.1.2.5.4.1 DTPs of Transformation 'RSDS 2LIS_02_ITM/E81CLNT800 -> ODSO APUR_O01'
6.5.1.2.5.4.1.1 DTP 2LIS_02_ITM E81CLNT800 -> APUR_O01
6.5.1.2.5.4.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4DLWV1UQ9YNAKG3DBC6YIST
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_02_ITM E81CLNT800 -> ODSO APUR_O01
Last changed by USER01
Date, time 26.02.2014 00:21:56
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
48
System: BW4
6.5.1.2.5.4.1.1.2 Filter
Field Description SelectionBSART [ ] 1000 - 2000
6.5.1.2.5.4.1.1.3 Semantic Groups
Field DescriptionEBELN
EBELP
6.5.1.2.5.4.2 Buildup of DataSource 2LIS_02_ITM/E81CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
49
System: BW4
Total delivery time in days LFZTA DEC 13 internal
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.5.1.2.5.4.2.1 InfoPackage Load Pucahsing data - Full
6.5.1.2.5.4.2.1.1 General Information
Parameter ValueTech. Name ZPAK_DEFLGAMH65T1UU74Z53U156LP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
50
System: BW4
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:35:09
6.5.1.2.5.4.2.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.5.1.2.5.4.2.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.5.1.2.5.4.2.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.5.1.2.5.4.2.2 InfoPackage 2LIS_02_ITM- DELTA
6.5.1.2.5.4.2.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFEG9C8V8VR63JFKF9AE0TP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:25:21
6.5.1.2.5.4.2.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.5.1.2.5.4.2.2.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.5.1.2.5.4.2.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.5.2 RSD_C001 - Service Level: Order Items
6.5.2.1 Comment
6.5.2.1.1 Objective
51
System: BW4
This Cube enables you to perform evaluations with respect to the service level at the level of order quantities. As a result, analyses such as order quantities delivered too late as a proportion of the total number of order items are possible, for example.
6.5.2.2 Technical Documentation
6.5.2.2.1 General Information
System BW4
InfoProvider RSD_C001, Service Level: Order Items
Type InfoCube, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:29:58
Timestamp of documentation 11.04.2014 10:57:06
6.5.2.2.2 Overview of Data Flow (up to DataSources)
Level of service contract options (RSD_C001) Startroutine (7.x)
Job options (HSD_O001) Startroutine (7.x)
Job options (Aquisition Layer) (ASD_O001) (7.x)
2LIS_13_VDITM/E80CLNT800 (7.x)
2LIS_03_BF/E81CLNT800
6.5.2.2.3 Buildup InfoProvider/Transform. from Source HSD_O001
Service Level: Order Items (RSD_C001)
Source: Job options (HSD_O001)RSD_C001T RSD_C001T Type Length Source/Value Aggr.Calendar Day 0CALDAY DATS 8 0CREATEDON
Calendar year/month 0CALMONTH NUMC 6 0CREATEDON
Calendar year / week 0CALWEEK NUMC 6 0CREATEDON
Fiscal year / period 0FISCPER NUMC 7 0CREATEDON
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
RSD_C001U RSD_C001UBase Unit of Measure 0BASE_UOM UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Local currency 0LOC_CURRCY CUKY 5
RSD_C0011 RSD_C0011Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Delivery Status 0DLV_STS CHAR 1 0DLV_STS
Overall delivery status of the item
0DLV_STSO CHAR 1 0DLV_STSO
Delivered Complete 0STS_DLV_C CHAR 1 RoutineConversion Exit: ALPHASource fields: 0BND_IND, 0DLV_QTY, 0RECORDMODE, 0REQU_QTY, 0SALES_UNIT, 0UPPR_BND
RSD_C0012 RSD_C0012Customer Group 0CUST_GROUP CHAR 2 0CUST_GROUP
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Payer 0PAYER CHAR 10 0PAYER
52
System: BW4
Ship-To Party 0SHIP_TO CHAR 10 0SHIP_TO
RSD_C0013 RSD_C0013Material 0MATERIAL CHAR 18 0MATERIAL
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Product hierarchy 0PROD_HIER CHAR 18 0PROD_HIER
RSD_C0014 RSD_C0014Company code 0COMP_CODE CHAR 4 0COMP_CODE
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Plant 0PLANT CHAR 4 0PLANT
Shipping point 0SHIP_POINT CHAR 4 0SHIP_POINT
RSD_C0015 RSD_C0015Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales Organization 0SALESORG CHAR 4 0SALESORG
Division 0DIVISION CHAR 2 0DIVISION
RSD_C0016 RSD_C0016Forw.Agent 0FORWAGENT CHAR 10 0FORWAGENT
RSD_C0017 RSD_C0017Batch number 0BATCH CHAR 10 0BATCH
RSD_C0018 RSD_C0018ZDPDOCNUM CHAR 10 ZDPDOCNUM
Key Figures Description Type Unit Source/Value Aggr.Value Confirmed as Requested
0VCOASREQ CURR 0DOC_CURRCY
Value with Delivery from Warehouse
0VSHP_STCK CURR 0DOC_CURRCY
Net value of the order item in document currency
0NET_VALUE CURR 0DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR 0DOC_CURRCY
Net price 0NETPRICE CURR 0LOC_CURRCY
Order quantity 0PO_QTY QUAN 0BASE_UOM
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4
Number of Document Items 0DOC_ITEMS DEC
Confirmed as Requested 0ICOASREQ INT4
Delivery from Warehouse 0ISHP_STCK INT4
6.5.2.2.3.1 Look-Ups and calls of subprograms
Look-Ups IOBJ 0COMP_CODE - Company code (Start Routine)
6.5.2.2.3.2 Details routines from source: HSD_O001Source: HSD_O001(Job options) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:57:24
Declarations
data lt_comp_code type table of /BI0/PCOMP_CODE.
Declarations, 2nd part... "insert your code here
Start Routine
53
System: BW4
"Company Codes puffern Select * from /BI0/PCOMP_CODE into table lt_comp_code.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
InfoObject Routines 0STS_DLV_C
DATA: l_bnd_lowr LIKE SOURCE_FIELDS-requ_qty, l_bnd_uppr LIKE SOURCE_FIELDS-requ_qty.
IF SOURCE_FIELDS-recordmode EQ ' ' OR SOURCE_FIELDS-recordmode EQ 'N'. IF SOURCE_FIELDS-bnd_ind EQ 'X'. IF SOURCE_FIELDS-dlv_qty GE SOURCE_FIELDS-requ_qty. RESULT = 'X'. ENDIF. ELSE. l_bnd_uppr = SOURCE_FIELDS-requ_qty * ( 1 + SOURCE_FIELDS-uppr_bnd ). IF SOURCE_FIELDS-dlv_qty GE l_bnd_uppr. RESULT = 'X'. ENDIF. ENDIF. ENDIF.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries... "to cancel the update process* raise exception type CX_RSROUT_ABORT.... "to skip a record* raise exception type CX_RSROUT_SKIP_RECORD.... "to clear target fields* raise exception type CX_RSROUT_SKIP_VAL.
6.5.2.2.3.3 DTPs of Transformation 'ODSO HSD_O001 -> CUBE RSD_C001'
6.5.2.2.3.3.1 DTP HSD_O001 -> RSD_C001
6.5.2.2.3.3.1.1 General Information
Parameter ValueTech. Name DTP_DH7RKRRM01HF3YOVL5MS8D6EL
Type Standard (Can Be Scheduled)
Source, Target ODSO HSD_O001 -> CUBE RSD_C001
Last changed by USER01
Date, time 08.04.2014 07:29:57
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.5.2.2.4 DSO HSD_O001 - Job options
6.5.2.2.4.1 General Information
System BW4
InfoProvider HSD_O001, Job options
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:57:24
Timestamp of documentation 11.04.2014 10:57:24
54
System: BW4
6.5.2.2.4.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.5.2.2.4.3 Buildup InfoProvider/Transform. from Source ASD_O001
Job options (HSD_O001)
Source: Job options (Aquisition Layer) (ASD_O001)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Sales document item 0S_ORD_ITEM NUMC 6 0S_ORD_ITEM
Data Fields, CharacteristicsDelivery Status 0DLV_STS CHAR 1 0DLV_STS
Overall delivery status of the item
0DLV_STSO CHAR 1 0DLV_STSO
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Material 0MATERIAL CHAR 18 0MATERIAL
Batch number 0BATCH CHAR 10 0BATCH
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Company code 0COMP_CODE CHAR 4 0COMP_CODE
Customer Group 0CUST_GROUP CHAR 2 0CUST_GROUP
Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Organization 0SALESORG CHAR 4 0SALESORG
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Product hierarchy 0PROD_HIER CHAR 18 0PROD_HIER
Plant 0PLANT CHAR 4 0PLANT
Ship-To Party 0SHIP_TO CHAR 10 0SHIP_TO
Shipping point 0SHIP_POINT CHAR 4 0SHIP_POINT
Division 0DIVISION CHAR 2 0DIVISION
Forw.Agent 0FORWAGENT CHAR 10 0FORWAGENT
Payer 0PAYER CHAR 10 0PAYER
Document currency 0DOC_CURRCY CUKY 5 0DOC_CURRCY
Item Deleted 0ITEM_DEL CHAR 1 0ITEM_DEL
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Independent of Delivery Tolerances
0BND_IND CHAR 1 0BND_IND
Sales unit 0SALES_UNIT UNIT 3 0SALES_UNIT
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitTolerance Limit for Under Delivery in %
0LOWR_BND DEC 0LOWR_BND Replace
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC 0UPPR_BND Replace
Net price 0NET_PRICE CURR DOC_CURRCY
0NET_PRICE Replace
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CU 0NETPR_VKM Replace
55
System: BW4
RRCY
Quantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
0QCOASREQ Replace
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
0CONF_QTY Replace
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
0REQU_QTY Replace
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
0DLV_QTY Replace
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
0GIS_QTY Replace
6.5.2.2.4.3.1 Look-Ups and calls of subprograms
Look-Ups IOBJ 0MATERIAL - Material (Start Routine) IOBJ 0CUST_GROUP - Customer Group (Start Routine) DSO ASD_O001 - Job options (Aquisition Layer) (Start Routine)
6.5.2.2.4.3.2 Details routines from source: ASD_O001Source: ASD_O001(Job options (Aquisition Layer)) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:57:24
Declarations
DATA lt_material TYPE TABLE OF /bi0/pmaterial. DATA lt_sd TYPE TABLE OF /bic/aasd_o00100. DATA lt_cust TYPE TABLE OF /bi0/pcust_group.
Declarations, 2nd part... "insert your code here
Start Routine
SELECT * FROM /bi0/pmaterial INTO TABLE lt_material.
SELECT * FROM /bi0/pcust_group INTO TABLE lt_cust.
SELECT * FROM /bic/aasd_o00100 INTO TABLE lt_sd.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.5.2.2.4.3.3 DTPs of Transformation 'ODSO ASD_O001 -> ODSO HSD_O001'
6.5.2.2.4.3.3.1 DTP ASD_O001 -> HSD_O001
6.5.2.2.4.3.3.1.1 General Information
Parameter ValueTech. Name DTP_DH7RLNWVJ0KV8NDI9SVUCK1PP
Type Standard (Can Be Scheduled)
Source, Target ODSO ASD_O001 -> ODSO HSD_O001
Last changed by USER01
Date, time 12.03.2014 09:40:55
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.5.2.2.5 DSO ASD_O001 - Job options (Aquisition Layer)
56
System: BW4
6.5.2.2.5.1 General Information
System BW4
InfoProvider ASD_O001, Job options (Aquisition Layer)
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:44:10
Timestamp of documentation 11.04.2014 10:57:34
6.5.2.2.5.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.5.2.2.5.3 Buildup InfoProvider/Transform. from Source 2LIS_13_VDITM/E80CLNT800
Job options (Aquisition Layer) (ASD_O001)
Source: Billing Document Item Data (2LIS_13_VDITM/E80CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 VBELN
Sales document item 0S_ORD_ITEM NUMC 6 POSNR
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 AEDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
Batch number 0BATCH CHAR 10
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
57
System: BW4
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.5.2.2.5.3.1 Buildup of DataSource 2LIS_13_VDITM/E80CLNT800
2LIS_13_VDITM, Billing Document Item Data (Source System: E80CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Sales and Distribution Document Number VBELN CHAR 10 ALPHA internal
Item number of the SD document POSNR NUMC 6 internal
Changed On AEDAT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Sales district BZIRK CHAR 6 internal
Billing Type FKART CHAR 4 internal
Billing date for billing index and printout FKDAT DATS 8 internal
Billing category FKTYP CHAR 1 internal
Local Currency HWAER CUKY 5 internal
Customer group KDGRP CHAR 2 internal
Sold-to party KUNAG CHAR 10 ALPHA internal
Payer KUNRG CHAR 10 ALPHA internal
Exchange rate for FI postings KURRF DEC 9,5 EXCRT internal
Exchange Rate Type KURST CHAR 4 internal
Statistics currency STWAE CUKY 5 internal
SD document category VBTYP CHAR 1 internal
Sales Organization VKORG CHAR 4 internal
Distribution Channel VTWEG CHAR 2 internal
SD Document Currency WAERK CUKY 5 internal
Promotion AKTNR CHAR 10 ALPHA internal
Sales Document AUBEL CHAR 10 ALPHA internal
Sales Document Item AUPOS NUMC 6 internal
Rebate basis 1 BONBA CURR 13,2 internal
Volume rebate group BONUS CHAR 2 internal
Gross weight BRGEW QUAN 15,3 internal
Gross value of the billing item in document currency BRTWR CURR 15,2 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
58
System: BW4
International Article Number (EAN/UPC) EAN11 CHAR 18 EAN11 internal
Date on Which Record Was Created ERDAT DATS 8 internal
Rule in billing plan/invoice plan FAREG CHAR 1 internal
Date on which services rendered FBUDA DATS 8 internal
Actual Invoiced Quantity FKIMG QUAN 13,3 internal
Billing quantity in stockkeeping unit FKLMG QUAN 13,3 internal
Weight Unit GEWEI UNIT 3 CUNIT internal
Sales deal KNUMA_AG CHAR 10 ALPHA internal
Controlling Area KOKRS CHAR 4 internal
Cost Center KOSTL CHAR 10 ALPHA internal
Exchange Rate for Price Determination KURSK DEC 9,5 EXCRT internal
Translation Date KURSK_DAT DATS 8 internal
Customer group 1 KVGR1 CHAR 3 internal
Customer group 2 KVGR2 CHAR 3 internal
Customer group 3 KVGR3 CHAR 3 internal
Customer group 4 KVGR4 CHAR 3 internal
Customer group 5 KVGR5 CHAR 3 internal
Subtotal 1 from pricing procedure for condition KZWI1 CURR 13,2 internal
Subtotal 2 from pricing procedure for condition KZWI2 CURR 13,2 internal
Subtotal 3 from pricing procedure for condition KZWI3 CURR 13,2 internal
Subtotal 4 from pricing procedure for condition KZWI4 CURR 13,2 internal
Subtotal 5 from pricing procedure for condition KZWI5 CURR 13,2 internal
Subtotal 6 from pricing procedure for condition KZWI6 CURR 13,2 internal
Storage Location LGORT CHAR 4 internal
Required quantity for mat.management in stockkeeping units LMENG QUAN 13,3 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 MATN1 internal
Material entered MATWA CHAR 18 MATN1 internal
Base Unit of Measure MEINS UNIT 3 CUNIT internal
Material group 1 MVGR1 CHAR 3 internal
Material group 2 MVGR2 CHAR 3 internal
Material group 3 MVGR3 CHAR 3 internal
Material group 4 MVGR4 CHAR 3 internal
Material group 5 MVGR5 CHAR 3 internal
Tax amount in document currency MWSBP CURR 13,2 internal
Net value of the billing item in document currency NETWR CURR 15,2 internal
Net weight NTGEW QUAN 15,3 internal
Bill-to party PKUNRE CHAR 10 ALPHA internal
Ship-to party PKUNWE CHAR 10 ALPHA internal
Item type POSAR CHAR 1 internal
Product hierarchy PRODH CHAR 18 internal
Commission group PROVG CHAR 2 internal
Date for pricing and exchange rate PRSDT DATS 8 internal
Sales document item category PSTYV CHAR 4 internal
Sales employee PVRTNR NUMC 8 internal
Amount eligible for cash discount in document currency SKFBP CURR 13,2 internal
Scale quantity in base unit of measure SMENG QUAN 13,3 internal
Division for order header SPARA CHAR 2 internal
Division SPART CHAR 2 internal
Statistics date STADAT DATS 8 internal
Exchange rate for statistics (Exch.rate at time of creation) STCUR DEC 9,5 EXCRT internal
Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 internal
59
System: BW4
Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 internal
Date of update for statistics updating VDATU DATS 8 internal
Document number of the reference document VGBEL CHAR 10 ALPHA internal
Item number of the reference item VGPOS NUMC 6 internal
Sales Office VKBUR CHAR 4 internal
Sales Group VKGRP CHAR 3 internal
Volume unit VOLEH UNIT 3 CUNIT internal
Volume VOLUM QUAN 15,3 internal
Sales unit VRKME UNIT 3 CUNIT internal
Shipping Point/Receiving Point VSTEL CHAR 4 internal
Cost in document currency WAVWR CURR 13,2 internal
Plant WERKS CHAR 4 internal
Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 ABPSN internal
Number of billing items ANZFKPOS DEC 9 internal
Fiscal Year Variant PERIV CHAR 2 internal
6.5.2.2.5.3.1.1 InfoPackage 2LIS_13_VDITM info package
6.5.2.2.5.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DFULHSVK8SM93DK4KU1FM2RHP
InfoSource
DataSource 2LIS_13_VDITM
Data Type Transaction data
Source System E80CLNT800
Delete content of Data Target -
Last changed by USER04
Date, time 15.08.2013 15:06:29
6.5.2.2.5.3.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.5.2.2.5.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.5.2.2.5.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.5.2.2.5.4 Buildup InfoProvider/Transform. from Source 2LIS_03_BF/E81CLNT800
Job options (Aquisition Layer) (ASD_O001)
Source: Goods Movements From Inventory Management (2LIS_03_BF/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 AKTNR
Sales document item 0S_ORD_ITEM NUMC 6 AUFNR
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, Characteristics
60
System: BW4
Fiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BLDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
Batch number 0BATCH CHAR 10
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.5.2.2.5.4.1 DTPs of Transformation 'RSDS 2LIS_03_BF/E81CLNT800 -> ODSO ASD_O001'
6.5.2.2.5.4.1.1 DTP 2LIS_03_BF E81CLNT800 -> ASD_O001
6.5.2.2.5.4.1.1.1 General Information
61
System: BW4
Parameter ValueTech. Name DTP_DH4GMAKVJS9SDBE3L301Q4JHP
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_03_BF E81CLNT800 -> ODSO ASD_O001
Last changed by USER01
Date, time 26.02.2014 08:53:35
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.5.2.2.5.4.1.1.2 Filter
Field Description SelectionBLDAT [ ] 20120101 - 99991231
6.5.2.2.5.4.1.1.3 Semantic Groups
Field DescriptionAKTNR
AUFNR
6.5.2.2.5.4.2 Buildup of DataSource 2LIS_03_BF/E81CLNT800
2LIS_03_BF, Goods Movements From Inventory Management (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Promotion AKTNR CHAR 10 internal
Order Number AUFNR CHAR 12 internal
Routing number of operations in the order AUFPL NUMC 10 internal
Valuation Class BKLAS CHAR 4 internal
Document Date in Document BLDAT DATS 8 internal
Delivery costs in local currency BNBTR CURR 15,2 internal
Stock Values in the Logistics Information System BSTAUS CHAR 1 internal
Stock categories in the Logistics Information System BSTTYP CHAR 1 internal
Posting Date in the Document BUDAT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Application Component BWAPPLNM CHAR 30 internal
Movement Type (Inventory Management) BWART CHAR 3 internal
BW: Stock Relevance BWBREL CHAR 1 internal
BW: Unique Identification of Line Item BWCOUNTER NUMC 6 internal
BW: Cost Value in Local Currency BWGEO CURR 19,2 internal
BW: Retail Value in Local Currency BWGVO CURR 19,2 internal
BW: Retail Value with Tax in Local Currency BWGVP CURR 19,2 internal
Valuation Area BWKEY CHAR 4 internal
BW: Quantity in Base Unit of Measure BWMNG QUAN 15,3 internal
Work Breakdown Structure Element (External) BWPSPEX CHAR 24 internal
Valuation Type BWTAR CHAR 10 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
Amount in local currency DMBTR CURR 15,2 internal
Purchasing Document Number EBELN CHAR 10 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
Unit of Entry ERFME UNIT 3 internal
Quantity in Unit of Entry ERFMG QUAN 13,3 internal
62
System: BW4
Reason for goods movment GRUND NUMC 4 internal
Business Area GSBER CHAR 4 internal
Sales Order Number KDAUF CHAR 10 internal
Delivery Schedule for Sales Order KDEIN NUMC 4 internal
Item Number in Sales Order KDPOS NUMC 6 internal
Controlling Area KOKRS CHAR 4 internal
Cost Center KOSTL CHAR 10 internal
Cost Object KSTRG CHAR 12 internal
Account Number of Customer KUNNR CHAR 10 internal
Movement Indicator KZBEW CHAR 1 internal
Valuation of Special Stock KZBWS CHAR 1 internal
Warehouse Number / Warehouse Complex LGNUM CHAR 3 internal
Storage Location LGORT CHAR 4 internal
Storage Bin LGPLA CHAR 10 internal
Storage Type LGTYP CHAR 3 internal
Vendor Account Number LIFNR CHAR 10 internal
Material Number MATNR CHAR 18 internal
Number of Material Document MBLNR CHAR 10 internal
Base Unit of Measure MEINS UNIT 3 internal
Quantity MENGE QUAN 15,3 internal
Material Document Year MJAHR NUMC 4 internal
Network Number for Account Assignment NPLNR CHAR 12 internal
WMS Number of pallets PALAN DEC 11 internal
Profitability Segment Number (CO-PA) PAOBJNR NUMC 10 internal
Profit Center PRCTR CHAR 10 internal
Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 internal
G/L Account Number SAKTO CHAR 10 internal
Debit/Credit Indicator SHKZG CHAR 1 internal
Special Stock Indicator SOBKZ CHAR 1 internal
Receiving/Issuing Plant UMWRK CHAR 4 internal
Local Currency WAERS CUKY 5 internal
Goods Recipient/Ship-To Party WEMPF CHAR 12 internal
Plant WERKS CHAR 4 internal
Item in Material Document ZEILE NUMC 4 internal
Fiscal Year Variant PERIV CHAR 2 internal
Counter for Items NOPOS DEC 3 internal
EA Retail BW Extr. Enhancement: Item Type ITEM_CAT NUMC 2 internal
EA Retail BW Extr. Enhancement: Data Record Type REC_TYPE NUMC 1 internal
Material Category ATTYP CHAR 2 internal
Plant category VLFKZ CHAR 1 internal
Item automatically created SAUTO CHAR 1 internal
Structured material MATST CHAR 18 internal
Value at Sales Prices Including Value-Added Tax VKSTT CURR 13,2 internal
Value at sales prices excluding value-added tax VKSTA CURR 13,2 internal
Indicator: Movement type is stock transfer UMLKZ CHAR 1 internal
Indicator: Return from call RETKZ CHAR 1 internal
Indicator: Movement type is physical inventory INVKZ CHAR 1 internal
Indicator: Movement type is inventory correction KORR CHAR 1 internal
Transfer Posting Material to Material UMMATKZ CHAR 1 internal
Currency Key WAERSST CUKY 5 internal
63
System: BW4
6.5.3 RSD_C002 - Service Level: Orders
6.5.3.1 Comment
6.5.3.1.1 ObjectiveThis Cube enables you to make evaluations with respect to the service level on the order header level. In this way, you can analyze, for example, the total number of orders for the share of orders with late delivery.
6.5.3.2 Technical Documentation
6.5.3.2.1 General Information
System BW4
InfoProvider RSD_C002, Service Level: Orders
Type InfoCube, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:27:37
Timestamp of documentation 11.04.2014 10:57:56
6.5.3.2.2 Overview of Data Flow (up to DataSources)
Level of service jobs (RSD_C002) Startroutine (7.x)
Orders (HSD_O003) (7.x)
Orders (Aquisition Layer) (ASD_O003) (7.x)
2LIS_11_VAITM/T90CLNT090
6.5.3.2.3 Active Nav.-Attributes
InfoObject Nav.-Attribut Nav.-Attribut (Descr.)0COMP_CODE 0COMPANY Company for Company Code
0SOLD_TO 0ACCNT_GRP Customer Account Group
6.5.3.2.4 Buildup InfoProvider/Transform. from Source HSD_O003
Service Level: Orders (RSD_C002)
Source: Orders (HSD_O003)RSD_C002T RSD_C002T Type Length Source/Value Aggr.Calendar Day 0CALDAY DATS 8 0CREATEDON
Calendar year/month 0CALMONTH NUMC 6 0CREATEDON
Calendar year / week 0CALWEEK NUMC 6 0CREATEDON
Fiscal year / period 0FISCPER NUMC 7 0CREATEDON
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
RSD_C002U RSD_C002UDocument currency 0DOC_CURRCY CUKY 5
RSD_C0021 RSD_C0021Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Delivery Status 0DLV_STS CHAR 1 0DLV_STS
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1 0DLV_STSOI
Delivered Complete 0STS_DLV_C CHAR 1
RSD_C0022 RSD_C0022Customer Group 1 0CUST_GRP1 CHAR 3
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
64
System: BW4
RSD_C0023 RSD_C0023Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales Organization 0SALESORG CHAR 4 0SALESORG
Division 0DIVISION CHAR 2 0DIVISION
RSD_C0024 RSD_C0024Company code 0COMP_CODE CHAR 4 0COMP_CODE
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Office 0SALES_OFF CHAR 4 0SALES_OFF
RSD_C0025 RSD_C0025ZDPDOCNUM CHAR 10 ZDPDOCNUM
Key Figures Description Type Unit Source/Value Aggr.Returns 0DITM_RET INT4 0DITM_RET Summ.
Delivery Within 24 Hours 0DLV_24 INT4 0DLV_24 Summ.
Confirmed as Requested 0ICOASREQ INT4 0ICOASREQ Summ.
Delivery from Warehouse 0ISHP_STCK INT4
Value Confirmed as Requested
0VCOASREQ CURR 0DOC_CURRCY
0VCOASREQ [0DOC_CURRCY]
Summ.
Value with Delivery from Warehouse
0VSHP_STCK CURR 0DOC_CURRCY
Number of orders 0ORDERS DEC
Requested Delivery Value 0REQU_VAL CURR 0DOC_CURRCY
0REQU_VAL [0DOC_CURRCY]
Summ.
Perfect Order Fulfillment (Number)
0DLVIPOF INT4
Perfect Order Fulfillment (Value)
0DLVVPOF CURR 0DOC_CURRCY
Value with Delivery Within 24 Hours
0VAL_24 CURR 0DOC_CURRCY
0VAL_24 [0DOC_CURRCY] Summ.
Value of Returns 0VAL_RET CURR 0DOC_CURRCY
0VAL_RET [0DOC_CURRCY] Summ.
Net value of the order in document currency
0NET_VAL_HD CURR 0DOC_CURRCY
0NET_VAL_HD [0DOC_CURRCY]
Summ.
Actual Delivered Value 0DLV_VAL CURR 0DOC_CURRCY
0DLV_VAL [0DOC_CURRCY] Summ.
6.5.3.2.4.1 Details routines from source: HSD_O003Source: HSD_O003(Orders) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:58:21
Declarations ... "insert your code here
Declarations, 2nd part... "insert your code here
Start Routine
loop at SOURCE_PACKAGE ASSIGNING <SOURCE_FIELDS>. if <SOURCE_FIELDS>-DOC_CURRCY Ne 'EUR' and <SOURCE_FIELDS>-DIVISION = '1000'. delete SOURCE_PACKAGE. endif. endloop.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.5.3.2.4.2 DTPs of Transformation 'ODSO HSD_O003 -> CUBE RSD_C002'
65
System: BW4
6.5.3.2.4.2.1 DTP HSD_O003 -> RSD_C002
6.5.3.2.4.2.1.1 General Information
Parameter ValueTech. Name DTP_DH7RUYL16SVVULXT1UVIF0SZ1
Type Standard (Can Be Scheduled)
Source, Target ODSO HSD_O003 -> CUBE RSD_C002
Last changed by USER01
Date, time 08.04.2014 07:27:37
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.5.3.2.5 DSO HSD_O003 - Orders
6.5.3.2.5.1 General Information
System BW4
InfoProvider HSD_O003, Orders
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:58:21
Timestamp of documentation 11.04.2014 10:58:10
6.5.3.2.5.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.5.3.2.5.3 Buildup InfoProvider/Transform. from Source ASD_O003
Orders (HSD_O003)
Source: Orders (Aquisition Layer) (ASD_O003)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Delivery Status 0DLV_STS CHAR 1 0DLV_STS
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Company code 0COMP_CODE CHAR 4 0COMP_CODE
Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Office 0SALES_OFF CHAR 4 0SALES_OFF
Sales Organization 0SALESORG CHAR 4 0SALESORG
Division 0DIVISION CHAR 2 0DIVISION
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1 0DLV_STSOI
Document currency 0DOC_CURRCY CUKY 5 0DOC_CURRCY
Header Deleted 0HEADER_DEL CHAR 1 0HEADER_DEL
66
System: BW4
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNumber of Document Items 0DOC_ITEMS DEC 0DOC_ITEMS Replace
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4 0CUML_TME Replace
Returns 0DITM_RET INT4 0DITM_RET Replace
Value of Returns 0VAL_RET CURR DOC_CURRCY
0VAL_RET Replace
Confirmed as Requested 0ICOASREQ INT4
Value Confirmed as Requested
0VCOASREQ CURR DOC_CURRCY
Delivery Within 24 Hours 0DLV_24 INT4
Value with Delivery Within 24 Hours
0VAL_24 CURR DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR DOC_CURRCY
0REQU_VAL Replace
Actual Delivered Value 0DLV_VAL CURR DOC_CURRCY
0DLV_VAL Replace
Net value of the order in document currency
0NET_VAL_HD CURR DOC_CURRCY
0NET_VAL_HD Replace
6.5.3.2.6 DSO ASD_O003 - Orders (Aquisition Layer)
6.5.3.2.6.1 General Information
System BW4
InfoProvider ASD_O003, Orders (Aquisition Layer)
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:55:58
Timestamp of documentation 11.04.2014 10:58:16
6.5.3.2.6.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.5.3.2.6.3 Buildup InfoProvider/Transform. from Source 2LIS_11_VAITM/T90CLNT090
Orders (Aquisition Layer) (ASD_O003)
Source: Sales Document Item Data (2LIS_11_VAITM/T90CLNT090)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 VBELN
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 PERIV
Date on which the record was created
0CREATEDON DATS 8 ERDAT
Header Deleted 0HEADER_DEL CHAR 1
Delivery Status 0DLV_STS CHAR 1
Sold-to party 0SOLD_TO CHAR 10 KUNNRConversion Exit: ALPHA
Company code 0COMP_CODE CHAR 4 BUKRS
Distribution Channel 0DISTR_CHAN CHAR 2 VTWEG
67
System: BW4
Sales group 0SALES_GRP CHAR 3 VKGRP
Sales Office 0SALES_OFF CHAR 4 VKBUR
Sales Organization 0SALESORG CHAR 4 VKORG
Division 0DIVISION CHAR 2 SPART
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1
Document currency 0DOC_CURRCY CUKY 5 WAERK
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNumber of Document Items 0DOC_ITEMS DEC
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4
Returns 0DITM_RET INT4
Value of Returns 0VAL_RET CURR DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR DOC_CURRCY
Actual Delivered Value 0DLV_VAL CURR DOC_CURRCY
Net value of the order in document currency
0NET_VAL_HD CURR DOC_CURRCY
6.5.3.2.6.3.1 Buildup of DataSource 2LIS_11_VAITM/T90CLNT090
2LIS_11_VAITM, Sales Document Item Data (Source System: T90CLNT090)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Sales and Distribution Document Number VBELN CHAR 10 internal
Rejection status for SD item ABSTA CHAR 1 internal
Item number of the SD document POSNR NUMC 6 internal
General Incompletion Status of Item UVALL CHAR 1 internal
Item Incompletion Status with Respect to Billing UVFAK CHAR 1 internal
Pricing for item is incomplete UVPRS CHAR 1 internal
Incompletion status of the item with regard to delivery UVVLK CHAR 1 internal
Quotation/Inquiry is valid from ANGDT DATS 8 internal
Sales Document Type AUART CHAR 4 internal
Order reason (reason for the business transaction) AUGRU CHAR 3 internal
Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Billing block in SD document FAKSK CHAR 2 internal
Local Currency HWAER CUKY 5 internal
Sold-to party KUNNR CHAR 10 internal
Exchange Rate Type KURST CHAR 4 internal
Customer group 1 KVGR1 CHAR 3 internal
Customer group 2 KVGR2 CHAR 3 internal
Customer group 3 KVGR3 CHAR 3 internal
Customer group 4 KVGR4 CHAR 3 internal
Customer group 5 KVGR5 CHAR 3 internal
Delivery block (document header) LIFSK CHAR 2 internal
Statistics currency STWAE CUKY 5 internal
SD document category VBTYP CHAR 1 internal
Sales Office VKBUR CHAR 4 internal
Sales Group VKGRP CHAR 3 internal
68
System: BW4
Sales Organization VKORG CHAR 4 internal
Distribution Channel VTWEG CHAR 2 internal
Reason for rejection of quotations and sales orders ABGRU CHAR 2 internal
Changed On AEDAT DATS 8 internal
Order probability of the item AWAHR NUMC 3 internal
Gross Weight of the Item BRGEW QUAN 15,3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
Credit data exchange rate for requested delivery date CMKUA DEC 9,5 internal
International Article Number (EAN/UPC) EAN11 CHAR 18 internal
Date on Which Record Was Created ERDAT DATS 8 internal
Name of Person who Created the Object ERNAM CHAR 12 internal
Entry time ERZET TIMS 6 internal
Billing block for item FAKSP CHAR 2 internal
Weight Unit GEWEI UNIT 3 internal
Cumulative confirmed quantity in sales unit KBMENG QUAN 15,3 internal
Cumulative confirmed quantity in base unit KLMENG QUAN 15,3 internal
Condition unit KMEIN UNIT 3 internal
Sales deal KNUMA_AG CHAR 10 internal
Condition pricing unit KPEIN DEC 5 internal
Cumulative Order Quantity in Sales Units KWMENG QUAN 15,3 internal
Subtotal 1 from pricing procedure for condition KZWI1 CURR 13,2 internal
Subtotal 2 from pricing procedure for condition KZWI2 CURR 13,2 internal
Subtotal 3 from pricing procedure for condition KZWI3 CURR 13,2 internal
Subtotal 4 from pricing procedure for condition KZWI4 CURR 13,2 internal
Subtotal 5 from pricing procedure for condition KZWI5 CURR 13,2 internal
Subtotal 6 from pricing procedure for condition KZWI6 CURR 13,2 internal
Minimum delivery quantity in delivery note processing LFMNG QUAN 13,3 internal
Storage Location LGORT CHAR 4 internal
Cumulative required delivery qty (all dlv-relev.sched.lines) LSMENG QUAN 15,3 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Material entered MATWA CHAR 18 internal
Base Unit of Measure MEINS UNIT 3 internal
Material group 1 MVGR1 CHAR 3 internal
Material group 2 MVGR2 CHAR 3 internal
Material group 3 MVGR3 CHAR 3 internal
Material group 4 MVGR4 CHAR 3 internal
Material group 5 MVGR5 CHAR 3 internal
Tax amount in document currency MWSBP CURR 13,2 internal
Net price NETPR CURR 11,2 internal
Net value of the order item in document currency NETWR CURR 15,2 internal
Net Weight of the Item NTGEW QUAN 15,3 internal
Unloading point of the ship-to party PABLA CHAR 25 internal
Bill-to party PKUNRE CHAR 10 internal
Payer PKUNRG CHAR 10 internal
Ship-to party PKUNWE CHAR 10 internal
Product hierarchy PRODH CHAR 18 internal
Forwarding agent PSPDNR CHAR 10 internal
Sales document item category PSTYV CHAR 4 internal
Sales employee PVRTNR NUMC 8 internal
69
System: BW4
Route ROUTE CHAR 6 internal
Special Stock Indicator SOBKZ CHAR 1 internal
Division SPART CHAR 2 internal
Statistics date STADAT DATS 8 internal
Exchange rate for statistics (Exch.rate at time of creation) STCUR DEC 9,5 internal
Reason for material substitution SUGRD CHAR 4 internal
Unlimited overdelivery allowed UEBTK CHAR 1 internal
Overdelivery Tolerance Limit UEBTO DEC 3,1 internal
Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 internal
Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 internal
Factor for converting sales units to base units (target qty) UMZIN DEC 5 internal
Factor for converting sales units to base units (target qty) UMZIZ DEC 5 internal
Underdelivery Tolerance Limit UNTTO DEC 3,1 internal
Date of update for statistics updating VDATU DATS 8 internal
Document number of the reference document VGBEL CHAR 10 internal
Item number of the reference item VGPOS NUMC 6 internal
Document category of preceding SD document VGTYP CHAR 1 internal
Volume unit VOLEH UNIT 3 internal
Volume of the item VOLUM QUAN 15,3 internal
Sales unit VRKME UNIT 3 internal
Shipping Point/Receiving Point VSTEL CHAR 4 internal
SD Document Currency WAERK CUKY 5 internal
Cost in document currency WAVWR CURR 13,2 internal
Plant (Own or External) WERKS CHAR 4 internal
Target quantity UoM ZIEME UNIT 3 internal
Target quantity in sales units ZMENG QUAN 13,3 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Sales district BZIRK CHAR 6 internal
Date on which services rendered FBUDA DATS 8 internal
Billing date for billing index and printout FKDAT DATS 8 internal
Incoterms (Part 1) INCO1 CHAR 3 internal
Incoterms (Part 2) INCO2 CHAR 28 internal
Customer group KDGRP CHAR 2 internal
Account assignment group for this customer KTGRD CHAR 2 internal
Exchange Rate for Price Determination KURSK DEC 9,5 internal
Translation Date KURSK_DAT DATS 8 internal
Date for pricing and exchange rate PRSDT DATS 8 internal
Promotion WAKTION CHAR 10 internal
Product catalog number WMINR CHAR 10 internal
SD Document Currency WAERK_VBAK CUKY 5 internal
Division for order header SPARA CHAR 2 internal
Sales Document Category of Reference Doc. in Order Header VGTYP_AK CHAR 1 internal
Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 internal
Number of order items ANZAUPO DEC 9 internal
Fiscal Year Variant PERIV CHAR 2 internal
Planning in APO APOPLANNED CHAR 1 internal
BW: Net Price Referring to Sales Quantity for Order Item MCBW_NETPR_AVKM
CURR 11,2 internal
Material Type ZMTART CHAR 4 internal
6.5.3.2.6.3.1.1 InfoPackage test
6.5.3.2.6.3.1.1.1 General Information
70
System: BW4
Parameter ValueTech. Name ZPAK_DGNLAWK9O332321ZLXYXE9CJ1
InfoSource
DataSource 2LIS_11_VAITM
Data Type Transaction data
Source System T90CLNT090
Delete content of Data Target -
Last changed by USER03
Date, time 24.12.2013 13:37:56
6.5.3.2.6.3.1.1.2 Selection
Field InfoObject Value from Value toBUKRS 0001
6.5.3.2.6.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.5.3.2.6.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.6 INFOPROVIDER_H
6.6.1 HPUR_O01 - Purchase Order Items (Harmonization)
6.6.1.1 Comment
6.6.1.1.1 ObjectiveThe ODS integrates data on purchase order items based on the purchase order items from the InfoSource 2LIS_02_ITM.
The ODS does not update deleted records. This takes place in the update start routine, where deleted records are converted to cancellations. You can identify deletion records via the characteristic 0ITEM_DEL.
6.6.1.2 Technical Documentation
6.6.1.2.1 General Information
System BW4
InfoProvider HPUR_O01, Purchase Order Items (Harmonization)
Type DSO, Standard
Last changed by BLUETELL
Last change (timestamp) 20.08.2013 08:43:38
Timestamp of documentation 11.04.2014 10:58:29
6.6.1.2.2 Overview of Data Flow (up to DataSources)
Made to order (HPUR_O01) Startroutine (7.x)
Made to order (Aquisition Layer) (APUR_O01) (7.x)
71
System: BW4
2LIS_02_ITM/E82CLNT800 (7.x)
2LIS_02_ITM/E81CLNT800
6.6.1.2.3 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.6.1.2.4 Buildup InfoProvider/Transform. from Source APUR_O01
Purchase Order Items (Harmonization) (HPUR_O01)
Source: Made to order (Aquisition Layer) (APUR_O01)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Purchasing document number 0OI_EBELN CHAR 10 0OI_EBELN
Item number of purchasing document
0OI_EBELP NUMC 5 0OI_EBELP
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Material 0MATERIAL CHAR 18 0MATERIAL
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Plant 0PLANT CHAR 4 0PLANT
Purchasing organization 0PURCH_ORG CHAR 4 0PURCH_ORG
Vendor 0VENDOR CHAR 10 0VENDOR
Local currency 0LOC_CURRCY CUKY 5 0LOC_CURRCY
Base Unit of Measure 0BASE_UOM UNIT 3 0BASE_UOM
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1 0COMPL_DEL
Purchasing Group 0PUR_GROUP CHAR 3 0PUR_GROUP
Storage location 0STOR_LOC CHAR 4 0STOR_LOC
Goods Supplier 0SUPPLIER CHAR 10 0SUPPLIER
Supplying vendor 0SUPPL_VEND CHAR 10 0SUPPL_VEND
Supplying Plant 0SUPP_PLANT CHAR 4 0SUPP_PLANT
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10 0SUP_PLANT
Item Deleted 0ITEM_DEL CHAR 1 0ITEM_DEL
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNet price 0NETPRICE CURR LOC_CU
RRCY0NETPRICE Replace
Price unit 0PRICE_UNIT DEC 0PRICE_UNIT Replace
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC 0UPPR_BND Replace
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC 0LOWR_BND Replace
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
0PQCOASREQ Replace
Confirmed Quantity 0PCONF_QTY QUAN BASE_U 0PCONF_QTY Replace
72
System: BW4
OM
Actual Delivered Value 0PDLV_VAL CURR LOC_CURRCY
6.6.1.2.4.1 Look-Ups and calls of subprograms
Look-Ups TABL tcurr - Umrechnungskurse (Start Routine)
6.6.1.2.4.2 Details routines from source: APUR_O01Source: APUR_O01(Made to order (Aquisition Layer)) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:49:12
Declarations
DATA lt_tcurr TYPE TABLE OF tcurr.
Declarations, 2nd part... "insert your code here
Start Routine
SELECT * FROM tcurr INTO TABLE lt_tcurr.
BREAK-POINT.
* Exclude deleted datasets LOOP AT SOURCE_PACKAGE ASSIGNING <source_fields>. IF ( <source_fields>-processkey NE '001' AND <source_fields>-processkey NE '011' AND <source_fields>-processkey NE '021' AND <source_fields>-processkey NE '002' AND <source_fields>-processkey NE '012' AND <source_fields>-processkey NE '022').* see OSS note 636914 ENDIF. ENDLOOP.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.6.1.2.4.3 DTPs of Transformation 'ODSO APUR_O01 -> ODSO HPUR_O01'
6.6.1.2.4.3.1 DTP APUR_O01 -> HPUR_O01
6.6.1.2.4.3.1.1 General Information
Parameter ValueTech. Name DTP_DH4GM0MM62QJ925NINB7BSA7H
Type Standard (Can Be Scheduled)
Source, Target ODSO APUR_O01 -> ODSO HPUR_O01
Last changed by USER01
Date, time 26.02.2014 08:52:35
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.6.1.2.5 DSO APUR_O01 - Made to order (Aquisition Layer)
6.6.1.2.5.1 General Information
System BW4
InfoProvider APUR_O01, Made to order (Aquisition Layer)
Type DSO, Standard
73
System: BW4
Last changed by USER01
Last change (timestamp) 08.04.2014 07:49:12
Timestamp of documentation 11.04.2014 10:58:39
6.6.1.2.5.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.6.1.2.5.3 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E82CLNT800
Made to order (Aquisition Layer) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E82CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
Purchasing document number 0OI_EBELN CHAR 10 EBELNConversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
74
System: BW4
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
6.6.1.2.5.3.1 Buildup of DataSource 2LIS_02_ITM/E82CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E82CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
Total delivery time in days LFZTA DEC 13 internal
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
75
System: BW4
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.6.1.2.5.3.1.1 InfoPackage 2LIS_02_ITM_full
6.6.1.2.5.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DEIFPOQJKNBNECI8SA73V7W6L
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER12
76
System: BW4
Date, time 23.01.2013 03:36:37
6.6.1.2.5.3.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.6.1.2.5.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.6.1.2.5.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.6.1.2.5.3.1.2 InfoPackage 2LIS_02_ITM-delta
6.6.1.2.5.3.1.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFVT3ZXJQGZLBEYK2S8XJN1
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 04:39:04
6.6.1.2.5.3.1.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.6.1.2.5.3.1.2.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.6.1.2.5.3.1.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.6.1.2.5.3.1.3 InfoPackage init
6.6.1.2.5.3.1.3.1 General Information
Parameter ValueTech. Name ZPAK_DEVBB7RSZVMT7TQULRDELR0RX
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
77
System: BW4
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER22
Date, time 18.03.2013 19:37:27
6.6.1.2.5.3.1.3.2 Selection
Field InfoObject Value from Value toNo selections set
6.6.1.2.5.3.1.3.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.6.1.2.5.3.1.3.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.6.1.2.5.4 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E81CLNT800
Made to order (Aquisition Layer) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
Purchasing document number 0OI_EBELN CHAR 10 EBELNConversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
78
System: BW4
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
6.6.1.2.5.4.1 DTPs of Transformation 'RSDS 2LIS_02_ITM/E81CLNT800 -> ODSO APUR_O01'
6.6.1.2.5.4.1.1 DTP 2LIS_02_ITM E81CLNT800 -> APUR_O01
6.6.1.2.5.4.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4DLWV1UQ9YNAKG3DBC6YIST
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_02_ITM E81CLNT800 -> ODSO APUR_O01
Last changed by USER01
Date, time 26.02.2014 00:21:56
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.6.1.2.5.4.1.1.2 Filter
Field Description SelectionBSART [ ] 1000 - 2000
6.6.1.2.5.4.1.1.3 Semantic Groups
Field DescriptionEBELN
EBELP
6.6.1.2.5.4.2 Buildup of DataSource 2LIS_02_ITM/E81CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
79
System: BW4
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
Total delivery time in days LFZTA DEC 13 internal
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
80
System: BW4
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.6.1.2.5.4.2.1 InfoPackage Load Pucahsing data - Full
6.6.1.2.5.4.2.1.1 General Information
Parameter ValueTech. Name ZPAK_DEFLGAMH65T1UU74Z53U156LP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:35:09
6.6.1.2.5.4.2.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.6.1.2.5.4.2.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.6.1.2.5.4.2.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.6.1.2.5.4.2.2 InfoPackage 2LIS_02_ITM- DELTA
81
System: BW4
6.6.1.2.5.4.2.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFEG9C8V8VR63JFKF9AE0TP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:25:21
6.6.1.2.5.4.2.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.6.1.2.5.4.2.2.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.6.1.2.5.4.2.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.6.2 HSD_O001 - Order Items (Harmonization)
6.6.2.1 Comment
6.6.2.1.1 ObjectiveThe DSO contains data on orders and complimentary orders on the basis of Data Source Order Headers (2LIS_11_VAITM) as well as Order Schedule Lines (2LIS_11_V_SSL). The Start Routine ensures that only orders and complimentary orders are updated in the ODS.
The Start routine also ensure that Reverse Images are converted to After Images. In this way, the Data Store Object does not delete any records. Instead, deleted records are marked with an indicator (0HEADER_DEL).
6.6.2.2 Technical Documentation
6.6.2.2.1 General Information
System BW4
InfoProvider HSD_O001, Order Items (Harmonization)
Type DSO, Standard
Last changed by BLUETELL
Last change (timestamp) 20.08.2013 08:30:13
Timestamp of documentation 11.04.2014 10:59:10
6.6.2.2.2 Overview of Data Flow (up to DataSources)
Job options (HSD_O001) Startroutine (7.x)
Job options (Aquisition Layer) (ASD_O001) (7.x)
2LIS_13_VDITM/E80CLNT800
82
System: BW4
(7.x) 2LIS_03_BF/E81CLNT800
6.6.2.2.3 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.6.2.2.4 Buildup InfoProvider/Transform. from Source ASD_O001
Order Items (Harmonization) (HSD_O001)
Source: Job options (Aquisition Layer) (ASD_O001)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Sales document item 0S_ORD_ITEM NUMC 6 0S_ORD_ITEM
Data Fields, CharacteristicsDelivery Status 0DLV_STS CHAR 1 0DLV_STS
Overall delivery status of the item
0DLV_STSO CHAR 1 0DLV_STSO
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Material 0MATERIAL CHAR 18 0MATERIAL
Batch number 0BATCH CHAR 10 0BATCH
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Company code 0COMP_CODE CHAR 4 0COMP_CODE
Customer Group 0CUST_GROUP CHAR 2 0CUST_GROUP
Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Organization 0SALESORG CHAR 4 0SALESORG
Material group 0MATL_GROUP CHAR 9 0MATL_GROUP
Product hierarchy 0PROD_HIER CHAR 18 0PROD_HIER
Plant 0PLANT CHAR 4 0PLANT
Ship-To Party 0SHIP_TO CHAR 10 0SHIP_TO
Shipping point 0SHIP_POINT CHAR 4 0SHIP_POINT
Division 0DIVISION CHAR 2 0DIVISION
Forw.Agent 0FORWAGENT CHAR 10 0FORWAGENT
Payer 0PAYER CHAR 10 0PAYER
Document currency 0DOC_CURRCY CUKY 5 0DOC_CURRCY
Item Deleted 0ITEM_DEL CHAR 1 0ITEM_DEL
Fiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Independent of Delivery Tolerances
0BND_IND CHAR 1 0BND_IND
Sales unit 0SALES_UNIT UNIT 3 0SALES_UNIT
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitTolerance Limit for Under Delivery in %
0LOWR_BND DEC 0LOWR_BND Replace
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC 0UPPR_BND Replace
83
System: BW4
Net price 0NET_PRICE CURR DOC_CURRCY
0NET_PRICE Replace
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
0NETPR_VKM Replace
Quantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
0QCOASREQ Replace
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
0CONF_QTY Replace
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
0REQU_QTY Replace
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
0DLV_QTY Replace
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
0GIS_QTY Replace
6.6.2.2.4.1 Look-Ups and calls of subprograms
Look-Ups IOBJ 0MATERIAL - Material (Start Routine) IOBJ 0CUST_GROUP - Customer Group (Start Routine) DSO ASD_O001 - Job options (Aquisition Layer) (Start Routine)
6.6.2.2.4.2 Details routines from source: ASD_O001Source: ASD_O001(Job options (Aquisition Layer)) Type: DataStore-ObjectChanged by: USER01, timestamp: 08.04.2014 07:57:24
Declarations
DATA lt_material TYPE TABLE OF /bi0/pmaterial. DATA lt_sd TYPE TABLE OF /bic/aasd_o00100. DATA lt_cust TYPE TABLE OF /bi0/pcust_group.
Declarations, 2nd part... "insert your code here
Start Routine
SELECT * FROM /bi0/pmaterial INTO TABLE lt_material.
SELECT * FROM /bi0/pcust_group INTO TABLE lt_cust.
SELECT * FROM /bic/aasd_o00100 INTO TABLE lt_sd.
*-- fill table "MONITOR" with values of structure "MONITOR_REC"*- to make monitor entries ... "to cancel the update process* raise exception type CX_RSROUT_ABORT.
6.6.2.2.4.3 DTPs of Transformation 'ODSO ASD_O001 -> ODSO HSD_O001'
6.6.2.2.4.3.1 DTP ASD_O001 -> HSD_O001
6.6.2.2.4.3.1.1 General Information
Parameter ValueTech. Name DTP_DH7RLNWVJ0KV8NDI9SVUCK1PP
Type Standard (Can Be Scheduled)
Source, Target ODSO ASD_O001 -> ODSO HSD_O001
Last changed by USER01
Date, time 12.03.2014 09:40:55
Extraction mode Delta
Error handling No Update, No Reporting
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
84
System: BW4
6.6.2.2.5 DSO ASD_O001 - Job options (Aquisition Layer)
6.6.2.2.5.1 General Information
System BW4
InfoProvider ASD_O001, Job options (Aquisition Layer)
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:44:10
Timestamp of documentation 11.04.2014 10:59:20
6.6.2.2.5.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.6.2.2.5.3 Buildup InfoProvider/Transform. from Source 2LIS_13_VDITM/E80CLNT800
Job options (Aquisition Layer) (ASD_O001)
Source: Billing Document Item Data (2LIS_13_VDITM/E80CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 VBELN
Sales document item 0S_ORD_ITEM NUMC 6 POSNR
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 AEDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
Batch number 0BATCH CHAR 10
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
85
System: BW4
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.6.2.2.5.3.1 Buildup of DataSource 2LIS_13_VDITM/E80CLNT800
2LIS_13_VDITM, Billing Document Item Data (Source System: E80CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Sales and Distribution Document Number VBELN CHAR 10 ALPHA internal
Item number of the SD document POSNR NUMC 6 internal
Changed On AEDAT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Sales district BZIRK CHAR 6 internal
Billing Type FKART CHAR 4 internal
Billing date for billing index and printout FKDAT DATS 8 internal
Billing category FKTYP CHAR 1 internal
Local Currency HWAER CUKY 5 internal
Customer group KDGRP CHAR 2 internal
Sold-to party KUNAG CHAR 10 ALPHA internal
Payer KUNRG CHAR 10 ALPHA internal
Exchange rate for FI postings KURRF DEC 9,5 EXCRT internal
Exchange Rate Type KURST CHAR 4 internal
Statistics currency STWAE CUKY 5 internal
SD document category VBTYP CHAR 1 internal
Sales Organization VKORG CHAR 4 internal
Distribution Channel VTWEG CHAR 2 internal
SD Document Currency WAERK CUKY 5 internal
Promotion AKTNR CHAR 10 ALPHA internal
Sales Document AUBEL CHAR 10 ALPHA internal
Sales Document Item AUPOS NUMC 6 internal
Rebate basis 1 BONBA CURR 13,2 internal
Volume rebate group BONUS CHAR 2 internal
Gross weight BRGEW QUAN 15,3 internal
Gross value of the billing item in document currency BRTWR CURR 15,2 internal
Application Component BWAPPLNM CHAR 30 internal
86
System: BW4
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
International Article Number (EAN/UPC) EAN11 CHAR 18 EAN11 internal
Date on Which Record Was Created ERDAT DATS 8 internal
Rule in billing plan/invoice plan FAREG CHAR 1 internal
Date on which services rendered FBUDA DATS 8 internal
Actual Invoiced Quantity FKIMG QUAN 13,3 internal
Billing quantity in stockkeeping unit FKLMG QUAN 13,3 internal
Weight Unit GEWEI UNIT 3 CUNIT internal
Sales deal KNUMA_AG CHAR 10 ALPHA internal
Controlling Area KOKRS CHAR 4 internal
Cost Center KOSTL CHAR 10 ALPHA internal
Exchange Rate for Price Determination KURSK DEC 9,5 EXCRT internal
Translation Date KURSK_DAT DATS 8 internal
Customer group 1 KVGR1 CHAR 3 internal
Customer group 2 KVGR2 CHAR 3 internal
Customer group 3 KVGR3 CHAR 3 internal
Customer group 4 KVGR4 CHAR 3 internal
Customer group 5 KVGR5 CHAR 3 internal
Subtotal 1 from pricing procedure for condition KZWI1 CURR 13,2 internal
Subtotal 2 from pricing procedure for condition KZWI2 CURR 13,2 internal
Subtotal 3 from pricing procedure for condition KZWI3 CURR 13,2 internal
Subtotal 4 from pricing procedure for condition KZWI4 CURR 13,2 internal
Subtotal 5 from pricing procedure for condition KZWI5 CURR 13,2 internal
Subtotal 6 from pricing procedure for condition KZWI6 CURR 13,2 internal
Storage Location LGORT CHAR 4 internal
Required quantity for mat.management in stockkeeping units LMENG QUAN 13,3 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 MATN1 internal
Material entered MATWA CHAR 18 MATN1 internal
Base Unit of Measure MEINS UNIT 3 CUNIT internal
Material group 1 MVGR1 CHAR 3 internal
Material group 2 MVGR2 CHAR 3 internal
Material group 3 MVGR3 CHAR 3 internal
Material group 4 MVGR4 CHAR 3 internal
Material group 5 MVGR5 CHAR 3 internal
Tax amount in document currency MWSBP CURR 13,2 internal
Net value of the billing item in document currency NETWR CURR 15,2 internal
Net weight NTGEW QUAN 15,3 internal
Bill-to party PKUNRE CHAR 10 ALPHA internal
Ship-to party PKUNWE CHAR 10 ALPHA internal
Item type POSAR CHAR 1 internal
Product hierarchy PRODH CHAR 18 internal
Commission group PROVG CHAR 2 internal
Date for pricing and exchange rate PRSDT DATS 8 internal
Sales document item category PSTYV CHAR 4 internal
Sales employee PVRTNR NUMC 8 internal
Amount eligible for cash discount in document currency SKFBP CURR 13,2 internal
Scale quantity in base unit of measure SMENG QUAN 13,3 internal
Division for order header SPARA CHAR 2 internal
Division SPART CHAR 2 internal
Statistics date STADAT DATS 8 internal
87
System: BW4
Exchange rate for statistics (Exch.rate at time of creation) STCUR DEC 9,5 EXCRT internal
Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 internal
Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 internal
Date of update for statistics updating VDATU DATS 8 internal
Document number of the reference document VGBEL CHAR 10 ALPHA internal
Item number of the reference item VGPOS NUMC 6 internal
Sales Office VKBUR CHAR 4 internal
Sales Group VKGRP CHAR 3 internal
Volume unit VOLEH UNIT 3 CUNIT internal
Volume VOLUM QUAN 15,3 internal
Sales unit VRKME UNIT 3 CUNIT internal
Shipping Point/Receiving Point VSTEL CHAR 4 internal
Cost in document currency WAVWR CURR 13,2 internal
Plant WERKS CHAR 4 internal
Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 ABPSN internal
Number of billing items ANZFKPOS DEC 9 internal
Fiscal Year Variant PERIV CHAR 2 internal
6.6.2.2.5.3.1.1 InfoPackage 2LIS_13_VDITM info package
6.6.2.2.5.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DFULHSVK8SM93DK4KU1FM2RHP
InfoSource
DataSource 2LIS_13_VDITM
Data Type Transaction data
Source System E80CLNT800
Delete content of Data Target -
Last changed by USER04
Date, time 15.08.2013 15:06:29
6.6.2.2.5.3.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.6.2.2.5.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.6.2.2.5.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.6.2.2.5.4 Buildup InfoProvider/Transform. from Source 2LIS_03_BF/E81CLNT800
Job options (Aquisition Layer) (ASD_O001)
Source: Goods Movements From Inventory Management (2LIS_03_BF/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 AKTNR
Sales document item 0S_ORD_ITEM NUMC 6 AUFNR
88
System: BW4
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BLDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
Batch number 0BATCH CHAR 10
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.6.2.2.5.4.1 DTPs of Transformation 'RSDS 2LIS_03_BF/E81CLNT800 -> ODSO ASD_O001'
6.6.2.2.5.4.1.1 DTP 2LIS_03_BF E81CLNT800 -> ASD_O001
89
System: BW4
6.6.2.2.5.4.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4GMAKVJS9SDBE3L301Q4JHP
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_03_BF E81CLNT800 -> ODSO ASD_O001
Last changed by USER01
Date, time 26.02.2014 08:53:35
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.6.2.2.5.4.1.1.2 Filter
Field Description SelectionBLDAT [ ] 20120101 - 99991231
6.6.2.2.5.4.1.1.3 Semantic Groups
Field DescriptionAKTNR
AUFNR
6.6.2.2.5.4.2 Buildup of DataSource 2LIS_03_BF/E81CLNT800
2LIS_03_BF, Goods Movements From Inventory Management (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Promotion AKTNR CHAR 10 internal
Order Number AUFNR CHAR 12 internal
Routing number of operations in the order AUFPL NUMC 10 internal
Valuation Class BKLAS CHAR 4 internal
Document Date in Document BLDAT DATS 8 internal
Delivery costs in local currency BNBTR CURR 15,2 internal
Stock Values in the Logistics Information System BSTAUS CHAR 1 internal
Stock categories in the Logistics Information System BSTTYP CHAR 1 internal
Posting Date in the Document BUDAT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Application Component BWAPPLNM CHAR 30 internal
Movement Type (Inventory Management) BWART CHAR 3 internal
BW: Stock Relevance BWBREL CHAR 1 internal
BW: Unique Identification of Line Item BWCOUNTER NUMC 6 internal
BW: Cost Value in Local Currency BWGEO CURR 19,2 internal
BW: Retail Value in Local Currency BWGVO CURR 19,2 internal
BW: Retail Value with Tax in Local Currency BWGVP CURR 19,2 internal
Valuation Area BWKEY CHAR 4 internal
BW: Quantity in Base Unit of Measure BWMNG QUAN 15,3 internal
Work Breakdown Structure Element (External) BWPSPEX CHAR 24 internal
Valuation Type BWTAR CHAR 10 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
Amount in local currency DMBTR CURR 15,2 internal
Purchasing Document Number EBELN CHAR 10 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
Unit of Entry ERFME UNIT 3 internal
90
System: BW4
Quantity in Unit of Entry ERFMG QUAN 13,3 internal
Reason for goods movment GRUND NUMC 4 internal
Business Area GSBER CHAR 4 internal
Sales Order Number KDAUF CHAR 10 internal
Delivery Schedule for Sales Order KDEIN NUMC 4 internal
Item Number in Sales Order KDPOS NUMC 6 internal
Controlling Area KOKRS CHAR 4 internal
Cost Center KOSTL CHAR 10 internal
Cost Object KSTRG CHAR 12 internal
Account Number of Customer KUNNR CHAR 10 internal
Movement Indicator KZBEW CHAR 1 internal
Valuation of Special Stock KZBWS CHAR 1 internal
Warehouse Number / Warehouse Complex LGNUM CHAR 3 internal
Storage Location LGORT CHAR 4 internal
Storage Bin LGPLA CHAR 10 internal
Storage Type LGTYP CHAR 3 internal
Vendor Account Number LIFNR CHAR 10 internal
Material Number MATNR CHAR 18 internal
Number of Material Document MBLNR CHAR 10 internal
Base Unit of Measure MEINS UNIT 3 internal
Quantity MENGE QUAN 15,3 internal
Material Document Year MJAHR NUMC 4 internal
Network Number for Account Assignment NPLNR CHAR 12 internal
WMS Number of pallets PALAN DEC 11 internal
Profitability Segment Number (CO-PA) PAOBJNR NUMC 10 internal
Profit Center PRCTR CHAR 10 internal
Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 internal
G/L Account Number SAKTO CHAR 10 internal
Debit/Credit Indicator SHKZG CHAR 1 internal
Special Stock Indicator SOBKZ CHAR 1 internal
Receiving/Issuing Plant UMWRK CHAR 4 internal
Local Currency WAERS CUKY 5 internal
Goods Recipient/Ship-To Party WEMPF CHAR 12 internal
Plant WERKS CHAR 4 internal
Item in Material Document ZEILE NUMC 4 internal
Fiscal Year Variant PERIV CHAR 2 internal
Counter for Items NOPOS DEC 3 internal
EA Retail BW Extr. Enhancement: Item Type ITEM_CAT NUMC 2 internal
EA Retail BW Extr. Enhancement: Data Record Type REC_TYPE NUMC 1 internal
Material Category ATTYP CHAR 2 internal
Plant category VLFKZ CHAR 1 internal
Item automatically created SAUTO CHAR 1 internal
Structured material MATST CHAR 18 internal
Value at Sales Prices Including Value-Added Tax VKSTT CURR 13,2 internal
Value at sales prices excluding value-added tax VKSTA CURR 13,2 internal
Indicator: Movement type is stock transfer UMLKZ CHAR 1 internal
Indicator: Return from call RETKZ CHAR 1 internal
Indicator: Movement type is physical inventory INVKZ CHAR 1 internal
Indicator: Movement type is inventory correction KORR CHAR 1 internal
Transfer Posting Material to Material UMMATKZ CHAR 1 internal
Currency Key WAERSST CUKY 5 internal
91
System: BW4
6.6.3 HSD_O003 - Orders
6.6.3.1 Technical Documentation
6.6.3.1.1 General Information
System BW4
InfoProvider HSD_O003, Orders
Type DSO, Standard
Last changed by BLUETELL
Last change (timestamp) 20.08.2013 08:37:15
Timestamp of documentation 11.04.2014 10:59:41
6.6.3.1.2 Overview of Data Flow (up to DataSources)
Orders (HSD_O003) (7.x)
Orders (Aquisition Layer) (ASD_O003) (7.x)
2LIS_11_VAITM/T90CLNT090
6.6.3.1.3 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.6.3.1.4 Buildup InfoProvider/Transform. from Source ASD_O003
Orders (HSD_O003)
Source: Orders (Aquisition Layer) (ASD_O003)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 ZDPDOCNUM
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 0FISCVARNT
Date on which the record was created
0CREATEDON DATS 8 0CREATEDON
Delivery Status 0DLV_STS CHAR 1 0DLV_STS
Sold-to party 0SOLD_TO CHAR 10 0SOLD_TO
Company code 0COMP_CODE CHAR 4 0COMP_CODE
Distribution Channel 0DISTR_CHAN CHAR 2 0DISTR_CHAN
Sales group 0SALES_GRP CHAR 3 0SALES_GRP
Sales Office 0SALES_OFF CHAR 4 0SALES_OFF
Sales Organization 0SALESORG CHAR 4 0SALESORG
Division 0DIVISION CHAR 2 0DIVISION
Overall Delivery Status of All Items
0DLV_STSOI CHAR 1 0DLV_STSOI
Document currency 0DOC_CURRCY CUKY 5 0DOC_CURRCY
Header Deleted 0HEADER_DEL CHAR 1 0HEADER_DEL
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNumber of Document Items 0DOC_ITEMS DEC 0DOC_ITEMS Replace
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4 0CUML_TME Replace
92
System: BW4
Returns 0DITM_RET INT4 0DITM_RET Replace
Value of Returns 0VAL_RET CURR DOC_CURRCY
0VAL_RET Replace
Confirmed as Requested 0ICOASREQ INT4
Value Confirmed as Requested
0VCOASREQ CURR DOC_CURRCY
Delivery Within 24 Hours 0DLV_24 INT4
Value with Delivery Within 24 Hours
0VAL_24 CURR DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR DOC_CURRCY
0REQU_VAL Replace
Actual Delivered Value 0DLV_VAL CURR DOC_CURRCY
0DLV_VAL Replace
Net value of the order in document currency
0NET_VAL_HD CURR DOC_CURRCY
0NET_VAL_HD Replace
6.6.3.1.5 DSO ASD_O003 - Orders (Aquisition Layer)
6.6.3.1.5.1 General Information
System BW4
InfoProvider ASD_O003, Orders (Aquisition Layer)
Type DSO, Standard
Last changed by USER01
Last change (timestamp) 08.04.2014 07:55:58
Timestamp of documentation 11.04.2014 10:59:46
6.6.3.1.5.2 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.6.3.1.5.3 Buildup InfoProvider/Transform. from Source 2LIS_11_VAITM/T90CLNT090
Orders (Aquisition Layer) (ASD_O003)
Source: Sales Document Item Data (2LIS_11_VAITM/T90CLNT090)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 VBELN
Data Fields, CharacteristicsFiscal year variant 0FISCVARNT CHAR 2 PERIV
Date on which the record was created
0CREATEDON DATS 8 ERDAT
Header Deleted 0HEADER_DEL CHAR 1
Delivery Status 0DLV_STS CHAR 1
Sold-to party 0SOLD_TO CHAR 10 KUNNRConversion Exit: ALPHA
Company code 0COMP_CODE CHAR 4 BUKRS
Distribution Channel 0DISTR_CHAN CHAR 2 VTWEG
Sales group 0SALES_GRP CHAR 3 VKGRP
Sales Office 0SALES_OFF CHAR 4 VKBUR
Sales Organization 0SALESORG CHAR 4 VKORG
Division 0DIVISION CHAR 2 SPART
Overall Delivery Status of All 0DLV_STSOI CHAR 1
93
System: BW4
Items
Document currency 0DOC_CURRCY CUKY 5 WAERK
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitNumber of Document Items 0DOC_ITEMS DEC
Cumulated Order Processing Time for All Document Items
0CUML_TME INT4
Returns 0DITM_RET INT4
Value of Returns 0VAL_RET CURR DOC_CURRCY
Requested Delivery Value 0REQU_VAL CURR DOC_CURRCY
Actual Delivered Value 0DLV_VAL CURR DOC_CURRCY
Net value of the order in document currency
0NET_VAL_HD CURR DOC_CURRCY
6.6.3.1.5.3.1 Buildup of DataSource 2LIS_11_VAITM/T90CLNT090
2LIS_11_VAITM, Sales Document Item Data (Source System: T90CLNT090)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Sales and Distribution Document Number VBELN CHAR 10 internal
Rejection status for SD item ABSTA CHAR 1 internal
Item number of the SD document POSNR NUMC 6 internal
General Incompletion Status of Item UVALL CHAR 1 internal
Item Incompletion Status with Respect to Billing UVFAK CHAR 1 internal
Pricing for item is incomplete UVPRS CHAR 1 internal
Incompletion status of the item with regard to delivery UVVLK CHAR 1 internal
Quotation/Inquiry is valid from ANGDT DATS 8 internal
Sales Document Type AUART CHAR 4 internal
Order reason (reason for the business transaction) AUGRU CHAR 3 internal
Date until which bid/quotation is binding (valid-to date) BNDDT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Billing block in SD document FAKSK CHAR 2 internal
Local Currency HWAER CUKY 5 internal
Sold-to party KUNNR CHAR 10 internal
Exchange Rate Type KURST CHAR 4 internal
Customer group 1 KVGR1 CHAR 3 internal
Customer group 2 KVGR2 CHAR 3 internal
Customer group 3 KVGR3 CHAR 3 internal
Customer group 4 KVGR4 CHAR 3 internal
Customer group 5 KVGR5 CHAR 3 internal
Delivery block (document header) LIFSK CHAR 2 internal
Statistics currency STWAE CUKY 5 internal
SD document category VBTYP CHAR 1 internal
Sales Office VKBUR CHAR 4 internal
Sales Group VKGRP CHAR 3 internal
Sales Organization VKORG CHAR 4 internal
Distribution Channel VTWEG CHAR 2 internal
Reason for rejection of quotations and sales orders ABGRU CHAR 2 internal
Changed On AEDAT DATS 8 internal
Order probability of the item AWAHR NUMC 3 internal
94
System: BW4
Gross Weight of the Item BRGEW QUAN 15,3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
Credit data exchange rate for requested delivery date CMKUA DEC 9,5 internal
International Article Number (EAN/UPC) EAN11 CHAR 18 internal
Date on Which Record Was Created ERDAT DATS 8 internal
Name of Person who Created the Object ERNAM CHAR 12 internal
Entry time ERZET TIMS 6 internal
Billing block for item FAKSP CHAR 2 internal
Weight Unit GEWEI UNIT 3 internal
Cumulative confirmed quantity in sales unit KBMENG QUAN 15,3 internal
Cumulative confirmed quantity in base unit KLMENG QUAN 15,3 internal
Condition unit KMEIN UNIT 3 internal
Sales deal KNUMA_AG CHAR 10 internal
Condition pricing unit KPEIN DEC 5 internal
Cumulative Order Quantity in Sales Units KWMENG QUAN 15,3 internal
Subtotal 1 from pricing procedure for condition KZWI1 CURR 13,2 internal
Subtotal 2 from pricing procedure for condition KZWI2 CURR 13,2 internal
Subtotal 3 from pricing procedure for condition KZWI3 CURR 13,2 internal
Subtotal 4 from pricing procedure for condition KZWI4 CURR 13,2 internal
Subtotal 5 from pricing procedure for condition KZWI5 CURR 13,2 internal
Subtotal 6 from pricing procedure for condition KZWI6 CURR 13,2 internal
Minimum delivery quantity in delivery note processing LFMNG QUAN 13,3 internal
Storage Location LGORT CHAR 4 internal
Cumulative required delivery qty (all dlv-relev.sched.lines) LSMENG QUAN 15,3 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Material entered MATWA CHAR 18 internal
Base Unit of Measure MEINS UNIT 3 internal
Material group 1 MVGR1 CHAR 3 internal
Material group 2 MVGR2 CHAR 3 internal
Material group 3 MVGR3 CHAR 3 internal
Material group 4 MVGR4 CHAR 3 internal
Material group 5 MVGR5 CHAR 3 internal
Tax amount in document currency MWSBP CURR 13,2 internal
Net price NETPR CURR 11,2 internal
Net value of the order item in document currency NETWR CURR 15,2 internal
Net Weight of the Item NTGEW QUAN 15,3 internal
Unloading point of the ship-to party PABLA CHAR 25 internal
Bill-to party PKUNRE CHAR 10 internal
Payer PKUNRG CHAR 10 internal
Ship-to party PKUNWE CHAR 10 internal
Product hierarchy PRODH CHAR 18 internal
Forwarding agent PSPDNR CHAR 10 internal
Sales document item category PSTYV CHAR 4 internal
Sales employee PVRTNR NUMC 8 internal
Route ROUTE CHAR 6 internal
Special Stock Indicator SOBKZ CHAR 1 internal
Division SPART CHAR 2 internal
Statistics date STADAT DATS 8 internal
Exchange rate for statistics (Exch.rate at time of creation) STCUR DEC 9,5 internal
95
System: BW4
Reason for material substitution SUGRD CHAR 4 internal
Unlimited overdelivery allowed UEBTK CHAR 1 internal
Overdelivery Tolerance Limit UEBTO DEC 3,1 internal
Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 internal
Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 internal
Factor for converting sales units to base units (target qty) UMZIN DEC 5 internal
Factor for converting sales units to base units (target qty) UMZIZ DEC 5 internal
Underdelivery Tolerance Limit UNTTO DEC 3,1 internal
Date of update for statistics updating VDATU DATS 8 internal
Document number of the reference document VGBEL CHAR 10 internal
Item number of the reference item VGPOS NUMC 6 internal
Document category of preceding SD document VGTYP CHAR 1 internal
Volume unit VOLEH UNIT 3 internal
Volume of the item VOLUM QUAN 15,3 internal
Sales unit VRKME UNIT 3 internal
Shipping Point/Receiving Point VSTEL CHAR 4 internal
SD Document Currency WAERK CUKY 5 internal
Cost in document currency WAVWR CURR 13,2 internal
Plant (Own or External) WERKS CHAR 4 internal
Target quantity UoM ZIEME UNIT 3 internal
Target quantity in sales units ZMENG QUAN 13,3 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Sales district BZIRK CHAR 6 internal
Date on which services rendered FBUDA DATS 8 internal
Billing date for billing index and printout FKDAT DATS 8 internal
Incoterms (Part 1) INCO1 CHAR 3 internal
Incoterms (Part 2) INCO2 CHAR 28 internal
Customer group KDGRP CHAR 2 internal
Account assignment group for this customer KTGRD CHAR 2 internal
Exchange Rate for Price Determination KURSK DEC 9,5 internal
Translation Date KURSK_DAT DATS 8 internal
Date for pricing and exchange rate PRSDT DATS 8 internal
Promotion WAKTION CHAR 10 internal
Product catalog number WMINR CHAR 10 internal
SD Document Currency WAERK_VBAK CUKY 5 internal
Division for order header SPARA CHAR 2 internal
Sales Document Category of Reference Doc. in Order Header VGTYP_AK CHAR 1 internal
Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 internal
Number of order items ANZAUPO DEC 9 internal
Fiscal Year Variant PERIV CHAR 2 internal
Planning in APO APOPLANNED CHAR 1 internal
BW: Net Price Referring to Sales Quantity for Order Item MCBW_NETPR_AVKM
CURR 11,2 internal
Material Type ZMTART CHAR 4 internal
6.6.3.1.5.3.1.1 InfoPackage test
6.6.3.1.5.3.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DGNLAWK9O332321ZLXYXE9CJ1
InfoSource
DataSource 2LIS_11_VAITM
96
System: BW4
Data Type Transaction data
Source System T90CLNT090
Delete content of Data Target -
Last changed by USER03
Date, time 24.12.2013 13:37:56
6.6.3.1.5.3.1.1.2 Selection
Field InfoObject Value from Value toBUKRS 0001
6.6.3.1.5.3.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.6.3.1.5.3.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.7 INFOPROVIDER_A
6.7.1 APUR_O01 - Purchase Order Items (Acquisition)
6.7.1.1 Technical Documentation
6.7.1.1.1 General Information
System BW4
InfoProvider APUR_O01, Purchase Order Items (Acquisition)
Type DSO, Standard
Last changed by BLUETELL
Last change (timestamp) 20.08.2013 08:41:09
Timestamp of documentation 11.04.2014 10:59:59
6.7.1.1.2 Overview of Data Flow (up to DataSources)
Made to order (Aquisition Layer) (APUR_O01) (7.x)
2LIS_02_ITM/E82CLNT800 (7.x)
2LIS_02_ITM/E81CLNT800
6.7.1.1.3 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.7.1.1.4 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E82CLNT800
Purchase Order Items (Acquisition) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E82CLNT800)
97
System: BW4
Key Fields Tech. Name Type Length Source/Value Aggr.Purchasing document number 0OI_EBELN CHAR 10 EBELN
Conversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
6.7.1.1.4.1 Buildup of DataSource 2LIS_02_ITM/E82CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E82CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
98
System: BW4
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
Total delivery time in days LFZTA DEC 13 internal
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
99
System: BW4
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.7.1.1.4.1.1 InfoPackage 2LIS_02_ITM_full
6.7.1.1.4.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DEIFPOQJKNBNECI8SA73V7W6L
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 03:36:37
6.7.1.1.4.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.7.1.1.4.1.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.7.1.1.4.1.1.4 Processing
Parameter Value
100
System: BW4
Update Data Only PSA
Consistency check for Char. -
6.7.1.1.4.1.2 InfoPackage 2LIS_02_ITM-delta
6.7.1.1.4.1.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFVT3ZXJQGZLBEYK2S8XJN1
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 04:39:04
6.7.1.1.4.1.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.7.1.1.4.1.2.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.7.1.1.4.1.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.7.1.1.4.1.3 InfoPackage init
6.7.1.1.4.1.3.1 General Information
Parameter ValueTech. Name ZPAK_DEVBB7RSZVMT7TQULRDELR0RX
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E82CLNT800
Delete content of Data Target -
Last changed by USER22
Date, time 18.03.2013 19:37:27
6.7.1.1.4.1.3.2 Selection
Field InfoObject Value from Value toNo selections set
6.7.1.1.4.1.3.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
101
System: BW4
6.7.1.1.4.1.3.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.7.1.1.5 Buildup InfoProvider/Transform. from Source 2LIS_02_ITM/E81CLNT800
Purchase Order Items (Acquisition) (APUR_O01)
Source: Purchasing Data (Item Level) (2LIS_02_ITM/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
Purchasing document number 0OI_EBELN CHAR 10 EBELNConversion Exit: ALPHA
Item number of purchasing document
0OI_EBELP NUMC 5 EBELP
ZDPDOCNUM CHAR 10
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Fiscal year variant 0FISCVARNT CHAR 2
"Delivery Completed" Indicator 0COMPL_DEL CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BUDAT
Material 0MATERIAL CHAR 18
Material group 0MATL_GROUP CHAR 9
Plant 0PLANT CHAR 4
Purchasing organization 0PURCH_ORG CHAR 4
Purchasing Group 0PUR_GROUP CHAR 3
Storage location 0STOR_LOC CHAR 4
Goods Supplier 0SUPPLIER CHAR 10
Supplying vendor 0SUPPL_VEND CHAR 10
Supplying Plant 0SUPP_PLANT CHAR 4
Supplying plant to which partner roles have been assigned
0SUP_PLANT CHAR 10
Item Deleted 0ITEM_DEL CHAR 1
Vendor 0VENDOR CHAR 10
Local currency 0LOC_CURRCY CUKY 5
Base Unit of Measure 0BASE_UOM UNIT 3
Logical System 0LOG_SYS CHAR 2
BW: Transaction Key 0PROCESSKEY NUMC 3
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitPrice unit 0PRICE_UNIT DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Net price 0NETPRICE CURR LOC_CURRCY
Quantity Confirmed as Requested
0PQCOASREQ QUAN BASE_UOM
Confirmed Quantity 0PCONF_QTY QUAN BASE_UOM
102
System: BW4
6.7.1.1.5.1 DTPs of Transformation 'RSDS 2LIS_02_ITM/E81CLNT800 -> ODSO APUR_O01'
6.7.1.1.5.1.1 DTP 2LIS_02_ITM E81CLNT800 -> APUR_O01
6.7.1.1.5.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4DLWV1UQ9YNAKG3DBC6YIST
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_02_ITM E81CLNT800 -> ODSO APUR_O01
Last changed by USER01
Date, time 26.02.2014 00:21:56
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.7.1.1.5.1.1.2 Filter
Field Description SelectionBSART [ ] 1000 - 2000
6.7.1.1.5.1.1.3 Semantic Groups
Field DescriptionEBELN
EBELP
6.7.1.1.5.2 Buildup of DataSource 2LIS_02_ITM/E81CLNT800
2LIS_02_ITM, Purchasing Data (Item Level) (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Purchasing Document Date BEDAT DATS 8 internal
Purchasing Document Type BSART CHAR 4 internal
Purchasing Document Category BSTYP CHAR 1 internal
Posting date of goods received or invoice receipt for order BUDAT DATS 8 internal
Purchasing Document Number EBELN CHAR 10 internal
Purchasing Group EKGRP CHAR 3 internal
Purchasing Organization EKORG CHAR 4 internal
Local Currency HWAER CUKY 5 internal
Start of Validity Period KDATB DATS 8 internal
End of Validity Period KDATE DATS 8 internal
Field not used LBLIF CHAR 10 internal
Vendor Account Number LIFNR CHAR 10 internal
Different Invoicing Party LIFRE CHAR 10 internal
Supplying Vendor LLIEF CHAR 10 internal
Logical System LOGSY CHAR 10 internal
Logical System ORGLOGSY CHAR 10 internal
Supplying (Issuing) Plant in Stock Transport Order RESWK CHAR 4 internal
Status of Purchasing Document STATU CHAR 1 internal
Date on which the purchasing document was entered SYDAT DATS 8 internal
Purchase order currency WAERS CUKY 5 internal
Exchange Rate WKURS DEC 9,5 internal
Name of Requisitioner/Requester AFNAM CHAR 12 internal
Promotion AKTNR CHAR 10 internal
Current goods receipt quantity in order unit AKTWE QUAN 13,3 internal
103
System: BW4
Number of deliveries ALIEF DEC 9 internal
Reason for Ordering BSGRU CHAR 3 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
"Delivery Completed" Indicator ELIKZ CHAR 1 internal
Material Number EMATN CHAR 18 internal
Final Invoice Indicator EREKZ CHAR 1 internal
Number of Principal Purchase Agreement KONNR CHAR 10 internal
Target Quantity KTMNG QUAN 13,3 internal
Item Number of Principal Purchase Agreement KTPNR NUMC 5 internal
Indicator: relevant quantity deviation KZMAB CHAR 1 internal
Indicator: item counter relevant (R/2->R/3 link, schd.agmt) KZPOS CHAR 1 internal
Indicator: relevant schedule deviation KZTAB CHAR 1 internal
Points score: Shipping notification LAVI DEC 3 internal
Total delivery time in days LFZTA DEC 13 internal
Storage Location LGORT CHAR 4 internal
Base Unit of Measure LMEIN UNIT 3 internal
Variance in the quantity delivered as % MABW DEC 6,2 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 internal
Purchase Order Unit of Measure MEINS UNIT 3 internal
Purchase Order Quantity MENGE QUAN 13,3 internal
Net price NETPR CURR 11,2 internal
Net order value in order currency NETWR CURR 13,2 internal
Price Unit PEINH DEC 5 internal
Item Category in Purchasing Document PSTYP CHAR 1 internal
Points score for compliance with shipping instructions PWEV DEC 3 internal
Points score for on-time delivery PWFR DEC 3 internal
Points score for quantity reliability PWMT DEC 3 internal
Points score for on-time delivery performance PWTT DEC 3 internal
Points score for quality of services PWWE DEC 3 internal
Invoice Receipt Indicator REPOS CHAR 1 internal
Delivery Date Variance in Days TABW DEC 3 internal
Short Text TXZ01 CHAR 40 internal
Denominator for Conversion of Order Unit to Base Unit UMREN DEC 5 internal
Numerator for Conversion of Order Unit to Base Unit UMREZ DEC 5 internal
Indicator: GR-Based Invoice Verification WEBRE CHAR 1 internal
Goods Receipt Indicator WEPOS CHAR 1 internal
Plant WERKS CHAR 4 internal
Evaluated Receipt Settlement (ERS) XERSY CHAR 1 internal
Target Value for Outline Agreement in Document Currency ZWERT CURR 13,2 internal
Fiscal Year Variant PERIV CHAR 2 internal
Interval for Quantity Interval QUAN_INT DEC 3 internal
Interval for Date Split TIME_INT DEC 3 internal
Counter for Date Split NOTIME DEC 3 internal
Counter for Quantity Interval NOQUAN DEC 3 internal
Counter for Items NOPOS DEC 3 internal
Goods supplier PWLIF CHAR 10 internal
Invoicing party PREST CHAR 10 internal
Supplying plant to which partner roles have been assigned PLIWK CHAR 10 internal
Vendor to whom partner roles have been assigned PLIEF CHAR 10 internal
104
System: BW4
Ordering address PBEST CHAR 10 internal
Smoothing Factor: Quantity Variance MGABW DEC 3,2 internal
Smoothing Factor: Date Variance LFABW DEC 3,2 internal
Best Score MAXBW DEC 3 internal
Smoothing Factor: Compliance with Shipping Instructions VVABW DEC 3,2 internal
Time UZEIT TIMS 6 internal
6.7.1.1.5.2.1 InfoPackage Load Pucahsing data - Full
6.7.1.1.5.2.1.1 General Information
Parameter ValueTech. Name ZPAK_DEFLGAMH65T1UU74Z53U156LP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:35:09
6.7.1.1.5.2.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.7.1.1.5.2.1.3 External Data
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.7.1.1.5.2.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.7.1.1.5.2.2 InfoPackage 2LIS_02_ITM- DELTA
6.7.1.1.5.2.2.1 General Information
Parameter ValueTech. Name ZPAK_DEIFEG9C8V8VR63JFKF9AE0TP
InfoSource
DataSource 2LIS_02_ITM
Data Type Transaction data
Source System E81CLNT800
Delete content of Data Target -
Last changed by USER12
Date, time 23.01.2013 02:25:21
6.7.1.1.5.2.2.2 Selection
Field InfoObject Value from Value toNo selections set
6.7.1.1.5.2.2.3 External Data
105
System: BW4
Parameter Value
106
System: BW4
Type of External System
Filename for Ext. Data
Type of External File
6.7.1.1.5.2.2.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.7.2 ASD_O001 - Order Items (Acquisition)
6.7.2.1 Technical Documentation
6.7.2.1.1 General Information
System BW4
InfoProvider ASD_O001, Order Items (Acquisition)
Type DSO, Standard
Last changed by BLUETELL
Last change (timestamp) 20.08.2013 06:40:16
Timestamp of documentation 11.04.2014 11:00:29
6.7.2.1.2 Overview of Data Flow (up to DataSources)
Job options (Aquisition Layer) (ASD_O001) (7.x)
2LIS_13_VDITM/E80CLNT800 (7.x)
2LIS_03_BF/E81CLNT800
6.7.2.1.3 Settings
SIDs Generation upon Activation -
Unique Data Records -
Set Quality Status to OK automatically -
Activate Data Automatically -
Update Data Automatically -
6.7.2.1.4 Buildup InfoProvider/Transform. from Source 2LIS_13_VDITM/E80CLNT800
Order Items (Acquisition) (ASD_O001)
Source: Billing Document Item Data (2LIS_13_VDITM/E80CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 VBELN
Sales document item 0S_ORD_ITEM NUMC 6 POSNR
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 AEDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
Batch number 0BATCH CHAR 10
107
System: BW4
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.7.2.1.4.1 Buildup of DataSource 2LIS_13_VDITM/E80CLNT800
2LIS_13_VDITM, Billing Document Item Data (Source System: E80CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Sales and Distribution Document Number VBELN CHAR 10 ALPHA internal
Item number of the SD document POSNR NUMC 6 internal
Changed On AEDAT DATS 8 internal
Company Code BUKRS CHAR 4 internal
Sales district BZIRK CHAR 6 internal
Billing Type FKART CHAR 4 internal
Billing date for billing index and printout FKDAT DATS 8 internal
Billing category FKTYP CHAR 1 internal
Local Currency HWAER CUKY 5 internal
Customer group KDGRP CHAR 2 internal
108
System: BW4
Sold-to party KUNAG CHAR 10 ALPHA internal
Payer KUNRG CHAR 10 ALPHA internal
Exchange rate for FI postings KURRF DEC 9,5 EXCRT internal
Exchange Rate Type KURST CHAR 4 internal
Statistics currency STWAE CUKY 5 internal
SD document category VBTYP CHAR 1 internal
Sales Organization VKORG CHAR 4 internal
Distribution Channel VTWEG CHAR 2 internal
SD Document Currency WAERK CUKY 5 internal
Promotion AKTNR CHAR 10 ALPHA internal
Sales Document AUBEL CHAR 10 ALPHA internal
Sales Document Item AUPOS NUMC 6 internal
Rebate basis 1 BONBA CURR 13,2 internal
Volume rebate group BONUS CHAR 2 internal
Gross weight BRGEW QUAN 15,3 internal
Gross value of the billing item in document currency BRTWR CURR 15,2 internal
Application Component BWAPPLNM CHAR 30 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
International Article Number (EAN/UPC) EAN11 CHAR 18 EAN11 internal
Date on Which Record Was Created ERDAT DATS 8 internal
Rule in billing plan/invoice plan FAREG CHAR 1 internal
Date on which services rendered FBUDA DATS 8 internal
Actual Invoiced Quantity FKIMG QUAN 13,3 internal
Billing quantity in stockkeeping unit FKLMG QUAN 13,3 internal
Weight Unit GEWEI UNIT 3 CUNIT internal
Sales deal KNUMA_AG CHAR 10 ALPHA internal
Controlling Area KOKRS CHAR 4 internal
Cost Center KOSTL CHAR 10 ALPHA internal
Exchange Rate for Price Determination KURSK DEC 9,5 EXCRT internal
Translation Date KURSK_DAT DATS 8 internal
Customer group 1 KVGR1 CHAR 3 internal
Customer group 2 KVGR2 CHAR 3 internal
Customer group 3 KVGR3 CHAR 3 internal
Customer group 4 KVGR4 CHAR 3 internal
Customer group 5 KVGR5 CHAR 3 internal
Subtotal 1 from pricing procedure for condition KZWI1 CURR 13,2 internal
Subtotal 2 from pricing procedure for condition KZWI2 CURR 13,2 internal
Subtotal 3 from pricing procedure for condition KZWI3 CURR 13,2 internal
Subtotal 4 from pricing procedure for condition KZWI4 CURR 13,2 internal
Subtotal 5 from pricing procedure for condition KZWI5 CURR 13,2 internal
Subtotal 6 from pricing procedure for condition KZWI6 CURR 13,2 internal
Storage Location LGORT CHAR 4 internal
Required quantity for mat.management in stockkeeping units LMENG QUAN 13,3 internal
Material Group MATKL CHAR 9 internal
Material Number MATNR CHAR 18 MATN1 internal
Material entered MATWA CHAR 18 MATN1 internal
Base Unit of Measure MEINS UNIT 3 CUNIT internal
Material group 1 MVGR1 CHAR 3 internal
Material group 2 MVGR2 CHAR 3 internal
Material group 3 MVGR3 CHAR 3 internal
Material group 4 MVGR4 CHAR 3 internal
109
System: BW4
Material group 5 MVGR5 CHAR 3 internal
Tax amount in document currency MWSBP CURR 13,2 internal
Net value of the billing item in document currency NETWR CURR 15,2 internal
Net weight NTGEW QUAN 15,3 internal
Bill-to party PKUNRE CHAR 10 ALPHA internal
Ship-to party PKUNWE CHAR 10 ALPHA internal
Item type POSAR CHAR 1 internal
Product hierarchy PRODH CHAR 18 internal
Commission group PROVG CHAR 2 internal
Date for pricing and exchange rate PRSDT DATS 8 internal
Sales document item category PSTYV CHAR 4 internal
Sales employee PVRTNR NUMC 8 internal
Amount eligible for cash discount in document currency SKFBP CURR 13,2 internal
Scale quantity in base unit of measure SMENG QUAN 13,3 internal
Division for order header SPARA CHAR 2 internal
Division SPART CHAR 2 internal
Statistics date STADAT DATS 8 internal
Exchange rate for statistics (Exch.rate at time of creation) STCUR DEC 9,5 EXCRT internal
Denominator (Divisor) for Conversion of Sales Qty into SKU UMVKN DEC 5 internal
Numerator (factor) for conversion of sales quantity into SKU UMVKZ DEC 5 internal
Date of update for statistics updating VDATU DATS 8 internal
Document number of the reference document VGBEL CHAR 10 ALPHA internal
Item number of the reference item VGPOS NUMC 6 internal
Sales Office VKBUR CHAR 4 internal
Sales Group VKGRP CHAR 3 internal
Volume unit VOLEH UNIT 3 CUNIT internal
Volume VOLUM QUAN 15,3 internal
Sales unit VRKME UNIT 3 CUNIT internal
Shipping Point/Receiving Point VSTEL CHAR 4 internal
Cost in document currency WAVWR CURR 13,2 internal
Plant WERKS CHAR 4 internal
Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 ABPSN internal
Number of billing items ANZFKPOS DEC 9 internal
Fiscal Year Variant PERIV CHAR 2 internal
6.7.2.1.4.1.1 InfoPackage 2LIS_13_VDITM info package
6.7.2.1.4.1.1.1 General Information
Parameter ValueTech. Name ZPAK_DFULHSVK8SM93DK4KU1FM2RHP
InfoSource
DataSource 2LIS_13_VDITM
Data Type Transaction data
Source System E80CLNT800
Delete content of Data Target -
Last changed by USER04
Date, time 15.08.2013 15:06:29
6.7.2.1.4.1.1.2 Selection
Field InfoObject Value from Value toNo selections set
6.7.2.1.4.1.1.3 External Data
110
System: BW4
Parameter ValueType of External System
Filename for Ext. Data
Type of External File
6.7.2.1.4.1.1.4 Processing
Parameter ValueUpdate Data Only PSA
Consistency check for Char. -
6.7.2.1.5 Buildup InfoProvider/Transform. from Source 2LIS_03_BF/E81CLNT800
Order Items (Acquisition) (ASD_O001)
Source: Goods Movements From Inventory Management (2LIS_03_BF/E81CLNT800)Key Fields Tech. Name Type Length Source/Value Aggr.
ZDPDOCNUM CHAR 10 AKTNR
Sales document item 0S_ORD_ITEM NUMC 6 AUFNR
Fiscal year variant 0FISCVARNT CHAR 2
Data Fields, CharacteristicsFiscal year / period 0FISCPER NUMC 7
Delivery Status 0DLV_STS CHAR 1
Overall delivery status of the item
0DLV_STSO CHAR 1
Date on which the record was created
0CREATEDON DATS 8 BLDAT
Independent of Delivery Tolerances
0BND_IND CHAR 1
Material 0MATERIAL CHAR 18
Batch number 0BATCH CHAR 10
Sold-to party 0SOLD_TO CHAR 10
Company code 0COMP_CODE CHAR 4
Customer Group 0CUST_GROUP CHAR 2
Distribution Channel 0DISTR_CHAN CHAR 2
Sales group 0SALES_GRP CHAR 3
Sales Organization 0SALESORG CHAR 4
Material group 0MATL_GROUP CHAR 9
Product hierarchy 0PROD_HIER CHAR 18
Plant 0PLANT CHAR 4
Ship-To Party 0SHIP_TO CHAR 10
Shipping point 0SHIP_POINT CHAR 4
Division 0DIVISION CHAR 2
Forw.Agent 0FORWAGENT CHAR 10
Payer 0PAYER CHAR 10
Sales unit 0SALES_UNIT UNIT 3
Document currency 0DOC_CURRCY CUKY 5
Item Deleted 0ITEM_DEL CHAR 1
BW Delta Process: Update Mode
0RECORDMODE CHAR 1
Data Fields, Key Figures Tech. Name Type UnitQuantity Confirmed as Requested
0QCOASREQ QUAN SALES_UNIT
111
System: BW4
Confirmed quantity 0CONF_QTY QUAN SALES_UNIT
Desired Delivery Quantity 0REQU_QTY QUAN SALES_UNIT
Actual quantity delivered (in sales units)
0DLV_QTY QUAN SALES_UNIT
Amount with Set GI Status 0GIS_QTY QUAN SALES_UNIT
Tolerance Limit for Under Delivery in %
0LOWR_BND DEC
Tolerance Limit for Over Delivery in %
0UPPR_BND DEC
Net price 0NET_PRICE CURR DOC_CURRCY
Net Price per 1*VKME 0NETPR_VKM CURR DOC_CURRCY
6.7.2.1.5.1 DTPs of Transformation 'RSDS 2LIS_03_BF/E81CLNT800 -> ODSO ASD_O001'
6.7.2.1.5.1.1 DTP 2LIS_03_BF E81CLNT800 -> ASD_O001
6.7.2.1.5.1.1.1 General Information
Parameter ValueTech. Name DTP_DH4GMAKVJS9SDBE3L301Q4JHP
Type Standard (Can Be Scheduled)
Source, Target RSDS 2LIS_03_BF E81CLNT800 -> ODSO ASD_O001
Last changed by USER01
Date, time 26.02.2014 08:53:35
Extraction mode Delta
Error handling Valid Records Update, No Reporting (Request Red)
Processing mode Serial Extraction, Immediate Parallel Processing
Batch Parameter 3 parallel processes, Job Class 'C'
6.7.2.1.5.1.1.2 Filter
Field Description SelectionBLDAT [ ] 20120101 - 99991231
6.7.2.1.5.1.1.3 Semantic Groups
Field DescriptionAKTNR
AUFNR
6.7.2.1.5.2 Buildup of DataSource 2LIS_03_BF/E81CLNT800
2LIS_03_BF, Goods Movements From Inventory Management (Source System: E81CLNT800)Field, Description Field, Tech. name Type Length Conv. FormatIndicator: Cancel Data Record ROCANCEL CHAR 1 internal
Promotion AKTNR CHAR 10 internal
Order Number AUFNR CHAR 12 internal
Routing number of operations in the order AUFPL NUMC 10 internal
Valuation Class BKLAS CHAR 4 internal
Document Date in Document BLDAT DATS 8 internal
Delivery costs in local currency BNBTR CURR 15,2 internal
Stock Values in the Logistics Information System BSTAUS CHAR 1 internal
Stock categories in the Logistics Information System BSTTYP CHAR 1 internal
Posting Date in the Document BUDAT DATS 8 internal
112
System: BW4
Company Code BUKRS CHAR 4 internal
Application Component BWAPPLNM CHAR 30 internal
Movement Type (Inventory Management) BWART CHAR 3 internal
BW: Stock Relevance BWBREL CHAR 1 internal
BW: Unique Identification of Line Item BWCOUNTER NUMC 6 internal
BW: Cost Value in Local Currency BWGEO CURR 19,2 internal
BW: Retail Value in Local Currency BWGVO CURR 19,2 internal
BW: Retail Value with Tax in Local Currency BWGVP CURR 19,2 internal
Valuation Area BWKEY CHAR 4 internal
BW: Quantity in Base Unit of Measure BWMNG QUAN 15,3 internal
Work Breakdown Structure Element (External) BWPSPEX CHAR 24 internal
Valuation Type BWTAR CHAR 10 internal
SAP BW transaction key BWVORG NUMC 3 internal
Batch Number CHARG CHAR 10 internal
Amount in local currency DMBTR CURR 15,2 internal
Purchasing Document Number EBELN CHAR 10 internal
Item Number of Purchasing Document EBELP NUMC 5 internal
Unit of Entry ERFME UNIT 3 internal
Quantity in Unit of Entry ERFMG QUAN 13,3 internal
Reason for goods movment GRUND NUMC 4 internal
Business Area GSBER CHAR 4 internal
Sales Order Number KDAUF CHAR 10 internal
Delivery Schedule for Sales Order KDEIN NUMC 4 internal
Item Number in Sales Order KDPOS NUMC 6 internal
Controlling Area KOKRS CHAR 4 internal
Cost Center KOSTL CHAR 10 internal
Cost Object KSTRG CHAR 12 internal
Account Number of Customer KUNNR CHAR 10 internal
Movement Indicator KZBEW CHAR 1 internal
Valuation of Special Stock KZBWS CHAR 1 internal
Warehouse Number / Warehouse Complex LGNUM CHAR 3 internal
Storage Location LGORT CHAR 4 internal
Storage Bin LGPLA CHAR 10 internal
Storage Type LGTYP CHAR 3 internal
Vendor Account Number LIFNR CHAR 10 internal
Material Number MATNR CHAR 18 internal
Number of Material Document MBLNR CHAR 10 internal
Base Unit of Measure MEINS UNIT 3 internal
Quantity MENGE QUAN 15,3 internal
Material Document Year MJAHR NUMC 4 internal
Network Number for Account Assignment NPLNR CHAR 12 internal
WMS Number of pallets PALAN DEC 11 internal
Profitability Segment Number (CO-PA) PAOBJNR NUMC 10 internal
Profit Center PRCTR CHAR 10 internal
Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 internal
G/L Account Number SAKTO CHAR 10 internal
Debit/Credit Indicator SHKZG CHAR 1 internal
Special Stock Indicator SOBKZ CHAR 1 internal
Receiving/Issuing Plant UMWRK CHAR 4 internal
Local Currency WAERS CUKY 5 internal
Goods Recipient/Ship-To Party WEMPF CHAR 12 internal
Plant WERKS CHAR 4 internal
113
System: BW4
Item in Material Document ZEILE NUMC 4 internal
Fiscal Year Variant PERIV CHAR 2 internal
Counter for Items NOPOS DEC 3 internal
EA Retail BW Extr. Enhancement: Item Type ITEM_CAT NUMC 2 internal
EA Retail BW Extr. Enhancement: Data Record Type REC_TYPE NUMC 1 internal
Material Category ATTYP CHAR 2 internal
Plant category VLFKZ CHAR 1 internal
Item automatically created SAUTO CHAR 1 internal
Structured material MATST CHAR 18 internal
Value at Sales Prices Including Value-Added Tax VKSTT CURR 13,2 internal
Value at sales prices excluding value-added tax VKSTA CURR 13,2 internal
Indicator: Movement type is stock transfer UMLKZ CHAR 1 internal
Indicator: Return from call RETKZ CHAR 1 internal
Indicator: Movement type is physical inventory INVKZ CHAR 1 internal
Indicator: Movement type is inventory correction KORR CHAR 1 internal
Transfer Posting Material to Material UMMATKZ CHAR 1 internal
Currency Key WAERSST CUKY 5 internal
7 Roles and Authorizations
7.1 ZBI:DP_PUR_ACCESS/001 - DP - Purchase Access
7.1.1 Technical Documentation
7.1.1.1 General Information
System BW4
Role ZBI:DP_PUR_ACCESS/001, DP - Purchase Access
Parent Role -
Related Single Roles -
Profile name
Profile text
Status
Last changed by ADMUSER
Last change (timestamp) 11.01.2013 10:54:42
Timestamp of documentation 11.04.2014 11:00:47
7.1.1.2 Long descriptionRole Description: This role is a common role designed to provide general access to all end users using the SAP environment. This role should contain security troubleshooting reports, ability of user to reset their own password, ability of user to print their own print jobs, ability of users to execute their own batch jobs, etc. Should this role require any organization specific fields, this role will become a master role and derived roles will be created and assigned to split to specific organizations. Role Changes: 18/10/2010 - David Carvalho(CGI) - Initial Creation Intitial Role Creation.
7.1.1.3 Role menu
General Access Find in SAP Menu Find in User Menu Display Own Jobs Display Spool Requests Maintain Users Own Data Own data Evaluate Authorization Check Analyze User Buffer
114
System: BW4
7.1.1.4 Authorization data
7.1.1.4.1 AAAB - Cross-application Authorization Objects
S_TCODE - Transaction Code Check at Transaction Start [T-DW54001000]
Authorizations field ValuesTCD SEARCH_SAP_MENU, SEARCH_USER_MENU, SMX, SP02, SU3, SU50, SU53, SU56
7.1.1.4.2 BC_A - Basis: Administration
S_ADMI_FCD - System Authorizations [T-DW54001000]
Authorizations field ValuesS_ADMI_FCD ' '
S_SPO_ACT - Spool: Actions [T-DW54001000]
Authorizations field ValuesSPOACTION ATTR, BASE, DELE, REDI, REPR
SPOAUTH ' '
S_SPO_DEV - Spool: Device authorizations [T-DW54001000]
Authorizations field ValuesSPODEVICE LOCAL, LOCL
S_SPO_PAGE - Spool: Restriction on Maximum Number of Pages [T-DW54001000]
Authorizations field ValuesSPODEVICE LOCL
SPOPAGES *
S_USER_AGR - Authorizations: Role Check [T-DW54001000]
Authorizations field ValuesACT_GROUP *
ACTVT 03 Show
S_USER_AUT - User Master Maintenance: Authorizations [T-DW54001000]
Authorizations field ValuesACTVT 03 Show
AUTH *
OBJECT *
S_USER_GRP - User Master Maintenance: User Groups [T-DW54001000]
Authorizations field ValuesACTVT 03 Show
CLASS *
7.1.1.4.3 BC_C - Basis - Development Environment
115
System: BW4
S_DEVELOP - ABAP Workbench [T-DW54001000]
Authorizations field ValuesACTVT 03 Show
DEVCLASS *
OBJNAME *
OBJTYPE SUSO
P_GROUP *
S_DEVELOP - ABAP Workbench [T-DW54001001]
Authorizations field ValuesACTVT 01, 02 Change, 03 Show, 06, 16 Execute
DEVCLASS
OBJNAME
OBJTYPE
P_GROUP
116