SAP ABAP Table MCAFPO (Order Item)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ PP-IS (Application Component) Information System
⤷ MCF (Package) R/3 application development: Shop Floor Information System
⤷ PP-IS (Application Component) Information System
⤷ MCF (Package) R/3 application development: Shop Floor Information System
Basic Data
Table Category | INTTAB | Structure |
Structure | MCAFPO | Table Relationship Diagram |
Short Description | Order Item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
2 | POSNR | CO_POSNR | CO_POSNR | NUMC | 4 | 0 | Order item number | ||
3 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
4 | PWERK | CO_PWERK | WERKS | CHAR | 4 | 0 | Planning plant for the order | T001W | |
5 | ETRMP | CO_ETRMP | DATUM | DATS | 8 | 0 | Opening date of the planned order | ||
6 | STRMP | CO_STRMP | DATUM | DATS | 8 | 0 | Start date of the planned order | ||
7 | LTRMP | CO_LTRMP | DATUM | DATS | 8 | 0 | Delivery date from planned order | ||
8 | LTRMI | CO_LTRMI | DATUM | DATS | 8 | 0 | Actual delivery/finish date | ||
9 | PAMNG | MC_AVMNG | MENGV15_3 | QUAN | 15 | 3 | Fixed quantity of scrap from production | ||
10 | PGMNG | MC_GSMNG | MENGV15_3 | QUAN | 15 | 3 | Total planned order quantity | ||
11 | MEINS | LAGME | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
12 | MCPAMNG | MC_MCPAMNG | MENGV15 | QUAN | 15 | 3 | Fixed production scrap qty in unit of in-house production | ||
13 | MCPGMNG | MC_MCPGMNG | MENGV15 | QUAN | 15 | 3 | Total planned order quantity in unit of in-house production | ||
14 | PSAMG | MC_PSAMG | MENGV15_3 | QUAN | 15 | 3 | Scrap quantity in item | ||
15 | PSMNG | MC_PSMNG | MENGV15_3 | QUAN | 15 | 3 | Order item quantity | ||
16 | WEMNG | MC_WEMNG | MENGV15_3 | QUAN | 15 | 3 | Quantity of goods received | ||
17 | IAMNG | MC_IAMNG | MENGV15_3 | QUAN | 15 | 3 | Actual scrap quantity from an order item | ||
18 | AMEIN | CO_AUFME | MEINS | UNIT | 3 | 0 | Unit of measure for in-house production | T006 | |
19 | UMREZ | UMREZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion to Base Units of Measure | ||
20 | UMREN | UMREN | UMBSN | DEC | 5 | 0 | Denominator for conversion to base units of measure | ||
21 | DFZEH | DFZEH | EINHEIT | UNIT | 3 | 0 | Unit of measure for execution time | ||
22 | S_DFZ | S_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Target execution time | ||
23 | I_DFZ | I_DFZ | DAUER_6_1V | QUAN | 7 | 1 | Actual execution time | ||
24 | KEINH | CY_KEINH | MEINS | UNIT | 3 | 0 | Unit of of measure for displaying capacity requirements | T006 | |
25 | KSUMS | MC_KSUMS | DAUER_6_1V | QUAN | 7 | 1 | Total target capacity requirements | ||
26 | PLNUM | PLNUM | PLNUM | CHAR | 10 | 0 | Planned order number | PLAF | |
27 | KDAUF | CO_KDAUF | VBELN | CHAR | 10 | 0 | Sales order number | VBUK | |
28 | KDPOS | CO_KDPOS | POSNR | NUMC | 6 | 0 | Sales order item | * | |
29 | KDEIN | KDEIN | NUM04 | NUMC | 4 | 0 | Delivery schedule for sales order | ||
30 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
31 | SAFNR | SA_AUFNR | SA_AUFNR | CHAR | 12 | 0 | Run schedule header number | SAFK | |
32 | VERID | VERID | VERID | CHAR | 4 | 0 | Production Version | MKAL | |
33 | SERNR | SERNR | SERNR | CHAR | 8 | 0 | BOM explosion number | SNUM | |
34 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
35 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
36 | SOPNR | SAFNR | SAFNR | CHAR | 10 | 0 | SOP order number | ||
37 | PLCHK1P | MC_PLCHK1P | CHAR1 | CHAR | 1 | 0 | Plausibility check: item w/o actual start | ||
38 | PLCHK2P | MC_PLCHK2P | CHAR1 | CHAR | 1 | 0 | Plausibility Check: Actual Finish Date before Start Date | ||
39 | DFZEXEH | DFZEXEH | EINHEIT | UNIT | 3 | 0 | Unit for execution time (exact) | ||
40 | S_DFZ_EX | S_DFZ_EX | DAUER_10_2V | QUAN | 12 | 2 | Target execution time (exact) | ||
41 | I_DFZ_EX | I_DFZ_EX | DAUER_10_2V | QUAN | 12 | 2 | Actual execution time (exact) | ||
42 | S_DLZ_EX | S_DLZ_EX | DAUER_10_2V | QUAN | 12 | 2 | Target lead time (exact) | ||
43 | I_DLZ_EX | I_DLZ_EX | DAUER_10_2V | QUAN | 12 | 2 | Actual lead time (exact) | ||
44 | BUDAT | MC_LTRMI | DATUM | DATS | 8 | 0 | Posting date delivery/finish date, actual | ||
45 | GRUND | SA_GRUND | CO_AGRND | CHAR | 4 | 0 | Reason for scrap | * | |
46 | PSPNR | REM_PSPNR | PS_POSNR | NUMC | 8 | 0 | Production lot (WBS element) | * | |
47 | P_DLZ | P_DLZ | DAUER_6_1V | QUAN | 7 | 1 | Planned lead time | ||
48 | S_DLZ | S_DLZ | DAUER_6_1V | QUAN | 7 | 1 | Target lead time | ||
49 | I_DLZ | I_DLZ | DAUER_6_1V | QUAN | 7 | 1 | Actual lead time | ||
50 | PS_FREI | PS_FREI | DAUER_6_1V | QUAN | 7 | 1 | Planned/target deviation in scheduled release date | ||
51 | PI_FREI | PI_FREI | DAUER_6_1V | QUAN | 7 | 1 | Planned/actual deviation in scheduled release date | ||
52 | SI_FREI | DSI_FREI | DAUER_6_1V | QUAN | 7 | 1 | Target/actual deviation in scheduled release date | ||
53 | PS_STAR | PS_STAR | DAUER_6_1V | QUAN | 7 | 1 | Planned/target deviation in start date | ||
54 | PI_STAR | PI_STAR | DAUER_6_1V | QUAN | 7 | 1 | Planned/actual deviation in scheduled start date | ||
55 | SI_STAR | DSI_STAR | DAUER_6_1V | QUAN | 7 | 1 | Target/actual schedule deviation in start date | ||
56 | PS_LIEF | PS_LIEF | DAUER_6_1V | QUAN | 7 | 1 | Planned/target deviation in scheduled delivery date | ||
57 | PI_LIEF | PI_LIEF | DAUER_6_1V | QUAN | 7 | 1 | Planned/actual deviation in scheduled delivery date | ||
58 | SI_LIEF | DSI_LIEF | DAUER_6_1V | QUAN | 7 | 1 | Target/actual deviation in scheduled delivery date | ||
59 | .INCLUDE | 0 | 0 | Details: Order Item | |||||
60 | A | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
61 | VDATU | MC_VDATUM | DATUM | DATS | 8 | 0 | Date of update for statistics updating | ||
62 | .INCLUDE | 0 | 0 | User Structure: Order Item | |||||
63 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCAFPO | AMEIN | T006 | MSEHI | |||
2 | MCAFPO | AUFNR | AUFK | AUFNR | |||
3 | MCAFPO | CHARG | MCH1 | CHARG | |||
4 | MCAFPO | GSBER | TGSB | GSBER | |||
5 | MCAFPO | KDAUF | VBUK | VBELN | |||
6 | MCAFPO | KEINH | T006 | MSEHI | |||
7 | MCAFPO | LGORT | T001L | LGORT | |||
8 | MCAFPO | MATNR | MARA | MATNR | |||
9 | MCAFPO | MEINS | T006 | MSEHI | |||
10 | MCAFPO | PLNUM | PLAF | PLNUM | |||
11 | MCAFPO | PWERK | T001W | WERKS | |||
12 | MCAFPO | SAFNR | SAFK | AUFNR | |||
13 | MCAFPO | SERNR | SNUM | SERNR | |||
14 | MCAFPO | VERID | MKAL | VERID |
History
Last changed by/on | SAP | 20020219 |
SAP Release Created in |