SAP ABAP Table MC02MA0BST (Purchase Order Data)
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LO-LIS (Application Component) Logistics Information System (LIS)
⤷ MCEX (Package) Extraction Interface LIS-BW
⤷ LO-LIS (Application Component) Logistics Information System (LIS)
⤷ MCEX (Package) Extraction Interface LIS-BW
Basic Data
Table Category | INTTAB | Structure |
Structure | MC02MA0BST | Table Relationship Diagram |
Short Description | Purchase Order Data |
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 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
2 | .INCLUDE | 0 | 0 | Purchasing Document Header | |||||
3 | EBELN | EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | * | |
4 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
5 | BSTYP | BSTYP | BSTYP | CHAR | 1 | 0 | Purchasing document category | ||
6 | BSART | ESART | BSART | CHAR | 4 | 0 | Purchasing Document Type | * | |
7 | BSAKZ | BSAKZ | BSAKZ | CHAR | 1 | 0 | Control indicator for purchasing document type | ||
8 | LOEKZ_HEAD | ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
9 | LIFNR | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | * | |
10 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | * | |
11 | EKGRP | BKGRP | EKGRP | CHAR | 3 | 0 | Purchasing Group | * | |
12 | WAERS | BSTWA | WAERS | CUKY | 5 | 0 | Purchase order currency | * | |
13 | WKURS | WKURS | KURSP | DEC | 9 | 5 | Exchange Rate | ||
14 | KUFIX | KUFIX | XFELD | CHAR | 1 | 0 | Indicator: Fixing of Exchange Rate | ||
15 | BEDAT | EBDAT | DATUM | DATS | 8 | 0 | Purchasing Document Date | ||
16 | LLIEF | LLIEF | LIFNR | CHAR | 10 | 0 | Supplying Vendor | * | |
17 | KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | * | |
18 | RESWK | RESWK | WERKS | CHAR | 4 | 0 | Supplying (issuing) plant in case of stock transport order | * | |
19 | LBLIF | LBLIF | LIFNR | CHAR | 10 | 0 | Field not used | * | |
20 | KTWRT | KTWRT | WERT15 | CURR | 15 | 2 | Target Value for Header Area per Distribution | ||
21 | SUBMI | SUBMI | CHAR10 | CHAR | 10 | 0 | Collective Number | ||
22 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
23 | STAFO_HEAD | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
24 | LIFRE | LIFRE | LIFNR | CHAR | 10 | 0 | Different Invoicing Party | * | |
25 | FRGRL | FRGRL | XFELD | CHAR | 1 | 0 | Release Not Yet Completely Effected | ||
26 | STAKO | STAKO | XFELD | CHAR | 1 | 0 | Document with time-dependent conditions | ||
27 | KALSM | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | * | |
28 | KORNR | KORNR | KORNR | CHAR | 1 | 0 | Correction of miscellaneous provisions | ||
29 | RESBU | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
30 | .INCLUDE | 0 | 0 | Additional Fields: Purchasing Document Header | |||||
31 | KONZS | KONZS | KONZS | CHAR | 10 | 0 | Group key | ||
32 | LAND1 | MCLANDL | LAND1 | CHAR | 3 | 0 | Country key of vendor | T005 | |
33 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | * | |
34 | SYDAT | MC_ERFDAT | DATUM | DATS | 8 | 0 | Date on which the purchasing document was entered | ||
35 | KZKPF | MC_KZKPF | X | CHAR | 1 | 0 | Indicator: header counter relevant (R/2->R/3 link) | ||
36 | BUDAT | MC_BUDAT | DATUM | DATS | 8 | 0 | Posting date of goods received or invoice receipt for order | ||
37 | ARECH | MC_ARECH | MCZAEHLINT | INT4 | 10 | 0 | Number of invoices for vendors | ||
38 | AGUTS | MC_AGUTS | MCZAEHLINT | INT4 | 10 | 0 | Number of credit memos for vendors | ||
39 | .INCLUDE | 0 | 0 | Purchasing Document Item | |||||
40 | EBELP | EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | * | |
41 | LOEKZ | ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
42 | STATU | ASTAT | ASTAT | CHAR | 1 | 0 | RFQ status | ||
43 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
44 | EMATN | EMATNR | MATNR | CHAR | 18 | 0 | Material number | * | |
45 | WERKS | EWERK | WERKS | CHAR | 4 | 0 | Plant | * | |
46 | LGORT | LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | * | |
47 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | * | |
48 | INFNR | INFNR | INFNR | CHAR | 10 | 0 | Number of purchasing info record | * | |
49 | KTMNG | KTMNG | MENGE | QUAN | 13 | 3 | Target Quantity | ||
50 | MENGE_POS | BSTMG | MENG13 | QUAN | 13 | 3 | Purchase Order Quantity | ||
51 | MEINS | BSTME | MEINS | UNIT | 3 | 0 | Order unit | * | |
52 | BPRME | BBPRM | MEINS | UNIT | 3 | 0 | Order Price Unit (purchasing) | * | |
53 | BPUMZ | BPUMZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion of Order Price Unit into Order Unit | ||
54 | BPUMN | BPUMN | UMBSN | DEC | 5 | 0 | Denominator for Conv. of Order Price Unit into Order Unit | ||
55 | UMREZ | UMBSZ | UMBSZ | DEC | 5 | 0 | Numerator for Conversion of Order Unit to Base Unit | ||
56 | UMREN | UMBSN | UMBSN | DEC | 5 | 0 | Denominator for Conversion of Order Unit to Base Unit | ||
57 | NETWR_R | MC_NETWR_R | WERTV8 | CURR | 15 | 2 | Net value of returns | ||
58 | NETWR | MC_BNETWR | WERT7 | CURR | 13 | 2 | Net order value in order currency | ||
59 | BRTWR_R | MC_BRTWR_R | WERTV8 | CURR | 15 | 2 | Gross order value (returns) | ||
60 | BRTWR | MC_BBRTWR | WERT7 | CURR | 13 | 2 | Gross order value in order currency | ||
61 | MWSKZ | MWSKZ | MWSKZ | CHAR | 2 | 0 | Tax on sales/purchases code | * | |
62 | ELIKZ | ELIKZ | XFELD | CHAR | 1 | 0 | "Delivery Completed" Indicator | ||
63 | EREKZ | EREKZ | XFELD | CHAR | 1 | 0 | Final Invoice Indicator | ||
64 | PSTYP | PSTYP | PSTYP | CHAR | 1 | 0 | Item category in purchasing document | * | |
65 | KNTTP | KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | * | |
66 | WEPOS | WEPOS | XFELD | CHAR | 1 | 0 | Goods Receipt Indicator | ||
67 | REPOS | REPOS | XFELD | CHAR | 1 | 0 | Invoice receipt indicator | ||
68 | KONNR | KONNR | EBELN | CHAR | 10 | 0 | Number of principal purchase agreement | * | |
69 | LMEIN | LAGME | MEINS | UNIT | 3 | 0 | Base Unit of Measure | * | |
70 | ZWERT | DZWERT | WERT7 | CURR | 13 | 2 | Target value for outline agreement in document currency | ||
71 | NAVNW | NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
72 | EFFWR_R | MC_EFFWR_R | WERTV8 | CURR | 15 | 2 | Effective order value of returns | ||
73 | EFFWR | EFFWR | WERT7 | CURR | 13 | 2 | Effective value of item | ||
74 | BSTAE | BSTAE | BSTAE | CHAR | 4 | 0 | Confirmation Control Key | * | |
75 | MEPRF | MEPRF | MEPRF | CHAR | 1 | 0 | Price Determination (Pricing) Date Control | ||
76 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | * | |
77 | NTGEW | ENTGE | MENG13 | QUAN | 13 | 3 | Net Weight | ||
78 | BRGEW | BRGEW | MENG13 | QUAN | 13 | 3 | Gross weight | ||
79 | GEWEI | EGEWE | MEINS | UNIT | 3 | 0 | Unit of Weight | * | |
80 | VOLUM | VOLUM | MENG13 | QUAN | 13 | 3 | Volume | ||
81 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | * | |
82 | SATNR | SATNR | MATNR | CHAR | 18 | 0 | Cross-Plant Configurable Material | * | |
83 | AKTNR | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | * | |
84 | ANZPU | ANZPU | MENG13 | QUAN | 13 | 3 | Number of Points | ||
85 | PUNEI | PUNEI | MEINS | UNIT | 3 | 0 | Points unit | * | |
86 | EBONF | EBONY | XFELD | CHAR | 1 | 0 | Item Relevant to Subsequent (Period-End Rebate) Settlement | ||
87 | LTSNR | LTSNR | LTSNR | CHAR | 6 | 0 | Vendor Subrange | * | |
88 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
89 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
90 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
91 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
92 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
93 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
94 | RETPO | RETPO | XFELD | CHAR | 1 | 0 | Returns Item | ||
95 | WEUNB | WEUNB | XFELD | CHAR | 1 | 0 | Goods Receipt, Non-Valuated | ||
96 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | * | |
97 | MFRPN | MFRPN | CHAR40 | CHAR | 40 | 0 | Manufacturer Part Number | ||
98 | MFRNR | MFRNR | LIFNR | CHAR | 10 | 0 | Manufacturer number | * | |
99 | MPROF | MPROF | MPROF | CHAR | 4 | 0 | Mfr part profile | * | |
100 | EGLKZ | EGLKZ | XFELD | CHAR | 1 | 0 | "Outward Delivery Completed" Indicator | ||
101 | EMNFR | EMNFR | CHAR10 | CHAR | 10 | 0 | External manufacturer code name or number | ||
102 | PRDAT | PREDT | DATUM | DATS | 8 | 0 | Date of Price Determination | ||
103 | STAPO | STAPO | XFELD | CHAR | 1 | 0 | Item is statistical | ||
104 | FPLNR | IPLNR | CHAR10 | CHAR | 10 | 0 | Invoicing plan number | ||
105 | BSTYP_I | BSTYP | BSTYP | CHAR | 1 | 0 | Purchasing document category | ||
106 | .INCLUDE | 0 | 0 | Additional Fields: Purchasing Document Item | |||||
107 | ESOKZ | ESOKZ | ESOKZ | CHAR | 1 | 0 | Purchasing info record category | ||
108 | ALIEF | MC_ALIEF | MCZAEHLER | DEC | 9 | 0 | Number of deliveries | ||
109 | LFZTA | MC_LFZTA | DECV13 | DEC | 13 | 0 | Total delivery time in days | ||
110 | AKTWE | MC_AKTWE | MENG13 | QUAN | 13 | 3 | Current goods receipt quantity in order unit | ||
111 | KZTAB | MC_KZTAB | CHAR1 | CHAR | 1 | 0 | Indicator: relevant schedule deviation | ||
112 | TABW | MC_TABW | PL2 | DEC | 3 | 0 | Delivery Date Variance in Days | ||
113 | KZMAB | MC_KZMAB | CHAR1 | CHAR | 1 | 0 | Indicator: relevant quantity deviation | ||
114 | MABW | MC_MABW | PRZ32V | DEC | 6 | 2 | Variance in the quantity delivered as % | ||
115 | PWTT | MC_PWTT | DEC3 | DEC | 3 | 0 | Points score for on-time delivery performance | ||
116 | KZAVI | MC_KZAVI | CHAR1 | CHAR | 1 | 0 | Indicator: Update shipping notification | ||
117 | LAVI | MC_LAVI | DEC3 | DEC | 3 | 0 | Points score: Shipping notification | ||
118 | ALAV | MC_ALAV | DEC3 | DEC | 3 | 0 | Points score: Shipping notif. GR date - notified date | ||
119 | PWMT | MC_PWMT | DEC3 | DEC | 3 | 0 | Points score for quantity reliability | ||
120 | KZWEV | MC_KZWEV | CHAR1 | CHAR | 1 | 0 | Indicator: compliance with GR shipping instructions | ||
121 | PWEV | MC_PWEV | DEC3 | DEC | 3 | 0 | Points score for compliance with shipping instructions | ||
122 | PWWE | MC_PWWE | DEC3 | DEC | 3 | 0 | Points score for quality of services | ||
123 | PWFR | MC_PWFR | DEC3 | DEC | 3 | 0 | Points score for on-time delivery | ||
124 | PWQA | MC_PWQA | DEC3 | DEC | 3 | 0 | Points score for quality audit | ||
125 | KZPOS | MC_KZPOS | X | CHAR | 1 | 0 | Indicator: item counter relevant (R/2->R/3 link, schd.agmt) | ||
126 | KZKPO | MC_KZKPO | CHAR1 | CHAR | 1 | 0 | Indicator for updating number of contract items | ||
127 | BADAT | BADAT | DATUM | DATS | 8 | 0 | Requisition (request) date | ||
128 | WEBAZ | WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
129 | .INCLUDE | 0 | 0 | Purchasing Document Delivery Schedule | |||||
130 | ETENR | EETEN | EETEN | NUMC | 4 | 0 | Delivery Schedule Line Counter | * | |
131 | EINDT | EINDT | DATUM | DATS | 8 | 0 | Item delivery date | ||
132 | SLFDT | SLFDT | DATUM | DATS | 8 | 0 | Statistics-Relevant Delivery Date | ||
133 | MENGE_R | MC_MENGE_R | MENGV15_3 | QUAN | 15 | 3 | Order quantity (returns) | ||
134 | MENGE | ETMEN | MENGE | QUAN | 13 | 3 | Scheduled Quantity | ||
135 | UZEIT | UZEIT | UZEIT | TIMS | 6 | 0 | Time | ||
136 | MAHNZ | MAHNZ | PACK2 | DEC | 3 | 0 | Number of Reminders/Expediters | ||
137 | ETBDT | ETBDT | DATUM | DATS | 8 | 0 | Order date of schedule line | ||
138 | LPEIN | LPEIN | PRGBZ | CHAR | 1 | 0 | Category of delivery date | * | |
139 | WAMNG | WAMNG | MENG13 | QUAN | 13 | 3 | Issued quantity | ||
140 | GLMNG | GLMNG | MENG13 | QUAN | 13 | 3 | Quantity Delivered (Stock Transfer) | ||
141 | DABMG | DABMG | MENGE | QUAN | 13 | 3 | Quantity Reduced (MRP) | ||
142 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MC02MA0BST | LAND1 | T005 | LAND1 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |