MASSEKPOSCHAGREE SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
ABAP Code to SELECT data from MASSEKPOSCHAGREE
Related tables to MASSEKPOSCHAGREE
Access table MASSEKPOSCHAGREE
Related tables to MASSEKPOSCHAGREE
Access table MASSEKPOSCHAGREE
Table View field list including key, data, relationships and ABAP select examples
MASSEKPOSCHAGREE is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The MASSEKPOSCHAGREE table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include EBELN (Purchasing Document Number), EBELP (Item Number of Purchasing Document), LOEKZ (Deletion Indicator in Purchasing Document), STATU (RFQ status).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP MASSEKPOSCHAGREE table view fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
EBELN | Purchasing Document Number | EBELN | CHAR | 10 | EKKO | ALPHA | EBELN | BES | MEKK_C |
EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EBELP | BSP | |||
LOEKZ | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 1 | ELOEK | ||||
STATU | RFQ status | ASTAT | CHAR | 1 | ASTAT | ||||
AEDAT | Purchasing Document Item Change Date | PAEDT | DATS | 8 | DATUM | ||||
TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
EMATN | Material Number | EMATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
WERKS | Plant | EWERK | CHAR | 4 | T001W | WERKS | WRK | ||
LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | CHAR10 | ||||
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
KTMNG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
MENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | T006 | CUNIT | MEINS | ||
BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | UMBSZ | ||||
BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | UMBSN | ||||
UMREZ | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5 | UMBSZ | ||||
UMREN | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5 | UMBSN | ||||
NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 11(2) | WERT11 | ||||
PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
NETWR | Net Order Value in PO Currency | BWERT | CURR | 13(2) | WERT7 | ||||
BRTWR | Gross order value in PO currency | BBWERT | CURR | 13(2) | WERT7 | ||||
AGDAT | Deadline for Submission of Bid/Quotation | ANGAB | DATS | 8 | DATUM | ||||
WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
BONUS | Settlement Group 1 (Purchasing) | EBONU | CHAR | 2 | EBONU | ||||
INSMK | Stock Type | INSMK | CHAR | 1 | INSMK | ||||
SPINF | Indicator: Update Info Record | SPINF | CHAR | 1 | SPINF | ||||
PRSDR | Price Printout | PRSDR | CHAR | 1 | XFELD | ||||
SCHPR | Indicator: Estimated Price | SCHPR | CHAR | 1 | XFELD | ||||
MAHNZ | Number of Reminders/Expediters | MAHNZ | DEC | 3 | PACK2 | ||||
MAHN1 | Number of Days for First Reminder/Expediter | MAHN1 | DEC | 3 | MAHNT | ||||
MAHN2 | Number of Days for Second Reminder/Expediter | MAHN2 | DEC | 3 | MAHNT | ||||
MAHN3 | Number of Days for Third Reminder/Expediter | MAHN3 | DEC | 3 | MAHNT | ||||
UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | T149C | BWTTY | |||
ABSKZ | Rejection Indicator | ABSKZ | CHAR | 1 | XFELD | ||||
AGMEM | Internal Comment on Quotation | AGMEM | CHAR | 3 | TMAM | AGMEM | |||
ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | XFELD | ||||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | XFELD | ||||
REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | XFELD | ||||
KZABS | Order Acknowledgment Requirement | KZABS | CHAR | 1 | XFELD | ||||
LABNR | Order Acknowledgment Number | LABNR | CHAR | 20 | TEXT20 | ||||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | EKKO | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | EKPO | EBELP | |||
ABDAT | Reconciliation Date for Agreed Cumulative Quantity | ABDAT | DATS | 8 | DATUM | ||||
ABFTZ | Agreed Cumulative Quantity | ABFTZ | QUAN | 13(3) | MENG13 | ||||
ETFZ1 | Firm Zone (Go-Ahead for Production) | ETFZ1 | DEC | 3 | PACK2 | ||||
ETFZ2 | Trade-Off Zone (Go-Ahead for Materials Procurement) | ETFZ2 | DEC | 3 | PACK2 | ||||
KZSTU | Firm/Trade-Off Zones Binding with Regard to Mat. Planning | MRPRE | CHAR | 1 | KZFIX | ||||
NOTKZ | Exclusion in Outline Agreement Item with Material Class | NOTKZ | CHAR | 1 | XFELD | ||||
LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | T006 | CUNIT | MEINS | ||
EVERS | Shipping Instructions | EVERS | CHAR | 2 | T027A | EVERS | |||
ZWERT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13(2) | WERT7 | ||||
NAVNW | Non-deductible input tax | NAVNW | CURR | 13(2) | WERT7 | ||||
ABMNG | Standard release order quantity | NORAM | QUAN | 13(3) | MENG13 | ||||
PRDAT | Date of Price Determination | PREDT | DATS | 8 | DATUM | ||||
BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
EFFWR | Effective value of item | EFFWR | CURR | 13(2) | WERT7 | ||||
XOBLR | Item affects commitments | XOBLR | CHAR | 1 | XFELD | ||||
KUNNR | Customer | EKUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
ADRNR | Manual address number in purchasing document item | ADRNR_MM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
EKKOL | Condition Group with Vendor | EKKOG | CHAR | 4 | CHAR4 | ||||
SKTOF | Item Does Not Qualify for Cash Discount | ESKTOF | CHAR | 1 | XFELD | ||||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
PLIFZ | Planned Delivery Time in Days | EPLIF | DEC | 3 | DEC3 | ||||
NTGEW | Net Weight | ENTGE | QUAN | 13(3) | MENG13 | ||||
GEWEI | Unit of Weight | EGEWE | UNIT | 3 | T006 | CUNIT | MEINS | ||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
ETDRK | Indicator: Print-relevant schedule lines exist | ETDRK | CHAR | 1 | ETDRK | ||||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | MDNUM | ||||
ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | RSPOS | ||||
INSNC | Quality inspection indicator cannot be changed | INSNC | CHAR | 1 | XFELD | ||||
SSQSS | Control Key for Quality Management in Procurement | QSSPUR | CHAR | 8 | TQ08 | QSSPUR | |||
ZGTYP | Certificate Type | QZGTYP | CHAR | 4 | TQ05 | QZGTYP | QCT | ||
EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
BSTAE | Confirmation Control Key | BSTAE | CHAR | 4 | T163L | BSTAE | |||
REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | BP_GEBER | FIC | |||
FISTL | Funds Center | FISTL | CHAR | 16 | FISTL | FIS | |||
FIPOS | Commitment Item | FIPOS | CHAR | 14 | FMFPO | FIPOS | FIP | ||
KO_GSBER | Business area reported to the partner | GSBER_GP | CHAR | 4 | GSBER | ||||
KO_PARGB | assumed business area of the business partner | PARGB_GP | CHAR | 4 | GSBER | ||||
KO_PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
KO_PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PPC | |
MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1 | MEPRF | ||||
BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
VORAB | Advance procurement: project stock | VORAB | CHAR | 1 | XFELD | ||||
KOLIF | Prior Vendor | KOLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
LTSNR | Vendor Subrange | LTSNR | CHAR | 6 | WYT1 | LTSNR | |||
PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | PACKNO | |||
FPLNR | Invoicing plan number | IPLNR | CHAR | 10 | CHAR10 | ||||
GNETWR | Currently not used | GNETWR | CURR | 13(2) | WERT7 | ||||
STAPO | Item is statistical | STAPO | CHAR | 1 | XFELD | ||||
UEBPO | Higher-Level Item in Purchasing Documents | UEBPO | NUMC | 5 | EKPO | EBELP | |||
LEWED | Latest Possible Goods Receipt | LEWED | DATS | 8 | DATUM | ||||
EMLIF | Vendor to be supplied/who is to receive delivery | EMLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
LBLKZ | Subcontracting vendor | LBLKZ | CHAR | 1 | XFELD | ||||
SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
VSART | Shipping type | VERSART | CHAR | 2 | VERSART | ||||
HANDOVERLOC | Location for a physical handover of goods | HANDOVER_LOC | CHAR | 10 | ALPHA | HANDOVER_LOC | |||
KANBA | Kanban Indicator | KBNKZ | CHAR | 1 | KBNKZ | ||||
ADRN2 | Number of delivery address | ADRN2 | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | XFELD | ||||
EILDT | Start Date for GR-Based Settlement | EILDT | DATS | 8 | DATUM | ||||
DRDAT | Last Transmission | DRDAT | DATS | 8 | DATUM | ||||
DRUHR | Time | DRUHR | TIMS | 6 | UZEIT | ||||
DRUNR | Sequential Number | DRUNR | NUMC | 4 | NUMC4 | ||||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
ABELP | Item number of allocation table | ABELP | NUMC | 5 | ABELP | ||||
ANZPU | Number of Points | ANZPU | QUAN | 13(3) | MENG13 | ||||
PUNEI | Points unit | PUNEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
SAISO | Season Category | SAISO | CHAR | 4 | T6WSP | SAISO | SAISO | ||
SAISJ | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
EBON2 | Settlement Group 2 (Rebate Settlement, Purchasing) | EBON2 | CHAR | 2 | EBONU | ||||
EBON3 | Settlement Group 3 (Rebate Settlement, Purchasing) | EBON3 | CHAR | 2 | EBONU | ||||
EBONF | Item Relevant to Subsequent (Period-End Rebate) Settlement | EBONY | CHAR | 1 | XFELD | ||||
MLMAA | Material ledger activated at material level | CK_ML_MAAC | CHAR | 1 | XFELD | ||||
MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
ANFNR | RFQ Number | ANFNR | CHAR | 10 | EKKO | ALPHA | EBELN | ANF | |
ANFPS | Item Number of RFQ | ANFPS | NUMC | 5 | EKPO | EBELP | |||
KZKFG | Origin of Configuration | KZCUH | CHAR | 1 | KZCUH | ||||
USEQU | Quota arrangement usage | USEQU | CHAR | 1 | TMQ2 | USEQU | |||
UMSOK | Special Stock Indicator for Physical Stock Transfer | UMSOK | CHAR | 1 | SOBKZ | ||||
BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | EBAN | BNFPO | BAP | ||
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
UPTYP | Subitem Category, Purchasing Document | UPTYP | CHAR | 1 | TMSI1 | UPTYP | |||
UPVOR | Subitems Exist | UPVOR | CHAR | 1 | CHAR1 | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
SIKGR | Processing key for sub-items | SIKGR | CHAR | 3 | TMSI2 | SIKGR | |||
MFZHI | Maximum Cumulative Material Go-Ahead Quantity | MFZHI | QUAN | 15(3) | MENG15 | ||||
FFZHI | Maximum Cumulative Production Go-Ahead Quantity | FFZHI | QUAN | 15(3) | MENG15 | ||||
RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
AUREL | Relevant to Allocation Table | AUREL | CHAR | 1 | AUREL | ||||
BSGRU | Reason for Ordering | BSGRU | CHAR | 3 | TBSG | BSGRU | |||
LFRET | Delivery Type for Returns to Vendors | LFRET | CHAR | 4 | TVLK | LFART | |||
MFRGR | Material freight group | MFRGR | CHAR | 8 | TMFG | MFRGR | |||
NRFHG | Material qualifies for discount in kind | NRFHG | CHAR | 1 | NRFHG | ||||
J_1BNBM | Brazilian NCM Code | J_1BNBMCO1 | CHAR | 16 | T604F | STEUC | |||
J_1BMATUSE | Usage of the material | J_1BMATUSE | CHAR | 1 | J_1BMATUSE | ||||
J_1BMATORG | Origin of the material | J_1BMATORG | CHAR | 1 | J_1BMATORG | ||||
J_1BOWNPRO | Produced in-house | J_1BOWNPRO | CHAR | 1 | XFELD | ||||
J_1BINDUST | Material CFOP category | J_1BINDUS3 | CHAR | 2 | ALPHA | J_1BINDUS3 | |||
ABUEB | Release Creation Profile | ABUEB | CHAR | 4 | T163P | ABUEB | |||
NLABD | Next Forecast Delivery Schedule Transmission | NLABD | DATS | 8 | DATUM | ||||
NFABD | Next JIT Delivery Schedule Transmission | NFABD | DATS | 8 | DATUM | ||||
KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
BONBA | Rebate basis 1 | BONBA | CURR | 13(2) | WERTV7 | ||||
FABKZ | Indicator: Item Relevant to JIT Delivery Schedules | FABKZ | CHAR | 1 | FABKZ | ||||
J_1AINDXP | Inflation Index | J_1AINDXP | CHAR | 5 | J_1AINFT20 | J_1AINDXP | |||
J_1AIDATEP | Inflation Index Date | J_1AIDATEP | DATS | 8 | J_1AUDATEP | ||||
MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | MPROF | ||||
EGLKZ | 'Outward Delivery Completed' Indicator | EGLKZ | CHAR | 1 | XFELD | ||||
KZTLF | Partial Delivery at Item Level (Stock Transfer) | KZTUL | CHAR | 1 | KZTUL | ||||
KZFME | Units of measure usage | KZWSO | CHAR | 1 | KZWSO | ||||
RDPRF | Rounding Profile | RDPRF | CHAR | 4 | RDPR | RDPRF | |||
TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
CHG_SRV | Configuration changed | CHG_SRV | CHAR | 1 | XFELD | ||||
CHG_FPLNR | No invoice for this item although not free of charge | CHG_FPLNR | CHAR | 1 | XFELD | ||||
MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
MFRNR | Number of a Manufacturer | MFRNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
EMNFR | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
NOVET | Item blocked for SD delivery | NOVET | CHAR | 1 | XFELD | ||||
AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
TZONRC | Time zone of recipient location | TSEGZONREC | CHAR | 6 | TZNZONE | ||||
IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1 | XFELD | ||||
BERID | MRP Area | BERID | CHAR | 10 | MDLV | BERID | BERID | ||
XCONDITIONS | Conditions for item although no invoice | XCONDITIONS | CHAR | 1 | XCONDITIONS | ||||
APOMS | APO as Planning System | APOMS | CHAR | 1 | APOMS | ||||
CCOMP | Posting Logic in the Case of Stock Transfers | MMPUR_CCOMP | CHAR | 1 | MMPUR_CCOMP | ||||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
FKBER | Functional Area | FKBER | CHAR | 16 | FKBER | FBE | |||
STATUS | Status of Purchasing Document Item | EPSTATU | CHAR | 1 | EPSTATU | ||||
RESLO | Issuing Storage Location for Stock Transport Order | RESLO | CHAR | 4 | T001L | LGORT | |||
KBLNR | Document Number for Earmarked Funds | KBLNR | CHAR | 10 | ALPHA | KBLNR | KBL | ||
KBLPOS | Earmarked Funds: Document Item | KBLPOS | NUMC | 3 | KBLPOS | KBP | |||
WEORA | Acceptance At Origin | WEORA | CHAR | 1 | XFELD | ||||
SRV_BAS_COM | Service-Based Commitment | SRV_BAS_COM | CHAR | 1 | XFELD | ||||
PRIO_URG | Requirement Urgency | PRIO_URG | NUMC | 2 | PURG | PRIO_URG | |||
PRIO_REQ | Requirement Priority | PRIO_REQ | NUMC | 3 | PREQ | PRIO_REQ | |||
EMPST | Receiving point | EMPST | CHAR | 25 | TEXT25 | ||||
DIFF_INVOICE | Differential Invoicing | DIFF_INVOICE | CHAR | 2 | DIFF_INVOICE | ||||
TRMRISK_RELEVANT | Risk Relevancy in Purchasing | PUR_TRM_RISK_RELEVANCY | CHAR | 2 | LOGTRM_RISK_RELEVANCY | ||||
SPE_ABGRU | Reason for rejection of quotations and sales orders | ABGRU | CHAR | 2 | ABGRU | ||||
SPE_CRM_SO | CRM Sales Order Number for TPOP Process | /SPE/VBELN_CRM | CHAR | 10 | ALPHA | /SPE/VBELN_CRM | |||
SPE_CRM_SO_ITEM | CRM Sales Order Item Number in TPOP Process | /SPE/POSNR_CRM | NUMC | 6 | /SPE/POSNR_CRM | ||||
SPE_CRM_REF_SO | CRM Reference Order Number for TPOP Process | /SPE/REF_VBELN_CRM | CHAR | 35 | ALPHA | /SPE/REF_VBELN_CRM | |||
SPE_CRM_REF_ITEM | CRM Reference Sales Order Item Number in TPOP Process | /SPE/REF_POSNR_CRM | CHAR | 6 | /SPE/REF_POSNR_CRM | ||||
SPE_CRM_FKREL | Billing Relevance CRM | /SPE/FKREL_CRM | CHAR | 1 | FKREL | ||||
SPE_CHNG_SYS | Last Changer's System Type | /SPE/INB_CHNG_SYS | CHAR | 1 | /SPE/SYSTYPE_SHORT | ||||
SPE_INSMK_SRC | Stock Type of Source Storage Location in STO | /SPE/INSMK_SRC | CHAR | 1 | INSMK | ||||
SPE_CQ_CTRLTYPE | CQ Control Type | /SPE/CQ_CONTROL_TYPE | CHAR | 1 | /SPE/CQ_CONTROL_TYPE | ||||
SPE_CQ_NOCQ | No Transmission of Cumulative Quantities in SA Release | /SPE/CQ_NOCQ | CHAR | 1 | XFELD | ||||
REASON_CODE | Goods Receipt Reason Code | /SAPPSPRO/_GR_REASON_CODE | CHAR | 4 | /SAPPSPRO/_GR_REASON_CODE | ||||
CQU_SAR | Cumulative Goods Receipts from Redirected Purchase Orders | CQU_SAR | QUAN | 15(3) | MENG15 | ||||
ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | INT4 | ||||
SPE_EWM_DTC | EWM Delivery Based Tolerance Check | /SPE/EWM_DTC | CHAR | 1 | XFELD | ||||
EXLIN | Item Number Length | EXLIN | CHAR | 40 | EXLIN | ||||
EXSNR | External Sorting | EXSNR | NUMC | 5 | EXSNR | ||||
EHTYP | External Hierarchy Category | EHTYP | CHAR | 4 | TMSRM_EHTYP | EHTYP | |||
RETPC | Retention in Percent | RETPZ | DEC | 5(2) | PRZ32 | ||||
DPTYP | Down Payment Indicator | ME_DPTYP | CHAR | 4 | ME_DPTYPE_DOMAIN | ||||
DPPCT | Down Payment Percentage | ME_DPPCNT | DEC | 5(2) | PRZ32 | ||||
DPAMT | Down Payment Amount in Document Currency | ME_DPAMNT | CURR | 11(2) | WERT11 | ||||
DPDAT | Due Date for Down Payment | ME_DPDDAT | DATS | 8 | DATS | ||||
FLS_RSTO | Store Return with Inbound and Outbound Delivery | FLS_RSTO | CHAR | 1 | XFELD | ||||
EXT_RFX_NUMBER | Document Number of External Document | ME_PUR_EXT_DOC_ID | CHAR | 35 | ME_EXT_DOC_ID | ||||
EXT_RFX_ITEM | Item Number of External Document | ME_PUR_EXT_DOC_ITEM_ID | CHAR | 10 | ME_EXT_DOC_ITEM_ID | ||||
EXT_RFX_SYSTEM | Logical System | LOGSYSTEM | CHAR | 10 | ALPHA | LOGSYS | |||
SRM_CONTRACT_ID | Central Contract | SRM_CONTRACT_ID | CHAR | 10 | ALPHA | BBP_BAPI_EBELN | MMBSI_MEKK_CC | ||
SRM_CONTRACT_ITM | Central Contract Item Number | SRM_CONTRACT_ITEM | NUMC | 10 | BBP_ITEMNO | ||||
BLK_REASON_ID | Blocking Reason - ID | BLK_REASON_ID | CHAR | 4 | BLK_REASON_ID | ||||
BLK_REASON_TXT | Blocking Reason - Text | BLK_REASON_TXT | CHAR | 40 | BLK_REASON_TXT | ||||
ITCONS | Real-Time Consumption Posting of Subcontracting Components | ME_IR_CO_ORDER | CHAR | 1 | XFELD | ||||
FIXMG | Delivery Date and Quantity Fixed | ME_FIXMG | CHAR | 1 | ME_FIXMG | ||||
WABWE | Indicator for GI-based goods receipt | WABWE | CHAR | 1 | XFELD | ||||
TC_AUT_DET | Tax Code Automatically Determined | J_1BTC_AUT_DET | CHAR | 2 | MWSKZ | ||||
MANUAL_TC_REASON | Manual Tax Code Reason | J_1BMANUAL_TC_REASON | CHAR | 2 | J_1BMANUAL_TC_REASON | ||||
FISCAL_INCENTIVE | Tax Incentive Type | J_1BFISCAL_INCENTIVE_CODE | CHAR | 4 | J_1BFISCAL_INCENTIVE_CODE | ||||
TAX_SUBJECT_ST | Tax Subject to SubstituiĆ§Ć£o TributĆ”ria | J_1BTC_TAX_SUBJECT_ST | CHAR | 1 | J_1BYES_NO | ||||
FISCAL_INCENTIVE_ID | Incentive ID | J_1BFISCAL_INCENTIVE_ID | CHAR | 4 | J_1BFISCAL_INCENTIVE_ID | ||||
/BEV1/NEGEN_ITEM | Indicator: Item Is Generated | /BEV1/NEGEN_ITEM_FLAG | CHAR | 1 | XFELD | ||||
/BEV1/NEDEPFREE | Indicator: Dependent Items Are Free of Charge | /BEV1/NEDEPFREE | CHAR | 1 | XFELD | ||||
/BEV1/NESTRUCCAT | Structure Category for Material Relationship | /BEV1/NESTRUC_CAT | CHAR | 1 | /BEV1/NESTRUC_CAT | ||||
ADVCODE | Advice Code | /ISDFPS/ADVCODE | CHAR | 2 | /ISDFPS/ADVCODE | ||||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | FM_BUDGET_PERIOD | BUDPER | |||
EXCPE | Acceptance Period | EXCPE | NUMC | 2 | NUM02 | ||||
IUID_RELEVANT | IUID-Relevant | IUID_RELEVANT | CHAR | 1 | UID_RELEVANT | ||||
MRPIND | Max. Retail Price Relevant | J_1IRMRPIND | CHAR | 1 | J_1IRMRPIND | ||||
OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | OID_PIPEV | CHAR | 1 | X | ||||
OIC_LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
OIC_DCITYC | Destination city code | OIC_DCITYC | CHAR | 4 | T005G | CITYC | |||
OIC_DCOUNC | Destination county code | OIC_DCOUNC | CHAR | 3 | T005E | COUNC | |||
OIC_DREGIO | Destination region | OIC_DREGIO | CHAR | 3 | T005S | REGIO | |||
OIC_DLAND1 | Destination country | OIC_DLAND1 | CHAR | 3 | T005 | LAND1 | |||
OIC_OCITYC | Origin city code | OIC_OCITYC | CHAR | 4 | T005G | CITYC | |||
OIC_OCOUNC | Origin county code | OIC_OCOUNC | CHAR | 3 | T005E | COUNC | |||
OIC_OREGIO | Origin region | OIC_OREGIO | CHAR | 3 | T005S | REGIO | |||
OIC_OLAND1 | Origin country | OIC_OLAND1 | CHAR | 3 | T005 | LAND1 | |||
OIC_PORGIN | Tax origin | OIC_PORGIN | CHAR | 15 | OIC_PORGIN | ||||
OIC_PDESTN | Tax destination | OIC_PDESTN | CHAR | 15 | OIC_PDESTN | ||||
OIC_PTRIP | Pipeline trip number (external) | OIC_PTRIP | CHAR | 16 | OIC_PTRIP | ||||
OIC_PBATCH | Pipeline operatorĀ“s external batch number | OIC_PBATCH | CHAR | 16 | OIC_PBATCH | ||||
OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | CHAR | 2 | TVTR | VKTRA | |||
OIC_AORGIN | Alternate origin | OIC_AORGIN | CHAR | 15 | OIC_PORGIN | ||||
OIC_ADESTN | Alternate destination | OIC_ADESTN | CHAR | 15 | OIC_PDESTN | ||||
OIC_TRUCKN | Truck number | OIC_TRUCKN | CHAR | 10 | OIC_TRUCKN | ||||
OIA_BASELO | Base location | OIA_BASELO | CHAR | 15 | OIA_BASELO | ||||
OITAXFROM | Excise duty tax key for 'from' location | OIH_TAXFRO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | CHAR | 2 | OIH5 | OIH_HANTYP | |||
OIPRICIE | ED pricing: external (indicator) | OIH_PRICIE | CHAR | 1 | X | ||||
OITAXTO | Excise duty tax key for 'to' location | OIH_TAXTO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
OITAXCON | Excise duty tax from pricing conditions | OIH_TAXCON | CURR | 13(2) | OIH_TAXCON | ||||
OITAXGRP | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | OIH2 | OIH_TAXGRP | |||
OIOILCON | Oil content in a material as a percentage | OIH_OILCON | DEC | 5(2) | OIH_OILCON | ||||
OIINEX | Code for internal or external excise duty rate determination | OIH_INEX | CHAR | 2 | OIH16 | OIH_INEX | |||
OIEXGNUM | Exchange agreement number | OIA_EXGNUM | CHAR | 10 | ALPHA | OIA_EXGNUM | OI1 | OIAE | |
OIEXGTYP | Exchange type | OIA_EXGTYP | CHAR | 4 | TOIA2 | OIA_EXGTYP | OI3 | ||
OIFEETOT | Fee total | OIA_FEETOT | CURR | 13(2) | OIA_FEETOT | ||||
OIFEEDT | Fee pricing condition date | OIA_FEEDT | DATS | 8 | DATUM | ||||
OINETCYC | Netting cycle (FI blocking indicator) | OIA_NETCYC | CHAR | 1 | T008 | ZAHLS | NTG | ||
OIFERP | Fee repricing indicator | OIA_FERP | CHAR | 1 | OIA_FERP | ||||
OIFEECH | Fee edit control | OIA_FEECH | CHAR | 1 | OIA_FEECH | ||||
OIA_IPMVAT | VAT on internally-posted material | OIA_IPMVAT | CHAR | 1 | OIA_IPMVAT | ||||
OIA_SPLTIV | Indicator for split invoice verification | OIA_SPLTIV | CHAR | 1 | OIA_SPLTIV | ||||
OIVATH | Amount in Local Currency | DMBTR | CURR | 13(2) | WERT7 | ||||
OIVATF | Amount in document currency | WRBTR | CURR | 13(2) | WERT7 | ||||
OISBREL | Sub product/ base product relevence indicator | OIA_SBREL | NUMC | 3 | OIA_SBREL | ||||
OIBASPROD | Base product number | OIA_SBMAT | CHAR | 18 | MATN1 | MATNR | |||
OITRKNR | Tracking number | OIH_TRKNR | CHAR | 10 | ALPHA | OIH_TRKNR | OIH_TRKNR | ||
OITRKJR | Tracking number year | OIH_TRKJR | NUMC | 4 | NUMC4 | OIH_TRKJR | |||
OIEXTNR | External tracking number | OIH_EXTNR | CHAR | 18 | OIH_EXTNR | ||||
OIITMNR | Tracking number item line | OIH_ITMNR | NUMC | 5 | OIH_ITMNR | ||||
OIFTIND | Final transfer indicator | OIH_FTIND | CHAR | 1 | OIH_FTIND | ||||
OIPRIOP | Price options for gain calculation | OIH_PRIOP | CHAR | 1 | OIH_PRIOP | ||||
OITRIND | Transfer sign for plant-to-plant transfers | OIH_TRIND | CHAR | 1 | OIH_TRIND | ||||
OIGHNDL | Gain handling | OIH_GHNDL | CHAR | 1 | OIH_GHNDL | ||||
OIUMBAR | Valuation type of issuing location for two-step transfer | OIH_UMBAR | CHAR | 10 | T149D | BWTAR | |||
OITXCON1 | Excise duty tax from pricing conditions: rate 1 | OIH_TXCON1 | CURR | 13(2) | OIH_TAXCON | ||||
OITXCON2 | Excise duty tax from pricing conditions: rate 2 | OIH_TXCON2 | CURR | 13(2) | OIH_TAXCON | ||||
OITXCON3 | Excise duty tax from pricing conditions: rate 3 | OIH_TXCON3 | CURR | 13(2) | OIH_TAXCON | ||||
OITXCON4 | Excise duty tax from pricing conditions: rate 4 | OIH_TXCON4 | CURR | 13(2) | OIH_TAXCON | ||||
OITXCON5 | Excise duty tax from pricing conditions: rate 5 | OIH_TXCON5 | CURR | 13(2) | OIH_TAXCON | ||||
OITXCON6 | Excise duty tax from pricing conditions: rate 6 | OIH_TXCON6 | CURR | 13(2) | OIH_TAXCON | ||||
OID_EXTBOL | External bill of lading | OID_EXTBOL | CHAR | 16 | OID_EXTBOL | ||||
OID_MISCDL | Miscellaneous delivery number | OID_MISCDL | CHAR | 16 | OID_MISCDL | ||||
OIMATCYC | Invoicing cycle for purchase material costs | OIA_MATCYC | NUMC | 1 | OIA_INVCYC | ||||
OIEDOK | Excise duty validation indicator | OIH_EDOK | CHAR | 1 | X | ||||
OIEDBAL | Excise duty balancing is required (indicator) | OIH_EDBAL | CHAR | 1 | X | ||||
OIEDBALM | Excise duty balancing method indicator | OIH_EDBALM | CHAR | 1 | OIH_EDBALM | ||||
OICERTF1 | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | OIH_CERTF1 | ||||
OIDATFM1 | Excise Duty License Valid from Date | OIH_DATFM1 | DATS | 8 | DATUM | ||||
OIDATTO1 | Valid to date for excise duty tax certificate | OIH_DATTO1 | DATS | 8 | DATUM | ||||
OIH_LICTP | License type | OIH_LICTP | CHAR | 4 | OIH20 | OIH_LICTP | OII | ||
OIH_LICIN | Excise tax internal license number | OIH_LICIN | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | OIH | OIHL |
OIH_LCFOL | Follow-on license for quantity license | OIH_LCFOL | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | ||
OIH_FOLQTY | Excise Tax Follow-On License Quantity | OIH_FOLQTY | QUAN | 13(3) | MENG13 | ||||
OIEDOK_GI | Excise Duty Validation Indicator for Material (STO) | OIH_EDOK_GI | CHAR | 1 | X | ||||
OIEDBAL_GI | Excise Duty Balancing is Required for Mat. (STO) | OIH_EDBAL_GI | CHAR | 1 | X | ||||
OIEDBALM_GI | Excise Duty Balancing Method Indicator for Mat. (STO) | OIH_EDBALM_GI | CHAR | 1 | OIH_EDBALM | ||||
OIHANTYP_GI | Excise Duty Handling Type - Denotes Use of Material | OIH_HANTYP_GI | CHAR | 2 | OIH_HANTYP | ||||
OIINEX_GI | Code for Internal or External Excise Duty Rate Determination | OIH_INEX_GI | CHAR | 2 | OIH_INEX | ||||
OITAXGRP_GI | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | OIH_TAXGRP | ||||
OICERTF1_GI | Excise Tax External License Number Used During GI (STO) | OIH_CERTF1_GI | CHAR | 15 | OIH_CERTF1 | ||||
OIDATFM1_GI | Excise Duty License Valid from Date for Mat. (STO) | OIH_DATFM1_GI | DATS | 8 | DATUM | ||||
OIDATTO1_GI | Valid To Date for Excise Duty Tax Certificate for Mat. (STO) | OIH_DATTO1_GI | DATS | 8 | DATUM | ||||
OIH_LICTP_GI | License Type to Material (STO) | OIH_LICTP_GI | CHAR | 4 | OIH20 | OIH_LICTP | OII | ||
OIH_LICIN_GI | Excise Tax Internal License Number to Mat. (STO) | OIH_LICIN_GI | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | OIH | OIHL |
OIH_LCFOL_GI | Follow-On License for Quantity License to Mat. (STO) | OIH_LCFOL_GI | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | ||
OIH_FOLQTY_GI | Excise Tax Follow-On License Quantity to Mat. (STO) | OIH_FOLQTY_GI | QUAN | 13(3) | MENG13 | ||||
ZBILL_NUM | 0 | ||||||||
ZAGENT_DET | 0 | ||||||||
ZBILL_NUMB | 0 | ||||||||
ZBAL_AMOUNT | 0 | ||||||||
ZDAT_BILL | 0 | ||||||||
REFSITE | Reference Site For Purchasing | WREFSITE | CHAR | 4 | WERKS_W | ||||
/SAPMP/GPOSE | Global Item Number in Purchasing Document | /SAPMP/GPOSE | NUMC | 5 | EBELP | ||||
ANGPN | Quotation Item Number (SD) | ANGPN | NUMC | 6 | POSNR | ||||
ADMOI | Model ID code | ADMOI | CHAR | 4 | CSPCMOI | ADMOI | |||
ADPRI | Order priority | ADPRI | CHAR | 3 | CSPCPRI | ADPRI | |||
LPRIO | Delivery Priority | LPRIO | NUMC | 2 | TPRIO | LPRIO | |||
ADACN | Aircraft registration number | ADACN | CHAR | 5 | ADACN | ||||
AFPNR | Sales Document Item | POSNR_VA | NUMC | 6 | POSNR | APO | |||
BSARK | Vendor confirmation type | BSARL | CHAR | 4 | BSARK | ||||
AUDAT | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | DATUM | ||||
ANGNR | Quotation number | ADSPC_ANGNR | CHAR | 20 | ADSPC_ANGNR | ||||
PNSTAT | Flag for the S1PNSTAT message | ADSPC_PNSTAT | CHAR | 1 | ADSPC_FLAG | ||||
SERRU | Type of subcontracting | SERRU | CHAR | 1 | SERRU | SERRU | |||
SERNP | Serial Number Profile | SERAIL | CHAR | 4 | SERAIL | ||||
DISUB_SOBKZ | Special stock indicator Subcontracting | DISUB_SOBKZ_LB | CHAR | 1 | DISUB_SOBKZ_LB | ||||
DISUB_PSPNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | KONPR | PS_POSNR | |||
DISUB_KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
DISUB_VBELN | Sales and Distribution Document Number | VBELN | CHAR | 10 | ALPHA | VBELN | AUN | ||
DISUB_POSNR | Item number of the SD document | POSNR | NUMC | 6 | POSNR | ||||
DISUB_OWNER | Owner of stock | OWNER_D | CHAR | 10 | ALPHA | LIFNR | |||
STPAC | Activate Static Stopping of Releases | STPAC | CHAR | 1 | STPAC | ||||
LGBZO | (Automotive) Unloading Point | UNLPT | CHAR | 10 | LGBZO | ME_SH_UNLOADING_POINT | |||
LGBZO_B | (Automotive) Unloading Point | UNLPT | CHAR | 10 | LGBZO | ME_SH_UNLOADING_POINT | |||
ADDRNUM | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
CONSNUM | Sequence Number | AD_CONSNUM | NUMC | 3 | NUMC3 | ||||
BORGR_MISS | Indicator: Action at Registration | BORGR_MISS | CHAR | 1 | CHAR1 | ||||
REF_ITEM | Reference Item for Remaining Qty Cancellation | WRF_PSCD_REF_ITEM | NUMC | 5 | EBELP | ||||
SOURCE_ID | Origin Profile | WRF_POHF_SOURCE_ID | CHAR | 3 | WRFT_POHF_SOURCE | WRF_POHF_SOURCE_ID | |||
SOURCE_KEY | Key in Source System | WRF_POHF_SOURCE_KEY | CHAR | 32 | WRF_POHF_SOURCE_KEY | ||||
PUT_BACK | Indicator for Putting Back from Grouped PO Document | WRF_POHF_PUT_BACK_POG | CHAR | 1 | XFELD | ||||
POL_ID | Order List Item Number | WRF_POHF_POL_ID | CHAR | 10 | ALPHA | WRF_POHF_POL_ID | BSL | ||
CONS_ORDER | Purchase Order for Consignment | WRF_CONS_ORDER | CHAR | 1 | WRF_CONS_ORDER |
Key field | Non-key field |
How do I retrieve data from SAP table MASSEKPOSCHAGREE using ABAP code
The following ABAP code Example will allow you to do a basic selection on MASSEKPOSCHAGREE to SELECT all data from the tableDATA: WA_MASSEKPOSCHAGREE TYPE MASSEKPOSCHAGREE.
SELECT SINGLE *
FROM MASSEKPOSCHAGREE
INTO CORRESPONDING FIELDS OF WA_MASSEKPOSCHAGREE
WHERE...
How to access SAP table MASSEKPOSCHAGREE
Within an ECC or HANA version of SAP you can also view further information about MASSEKPOSCHAGREE and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects