SAP ABAP Table S280BIW1 (S280BIW1 * Order header and item, 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)
⤷ 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 | S280BIW1 | Table Relationship Diagram |
Short Description | S280BIW1 * Order header and item, 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 | POSNR | CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
10 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
11 | VWDAT | VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
12 | MEINS | LAGME | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
13 | DFZEH | DFZEH | EINHEIT | UNIT | 3 | 0 | Unit of measure for execution time | ||
14 | KEINH | CY_KEINH | MEINS | UNIT | 3 | 0 | Unit of of measure for displaying capacity requirements | T006 | |
15 | GLTRP | CO_GLTRP | DATUM | DATS | 8 | 0 | Basic finish date | ||
16 | FTRMI | CO_FTRMI | DATUM | DATS | 8 | 0 | Actual release date | ||
17 | FTRMP | CO_FTRMP | DATUM | DATS | 8 | 0 | Planned release date | ||
18 | GSTRI | CO_GSTRI | DATUM | DATS | 8 | 0 | Actual start date | ||
19 | GETRI | CO_GETRI | DATUM | DATS | 8 | 0 | Confirmed Order Finish Date | ||
20 | GSTRP | CO_GSTRP | DATUM | DATS | 8 | 0 | Basic start date | ||
21 | GLTRS | CO_GLTRS | DATUM | DATS | 8 | 0 | Scheduled finish | ||
22 | FTRMS | CO_FTRMS | DATUM | DATS | 8 | 0 | Scheduled release date | ||
23 | GSTRS | CO_GSTRS | DATUM | DATS | 8 | 0 | Scheduled start | ||
24 | LTRMI | CO_LTRMI | DATUM | DATS | 8 | 0 | Actual delivery/finish date | ||
25 | LTRMP | CO_LTRMP | DATUM | DATS | 8 | 0 | Delivery date from planned order | ||
26 | ETRMP | CO_ETRMP | DATUM | DATS | 8 | 0 | Opening date of the planned order | ||
27 | STRMP | CO_STRMP | DATUM | DATS | 8 | 0 | Start date of the planned order | ||
28 | PGMNG | MC_GSMNG | MENGV15_3 | QUAN | 15 | 3 | Total planned order quantity | ||
29 | PAMNG | MC_AVMNG | MENGV15_3 | QUAN | 15 | 3 | Fixed quantity of scrap from production | ||
30 | PSMNG | MC_PSMNG | MENGV15_3 | QUAN | 15 | 3 | Order item quantity | ||
31 | PSAMG | MC_PSAMG | MENGV15_3 | QUAN | 15 | 3 | Scrap quantity in item | ||
32 | WEMNG | MC_WEMNG | MENGV15_3 | QUAN | 15 | 3 | Quantity of goods received | ||
33 | IAMNG | MC_IAMNG | MENGV15_3 | QUAN | 15 | 3 | Actual scrap quantity from an order item | ||
34 | S_DFZ | S_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Target execution time | ||
35 | I_DFZ | I_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Actual execution time | ||
36 | KSUMS | MC_KSUMS | DAUER_6_1V | QUAN | 7 | 1 | Total target capacity requirements | ||
37 | MCGLTRP | MCGLTRP | DEC9 | DEC | 9 | 0 | Basic Finish Date | ||
38 | MCGSTRP | MCGSTRP | DEC9 | DEC | 9 | 0 | Basic start date | ||
39 | MCFTRMP | MCFTRMP | DEC9 | DEC | 9 | 0 | Planned release date | ||
40 | MCLTRMI | MCLTRMI | DEC9 | DEC | 9 | 0 | Actual delivery/finish date | ||
41 | MCGETRI | MCGETRI | DEC9 | DEC | 9 | 0 | Confirmed Order Finish Date | ||
42 | MCFTRMI | MCFTRMI | DEC9 | DEC | 9 | 0 | Actual release date | ||
43 | MCGSTRI | MCGSTRI | DEC9 | DEC | 9 | 0 | Actual Start Date | ||
44 | MCLTRMP | MCLTRMP | DEC9 | DEC | 9 | 0 | Delivery date from planned order | ||
45 | MCETRMP | MCETRMP | DEC9 | DEC | 9 | 0 | Opening Date of the Planned Order | ||
46 | MCSTRMP | MCSTRMP | DEC9 | DEC | 9 | 0 | Start date of the planned order | ||
47 | MCFTRMS | MCFTRMS | DEC9 | DEC | 9 | 0 | Scheduled release date | ||
48 | MCGSTRS | MCGSTRS | DEC9 | DEC | 9 | 0 | Scheduled Start | ||
49 | MCGLTRS | MCGLTRS | DEC9 | DEC | 9 | 0 | Scheduled finish | ||
50 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
51 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
52 | KDAUF | CO_KDAUF | VBELN | CHAR | 10 | 0 | Sales order number | VBUK | |
53 | PWERK | CO_PWERK | WERKS | CHAR | 4 | 0 | Planning plant for the order | T001W | |
54 | P_DLZ | P_DLZ | DAUER_6_1V | QUAN | 7 | 1 | Planned lead time | ||
55 | S_DLZ | S_DLZ | DAUER_6_1V | QUAN | 7 | 1 | Target lead time | ||
56 | I_DLZ | I_DLZ | DAUER_6_1V | QUAN | 7 | 1 | Actual lead time | ||
57 | PS_FREI | PS_FREI | DAUER_6_1V | QUAN | 7 | 1 | Planned/target deviation in scheduled release date | ||
58 | PI_FREI | PI_FREI | DAUER_6_1V | QUAN | 7 | 1 | Planned/actual deviation in scheduled release date | ||
59 | SI_FREI | DSI_FREI | DAUER_6_1V | QUAN | 7 | 1 | Target/actual deviation in scheduled release date | ||
60 | PS_STAR | PS_STAR | DAUER_6_1V | QUAN | 7 | 1 | Planned/target deviation in start date | ||
61 | PI_STAR | PI_STAR | DAUER_6_1V | QUAN | 7 | 1 | Planned/actual deviation in scheduled start date | ||
62 | SI_STAR | DSI_STAR | DAUER_6_1V | QUAN | 7 | 1 | Target/actual schedule deviation in start date | ||
63 | PS_LIEF | PS_LIEF | DAUER_6_1V | QUAN | 7 | 1 | Planned/target deviation in scheduled delivery date | ||
64 | PI_LIEF | PI_LIEF | DAUER_6_1V | QUAN | 7 | 1 | Planned/actual deviation in scheduled delivery date | ||
65 | SI_LIEF | DSI_LIEF | DAUER_6_1V | QUAN | 7 | 1 | Target/actual deviation in scheduled delivery date | ||
66 | PI_FREIP | PI_FREIP | DAUER_6_1 | QUAN | 7 | 1 | Release Schedule Deviation Plan/Actual Positive | ||
67 | PI_FREIN | PI_FREIN | DAUER_6_1 | QUAN | 7 | 1 | Release Schedule Deciation Plan/Actual Negative | ||
68 | PI_LIEFP | PI_LIEFP | DAUER_6_1 | QUAN | 7 | 1 | Delivery Schedule Deviation Plan/Actual Positive | ||
69 | PI_LIEFN | PI_LIEFN | DAUER_6_1 | QUAN | 7 | 1 | Delivery Schedule Deviation Plan/Actual Negative | ||
70 | PI_STARP | PI_STARP | DAUER_6_1 | QUAN | 7 | 1 | Start Schedule Deviation Plan/Actual Positive | ||
71 | PI_STARN | PI_STARN | DAUER_6_1 | QUAN | 7 | 1 | Start Schedule Deviation Plan/Actual Negative | ||
72 | PS_FREIP | PS_FREIP | DAUER_6_1 | QUAN | 7 | 1 | Release Schedule Deviation Plan/Target Positive | ||
73 | PS_FREIN | PS_FREIN | DAUER_6_1 | QUAN | 7 | 1 | Release Schedule Deviation Plan/Target Negative | ||
74 | PS_LIEFP | PS_LIEFP | DAUER_6_1 | QUAN | 7 | 1 | Delivery Schedule Deviation Plan/Target Positive | ||
75 | PS_LIEFN | PS_LIEFN | DAUER_6_1 | QUAN | 7 | 1 | Delivery Schedule Deviation Plan/Target Negative | ||
76 | PS_STARP | PS_STARP | DAUER_6_1 | QUAN | 7 | 1 | Start Schedule Deviation Plan/Target Positive | ||
77 | PS_STARN | PS_STARN | DAUER_6_1 | QUAN | 7 | 1 | Start Schedule Deviation Plan/Target Negative | ||
78 | SI_FREIP | DSI_FREIP | DAUER_6_1 | QUAN | 7 | 1 | Release Date Variance Target/Actual Positive | ||
79 | SI_FREIN | DSI_FREIN | DAUER_6_1 | QUAN | 7 | 1 | Release Date Variance Target/Actual Negative | ||
80 | SI_LIEFP | DSI_LIEFP | DAUER_6_1 | QUAN | 7 | 1 | Delivery Date Variance Target/Actual Positive | ||
81 | SI_LIEFN | DSI_LIEFN | DAUER_6_1 | QUAN | 7 | 1 | Delivery Date Variance Target/Actual Negative | ||
82 | SI_STARP | DSI_STARP | DAUER_6_1 | QUAN | 7 | 1 | Start Date Variance Target/Actual Positive | ||
83 | SI_STARN | DSI_STARN | DAUER_6_1 | QUAN | 7 | 1 | Start Date Variance Target/Actual Negative | ||
84 | 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 | S280BIW1 | AUFNR | AUFK | AUFNR | |||
2 | S280BIW1 | KDAUF | VBUK | VBELN | |||
3 | S280BIW1 | KEINH | T006 | MSEHI | |||
4 | S280BIW1 | MANDT | T000 | MANDT | |||
5 | S280BIW1 | MATNR | MARA | MATNR | |||
6 | S280BIW1 | MEINS | T006 | MSEHI | |||
7 | S280BIW1 | PWERK | T001W | WERKS | |||
8 | S280BIW1 | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in |