DRAFT_PR_ITEM

Transparent Table Application Table
52 Fields 1 CDS Views

SSP Requisition Item

DRAFT_PR_ITEM is an SAP database table in S/4HANA. SSP Requisition Item. It contains 52 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Purchaserequisitionitemdraft view from EXTENSION Purchase Requisition Item Draft Extensibility View

Fields (52)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purreqnitemdraftuuid sysuuid_x UUID
purreqndraftuuid sysuuid_x UUID
purchaserequisition banfn Purchase Req.
purchaserequisitionitem bnfpo Requisn. item
purchaserequisitionitemtext txz01 Short Text
material matnr Material
ctlg_item_key int4 INT4
materialgroup matkl Material Group
requestedquantity menge_d Quantity
baseunit meins Base Unit
purchaserequisitionprice preis Price
deliverydate lfdat Delivery date
supplierproduct char30 30 Characters
purchasinggroup ekgrp Purch. Group
companycode bukrs Company Code
goodsrecipient char30 30 Characters
plant werks_d Plant
internalnote char100 Character 100
notetosupplier char100 Character 100
fullname adfullname Full Name
formofaddress ad_title Title Key
faxnumber ad_fxnmbr1 Fax
supplier lifnr Supplier
purchasinginforecord infnr Info Record
purchasecontract konnr Agreement
purchasecontractitem ktpnr Agreement Item
hasactiveentity sdraft_has_active Has active
purchasingdocumentitemcategory pstyp Item Category
manualdeliveryaddressid adrnr Address
purchasingorganization ekorg Purchasing Org.
addresscityname ad_city1 City
addresscountry land1 Country/Reg.
fixedsupplier flief Fixed Vendor
addresshousenumber ad_hsnm1 House Number
careofname ad_name_co c/o
addresspostalcode ad_pstcd1 Postal Code
addressregion regio Region
addressstreetname ad_street Street
phonenumber1 ad_tlnmbr1 Telephone
accountassignmentcategory knttp Acct Assgmt Cat
currency waers Currency
netpricequantity epein Price Unit
purreqnsspcatalog bbp_ws_service_id Web Service ID
purreqnsspcatalogitem mmpur_req_d_catitem Catalog Item
purreqnsspcrosscatalogitem mmpur_cat_itm_key Catalog item key
multipleacctassgmtdistribution vrtkz Distribution
producttype pr_product_type Product Type Group
serviceperformer pr_serviceperformer Service Performer
performanceperiodstartdate mmpur_servproc_period_start Start Date
performanceperiodenddate mmpur_servproc_period_end End Date
emailaddress ad_smtpadr E-Mail Address

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.

-- SSP Requisition Item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRAFT_PR_ITEM (
    MANDT,                           -- Client [mandt]
    PURREQNITEMDRAFTUUID,            -- UUID [sysuuid_x]
    PURREQNDRAFTUUID,                -- UUID [sysuuid_x]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    PURCHASEREQUISITIONITEMTEXT,     -- Short Text [txz01]
    MATERIAL,                        -- Material [matnr]
    CTLG_ITEM_KEY,                   -- INT4 [int4]
    MATERIALGROUP,                   -- Material Group [matkl]
    REQUESTEDQUANTITY,               -- Quantity [menge_d]
    BASEUNIT,                        -- Base Unit [meins]
    PURCHASEREQUISITIONPRICE,        -- Price [preis]
    DELIVERYDATE,                    -- Delivery date [lfdat]
    SUPPLIERPRODUCT,                 -- 30 Characters [char30]
    PURCHASINGGROUP,                 -- Purch. Group [ekgrp]
    COMPANYCODE,                     -- Company Code [bukrs]
    GOODSRECIPIENT,                  -- 30 Characters [char30]
    PLANT,                           -- Plant [werks_d]
    INTERNALNOTE,                    -- Character 100 [char100]
    NOTETOSUPPLIER,                  -- Character 100 [char100]
    FULLNAME,                        -- Full Name [adfullname]
    FORMOFADDRESS,                   -- Title Key [ad_title]
    FAXNUMBER,                       -- Fax [ad_fxnmbr1]
    SUPPLIER,                        -- Supplier [lifnr]
    PURCHASINGINFORECORD,            -- Info Record [infnr]
    PURCHASECONTRACT,                -- Agreement [konnr]
    PURCHASECONTRACTITEM,            -- Agreement Item [ktpnr]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [pstyp]
    MANUALDELIVERYADDRESSID,         -- Address [adrnr]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    ADDRESSCITYNAME,                 -- City [ad_city1]
    ADDRESSCOUNTRY,                  -- Country/Reg. [land1]
    FIXEDSUPPLIER,                   -- Fixed Vendor [flief]
    ADDRESSHOUSENUMBER,              -- House Number [ad_hsnm1]
    CAREOFNAME,                      -- c/o [ad_name_co]
    ADDRESSPOSTALCODE,               -- Postal Code [ad_pstcd1]
    ADDRESSREGION,                   -- Region [regio]
    ADDRESSSTREETNAME,               -- Street [ad_street]
    PHONENUMBER1,                    -- Telephone [ad_tlnmbr1]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [knttp]
    CURRENCY,                        -- Currency [waers]
    NETPRICEQUANTITY,                -- Price Unit [epein]
    PURREQNSSPCATALOG,               -- Web Service ID [bbp_ws_service_id]
    PURREQNSSPCATALOGITEM,           -- Catalog Item [mmpur_req_d_catitem]
    PURREQNSSPCROSSCATALOGITEM,      -- Catalog item key [mmpur_cat_itm_key]
    MULTIPLEACCTASSGMTDISTRIBUTION,  -- Distribution [vrtkz]
    PRODUCTTYPE,                     -- Product Type Group [pr_product_type]
    SERVICEPERFORMER,                -- Service Performer [pr_serviceperformer]
    PERFORMANCEPERIODSTARTDATE,      -- Start Date [mmpur_servproc_period_start]
    PERFORMANCEPERIODENDDATE,        -- End Date [mmpur_servproc_period_end]
    EMAILADDRESS,                    -- E-Mail Address [ad_smtpadr]
    PRIMARY KEY (MANDT, PURREQNITEMDRAFTUUID)
);

Learn More