PPS_PO_ITEM_D
Draft table for entity R_PPS_PURCHASEORDERITEMTP
PPS_PO_ITEM_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCHASEORDERITEMTP. It contains 246 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_PPS_PurchaseOrderItemDraft | view_entity | from | EXTENSION | PPS Purchase Order Item - Extension |
| R_PPS_PurchaseOrderItemDraft | view_entity | from | BASIC | Purchase Order Item - Draft |
Fields (246)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | purchaseorder | VDM_PURCHASEORDER | Purchase Order | |||
| KEY | purchaseorderitem | VDM_PURCHASEORDERITEM | Purchase Order Item | |||
| KEY | draftuuid | SDRAFT_UUID | Draft Document ID | |||
| parentdraftuuid | SDRAFT_UUID | Draft Document ID | ||||
| purchaseordercategory | BSTYP | Doc. Category | ||||
| documentcurrency | WAERS | Currency | ||||
| purchasingorganization | EKORG | Purchasing Org. | ||||
| purchasingdocumentdeletioncode | ELOEK | Del. Indicator | ||||
| isdeleted | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| isblocked | BOOLEAN | Boolean Variable (X = True, - = False, Space = Unknown) | ||||
| purchasingdeliveryaddresstype | PURREQNADDRTYPE | Address Type | ||||
| ppsperdofperfstartdate | PPS_E_PEROP_START_DATE | PeROP Start Date | ||||
| ppsperdofperfenddate | PPS_E_PEROP_END_DATE | PeROP End Date | ||||
| ppssmartnumberitem | PPS_E_SMT_SMART_NUMBER | Smart Number | ||||
| ppssmartnumberitemismanual | XFELD | Checkbox | ||||
| ppsconfigurablelineitemnumber | PPS_E_CONFIG_ITEM_NO | Config. Itm. No. | ||||
| ppsdeliverytolerancekey | PPS_E_TOLERANCE_KEY | Tolerance Key | ||||
| ppspurorderitemstatus | PPS_E_ITEM_STATUS | Item Status | ||||
| ppspurorderitemstatustext | MMPUR_DOC_STATUS_NAME | Pur. Doc. Stat. Name | ||||
| ppspurorditemstatuscriticality | abap.int1 | |||||
| ppsisoptionalitem | BOOLE_D | TRUE | ||||
| ppsoptionalitemstatus | PPS_E_OPT_ITEM_STATUS | Optional Item Status | ||||
| ppsoptionexercisestartdate | PPS_E_OPT_EXEC_PER_START_DATE | Exe Start Date | ||||
| ppsoptionexerciseenddate | PPS_E_OPT_EXEC_PER_END_DATE | Execution End Date | ||||
| materialgroup | MATKL | Material Group | ||||
| materialgroupname | PRODUCTGROUPDESCRIPTION | prod Grp Desc. | ||||
| material | MATNR | Material | ||||
| materialtype | MTART | Material Type | ||||
| suppliermaterialnumber | IDNLF | Supp. Mat. No. | ||||
| suppliersubrange | LTSNR | Suppl. Subrange | ||||
| manufacturerpartnmbr | MFRPN | Mfr Part Number | ||||
| manufacturer | MFRNR | Manufacturer | ||||
| manufacturermaterial | EMATNR | Material | ||||
| materialname | MAKTX | Description | ||||
| purchaseorderitemtext | TXZ01 | Short Text | ||||
| producttypecode | PRODUCT_TYPE | Product Type Group | ||||
| companycode | BUKRS | Company Code | ||||
| ppssmartnumberheader | PPS_E_SMT_SMART_NUMBER | Smart Number | ||||
| plant | EWERK | Plant | ||||
| plantname | WERKS_NAME | Plant Name | ||||
| lastchangeddate | ABP_LASTCHANGE_DATE | Changed On | ||||
| manualdeliveryaddressid | ADRNR_MM | Address | ||||
| itemcategory | abap.char | |||||
| referencedeliveryaddressid | ADRN2 | Address | ||||
| customer | EKUNNR | Customer | ||||
| subcontractor | EMLIF | Supplier | ||||
| supplierissubcontractor | LBLKZ | SC Supplier | ||||
| crossplantconfigurableproduct | SATNR | Cross-plant CM | ||||
| articlecategory | ATTYP | Matl Category | ||||
| plndorderreplnmtelmnttype | KBNKZ | Kanban Indicat. | ||||
| productpurchasepointsqtyunit | PUNEI | Points Unit | ||||
| productpurchasepointsqty | ANZPU | Points | ||||
| storagelocation | VDM_STORAGE_LOCATION | Storage Location | ||||
| purchaseorderquantityunit | BSTME | Order Unit | ||||
| orderitemqtytobaseqtynmrtr | UMBSZ | Equal To | ||||
| orderitemqtytobaseqtydnmntr | UMBSN | Denominator | ||||
| netpricequantity | VDM_PRICE_UNIT | Price Unit | ||||
| iscompletelydelivered | ELIKZ | Deliv. Compl. | ||||
| isfinallyinvoiced | EREKZ | Final Invoice | ||||
| goodsreceiptisexpected | WEPOS | Goods Receipt | ||||
| invoiceisexpected | REPOS | Invoice Receipt | ||||
| isorderacknrqd | KZABS | Acknowl. Reqd. | ||||
| invoiceisgoodsreceiptbased | WEBRE | GR-Based IV | ||||
| purchasecontractitem | KTPNR | Agreement Item | ||||
| purchasecontract | KONNR | Agreement | ||||
| purchaserequisition | BANFN | Purchase Req. | ||||
| requirementtracking | BEDNR | Tracking Number | ||||
| purchaserequisitionitem | BNFPO | Requisn. item | ||||
| supplierquotation | ANFNR | RFQ | ||||
| supplierquotationitem | ANFPS | Item | ||||
| evaldrcptsettlmtisallowed | XERSY | ERS | ||||
| unlimitedoverdeliveryisallowed | UEBTK | Unlimited | ||||
| overdelivtolrtdlmtratioinpct | UEBTO | Overdeliv. Tol. | ||||
| underdelivtolrtdlmtratioinpct | UNTTO | Underdel. Tol. | ||||
| requisitionername | AFNAM | Requisitioner | ||||
| planneddeliverydurationindays | EPLIF | Pl. Deliv. Time | ||||
| goodsreceiptdurationindays | WEBAZ | GR proc. time | ||||
| partialdeliveryisallowed | KZTUL | Part. Del./Item | ||||
| consumptionposting | KZVBR | Consumption | ||||
| serviceperformer | SERVICEPERFORMER | Service Performer | ||||
| servicepackage | PACKNO | Package number | ||||
| baseunit | LAGME | Base Unit | ||||
| purchaseorderitemcategory | PSTYP | Item Category | ||||
| profitcenter | PRCTR | Profit Center | ||||
| orderpriceunit | BBPRM | Order Price Un. | ||||
| itemvolumeunit | VOLEH | Volume Unit | ||||
| itemweightunit | EGEWE | Unit of Weight | ||||
| multipleacctassgmtdistribution | VRTKZ | Distribution | ||||
| partialinvoicedistribution | TWRKZ | Partial invoice | ||||
| pricingdatecontrol | MEPRF | Pr. Date Cat. | ||||
| isstatisticalitem | STAPO | Statistical | ||||
| purchasingparentitem | UEBPO | H-Lev. Item | ||||
| goodsreceiptlatestcreationdate | LEWED | Latest GR Date | ||||
| isreturnsitem | RETPO | Returns Item | ||||
| purchasingorderreason | BSGRU | Reason for Ord. | ||||
| incotermsclassification | INCO1 | Incoterms | ||||
| incotermsclassificationname | INCOTERMS_CLASSIFICATION_NAME | Incoterms Classification Description | ||||
| incotermstransferlocation | INCO2 | Incoterms 2 | ||||
| incotermslocation1 | INCO2_L | Inco. Location1 | ||||
| incotermslocation2 | INCO3_L | Inco. Location2 | ||||
| priorsupplier | KOLIF | Prior Supplier | ||||
| internationalarticlenumber | EAN11 | EAN/UPC | ||||
| intrastatservicecode | /SAPSLL/ISVCO | Intrastat Srvc. Code | ||||
| commoditycode | /SAPSLL/COMCO | Commodity Code | ||||
| materialfreightgroup | MFRGR | Mat.Freight Grp | ||||
| discountinkindeligibility | NRFHG | Disc. in kind | ||||
| purgitemisblockedfordelivery | NOVET | Shipping block | ||||
| supplierconfirmationcontrolkey | BSTAE | Conf. Control | ||||
| purgdocorderacknnumber | LABNR | Order Acknowl. | ||||
| priceistobeprinted | PRSDR | Print Price | ||||
| accountassignmentcategory | KNTTP | Acct Assgmt Cat | ||||
| purchasinginforecord | INFNR | Info Record | ||||
| inforecordistobeupdated | INFUP | InfoUpdate | ||||
| purordexternalitemcategory | EPSTP | Item Category | ||||
| purorditemcategoryname | PTEXT_D | Text for ItCat. | ||||
| netamount | BWERT | Net Value | ||||
| grossamount | BBWERT | Gross value | ||||
| effectiveamount | EFFWR | Effective value | ||||
| subtotal1amount | KZWI1 | Subtotal 1 | ||||
| subtotal2amount | KZWI2 | Subtotal 2 | ||||
| subtotal3amount | KZWI3 | Subtotal 3 | ||||
| subtotal4amount | KZWI4 | Subtotal 4 | ||||
| subtotal5amount | KZWI5 | Subtotal 5 | ||||
| subtotal6amount | KZWI6 | Subtotal 6 | ||||
| orderquantity | BSTMG | PO Quantity | ||||
| netpriceamount | BPREI | Net Price | ||||
| itemvolume | VOLUM | Volume | ||||
| itemgrossweight | BRGEW | Gross Weight | ||||
| itemnetweight | ENTGE | Net Weight | ||||
| orderpriceunittoorderunitnmrtr | BPUMZ | Qty Conversion | ||||
| ordpriceunittoorderunitdnmntr | BPUMN | Qty Conversion | ||||
| goodsreceiptisnonvaluated | WEUNB | GR Non-Valuated | ||||
| purchaseordertype | ESART | Document Type | ||||
| taxcalculationprocedure | KALSM_D | Procedure | ||||
| taxcode | MWSKZ | Tax Code | ||||
| taxcodename | FIS_MWSKZ_NAME | Tax Code Name | ||||
| taxjurisdiction | TXJCD | Tax Jur. | ||||
| taxcountry | FOT_TAX_COUNTRY | Tax Ctry/Reg. | ||||
| taxdeterminationdate | TXDAT | Tax Date | ||||
| shippinginstruction | EVERS | Shipping Instr. | ||||
| nondeductibleinputtaxamount | NAVNW | Non-deductible | ||||
| stocktype | INSMK | Stock Type | ||||
| valuationtype | BWTAR_D | Valuation Type | ||||
| valuationcategory | BWTTY_D | Valuation Cat. | ||||
| itemisrejectedbysupplier | ABSKZ | Rejection Ind. | ||||
| purgdocpricedate | PREDT | Price Date | ||||
| purchasinginforecordupdatecode | SPINF | InfoUpdate | ||||
| inventoryspecialstocktype | SOBKZ | Special Stock | ||||
| deliverydocumenttype | LFRET | Del. Type Rtns | ||||
| issuingstoragelocation | RESLO | Iss. Stor. Loc. | ||||
| allocationtable | ABELN | Alloc. Table | ||||
| allocationtableitem | ABELP | Item | ||||
| retailpromotion | WAKTION | Promotion | ||||
| purgconfigurableitemnumber | EXLIN | Hierarchy Number | ||||
| purgdocaggrgdsubitemcategory | UPVOR | Sub-items | ||||
| purgdocsubitemcategory | UPTYP | Subitem Cat. | ||||
| purgexternalsortnumber | EXSNR | External Sort No. | ||||
| downpaymenttype | ME_DPTYP | Down Payment | ||||
| downpaymentpercentageoftotamt | ME_DPPCNT | Down Payment % | ||||
| downpaymentamount | ME_DPAMNT | Down Payment Amt | ||||
| downpaymentduedate | ME_DPDDAT | Due Date for DP | ||||
| expectedoveralllimitamount | COMMITMENT | Expected Value | ||||
| overalllimitamount | SUMLIMIT | Overall Limit | ||||
| purcontractforoveralllimit | CTR_FOR_LIMIT | Contract For Limit | ||||
| purgprodcmplncsupplierstatus | MMPUR_PC_STATUS_PCS | Supplier Check Sts | ||||
| purgproductmarketabilitystatus | MMPUR_PC_STATUS_PMA | Prod. Marktablty Sts | ||||
| purgsafetydatasheetstatus | MMPUR_PC_STATUS_SDS | Sfty Data Sheet Sts | ||||
| purgprodcmplncdngrsgoodsstatus | MMPUR_PC_STATUS_DG | Dangerous Goods Sts | ||||
| requirementsegment | SGT_RCAT | Req. Segment | ||||
| batch | CHARG_D | Batch | ||||
| batchbysupplier | LICHN | Supplier Batch | ||||
| fund | BP_GEBER | Fund | ||||
| budgetperiod | FM_BUDGET_PERIOD | Budget Period | ||||
| fundscenter | FISTL | Funds Center | ||||
| commitmentitem | FIPOS | Commitment item | ||||
| commitmentitemshortid | FMIS_CI_INTERNALNAME | Commitment Item Short ID | ||||
| functionalarea | FKBER | Functional Area | ||||
| grantid | GM_GRANT_NBR | Grant | ||||
| earmarkedfundsdocument | KBLNR | Earmarked Funds | ||||
| earmarkedfundsdocumentitem | KBLPOS | Document Item | ||||
| costcenter | KOSTL | Cost Center | ||||
| glaccount | SAKNR | G/L Account | ||||
| wbselementinternalid | PS_S4_PSPNR | WBS Internal ID | ||||
| wbselementexternalid | PS_POSID_EDIT | WBS Element | ||||
| wbsdescription | PS_S4_POST1 | WBS Element Name | ||||
| br_materialorigin | J_1BMATORG | Material Origin | ||||
| br_materialusage | J_1BMATUSE | Material Usage | ||||
| br_cfopcategory | J_1BINDUS3 | Mat. category | ||||
| br_ncm | J_1BNBMCO1 | NCM Code | ||||
| consumptiontaxctrlcode | J_1IG_HSN_SAC | HSN/SAC Code | ||||
| br_isproducedinhouse | J_1BOWNPRO | Prod. in-house | ||||
| productseasonyear | FSH_SAISJ | Season Year | ||||
| productseason | FSH_SAISO | Season | ||||
| productcollection | FSH_COLLECTION | Collection | ||||
| producttheme | FSH_THEME | Theme | ||||
| seasoncompletenessstatus | RFM_SCC_INDICATOR | Season Comp.Ind | ||||
| shippinggrouprule | RFM_PSST_RULE | PSST Grouping Rule | ||||
| shippinggroupnumber | RFM_PSST_GROUP_ID | PSST Group | ||||
| productcharacteristic1 | WRF_CHARSTC1 | Characteristic 1 | ||||
| productcharacteristic2 | WRF_CHARSTC2 | Characteristic 2 | ||||
| productcharacteristic3 | WRF_CHARSTC3 | Characteristic 3 | ||||
| diversionstatus | RFM_DIVERSION_STATUS | Diversion Status | ||||
| refdocnmbrfortrcblyinpo | RFM_REF_DOC | Reference Document | ||||
| referencedocumentitem | RFM_REF_ITEM | Reference Item | ||||
| purchaseorderreferencetype | RFM_REF_ACTION | Reference Action | ||||
| itemhasvalueaddedservice | FSH_VAS_REL | VAS Relevant | ||||
| valaddedsrvcparentitmnumber | EBELP | Item | ||||
| in_gstcontrolcode | J_1IG_HSN_SAC | HSN/SAC Code | ||||
| purchaseorderitemuniqueid | PURCHASINGDOCUMENTITEMUNIQUEID | Document Item | ||||
| producttypename | PRODUCT_TYPE_DESCRIPTION | Description | ||||
| pricechangeinsesisallowed | PRC_CHG_IN_SES_ALLOWED | Allow Price Change | ||||
| requestforquotation | RFQ_ID | RFQ | ||||
| requestforquotationitem | RFQ_ITEM | Item Number for RFQ | ||||
| incotermslocation1identifier | TMINCO_LOC_1_ID | Incoterm Loc. 1 ID | ||||
| incotermslocation2identifier | TMINCO_LOC_2_ID | Incoterm Loc. 2 ID | ||||
| incotermsdvtglocidentifier | TMINCO_LOC_D_ID | Deviating Loc. ID | ||||
| incotermsdvtglocdescription | TMINCO_LOC_D_DESCR | Deviating Loc. Desc. | ||||
| incotermssupchnloc1addluuid | /SCMTMS/INC_LOC_1_KEY_NC | Incoterm Location 1 | ||||
| incotermssupchnloc2addluuid | /SCMTMS/INC_LOC_2_KEY_NC | Incoterm Location 2 | ||||
| incotermssupchndvtglocaddluuid | /SCMTMS/INC_DV_PLCE_DST_KEY_NC | Dev. Destination | ||||
| taxcodevalidfromdate | FOT_TXDAT_FROM | Tax Rate Valid-From | ||||
| purchasinghierarchynode | RSNODEEXT | Hier.node | ||||
| hierarchyparentnode | RSNODEEXT | Hier.node | ||||
| hierarchylevel | abap.int4 | |||||
| hierarchynodesubtreesize | abap.int4 | |||||
| hierarchydrillstate | abap.char | |||||
| hierarchynodeordinalnumber | abap.int8 | |||||
| purchasingisitemset | MMPUR_IS_ITEMSET | Item Set | ||||
| purchasingitemisfreeofcharge | UMSON | Free of Charge | ||||
| itemdeliveryaddressid | ADRNR_MM | Address | ||||
| highestmessageseveritylevel | HGHSTMSGSVRTYLVL | Highest Message Severity Level | ||||
| poitmacctassgmtfieldsareenbld | POITMACCTASSGMTFIELDSAREENBLD | Acct Assignment Fields on Item Enabled | ||||
| stocksegment | SGT_SCAT | Stock Segment | ||||
| conditiontype | KSCHA | Condition Type | ||||
| purgdocnetamount | BPREI | Net Price | ||||
| conditionquantity | VDM_PRICE_UNIT | Price Unit | ||||
| conditionquantityunit | BBPRM | Order Price Un. | ||||
| ppsfieldchangeindicatorbinary | PPS_E_CONTROL_FLAG | Control | ||||
| incotermsversion | INCOV | Inco. Version | ||||
| draftentitycreationdatetime | SYCH_BDL_DRAFT_CREATED_AT | Created | ||||
| draftentitylastchangedatetime | SYCH_BDL_DRAFT_LAST_CHANGED_AT | Changed | ||||
| draftadministrativedatauuid | SYCH_BDL_DRAFT_ADMIN_UUID | UUID | ||||
| draftentityoperationcode | SYCH_BDL_DRAFT_OPERATION_CODE | Draft - Operation Code | ||||
| hasactiveentity | SYCH_BDL_DRAFT_HASACTIVE | Has active | ||||
| draftfieldchanges | SYCH_BDL_DRAFT_FIELD_CHANGES | Field Changes |
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.
-- Draft table for entity R_PPS_PURCHASEORDERITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PO_ITEM_D (
MANDT, -- Client [MANDT]
PURCHASEORDER, -- Purchase Order [VDM_PURCHASEORDER]
PURCHASEORDERITEM, -- Purchase Order Item [VDM_PURCHASEORDERITEM]
DRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
PARENTDRAFTUUID, -- Draft Document ID [SDRAFT_UUID]
PURCHASEORDERCATEGORY, -- Doc. Category [BSTYP]
DOCUMENTCURRENCY, -- Currency [WAERS]
PURCHASINGORGANIZATION, -- Purchasing Org. [EKORG]
PURCHASINGDOCUMENTDELETIONCODE, -- Del. Indicator [ELOEK]
ISDELETED, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
ISBLOCKED, -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
PURCHASINGDELIVERYADDRESSTYPE, -- Address Type [PURREQNADDRTYPE]
PPSPERDOFPERFSTARTDATE, -- PeROP Start Date [PPS_E_PEROP_START_DATE]
PPSPERDOFPERFENDDATE, -- PeROP End Date [PPS_E_PEROP_END_DATE]
PPSSMARTNUMBERITEM, -- Smart Number [PPS_E_SMT_SMART_NUMBER]
PPSSMARTNUMBERITEMISMANUAL, -- Checkbox [XFELD]
PPSCONFIGURABLELINEITEMNUMBER, -- Config. Itm. No. [PPS_E_CONFIG_ITEM_NO]
PPSDELIVERYTOLERANCEKEY, -- Tolerance Key [PPS_E_TOLERANCE_KEY]
PPSPURORDERITEMSTATUS, -- Item Status [PPS_E_ITEM_STATUS]
PPSPURORDERITEMSTATUSTEXT, -- Pur. Doc. Stat. Name [MMPUR_DOC_STATUS_NAME]
PPSPURORDITEMSTATUSCRITICALITY, -- abap.int1
PPSISOPTIONALITEM, -- TRUE [BOOLE_D]
PPSOPTIONALITEMSTATUS, -- Optional Item Status [PPS_E_OPT_ITEM_STATUS]
PPSOPTIONEXERCISESTARTDATE, -- Exe Start Date [PPS_E_OPT_EXEC_PER_START_DATE]
PPSOPTIONEXERCISEENDDATE, -- Execution End Date [PPS_E_OPT_EXEC_PER_END_DATE]
MATERIALGROUP, -- Material Group [MATKL]
MATERIALGROUPNAME, -- prod Grp Desc. [PRODUCTGROUPDESCRIPTION]
MATERIAL, -- Material [MATNR]
MATERIALTYPE, -- Material Type [MTART]
SUPPLIERMATERIALNUMBER, -- Supp. Mat. No. [IDNLF]
SUPPLIERSUBRANGE, -- Suppl. Subrange [LTSNR]
MANUFACTURERPARTNMBR, -- Mfr Part Number [MFRPN]
MANUFACTURER, -- Manufacturer [MFRNR]
MANUFACTURERMATERIAL, -- Material [EMATNR]
MATERIALNAME, -- Description [MAKTX]
PURCHASEORDERITEMTEXT, -- Short Text [TXZ01]
PRODUCTTYPECODE, -- Product Type Group [PRODUCT_TYPE]
COMPANYCODE, -- Company Code [BUKRS]
PPSSMARTNUMBERHEADER, -- Smart Number [PPS_E_SMT_SMART_NUMBER]
PLANT, -- Plant [EWERK]
PLANTNAME, -- Plant Name [WERKS_NAME]
LASTCHANGEDDATE, -- Changed On [ABP_LASTCHANGE_DATE]
MANUALDELIVERYADDRESSID, -- Address [ADRNR_MM]
ITEMCATEGORY, -- abap.char
REFERENCEDELIVERYADDRESSID, -- Address [ADRN2]
CUSTOMER, -- Customer [EKUNNR]
SUBCONTRACTOR, -- Supplier [EMLIF]
SUPPLIERISSUBCONTRACTOR, -- SC Supplier [LBLKZ]
CROSSPLANTCONFIGURABLEPRODUCT, -- Cross-plant CM [SATNR]
ARTICLECATEGORY, -- Matl Category [ATTYP]
PLNDORDERREPLNMTELMNTTYPE, -- Kanban Indicat. [KBNKZ]
PRODUCTPURCHASEPOINTSQTYUNIT, -- Points Unit [PUNEI]
PRODUCTPURCHASEPOINTSQTY, -- Points [ANZPU]
STORAGELOCATION, -- Storage Location [VDM_STORAGE_LOCATION]
PURCHASEORDERQUANTITYUNIT, -- Order Unit [BSTME]
ORDERITEMQTYTOBASEQTYNMRTR, -- Equal To [UMBSZ]
ORDERITEMQTYTOBASEQTYDNMNTR, -- Denominator [UMBSN]
NETPRICEQUANTITY, -- Price Unit [VDM_PRICE_UNIT]
ISCOMPLETELYDELIVERED, -- Deliv. Compl. [ELIKZ]
ISFINALLYINVOICED, -- Final Invoice [EREKZ]
GOODSRECEIPTISEXPECTED, -- Goods Receipt [WEPOS]
INVOICEISEXPECTED, -- Invoice Receipt [REPOS]
ISORDERACKNRQD, -- Acknowl. Reqd. [KZABS]
INVOICEISGOODSRECEIPTBASED, -- GR-Based IV [WEBRE]
PURCHASECONTRACTITEM, -- Agreement Item [KTPNR]
PURCHASECONTRACT, -- Agreement [KONNR]
PURCHASEREQUISITION, -- Purchase Req. [BANFN]
REQUIREMENTTRACKING, -- Tracking Number [BEDNR]
PURCHASEREQUISITIONITEM, -- Requisn. item [BNFPO]
SUPPLIERQUOTATION, -- RFQ [ANFNR]
SUPPLIERQUOTATIONITEM, -- Item [ANFPS]
EVALDRCPTSETTLMTISALLOWED, -- ERS [XERSY]
UNLIMITEDOVERDELIVERYISALLOWED, -- Unlimited [UEBTK]
OVERDELIVTOLRTDLMTRATIOINPCT, -- Overdeliv. Tol. [UEBTO]
UNDERDELIVTOLRTDLMTRATIOINPCT, -- Underdel. Tol. [UNTTO]
REQUISITIONERNAME, -- Requisitioner [AFNAM]
PLANNEDDELIVERYDURATIONINDAYS, -- Pl. Deliv. Time [EPLIF]
GOODSRECEIPTDURATIONINDAYS, -- GR proc. time [WEBAZ]
PARTIALDELIVERYISALLOWED, -- Part. Del./Item [KZTUL]
CONSUMPTIONPOSTING, -- Consumption [KZVBR]
SERVICEPERFORMER, -- Service Performer [SERVICEPERFORMER]
SERVICEPACKAGE, -- Package number [PACKNO]
BASEUNIT, -- Base Unit [LAGME]
PURCHASEORDERITEMCATEGORY, -- Item Category [PSTYP]
PROFITCENTER, -- Profit Center [PRCTR]
ORDERPRICEUNIT, -- Order Price Un. [BBPRM]
ITEMVOLUMEUNIT, -- Volume Unit [VOLEH]
ITEMWEIGHTUNIT, -- Unit of Weight [EGEWE]
MULTIPLEACCTASSGMTDISTRIBUTION, -- Distribution [VRTKZ]
PARTIALINVOICEDISTRIBUTION, -- Partial invoice [TWRKZ]
PRICINGDATECONTROL, -- Pr. Date Cat. [MEPRF]
ISSTATISTICALITEM, -- Statistical [STAPO]
PURCHASINGPARENTITEM, -- H-Lev. Item [UEBPO]
GOODSRECEIPTLATESTCREATIONDATE, -- Latest GR Date [LEWED]
ISRETURNSITEM, -- Returns Item [RETPO]
PURCHASINGORDERREASON, -- Reason for Ord. [BSGRU]
INCOTERMSCLASSIFICATION, -- Incoterms [INCO1]
INCOTERMSCLASSIFICATIONNAME, -- Incoterms Classification Description [INCOTERMS_CLASSIFICATION_NAME]
INCOTERMSTRANSFERLOCATION, -- Incoterms 2 [INCO2]
INCOTERMSLOCATION1, -- Inco. Location1 [INCO2_L]
INCOTERMSLOCATION2, -- Inco. Location2 [INCO3_L]
PRIORSUPPLIER, -- Prior Supplier [KOLIF]
INTERNATIONALARTICLENUMBER, -- EAN/UPC [EAN11]
INTRASTATSERVICECODE, -- Intrastat Srvc. Code [/SAPSLL/ISVCO]
COMMODITYCODE, -- Commodity Code [/SAPSLL/COMCO]
MATERIALFREIGHTGROUP, -- Mat.Freight Grp [MFRGR]
DISCOUNTINKINDELIGIBILITY, -- Disc. in kind [NRFHG]
PURGITEMISBLOCKEDFORDELIVERY, -- Shipping block [NOVET]
SUPPLIERCONFIRMATIONCONTROLKEY, -- Conf. Control [BSTAE]
PURGDOCORDERACKNNUMBER, -- Order Acknowl. [LABNR]
PRICEISTOBEPRINTED, -- Print Price [PRSDR]
ACCOUNTASSIGNMENTCATEGORY, -- Acct Assgmt Cat [KNTTP]
PURCHASINGINFORECORD, -- Info Record [INFNR]
INFORECORDISTOBEUPDATED, -- InfoUpdate [INFUP]
PURORDEXTERNALITEMCATEGORY, -- Item Category [EPSTP]
PURORDITEMCATEGORYNAME, -- Text for ItCat. [PTEXT_D]
NETAMOUNT, -- Net Value [BWERT]
GROSSAMOUNT, -- Gross value [BBWERT]
EFFECTIVEAMOUNT, -- Effective value [EFFWR]
SUBTOTAL1AMOUNT, -- Subtotal 1 [KZWI1]
SUBTOTAL2AMOUNT, -- Subtotal 2 [KZWI2]
SUBTOTAL3AMOUNT, -- Subtotal 3 [KZWI3]
SUBTOTAL4AMOUNT, -- Subtotal 4 [KZWI4]
SUBTOTAL5AMOUNT, -- Subtotal 5 [KZWI5]
SUBTOTAL6AMOUNT, -- Subtotal 6 [KZWI6]
ORDERQUANTITY, -- PO Quantity [BSTMG]
NETPRICEAMOUNT, -- Net Price [BPREI]
ITEMVOLUME, -- Volume [VOLUM]
ITEMGROSSWEIGHT, -- Gross Weight [BRGEW]
ITEMNETWEIGHT, -- Net Weight [ENTGE]
ORDERPRICEUNITTOORDERUNITNMRTR, -- Qty Conversion [BPUMZ]
ORDPRICEUNITTOORDERUNITDNMNTR, -- Qty Conversion [BPUMN]
GOODSRECEIPTISNONVALUATED, -- GR Non-Valuated [WEUNB]
PURCHASEORDERTYPE, -- Document Type [ESART]
TAXCALCULATIONPROCEDURE, -- Procedure [KALSM_D]
TAXCODE, -- Tax Code [MWSKZ]
TAXCODENAME, -- Tax Code Name [FIS_MWSKZ_NAME]
TAXJURISDICTION, -- Tax Jur. [TXJCD]
TAXCOUNTRY, -- Tax Ctry/Reg. [FOT_TAX_COUNTRY]
TAXDETERMINATIONDATE, -- Tax Date [TXDAT]
SHIPPINGINSTRUCTION, -- Shipping Instr. [EVERS]
NONDEDUCTIBLEINPUTTAXAMOUNT, -- Non-deductible [NAVNW]
STOCKTYPE, -- Stock Type [INSMK]
VALUATIONTYPE, -- Valuation Type [BWTAR_D]
VALUATIONCATEGORY, -- Valuation Cat. [BWTTY_D]
ITEMISREJECTEDBYSUPPLIER, -- Rejection Ind. [ABSKZ]
PURGDOCPRICEDATE, -- Price Date [PREDT]
PURCHASINGINFORECORDUPDATECODE, -- InfoUpdate [SPINF]
INVENTORYSPECIALSTOCKTYPE, -- Special Stock [SOBKZ]
DELIVERYDOCUMENTTYPE, -- Del. Type Rtns [LFRET]
ISSUINGSTORAGELOCATION, -- Iss. Stor. Loc. [RESLO]
ALLOCATIONTABLE, -- Alloc. Table [ABELN]
ALLOCATIONTABLEITEM, -- Item [ABELP]
RETAILPROMOTION, -- Promotion [WAKTION]
PURGCONFIGURABLEITEMNUMBER, -- Hierarchy Number [EXLIN]
PURGDOCAGGRGDSUBITEMCATEGORY, -- Sub-items [UPVOR]
PURGDOCSUBITEMCATEGORY, -- Subitem Cat. [UPTYP]
PURGEXTERNALSORTNUMBER, -- External Sort No. [EXSNR]
DOWNPAYMENTTYPE, -- Down Payment [ME_DPTYP]
DOWNPAYMENTPERCENTAGEOFTOTAMT, -- Down Payment % [ME_DPPCNT]
DOWNPAYMENTAMOUNT, -- Down Payment Amt [ME_DPAMNT]
DOWNPAYMENTDUEDATE, -- Due Date for DP [ME_DPDDAT]
EXPECTEDOVERALLLIMITAMOUNT, -- Expected Value [COMMITMENT]
OVERALLLIMITAMOUNT, -- Overall Limit [SUMLIMIT]
PURCONTRACTFOROVERALLLIMIT, -- Contract For Limit [CTR_FOR_LIMIT]
PURGPRODCMPLNCSUPPLIERSTATUS, -- Supplier Check Sts [MMPUR_PC_STATUS_PCS]
PURGPRODUCTMARKETABILITYSTATUS, -- Prod. Marktablty Sts [MMPUR_PC_STATUS_PMA]
PURGSAFETYDATASHEETSTATUS, -- Sfty Data Sheet Sts [MMPUR_PC_STATUS_SDS]
PURGPRODCMPLNCDNGRSGOODSSTATUS, -- Dangerous Goods Sts [MMPUR_PC_STATUS_DG]
REQUIREMENTSEGMENT, -- Req. Segment [SGT_RCAT]
BATCH, -- Batch [CHARG_D]
BATCHBYSUPPLIER, -- Supplier Batch [LICHN]
FUND, -- Fund [BP_GEBER]
BUDGETPERIOD, -- Budget Period [FM_BUDGET_PERIOD]
FUNDSCENTER, -- Funds Center [FISTL]
COMMITMENTITEM, -- Commitment item [FIPOS]
COMMITMENTITEMSHORTID, -- Commitment Item Short ID [FMIS_CI_INTERNALNAME]
FUNCTIONALAREA, -- Functional Area [FKBER]
GRANTID, -- Grant [GM_GRANT_NBR]
EARMARKEDFUNDSDOCUMENT, -- Earmarked Funds [KBLNR]
EARMARKEDFUNDSDOCUMENTITEM, -- Document Item [KBLPOS]
COSTCENTER, -- Cost Center [KOSTL]
GLACCOUNT, -- G/L Account [SAKNR]
WBSELEMENTINTERNALID, -- WBS Internal ID [PS_S4_PSPNR]
WBSELEMENTEXTERNALID, -- WBS Element [PS_POSID_EDIT]
WBSDESCRIPTION, -- WBS Element Name [PS_S4_POST1]
BR_MATERIALORIGIN, -- Material Origin [J_1BMATORG]
BR_MATERIALUSAGE, -- Material Usage [J_1BMATUSE]
BR_CFOPCATEGORY, -- Mat. category [J_1BINDUS3]
BR_NCM, -- NCM Code [J_1BNBMCO1]
CONSUMPTIONTAXCTRLCODE, -- HSN/SAC Code [J_1IG_HSN_SAC]
BR_ISPRODUCEDINHOUSE, -- Prod. in-house [J_1BOWNPRO]
PRODUCTSEASONYEAR, -- Season Year [FSH_SAISJ]
PRODUCTSEASON, -- Season [FSH_SAISO]
PRODUCTCOLLECTION, -- Collection [FSH_COLLECTION]
PRODUCTTHEME, -- Theme [FSH_THEME]
SEASONCOMPLETENESSSTATUS, -- Season Comp.Ind [RFM_SCC_INDICATOR]
SHIPPINGGROUPRULE, -- PSST Grouping Rule [RFM_PSST_RULE]
SHIPPINGGROUPNUMBER, -- PSST Group [RFM_PSST_GROUP_ID]
PRODUCTCHARACTERISTIC1, -- Characteristic 1 [WRF_CHARSTC1]
PRODUCTCHARACTERISTIC2, -- Characteristic 2 [WRF_CHARSTC2]
PRODUCTCHARACTERISTIC3, -- Characteristic 3 [WRF_CHARSTC3]
DIVERSIONSTATUS, -- Diversion Status [RFM_DIVERSION_STATUS]
REFDOCNMBRFORTRCBLYINPO, -- Reference Document [RFM_REF_DOC]
REFERENCEDOCUMENTITEM, -- Reference Item [RFM_REF_ITEM]
PURCHASEORDERREFERENCETYPE, -- Reference Action [RFM_REF_ACTION]
ITEMHASVALUEADDEDSERVICE, -- VAS Relevant [FSH_VAS_REL]
VALADDEDSRVCPARENTITMNUMBER, -- Item [EBELP]
IN_GSTCONTROLCODE, -- HSN/SAC Code [J_1IG_HSN_SAC]
PURCHASEORDERITEMUNIQUEID, -- Document Item [PURCHASINGDOCUMENTITEMUNIQUEID]
PRODUCTTYPENAME, -- Description [PRODUCT_TYPE_DESCRIPTION]
PRICECHANGEINSESISALLOWED, -- Allow Price Change [PRC_CHG_IN_SES_ALLOWED]
REQUESTFORQUOTATION, -- RFQ [RFQ_ID]
REQUESTFORQUOTATIONITEM, -- Item Number for RFQ [RFQ_ITEM]
INCOTERMSLOCATION1IDENTIFIER, -- Incoterm Loc. 1 ID [TMINCO_LOC_1_ID]
INCOTERMSLOCATION2IDENTIFIER, -- Incoterm Loc. 2 ID [TMINCO_LOC_2_ID]
INCOTERMSDVTGLOCIDENTIFIER, -- Deviating Loc. ID [TMINCO_LOC_D_ID]
INCOTERMSDVTGLOCDESCRIPTION, -- Deviating Loc. Desc. [TMINCO_LOC_D_DESCR]
INCOTERMSSUPCHNLOC1ADDLUUID, -- Incoterm Location 1 [/SCMTMS/INC_LOC_1_KEY_NC]
INCOTERMSSUPCHNLOC2ADDLUUID, -- Incoterm Location 2 [/SCMTMS/INC_LOC_2_KEY_NC]
INCOTERMSSUPCHNDVTGLOCADDLUUID, -- Dev. Destination [/SCMTMS/INC_DV_PLCE_DST_KEY_NC]
TAXCODEVALIDFROMDATE, -- Tax Rate Valid-From [FOT_TXDAT_FROM]
PURCHASINGHIERARCHYNODE, -- Hier.node [RSNODEEXT]
HIERARCHYPARENTNODE, -- Hier.node [RSNODEEXT]
HIERARCHYLEVEL, -- abap.int4
HIERARCHYNODESUBTREESIZE, -- abap.int4
HIERARCHYDRILLSTATE, -- abap.char
HIERARCHYNODEORDINALNUMBER, -- abap.int8
PURCHASINGISITEMSET, -- Item Set [MMPUR_IS_ITEMSET]
PURCHASINGITEMISFREEOFCHARGE, -- Free of Charge [UMSON]
ITEMDELIVERYADDRESSID, -- Address [ADRNR_MM]
HIGHESTMESSAGESEVERITYLEVEL, -- Highest Message Severity Level [HGHSTMSGSVRTYLVL]
POITMACCTASSGMTFIELDSAREENBLD, -- Acct Assignment Fields on Item Enabled [POITMACCTASSGMTFIELDSAREENBLD]
STOCKSEGMENT, -- Stock Segment [SGT_SCAT]
CONDITIONTYPE, -- Condition Type [KSCHA]
PURGDOCNETAMOUNT, -- Net Price [BPREI]
CONDITIONQUANTITY, -- Price Unit [VDM_PRICE_UNIT]
CONDITIONQUANTITYUNIT, -- Order Price Un. [BBPRM]
PPSFIELDCHANGEINDICATORBINARY, -- Control [PPS_E_CONTROL_FLAG]
INCOTERMSVERSION, -- Inco. Version [INCOV]
DRAFTENTITYCREATIONDATETIME, -- Created [SYCH_BDL_DRAFT_CREATED_AT]
DRAFTENTITYLASTCHANGEDATETIME, -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
DRAFTADMINISTRATIVEDATAUUID, -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
DRAFTENTITYOPERATIONCODE, -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
HASACTIVEENTITY, -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
DRAFTFIELDCHANGES, -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, DRAFTUUID)
);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