SAP ABAP Table S281BIW2 (S281BIW2 * Order Process, BW)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   LO-LIS (Application Component) Logistics Information System (LIS)
     MCDX (Package) Logistics Information System / SAP-BW (Release-Dependent)
Basic Data
Table Category TRANSP    Transparent table 
Transparent table S281BIW2   Table Relationship Diagram
Short Description S281BIW2 * Order Process, BW    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 SSOUR SSOUR SSOUR CHAR 4   0   Statistic(s) origin  
3 VRSIO VRSIO VRSIO CHAR 3   0   Version number in the information structure *
4 SPMON SPMON MCPERIOD NUMC 6   0   Period to analyze - month  
5 SPTAG SPTAG DATUM DATS 8   0   Period to analyze - current date  
6 SPWOC SPWOC MCPERIOD NUMC 6   0   Period to analyze - week  
7 SPBUP SPBUP MCPERIOD NUMC 6   0   Period to analyze - posting period  
8 AUFNR AUFNR AUFNR CHAR 12   0   Order Number AUFK
9 VORNR VORNR VORNR CHAR 4   0   Operation/Activity Number  
10 UVORN UVORN VORNR CHAR 4   0   Suboperation  
11 PERIV PERIV PERIV CHAR 2   0   Fiscal Year Variant *
12 VWDAT VWDAT VWDAT NUMC 10   0   Pointer to administrative data  
13 MEINH VORME MEINS UNIT 3   0   Unit of measure for activity T006
14 DFZEH DFZEH EINHEIT UNIT 3   0   Unit of measure for execution time  
15 RSTZE RSTZE EINHEIT UNIT 3   0   Unit of measure for setup time  
16 BEAZE BEAZE EINHEIT UNIT 3   0   Unit of measure for processing time  
17 ARUZE ARUZE EINHEIT UNIT 3   0   Unit of measure for teardown  
18 LIGZE LIGZE EINHEIT UNIT 3   0   Unit of measure for wait time  
19 TRAZE TRAZE EINHEIT UNIT 3   0   Unit of measure for move time  
20 WRTZE WTRZE EINHEIT UNIT 3   0   Unit of measure for queue time  
21 KEINH CY_KEINH MEINS UNIT 3   0   Unit of of measure for displaying capacity requirements T006
22 MGVRG MC_MGVRG MENGV15 QUAN 15   3   Operation quantity  
23 ASVRG MC_ASVRG MENGV15 QUAN 15   3   Operation scrap  
24 GMNGA MC_GMNGA MENGV15 QUAN 15   3   Total Delivered Lot Size  
25 LMNGA MC_LMNGA MENGV15 QUAN 15   3   Total quantity confirmed  
26 XMNGA MC_XMNGA MENGV15 QUAN 15   3   Total scrap quantity confirmed  
27 FSEDD FSEDD DATUM DATS 8   0   Earliest scheduled finish: Execution (date)  
28 FSAVD FSAVD DATUM DATS 8   0   Earliest scheduled start: Execution (date)  
29 IEAVD IEAVD DATUM DATS 8   0   Actual finish of operation (date)  
30 IADD IADD DATUM DATS 8   0   Actual input date  
31 IEDD IEDD DATUM DATS 8   0   Actual finish: Execution (date)  
32 ISDD ISDD DATUM DATS 8   0   Actual start: Execution (date)  
33 SSADD SSADD DATUM DATS 8   0   Latest target input date  
34 SSAVD SSAVD DATUM DATS 8   0   Latest scheduled start: Execution (date)  
35 SSEDD SSEDD DATUM DATS 8   0   Latest scheduled finish: Execution (date)  
36 ISAVD ISAVD DATUM DATS 8   0   Actual operation start (date)  
37 S_DFZ S_DFZ DAUER_6_1V QUAN 7   1   Target execution time  
38 I_DFZ I_DFZ DAUER_6_1V QUAN 7   1   Actual execution time  
39 RUEST MC_RUEST DAUER_6_1V QUAN 7   1   Scheduled setup time  
40 BEARZ MC_BEARZ DAUER_6_1V QUAN 7   1   Scheduled processing time  
41 ABRUE MC_ABRUE DAUER_6_1V QUAN 7   1   Scheduled teardown time  
42 LIEGZ MC_LIEGZ DAUER_6_1V QUAN 7   1   Wait time used for scheduling  
43 TRANZ MC_TRANZ DAUER_6_1V QUAN 7   1   Move time used for scheduling  
44 WARTZ MC_WARTZ DAUER_6_1V QUAN 7   1   Queue time used for scheduling  
45 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
46 ARBPL ARBPL ARBPL CHAR 8   0   Work center  
47 KRUES MC_KRUES DAUER_6_1V QUAN 7   1   Scheduled cap. requirements for the op. segment "setup"  
48 KBEAS MC_KBEAS DAUER_6_1V QUAN 7   1   Scheduled cap. requirements for the op. segment "processing"  
49 KABRS MC_KABRS DAUER_6_1V QUAN 7   1   Scheduled cap. requirements for the op. segment teardown  
50 MCFSEDD MCFSEDD DEC9 DEC 9   0   Earliest Scheduled Finish: Execution (Date)  
51 MCFSAVD MCFSAVD DEC9 DEC 9   0   Earliest Scheduled Start: Execution (Date)  
52 MCIADD MCIADD DEC9 DEC 9   0   Actual input date  
53 MCIEAVD MCIEAVD DEC9 DEC 9   0   Actual Finish of Operation (Date)  
54 MCISAVD MCISAVD DEC9 DEC 9   0   Actual operation start (date)  
55 MCSSADD MCSSADD DEC9 DEC 9   0   Latest target input date  
56 MCSSEDD MCSSEDD DEC9 DEC 9   0   Latest Scheduled Finish: Execution (Date)  
57 MCSSAVD MCSSAVD DEC9 DEC 9   0   Latest Scheduled Start: Execution (Date)  
58 MCISDD MCISDD DEC9 DEC 9   0   Actual Start: Execution (Date)  
59 MCIEDD MCIEDD DEC9 DEC 9   0   Actual End: Execution (Date)  
60 PWERK CO_PWERK WERKS CHAR 4   0   Planning plant for the order T001W
61 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
62 KDAUF CO_KDAUF VBELN CHAR 10   0   Sales order number VBUK
63 S_DLZ S_DLZ DAUER_6_1V QUAN 7   1   Target lead time  
64 I_DLZ I_DLZ DAUER_6_1V QUAN 7   1   Actual lead time  
65 Z_TAB X_TAB DAUER_6_1V QUAN 7   1   Deviation from scheduled input date  
66 A_TAB A_TAB DAUER_6_1V QUAN 7   1   Deviation in scheduled output date  
67 R_TAB R_TAB DAUER_6_1V QUAN 7   1   Relative schedule deviation  
68 R_TABP R_TABP DAUER_6_1 QUAN 7   1   Relative Schedule Deviation Positive  
69 R_TABN R_TABN DAUER_6_1 QUAN 7   1   Relative Schedule Deviation Negative  
70 A_TABP A_TABP DAUER_6_1 QUAN 7   1   Date Variance of Issue, Positive  
71 A_TABN A_TABN DAUER_6_1 QUAN 7   1   Date Variance of Issue, Negative  
72 Z_TABP X_TABP DAUER_6_1 QUAN 7   1   Schedule Deviation Input Positive  
73 Z_TABN X_TABN DAUER_6_1 QUAN 7   1   Schedule Deviation Input Negative  
74 FTRMI CO_FTRMI DATUM DATS 8   0   Actual release date  
75 ANZFA MC_ANZFA MCZAEHLER DEC 9   0   Number of production orders  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 S281BIW2 AUFNR AUFK AUFNR    
2 S281BIW2 KDAUF VBUK VBELN    
3 S281BIW2 KEINH T006 MSEHI    
4 S281BIW2 MANDT T000 MANDT    
5 S281BIW2 MATNR MARA MATNR    
6 S281BIW2 MEINH T006 MSEHI    
7 S281BIW2 PWERK T001W WERKS    
8 S281BIW2 WERKS T001W WERKS    
History
Last changed by/on SAP  20110901 
SAP Release Created in