PURCHASECTRITM_D

Transparent Table Temporary Data
61 Fields 1 CDS Views

Generated draft table for core CDS view: I_PurchaseContractI

PURCHASECTRITM_D is an SAP database table in S/4HANA. Generated draft table for core CDS view: I_PurchaseContractI. It contains 61 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_PurchaseContractItemDraft view from EXTENSION Extension for Purchase Contract Item Draft

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purchasecontractitemdraftuuid /bobf/uuid Key
activepurchasecontract ebeln Purchasing Doc.
activepurchasecontractitem ebelp Item
material matnr Material
purchasecontractitemtext txz01 Short Text
contractnetpriceamount bprei Net Price
orderpriceunit bbprm Order Price Un.
volumeunit voleh Volume Unit
orderquantityunit bstme Order Unit
materialgroup matkl Material Group
customer ekunnr Customer
subcontractor emlif Supplier
referencedeliveryaddressid adrn2 Address
manualdeliveryaddressid adrnr_mm Address
deliveryaddressid contactcardaddress Address
plant ewerk Plant
storagelocation mm_oa_storage_location Storage Location
accountassignmentcategory knttp Acct Assgmt Cat
goodsreceiptisexpected wepos Goods Receipt
netpricequantity mm_oa_price_unit Price Unit
multipleacctassgmtdistribution vrtkz Distribution
targetquantity ktmng Target Quantity
targetamount dzwert Target Value
documentcurrency waers Currency
ordpriceunittoorderunitdnmntr bpumn Qty Conversion
orderpriceunittoorderunitnmrtr bpumz Qty Conversion
purchasingdocumentitemcategory pstyp Item Category
suppliermaterialnumber idnlf Supp. Mat. No.
evaldrcptsettlmtisallowed xersy ERS
underdelivtolrtdlmtratioinpct untto Underdel. Tol.
priceistobeprinted prsdr Print Price
confirmationcontrol bstae Conf. Control
overdelivtolrtdlmtratioinpct uebto Overdeliv. Tol.
unlimitedoverdeliveryisallowed uebtk Unlimited
invoiceisexpected repos Invoice Receipt
invoiceisgoodsreceiptbased webre GR-Based IV
purgdocpricedate predt Price Date
isinforecordupdated spinf InfoUpdate
purgdocreleaseorderquantity noram Rel. order qty.
purgdocorderacknnumber labnr Order Acknowl.
purgdocestimatedprice schpr Estimated Price
isinfoatregistration borgr_miss Info at Reg.
nodaysreminder1 mahn1 1st Rem./Exped.
nodaysreminder2 mahn2 2nd Rem./Exped.
nodaysreminder3 mahn3 3rd Rem./Exped.
stocktype insmk Stock Type
taxcode mwskz Tax Code
requirementtracking bednr Tracking Number
isorderacknrqd kzabs Acknowl. Reqd.
shippinginstruction evers Shipping Instr.
goodsreceiptisnonvaluated weunb GR Non-Valuated
purchasecontractitem ebelp Item
purchasecontractdraftuuid /bobf/uuid Key
hasactiveentity sdraft_has_active Has active
serviceperformer serviceperformer Service Performer
producttype product_type Product Type Group
materialtype mtart Material Type
formattedpurchasecontractitem char15 Char15
purchaserequisition banfn Purchase Req.
purchaserequisitionitem bnfpo Requisn. item

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.

-- Generated draft table for core CDS view: I_PurchaseContractI
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURCHASECTRITM_D (
    MANDT,                           -- Client [mandt]
    PURCHASECONTRACTITEMDRAFTUUID,   -- Key [/bobf/uuid]
    ACTIVEPURCHASECONTRACT,          -- Purchasing Doc. [ebeln]
    ACTIVEPURCHASECONTRACTITEM,      -- Item [ebelp]
    MATERIAL,                        -- Material [matnr]
    PURCHASECONTRACTITEMTEXT,        -- Short Text [txz01]
    CONTRACTNETPRICEAMOUNT,          -- Net Price [bprei]
    ORDERPRICEUNIT,                  -- Order Price Un. [bbprm]
    VOLUMEUNIT,                      -- Volume Unit [voleh]
    ORDERQUANTITYUNIT,               -- Order Unit [bstme]
    MATERIALGROUP,                   -- Material Group [matkl]
    CUSTOMER,                        -- Customer [ekunnr]
    SUBCONTRACTOR,                   -- Supplier [emlif]
    REFERENCEDELIVERYADDRESSID,      -- Address [adrn2]
    MANUALDELIVERYADDRESSID,         -- Address [adrnr_mm]
    DELIVERYADDRESSID,               -- Address [contactcardaddress]
    PLANT,                           -- Plant [ewerk]
    STORAGELOCATION,                 -- Storage Location [mm_oa_storage_location]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [knttp]
    GOODSRECEIPTISEXPECTED,          -- Goods Receipt [wepos]
    NETPRICEQUANTITY,                -- Price Unit [mm_oa_price_unit]
    MULTIPLEACCTASSGMTDISTRIBUTION,  -- Distribution [vrtkz]
    TARGETQUANTITY,                  -- Target Quantity [ktmng]
    TARGETAMOUNT,                    -- Target Value [dzwert]
    DOCUMENTCURRENCY,                -- Currency [waers]
    ORDPRICEUNITTOORDERUNITDNMNTR,   -- Qty Conversion [bpumn]
    ORDERPRICEUNITTOORDERUNITNMRTR,  -- Qty Conversion [bpumz]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [pstyp]
    SUPPLIERMATERIALNUMBER,          -- Supp. Mat. No. [idnlf]
    EVALDRCPTSETTLMTISALLOWED,       -- ERS [xersy]
    UNDERDELIVTOLRTDLMTRATIOINPCT,   -- Underdel. Tol. [untto]
    PRICEISTOBEPRINTED,              -- Print Price [prsdr]
    CONFIRMATIONCONTROL,             -- Conf. Control [bstae]
    OVERDELIVTOLRTDLMTRATIOINPCT,    -- Overdeliv. Tol. [uebto]
    UNLIMITEDOVERDELIVERYISALLOWED,  -- Unlimited [uebtk]
    INVOICEISEXPECTED,               -- Invoice Receipt [repos]
    INVOICEISGOODSRECEIPTBASED,      -- GR-Based IV [webre]
    PURGDOCPRICEDATE,                -- Price Date [predt]
    ISINFORECORDUPDATED,             -- InfoUpdate [spinf]
    PURGDOCRELEASEORDERQUANTITY,     -- Rel. order qty. [noram]
    PURGDOCORDERACKNNUMBER,          -- Order Acknowl. [labnr]
    PURGDOCESTIMATEDPRICE,           -- Estimated Price [schpr]
    ISINFOATREGISTRATION,            -- Info at Reg. [borgr_miss]
    NODAYSREMINDER1,                 -- 1st Rem./Exped. [mahn1]
    NODAYSREMINDER2,                 -- 2nd Rem./Exped. [mahn2]
    NODAYSREMINDER3,                 -- 3rd Rem./Exped. [mahn3]
    STOCKTYPE,                       -- Stock Type [insmk]
    TAXCODE,                         -- Tax Code [mwskz]
    REQUIREMENTTRACKING,             -- Tracking Number [bednr]
    ISORDERACKNRQD,                  -- Acknowl. Reqd. [kzabs]
    SHIPPINGINSTRUCTION,             -- Shipping Instr. [evers]
    GOODSRECEIPTISNONVALUATED,       -- GR Non-Valuated [weunb]
    PURCHASECONTRACTITEM,            -- Item [ebelp]
    PURCHASECONTRACTDRAFTUUID,       -- Key [/bobf/uuid]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    SERVICEPERFORMER,                -- Service Performer [serviceperformer]
    PRODUCTTYPE,                     -- Product Type Group [product_type]
    MATERIALTYPE,                    -- Material Type [mtart]
    FORMATTEDPURCHASECONTRACTITEM,   -- Char15 [char15]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    PRIMARY KEY (MANDT, PURCHASECONTRACTITEMDRAFTUUID)
);

Learn More