MMPUR_EXT_EKPO
Purchasing Document Item
MMPUR_EXT_EKPO is an SAP database table in S/4HANA. Purchasing Document Item. It contains 333 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PrmtHbRpldPurchaseOrderItem | view | from | EXTENSION | Extensibility view for C_CentralPurchaseOrderItemTP |
| I_CentralPurchaseOrderItem | view | from | BASIC | Central Purchase Order Item |
Fields (333)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | ebeln | EBELN | Purchasing Doc. | |||
| KEY | ebelp | EBELP | Item | |||
| KEY | extsourcesystem | MMPUR_D_SOURCE_SYS | Connected System ID | |||
| uniqueid | CENTRLPURCHASEDOCITEMUNIQUEID | Document Item | ||||
| loekz | ELOEK | Del. Indicator | ||||
| statu | ASTAT | Origin | ||||
| aedat | PAEDT | Changed On | ||||
| txz01 | TXZ01 | Short Text | ||||
| matnr | MATNR | Material | ||||
| ematn | EMATNR | Material | ||||
| bukrs | BUKRS | Company Code | ||||
| werks | EWERK | Plant | ||||
| lgort | LGORT_D | Location | ||||
| bednr | BEDNR | Tracking Number | ||||
| matkl | MATKL | Material Group | ||||
| infnr | INFNR | Info Record | ||||
| idnlf | IDNLF | Supp. Mat. No. | ||||
| ktmng | KTMNG | Target Quantity | ||||
| menge | BSTMG | PO Quantity | ||||
| meins | BSTME | Order Unit | ||||
| bprme | BBPRM | Order Price Un. | ||||
| bpumz | BPUMZ | Qty Conversion | ||||
| bpumn | BPUMN | Qty Conversion | ||||
| umrez | UMBSZ | Equal To | ||||
| umren | UMBSN | Denominator | ||||
| netpr | BPREI | Net Price | ||||
| peinh | EPEIN | Price Unit | ||||
| netwr | BWERT | Net Value | ||||
| brtwr | BBWERT | Gross value | ||||
| agdat | ANGAB | Quot. Deadline | ||||
| webaz | WEBAZ | GR proc. time | ||||
| mwskz | MWSKZ | Tax Code | ||||
| txdat_from | FOT_TXDAT_FROM | Tax Rate Valid-From | ||||
| txdat | TXDAT | Tax Date | ||||
| tax_country | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| bonus | EBONU | Sett. Group 1 | ||||
| insmk | INSMK | Stock Type | ||||
| spinf | SPINF | InfoUpdate | ||||
| prsdr | PRSDR | Print Price | ||||
| schpr | SCHPR | Estimated Price | ||||
| mahnz | MAHNZ | No. Rem./Exp. | ||||
| mahn1 | MAHN1 | 1st Rem./Exped. | ||||
| mahn2 | MAHN2 | 2nd Rem./Exped. | ||||
| mahn3 | MAHN3 | 3rd Rem./Exped. | ||||
| uebto | UEBTO | Overdeliv. Tol. | ||||
| uebtk | UEBTK | Unlimited | ||||
| untto | UNTTO | Underdel. Tol. | ||||
| bwtar | BWTAR_D | Valuation Type | ||||
| bwtty | BWTTY_D | Valuation Cat. | ||||
| abskz | ABSKZ | Rejection Ind. | ||||
| agmem | AGMEM | Quot. Comment | ||||
| elikz | ELIKZ | Deliv. Compl. | ||||
| erekz | EREKZ | Final Invoice | ||||
| pstyp | PSTYP | Item Category | ||||
| knttp | KNTTP | Acct Assgmt Cat | ||||
| kzvbr | KZVBR | Consumption | ||||
| vrtkz | VRTKZ | Distribution | ||||
| twrkz | TWRKZ | Partial invoice | ||||
| wepos | WEPOS | Goods Receipt | ||||
| weunb | WEUNB | GR Non-Valuated | ||||
| repos | REPOS | Invoice Receipt | ||||
| webre | WEBRE | GR-Based IV | ||||
| kzabs | KZABS | Acknowl. Reqd. | ||||
| labnr | LABNR | Order Acknowl. | ||||
| konnr | KONNR | Agreement | ||||
| ktpnr | KTPNR | Agreement Item | ||||
| abdat | ABDAT | Recon.Date | ||||
| abftz | ABFTZ | Agr. Cum. Qty | ||||
| etfz1 | ETFZ1 | Firm Zone | ||||
| etfz2 | ETFZ2 | Trade-Off Zone | ||||
| kzstu | MRPRE | Binding on MRP | ||||
| notkz | NOTKZ | Exclusion | ||||
| lmein | LAGME | Base Unit | ||||
| evers | EVERS | Shipping Instr. | ||||
| zwert | DZWERT | Target Value | ||||
| navnw | NAVNW | Non-deductible | ||||
| abmng | NORAM | Rel. order qty. | ||||
| prdat | PREDT | Price Date | ||||
| bstyp | BSTYP | Doc. Category | ||||
| effwr | EFFWR | Effective value | ||||
| xoblr | XOBLR | Commitments | ||||
| kunnr | EKUNNR | Customer | ||||
| adrnr | ADRNR_MM | Address | ||||
| ekkol | EKKOG | Condition Group | ||||
| sktof | ESKTOF | No Cash Disc. | ||||
| stafo | STAFO | Update Group | ||||
| plifz | EPLIF | Pl. Deliv. Time | ||||
| ntgew | ENTGE | Net Weight | ||||
| gewei | EGEWE | Unit of Weight | ||||
| txjcd | TXJCD | Tax Jur. | ||||
| etdrk | ETDRK | Print-relevant | ||||
| sobkz | SOBKZ | Special Stock | ||||
| arsnr | ARSNR | Settle.reser.No | ||||
| arsps | ARSPS | Settle.item no. | ||||
| insnc | INSNC | Not changeable | ||||
| ssqss | QSSPUR | QM Control Key | ||||
| zgtyp | QZGTYP | CertificateType | ||||
| ean11 | EAN11 | EAN/UPC | ||||
| bstae | BSTAE | Conf. Control | ||||
| revlv | REVLV | Revision Level | ||||
| geber | BP_GEBER | Fund | ||||
| fistl | FISTL | Funds Center | ||||
| fipos | FIPOS | Commitment item | ||||
| ko_gsber | GSBER_GP | Bus.area:prtner | ||||
| ko_pargb | PARGB_GP | Ptr's assum.BA | ||||
| ko_prctr | PRCTR | Profit Center | ||||
| ko_pprctr | PPRCTR | Partner PC | ||||
| meprf | MEPRF | Pr. Date Cat. | ||||
| brgew | BRGEW | Gross Weight | ||||
| volum | VOLUM | Volume | ||||
| voleh | VOLEH | Volume Unit | ||||
| inco1 | INCO1 | Incoterms | ||||
| inco2 | INCO2 | Incoterms 2 | ||||
| vorab | VORAB | Advance proc. | ||||
| kolif | KOLIF | Prior Supplier | ||||
| ltsnr | LTSNR | Suppl. Subrange | ||||
| packno | PACKNO | Package number | ||||
| fplnr | IPLNR | Invoicing plan | ||||
| gnetwr | GNETWR | Net value | ||||
| stapo | STAPO | Statistical | ||||
| uebpo | UEBPO | H-Lev. Item | ||||
| lewed | LEWED | Latest GR Date | ||||
| emlif | EMLIF | Supplier | ||||
| lblkz | LBLKZ | SC Supplier | ||||
| satnr | SATNR | Cross-plant CM | ||||
| attyp | ATTYP | Matl Category | ||||
| vsart | VERSART | Shipping Type | ||||
| handoverloc | HANDOVER_LOC | Handover Location | ||||
| kanba | KBNKZ | Kanban Indicat. | ||||
| adrn2 | ADRN2 | Address | ||||
| delivery_address_type | PURDELIVERYADDRTYPE | Delivery Addr Type | ||||
| cuobj | CUOBJ | Int. object no. | ||||
| xersy | XERSY | ERS | ||||
| eildt | EILDT | GR-B.Sett.from | ||||
| drdat | DRDAT | Last Transm. | ||||
| druhr | DRUHR | Time of Transmission | ||||
| drunr | DRUNR | Sequential Number | ||||
| aktnr | WAKTION | Promotion | ||||
| abeln | ABELN | Alloc. Table | ||||
| abelp | ABELP | Item | ||||
| anzpu | ANZPU | Points | ||||
| punei | PUNEI | Points Unit | ||||
| saiso | SAISO | Season | ||||
| saisj | SAISJ | Season Year | ||||
| ebon2 | EBON2 | Sett. Group 2 | ||||
| ebon3 | EBON3 | Sett. Group 3 | ||||
| ebonf | EBONY | Settlement | ||||
| mlmaa | CK_ML_MAAC | ML Act. | ||||
| mhdrz | MHDRZ | Rem. Shelf Life | ||||
| anfnr | ANFNR | RFQ | ||||
| anfps | ANFPS | Item | ||||
| kzkfg | KZCUH | Origin of config | ||||
| usequ | USEQU | Quota arr.usage | ||||
| umsok | UMSOK | Sp.ind.st.tfr. | ||||
| banfn | BANFN | Purchase Req. | ||||
| bnfpo | BNFPO | Requisn. item | ||||
| mtart | MTART | Material Type | ||||
| uptyp | UPTYP | Subitem Cat. | ||||
| upvor | UPVOR | Sub-items | ||||
| kzwi1 | KZWI1 | Subtotal 1 | ||||
| kzwi2 | KZWI2 | Subtotal 2 | ||||
| kzwi3 | KZWI3 | Subtotal 3 | ||||
| kzwi4 | KZWI4 | Subtotal 4 | ||||
| kzwi5 | KZWI5 | Subtotal 5 | ||||
| kzwi6 | KZWI6 | Subtotal 6 | ||||
| sikgr | SIKGR | Key | ||||
| mfzhi | MFZHI | Max. CMG Qty | ||||
| ffzhi | FFZHI | Maximum CPGQ | ||||
| retpo | RETPO | Returns Item | ||||
| aurel | AUREL | AT-Relevant | ||||
| bsgru | BSGRU | Reason for Ord. | ||||
| lfret | LFRET | Del. Type Rtns | ||||
| mfrgr | MFRGR | Mat.Freight Grp | ||||
| nrfhg | NRFHG | Disc. in kind | ||||
| j_1bnbm | J_1BNBMCO1 | NCM Code | ||||
| j_1bmatuse | J_1BMATUSE | Material Usage | ||||
| j_1bmatorg | J_1BMATORG | Material Origin | ||||
| j_1bownpro | J_1BOWNPRO | Prod. in-house | ||||
| j_1bindust | J_1BINDUS3 | Mat. category | ||||
| abueb | ABUEB | Creation Profile | ||||
| nlabd | NLABD | Next FRC Sched. | ||||
| nfabd | NFABD | Next JIT Sched. | ||||
| kzbws | KZBWS | Valuation | ||||
| bonba | BONBA | Rebate Basis | ||||
| fabkz | FABKZ | JIT Delivery | ||||
| loadingpoint | /SCMTMS/LOADING_POINT_ID | Load./Unload. Pt | ||||
| j_1aindxp | J_1AINDXP | Inflation index | ||||
| j_1aidatep | J_1AIDATEP | Index Date | ||||
| mprof | MPROF | Mfr Part Profile | ||||
| eglkz | EGLKZ | Final Delivery | ||||
| kztlf | KZTUL | Part. Del./Item | ||||
| kzfme | KZWSO | Units meas. use | ||||
| rdprf | RDPRF | Rnding Profile | ||||
| techs | TECHS | StandardVariant | ||||
| chg_srv | CHG_SRV | Configuration changed | ||||
| chg_fplnr | CHG_FPLNR | No invoice for this item although not free of charge | ||||
| mfrpn | MFRPN | Mfr Part Number | ||||
| mfrnr | MFRNR | Manufacturer | ||||
| emnfr | EMNFR | External manuf. | ||||
| novet | NOVET | Shipping block | ||||
| afnam | AFNAM | Requisitioner | ||||
| tzonrc | TSEGZONREC | Rec. time zone | ||||
| iprkz | DATTP | Period Ind. | ||||
| lebre | LEBRE | Srv.-Based Inv. Ver. | ||||
| berid | BERID | MRP Area | ||||
| xconditions | XCONDITIONS | Cndn. for item without invoice | ||||
| apoms | APOMS | Ext. Planning | ||||
| ccomp | MMPUR_CCOMP | Stock transf. cat. | ||||
| grant_nbr | GM_GRANT_NBR | Grant | ||||
| fkber | FKBER | Functional Area | ||||
| status | EPSTATU | Item status | ||||
| reslo | RESLO | Iss. Stor. Loc. | ||||
| kblnr | KBLNR | Earmarked Funds | ||||
| kblpos | KBLPOS | Document Item | ||||
| ps_psp_pnr | PS_PSP_PNR | WBS Element | ||||
| kostl | KOSTL | Cost Center | ||||
| sakto | SAKNR | G/L Account | ||||
| weora | WEORA | Origin Accept. | ||||
| srv_bas_com | SRV_BAS_COM | Service-Based Comm. | ||||
| prio_urg | PRIO_URG | Reqmt Urgency | ||||
| prio_req | PRIO_REQ | Reqmt Priority | ||||
| empst | EMPST | Recv. Point | ||||
| diff_invoice | DIFF_INVOICE | Diff. Invoicing | ||||
| trmrisk_relevant | PUR_TRM_RISK_RELEVANCY | Risk Relevancy | ||||
| creationdate | ME_PDI_CREATIONDATE | Creation Date | ||||
| creationtime | ME_PDI_CREATIONTIME | Creation Time | ||||
| vcm_chain_category | VCM_CHAIN_CATEGORY | Value Chain Category | ||||
| spe_abgru | ABGRU | RejectionReason | ||||
| spe_crm_so | /SPE/VBELN_CRM | CRM Sales Order | ||||
| spe_crm_so_item | /SPE/POSNR_CRM | CRM Item No | ||||
| spe_crm_ref_so | /SPE/REF_VBELN_CRM | CRM Ref Order | ||||
| spe_crm_ref_item | /SPE/REF_POSNR_CRM | CRM Rf Item No | ||||
| spe_crm_fkrel | /SPE/FKREL_CRM | Bill. Relevance | ||||
| spe_chng_sys | /SPE/INB_CHNG_SYS | Changer's Sys.Type | ||||
| spe_insmk_src | /SPE/INSMK_SRC | Source Stock Type | ||||
| spe_cq_ctrltype | /SPE/CQ_CONTROL_TYPE | Control Type | ||||
| spe_cq_nocq | /SPE/CQ_NOCQ | No CQ Transmission | ||||
| reason_code | /SAPPSPRO/_GR_REASON_CODE | Reason Code | ||||
| cqu_sar | CQU_SAR | Cumulative GRs | ||||
| anzsn | ANZSN | No.serial no. | ||||
| spe_ewm_dtc | /SPE/EWM_DTC | EWM Del.Tol.Chk | ||||
| exlin | EXLIN | Hierarchy Number | ||||
| exsnr | EXSNR | External Sort No. | ||||
| ehtyp | EHTYP | Ext.Hierarchy Cat. | ||||
| retpc | RETPZ | Retention % | ||||
| dptyp | ME_DPTYP | Down Payment | ||||
| dppct | ME_DPPCNT | Down Payment % | ||||
| dpamt | ME_DPAMNT | Down Payment Amt | ||||
| dpdat | ME_DPDDAT | Due Date for DP | ||||
| fls_rsto | FLS_RSTO | Enh. Store Ret. | ||||
| ext_rfx_number | ME_PUR_EXT_DOC_ID | External Document | ||||
| ext_rfx_item | ME_PUR_EXT_DOC_ITEM_ID | External Item | ||||
| ext_rfx_system | LOGSYSTEM | Logical System | ||||
| srm_contract_id | SRM_CONTRACT_ID | Central Contract | ||||
| srm_contract_itm | SRM_CONTRACT_ITEM | Cent. Contract Item | ||||
| goods_count_correction | MMPUR_GOODS_COUNT_CORR | Gds. Ct. Crrtn | ||||
| lifex | MMPUR_LIFEX | Ext. Delivery | ||||
| lifexpos | MMPUR_LIFEXPOS | Ext. Item | ||||
| blk_reason_id | BLK_REASON_ID | Block Reason ID | ||||
| blk_reason_txt | BLK_REASON_TXT | Block Reas. Text | ||||
| itcons | ME_IR_CO_ORDER | RT Consumption | ||||
| fixmg | ME_FIXMG | Fixed Date | ||||
| wabwe | WABWE | GI-based GR | ||||
| cmpl_dlv_itm | CMP_DLV_ITM | Complete Deliv. | ||||
| inco2_l | INCO2_L | Inco. Location1 | ||||
| inco3_l | INCO3_L | Inco. Location2 | ||||
| inco2_key | /SCMTMS/INC_LOC_1_KEY | Incoterm Location 1 | ||||
| inco3_key | /SCMTMS/INC_LOC_2_KEY | Incoterm Location 2 | ||||
| inco4_key | /SCMTMS/INC_DEV_PLACE_DEST_KEY | Dev. Destination | ||||
| stawn | /SAPSLL/COMCO | Commodity Code | ||||
| isvco | /SAPSLL/ISVCO | Intrastat Srvc. Code | ||||
| grwrt | GRWRT | Statist. Value | ||||
| serviceperformer | SERVICEPERFORMER | Service Performer | ||||
| producttype | PRODUCT_TYPE | Product Type Group | ||||
| gr_by_ses | MMPUR_GR_BY_SES | GR By SES | ||||
| price_change_in_ses_allowed | PRC_CHG_IN_SES_ALLOWED | Allow Price Change | ||||
| requestforquotation | RFQ_ID | RFQ | ||||
| requestforquotationitem | RFQ_ITEM | Item Number for RFQ | ||||
| renegotiation_status | MEPROC_RENOGSTATE | Renegotiation Status | ||||
| status_pcs | MMPUR_PC_STATUS_PCS | Supplier Check Sts | ||||
| status_pma | MMPUR_PC_STATUS_PMA | Prod. Marktablty Sts | ||||
| status_dg | MMPUR_PC_STATUS_DG | Dangerous Goods Sts | ||||
| status_sds | MMPUR_PC_STATUS_SDS | Sfty Data Sheet Sts | ||||
| extmaterialforpurg | MM_PUR_HUB_MATNR | Material | ||||
| procmt_hub_source_system | MM_PUR_SOURCE_SYS | Source Connected Sys | ||||
| is_catalog_relevant | MMPUR_DOC_ITEM_IS_CATALOG_RLVT | Ctlg Item Indicator | ||||
| target_value | ME_PUR_HUB_ITM_TARGET_VAL | Item Target Value | ||||
| externalreferenceid | MMPUR_EXTERNALREFERENCEID | Ext. Reference ID | ||||
| tc_aut_det | J_1BTC_AUT_DET | TC Auto. Det. | ||||
| manual_tc_reason | J_1BMANUAL_TC_REASON | Man. TC Reason | ||||
| fiscal_incentive | J_1BFISCAL_INCENTIVE_CODE | Tax Incent Type | ||||
| tax_subject_st | J_1BTC_TAX_SUBJECT_ST | Tax Subj. to ST | ||||
| fiscal_incentive_id | J_1BFISCAL_INCENTIVE_ID | Incentive ID | ||||
| sf_txjcd | J_1BCTE_SJCD | OrigJurCod | ||||
| dummy_ekpo_incl_eew_ps | EKPO_INCL_EEW | Ext. Include | ||||
| expected_value | COMMITMENT | Expected Value | ||||
| limit_amount | SUMLIMIT | Overall Limit | ||||
| contract_for_limit | CTR_FOR_LIMIT | Contract For Limit | ||||
| enh_date1 | WKA_DATE1 | WKA Start Date | ||||
| enh_date2 | WKA_DATE2 | WKA end date | ||||
| enh_percent | WKA_PERCENT | Percentage | ||||
| enh_numc1 | WKA_HOURS | Wrk. time hours | ||||
| _dataaging | DATA_TEMPERATURE | Data Aging | ||||
| cupit | GLO_IT_CUP | CUP Italy | ||||
| cigit | GLO_IT_CIG | CIG Italy | ||||
| mgoit | GLO_IT_MGO | MGO Italy | ||||
| txs_business_transaction | TXS_BUSINESS_TRANSACTION | Business Transaction | ||||
| txs_material_usage | TXS_MATERIAL_USAGE | Customer Usage | ||||
| txs_usage_purpose | TXS_USAGE_PURPOSE | Usage Purpose | ||||
| advcode | /ISDFPS/ADVCODE | Advice Code | ||||
| budget_pd | FM_BUDGET_PERIOD | Budget Period | ||||
| excpe | EXCPE | Acceptance Period | ||||
| fmfgus_key | FMFG_US_KEY | US Govt | ||||
| iuid_relevant | IUID_RELEVANT | IUID-Relevant | ||||
| mrpind | J_1IRMRPIND | MRPind | ||||
| sgt_scat | SGT_SCAT | Stock Segment | ||||
| sgt_rcat | SGT_RCAT | Req. Segment | ||||
| tms_ref_uuid | TMS_REF_UUID | GUID of SAP TM | ||||
| tms_src_loc_key | /SCMTMS/LOCUUID | Location | ||||
| tms_des_loc_key | /SCMTMS/LOCUUID | Location | ||||
| wrf_charstc1 | WRF_CHARSTC1 | Characteristic 1 | ||||
| wrf_charstc2 | WRF_CHARSTC2 | Characteristic 2 | ||||
| wrf_charstc3 | WRF_CHARSTC3 | Characteristic 3 | ||||
| taxprocedure | KALSM_D | Procedure | ||||
| isnoteavailable | BOOLEAN_FLG | Boolean Variables (X=true, space=false) | ||||
| isattachmentavailable | BOOLEAN_FLG | Boolean Variables (X=true, space=false) | ||||
| subcontractoraddressid | ADRNR | Address | ||||
| customeraddressid | ADRNR | Address | ||||
| dummy_ext_ekpo_incl_eew_ps | EKPO_INCL_EEW | Ext. Include | ||||
| purchaseorderitemstatus | VDM_PURCHASEORDERITEMSTATUS | Status | ||||
| purchaseorderitemstatusname | PURCHASEORDERITEMSTATUSNAME | PurOrdItmStatus | ||||
| poitemdeliveryaddressid | AD_ADDRNUM | Address Number |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Purchasing Document Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MMPUR_EXT_EKPO (
MANDT, -- Client [MANDT]
EBELN, -- Purchasing Doc. [EBELN]
EBELP, -- Item [EBELP]
EXTSOURCESYSTEM, -- Connected System ID [MMPUR_D_SOURCE_SYS]
UNIQUEID, -- Document Item [CENTRLPURCHASEDOCITEMUNIQUEID]
LOEKZ, -- Del. Indicator [ELOEK]
STATU, -- Origin [ASTAT]
AEDAT, -- Changed On [PAEDT]
TXZ01, -- Short Text [TXZ01]
MATNR, -- Material [MATNR]
EMATN, -- Material [EMATNR]
BUKRS, -- Company Code [BUKRS]
WERKS, -- Plant [EWERK]
LGORT, -- Location [LGORT_D]
BEDNR, -- Tracking Number [BEDNR]
MATKL, -- Material Group [MATKL]
INFNR, -- Info Record [INFNR]
IDNLF, -- Supp. Mat. No. [IDNLF]
KTMNG, -- Target Quantity [KTMNG]
MENGE, -- PO Quantity [BSTMG]
MEINS, -- Order Unit [BSTME]
BPRME, -- Order Price Un. [BBPRM]
BPUMZ, -- Qty Conversion [BPUMZ]
BPUMN, -- Qty Conversion [BPUMN]
UMREZ, -- Equal To [UMBSZ]
UMREN, -- Denominator [UMBSN]
NETPR, -- Net Price [BPREI]
PEINH, -- Price Unit [EPEIN]
NETWR, -- Net Value [BWERT]
BRTWR, -- Gross value [BBWERT]
AGDAT, -- Quot. Deadline [ANGAB]
WEBAZ, -- GR proc. time [WEBAZ]
MWSKZ, -- Tax Code [MWSKZ]
TXDAT_FROM, -- Tax Rate Valid-From [FOT_TXDAT_FROM]
TXDAT, -- Tax Date [TXDAT]
TAX_COUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
BONUS, -- Sett. Group 1 [EBONU]
INSMK, -- Stock Type [INSMK]
SPINF, -- InfoUpdate [SPINF]
PRSDR, -- Print Price [PRSDR]
SCHPR, -- Estimated Price [SCHPR]
MAHNZ, -- No. Rem./Exp. [MAHNZ]
MAHN1, -- 1st Rem./Exped. [MAHN1]
MAHN2, -- 2nd Rem./Exped. [MAHN2]
MAHN3, -- 3rd Rem./Exped. [MAHN3]
UEBTO, -- Overdeliv. Tol. [UEBTO]
UEBTK, -- Unlimited [UEBTK]
UNTTO, -- Underdel. Tol. [UNTTO]
BWTAR, -- Valuation Type [BWTAR_D]
BWTTY, -- Valuation Cat. [BWTTY_D]
ABSKZ, -- Rejection Ind. [ABSKZ]
AGMEM, -- Quot. Comment [AGMEM]
ELIKZ, -- Deliv. Compl. [ELIKZ]
EREKZ, -- Final Invoice [EREKZ]
PSTYP, -- Item Category [PSTYP]
KNTTP, -- Acct Assgmt Cat [KNTTP]
KZVBR, -- Consumption [KZVBR]
VRTKZ, -- Distribution [VRTKZ]
TWRKZ, -- Partial invoice [TWRKZ]
WEPOS, -- Goods Receipt [WEPOS]
WEUNB, -- GR Non-Valuated [WEUNB]
REPOS, -- Invoice Receipt [REPOS]
WEBRE, -- GR-Based IV [WEBRE]
KZABS, -- Acknowl. Reqd. [KZABS]
LABNR, -- Order Acknowl. [LABNR]
KONNR, -- Agreement [KONNR]
KTPNR, -- Agreement Item [KTPNR]
ABDAT, -- Recon.Date [ABDAT]
ABFTZ, -- Agr. Cum. Qty [ABFTZ]
ETFZ1, -- Firm Zone [ETFZ1]
ETFZ2, -- Trade-Off Zone [ETFZ2]
KZSTU, -- Binding on MRP [MRPRE]
NOTKZ, -- Exclusion [NOTKZ]
LMEIN, -- Base Unit [LAGME]
EVERS, -- Shipping Instr. [EVERS]
ZWERT, -- Target Value [DZWERT]
NAVNW, -- Non-deductible [NAVNW]
ABMNG, -- Rel. order qty. [NORAM]
PRDAT, -- Price Date [PREDT]
BSTYP, -- Doc. Category [BSTYP]
EFFWR, -- Effective value [EFFWR]
XOBLR, -- Commitments [XOBLR]
KUNNR, -- Customer [EKUNNR]
ADRNR, -- Address [ADRNR_MM]
EKKOL, -- Condition Group [EKKOG]
SKTOF, -- No Cash Disc. [ESKTOF]
STAFO, -- Update Group [STAFO]
PLIFZ, -- Pl. Deliv. Time [EPLIF]
NTGEW, -- Net Weight [ENTGE]
GEWEI, -- Unit of Weight [EGEWE]
TXJCD, -- Tax Jur. [TXJCD]
ETDRK, -- Print-relevant [ETDRK]
SOBKZ, -- Special Stock [SOBKZ]
ARSNR, -- Settle.reser.No [ARSNR]
ARSPS, -- Settle.item no. [ARSPS]
INSNC, -- Not changeable [INSNC]
SSQSS, -- QM Control Key [QSSPUR]
ZGTYP, -- CertificateType [QZGTYP]
EAN11, -- EAN/UPC [EAN11]
BSTAE, -- Conf. Control [BSTAE]
REVLV, -- Revision Level [REVLV]
GEBER, -- Fund [BP_GEBER]
FISTL, -- Funds Center [FISTL]
FIPOS, -- Commitment item [FIPOS]
KO_GSBER, -- Bus.area:prtner [GSBER_GP]
KO_PARGB, -- Ptr's assum.BA [PARGB_GP]
KO_PRCTR, -- Profit Center [PRCTR]
KO_PPRCTR, -- Partner PC [PPRCTR]
MEPRF, -- Pr. Date Cat. [MEPRF]
BRGEW, -- Gross Weight [BRGEW]
VOLUM, -- Volume [VOLUM]
VOLEH, -- Volume Unit [VOLEH]
INCO1, -- Incoterms [INCO1]
INCO2, -- Incoterms 2 [INCO2]
VORAB, -- Advance proc. [VORAB]
KOLIF, -- Prior Supplier [KOLIF]
LTSNR, -- Suppl. Subrange [LTSNR]
PACKNO, -- Package number [PACKNO]
FPLNR, -- Invoicing plan [IPLNR]
GNETWR, -- Net value [GNETWR]
STAPO, -- Statistical [STAPO]
UEBPO, -- H-Lev. Item [UEBPO]
LEWED, -- Latest GR Date [LEWED]
EMLIF, -- Supplier [EMLIF]
LBLKZ, -- SC Supplier [LBLKZ]
SATNR, -- Cross-plant CM [SATNR]
ATTYP, -- Matl Category [ATTYP]
VSART, -- Shipping Type [VERSART]
HANDOVERLOC, -- Handover Location [HANDOVER_LOC]
KANBA, -- Kanban Indicat. [KBNKZ]
ADRN2, -- Address [ADRN2]
DELIVERY_ADDRESS_TYPE, -- Delivery Addr Type [PURDELIVERYADDRTYPE]
CUOBJ, -- Int. object no. [CUOBJ]
XERSY, -- ERS [XERSY]
EILDT, -- GR-B.Sett.from [EILDT]
DRDAT, -- Last Transm. [DRDAT]
DRUHR, -- Time of Transmission [DRUHR]
DRUNR, -- Sequential Number [DRUNR]
AKTNR, -- Promotion [WAKTION]
ABELN, -- Alloc. Table [ABELN]
ABELP, -- Item [ABELP]
ANZPU, -- Points [ANZPU]
PUNEI, -- Points Unit [PUNEI]
SAISO, -- Season [SAISO]
SAISJ, -- Season Year [SAISJ]
EBON2, -- Sett. Group 2 [EBON2]
EBON3, -- Sett. Group 3 [EBON3]
EBONF, -- Settlement [EBONY]
MLMAA, -- ML Act. [CK_ML_MAAC]
MHDRZ, -- Rem. Shelf Life [MHDRZ]
ANFNR, -- RFQ [ANFNR]
ANFPS, -- Item [ANFPS]
KZKFG, -- Origin of config [KZCUH]
USEQU, -- Quota arr.usage [USEQU]
UMSOK, -- Sp.ind.st.tfr. [UMSOK]
BANFN, -- Purchase Req. [BANFN]
BNFPO, -- Requisn. item [BNFPO]
MTART, -- Material Type [MTART]
UPTYP, -- Subitem Cat. [UPTYP]
UPVOR, -- Sub-items [UPVOR]
KZWI1, -- Subtotal 1 [KZWI1]
KZWI2, -- Subtotal 2 [KZWI2]
KZWI3, -- Subtotal 3 [KZWI3]
KZWI4, -- Subtotal 4 [KZWI4]
KZWI5, -- Subtotal 5 [KZWI5]
KZWI6, -- Subtotal 6 [KZWI6]
SIKGR, -- Key [SIKGR]
MFZHI, -- Max. CMG Qty [MFZHI]
FFZHI, -- Maximum CPGQ [FFZHI]
RETPO, -- Returns Item [RETPO]
AUREL, -- AT-Relevant [AUREL]
BSGRU, -- Reason for Ord. [BSGRU]
LFRET, -- Del. Type Rtns [LFRET]
MFRGR, -- Mat.Freight Grp [MFRGR]
NRFHG, -- Disc. in kind [NRFHG]
J_1BNBM, -- NCM Code [J_1BNBMCO1]
J_1BMATUSE, -- Material Usage [J_1BMATUSE]
J_1BMATORG, -- Material Origin [J_1BMATORG]
J_1BOWNPRO, -- Prod. in-house [J_1BOWNPRO]
J_1BINDUST, -- Mat. category [J_1BINDUS3]
ABUEB, -- Creation Profile [ABUEB]
NLABD, -- Next FRC Sched. [NLABD]
NFABD, -- Next JIT Sched. [NFABD]
KZBWS, -- Valuation [KZBWS]
BONBA, -- Rebate Basis [BONBA]
FABKZ, -- JIT Delivery [FABKZ]
LOADINGPOINT, -- Load./Unload. Pt [/SCMTMS/LOADING_POINT_ID]
J_1AINDXP, -- Inflation index [J_1AINDXP]
J_1AIDATEP, -- Index Date [J_1AIDATEP]
MPROF, -- Mfr Part Profile [MPROF]
EGLKZ, -- Final Delivery [EGLKZ]
KZTLF, -- Part. Del./Item [KZTUL]
KZFME, -- Units meas. use [KZWSO]
RDPRF, -- Rnding Profile [RDPRF]
TECHS, -- StandardVariant [TECHS]
CHG_SRV, -- Configuration changed [CHG_SRV]
CHG_FPLNR, -- No invoice for this item although not free of charge [CHG_FPLNR]
MFRPN, -- Mfr Part Number [MFRPN]
MFRNR, -- Manufacturer [MFRNR]
EMNFR, -- External manuf. [EMNFR]
NOVET, -- Shipping block [NOVET]
AFNAM, -- Requisitioner [AFNAM]
TZONRC, -- Rec. time zone [TSEGZONREC]
IPRKZ, -- Period Ind. [DATTP]
LEBRE, -- Srv.-Based Inv. Ver. [LEBRE]
BERID, -- MRP Area [BERID]
XCONDITIONS, -- Cndn. for item without invoice [XCONDITIONS]
APOMS, -- Ext. Planning [APOMS]
CCOMP, -- Stock transf. cat. [MMPUR_CCOMP]
GRANT_NBR, -- Grant [GM_GRANT_NBR]
FKBER, -- Functional Area [FKBER]
STATUS, -- Item status [EPSTATU]
RESLO, -- Iss. Stor. Loc. [RESLO]
KBLNR, -- Earmarked Funds [KBLNR]
KBLPOS, -- Document Item [KBLPOS]
PS_PSP_PNR, -- WBS Element [PS_PSP_PNR]
KOSTL, -- Cost Center [KOSTL]
SAKTO, -- G/L Account [SAKNR]
WEORA, -- Origin Accept. [WEORA]
SRV_BAS_COM, -- Service-Based Comm. [SRV_BAS_COM]
PRIO_URG, -- Reqmt Urgency [PRIO_URG]
PRIO_REQ, -- Reqmt Priority [PRIO_REQ]
EMPST, -- Recv. Point [EMPST]
DIFF_INVOICE, -- Diff. Invoicing [DIFF_INVOICE]
TRMRISK_RELEVANT, -- Risk Relevancy [PUR_TRM_RISK_RELEVANCY]
CREATIONDATE, -- Creation Date [ME_PDI_CREATIONDATE]
CREATIONTIME, -- Creation Time [ME_PDI_CREATIONTIME]
VCM_CHAIN_CATEGORY, -- Value Chain Category [VCM_CHAIN_CATEGORY]
SPE_ABGRU, -- RejectionReason [ABGRU]
SPE_CRM_SO, -- CRM Sales Order [/SPE/VBELN_CRM]
SPE_CRM_SO_ITEM, -- CRM Item No [/SPE/POSNR_CRM]
SPE_CRM_REF_SO, -- CRM Ref Order [/SPE/REF_VBELN_CRM]
SPE_CRM_REF_ITEM, -- CRM Rf Item No [/SPE/REF_POSNR_CRM]
SPE_CRM_FKREL, -- Bill. Relevance [/SPE/FKREL_CRM]
SPE_CHNG_SYS, -- Changer's Sys.Type [/SPE/INB_CHNG_SYS]
SPE_INSMK_SRC, -- Source Stock Type [/SPE/INSMK_SRC]
SPE_CQ_CTRLTYPE, -- Control Type [/SPE/CQ_CONTROL_TYPE]
SPE_CQ_NOCQ, -- No CQ Transmission [/SPE/CQ_NOCQ]
REASON_CODE, -- Reason Code [/SAPPSPRO/_GR_REASON_CODE]
CQU_SAR, -- Cumulative GRs [CQU_SAR]
ANZSN, -- No.serial no. [ANZSN]
SPE_EWM_DTC, -- EWM Del.Tol.Chk [/SPE/EWM_DTC]
EXLIN, -- Hierarchy Number [EXLIN]
EXSNR, -- External Sort No. [EXSNR]
EHTYP, -- Ext.Hierarchy Cat. [EHTYP]
RETPC, -- Retention % [RETPZ]
DPTYP, -- Down Payment [ME_DPTYP]
DPPCT, -- Down Payment % [ME_DPPCNT]
DPAMT, -- Down Payment Amt [ME_DPAMNT]
DPDAT, -- Due Date for DP [ME_DPDDAT]
FLS_RSTO, -- Enh. Store Ret. [FLS_RSTO]
EXT_RFX_NUMBER, -- External Document [ME_PUR_EXT_DOC_ID]
EXT_RFX_ITEM, -- External Item [ME_PUR_EXT_DOC_ITEM_ID]
EXT_RFX_SYSTEM, -- Logical System [LOGSYSTEM]
SRM_CONTRACT_ID, -- Central Contract [SRM_CONTRACT_ID]
SRM_CONTRACT_ITM, -- Cent. Contract Item [SRM_CONTRACT_ITEM]
GOODS_COUNT_CORRECTION, -- Gds. Ct. Crrtn [MMPUR_GOODS_COUNT_CORR]
LIFEX, -- Ext. Delivery [MMPUR_LIFEX]
LIFEXPOS, -- Ext. Item [MMPUR_LIFEXPOS]
BLK_REASON_ID, -- Block Reason ID [BLK_REASON_ID]
BLK_REASON_TXT, -- Block Reas. Text [BLK_REASON_TXT]
ITCONS, -- RT Consumption [ME_IR_CO_ORDER]
FIXMG, -- Fixed Date [ME_FIXMG]
WABWE, -- GI-based GR [WABWE]
CMPL_DLV_ITM, -- Complete Deliv. [CMP_DLV_ITM]
INCO2_L, -- Inco. Location1 [INCO2_L]
INCO3_L, -- Inco. Location2 [INCO3_L]
INCO2_KEY, -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY]
INCO3_KEY, -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY]
INCO4_KEY, -- Dev. Destination [/SCMTMS/INC_DEV_PLACE_DEST_KEY]
STAWN, -- Commodity Code [/SAPSLL/COMCO]
ISVCO, -- Intrastat Srvc. Code [/SAPSLL/ISVCO]
GRWRT, -- Statist. Value [GRWRT]
SERVICEPERFORMER, -- Service Performer [SERVICEPERFORMER]
PRODUCTTYPE, -- Product Type Group [PRODUCT_TYPE]
GR_BY_SES, -- GR By SES [MMPUR_GR_BY_SES]
PRICE_CHANGE_IN_SES_ALLOWED, -- Allow Price Change [PRC_CHG_IN_SES_ALLOWED]
REQUESTFORQUOTATION, -- RFQ [RFQ_ID]
REQUESTFORQUOTATIONITEM, -- Item Number for RFQ [RFQ_ITEM]
RENEGOTIATION_STATUS, -- Renegotiation Status [MEPROC_RENOGSTATE]
STATUS_PCS, -- Supplier Check Sts [MMPUR_PC_STATUS_PCS]
STATUS_PMA, -- Prod. Marktablty Sts [MMPUR_PC_STATUS_PMA]
STATUS_DG, -- Dangerous Goods Sts [MMPUR_PC_STATUS_DG]
STATUS_SDS, -- Sfty Data Sheet Sts [MMPUR_PC_STATUS_SDS]
EXTMATERIALFORPURG, -- Material [MM_PUR_HUB_MATNR]
PROCMT_HUB_SOURCE_SYSTEM, -- Source Connected Sys [MM_PUR_SOURCE_SYS]
IS_CATALOG_RELEVANT, -- Ctlg Item Indicator [MMPUR_DOC_ITEM_IS_CATALOG_RLVT]
TARGET_VALUE, -- Item Target Value [ME_PUR_HUB_ITM_TARGET_VAL]
EXTERNALREFERENCEID, -- Ext. Reference ID [MMPUR_EXTERNALREFERENCEID]
TC_AUT_DET, -- TC Auto. Det. [J_1BTC_AUT_DET]
MANUAL_TC_REASON, -- Man. TC Reason [J_1BMANUAL_TC_REASON]
FISCAL_INCENTIVE, -- Tax Incent Type [J_1BFISCAL_INCENTIVE_CODE]
TAX_SUBJECT_ST, -- Tax Subj. to ST [J_1BTC_TAX_SUBJECT_ST]
FISCAL_INCENTIVE_ID, -- Incentive ID [J_1BFISCAL_INCENTIVE_ID]
SF_TXJCD, -- OrigJurCod [J_1BCTE_SJCD]
DUMMY_EKPO_INCL_EEW_PS, -- Ext. Include [EKPO_INCL_EEW]
EXPECTED_VALUE, -- Expected Value [COMMITMENT]
LIMIT_AMOUNT, -- Overall Limit [SUMLIMIT]
CONTRACT_FOR_LIMIT, -- Contract For Limit [CTR_FOR_LIMIT]
ENH_DATE1, -- WKA Start Date [WKA_DATE1]
ENH_DATE2, -- WKA end date [WKA_DATE2]
ENH_PERCENT, -- Percentage [WKA_PERCENT]
ENH_NUMC1, -- Wrk. time hours [WKA_HOURS]
_DATAAGING, -- Data Aging [DATA_TEMPERATURE]
CUPIT, -- CUP Italy [GLO_IT_CUP]
CIGIT, -- CIG Italy [GLO_IT_CIG]
MGOIT, -- MGO Italy [GLO_IT_MGO]
TXS_BUSINESS_TRANSACTION, -- Business Transaction [TXS_BUSINESS_TRANSACTION]
TXS_MATERIAL_USAGE, -- Customer Usage [TXS_MATERIAL_USAGE]
TXS_USAGE_PURPOSE, -- Usage Purpose [TXS_USAGE_PURPOSE]
ADVCODE, -- Advice Code [/ISDFPS/ADVCODE]
BUDGET_PD, -- Budget Period [FM_BUDGET_PERIOD]
EXCPE, -- Acceptance Period [EXCPE]
FMFGUS_KEY, -- US Govt [FMFG_US_KEY]
IUID_RELEVANT, -- IUID-Relevant [IUID_RELEVANT]
MRPIND, -- MRPind [J_1IRMRPIND]
SGT_SCAT, -- Stock Segment [SGT_SCAT]
SGT_RCAT, -- Req. Segment [SGT_RCAT]
TMS_REF_UUID, -- GUID of SAP TM [TMS_REF_UUID]
TMS_SRC_LOC_KEY, -- Location [/SCMTMS/LOCUUID]
TMS_DES_LOC_KEY, -- Location [/SCMTMS/LOCUUID]
WRF_CHARSTC1, -- Characteristic 1 [WRF_CHARSTC1]
WRF_CHARSTC2, -- Characteristic 2 [WRF_CHARSTC2]
WRF_CHARSTC3, -- Characteristic 3 [WRF_CHARSTC3]
TAXPROCEDURE, -- Procedure [KALSM_D]
ISNOTEAVAILABLE, -- Boolean Variables (X=true, space=false) [BOOLEAN_FLG]
ISATTACHMENTAVAILABLE, -- Boolean Variables (X=true, space=false) [BOOLEAN_FLG]
SUBCONTRACTORADDRESSID, -- Address [ADRNR]
CUSTOMERADDRESSID, -- Address [ADRNR]
DUMMY_EXT_EKPO_INCL_EEW_PS, -- Ext. Include [EKPO_INCL_EEW]
PURCHASEORDERITEMSTATUS, -- Status [VDM_PURCHASEORDERITEMSTATUS]
PURCHASEORDERITEMSTATUSNAME, -- PurOrdItmStatus [PURCHASEORDERITEMSTATUSNAME]
POITEMDELIVERYADDRESSID, -- Address Number [AD_ADDRNUM]
PRIMARY KEY (MANDT, EBELN, EBELP, EXTSOURCESYSTEM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA