PURREQNITM_D

Transparent Table Application Table
123 Fields 1 CDS Views

T_PURCHASEREQN T_PURCHASEREQNITEM

PURREQNITM_D is an SAP database table in S/4HANA. T_PURCHASEREQN T_PURCHASEREQNITEM. It contains 123 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PurReqnItmHierNodeRltnDrft view from BASIC

Fields (123)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY draftuuid /bobf/uuid Key
parentdraftuuid /bobf/uuid Key
purchaserequisition vdm_purchaserequisition Purch.Reqn.
purchaserequisitionitem vdm_purchaserequisitionitem Requisn. item
purchaserequisitionitemforedit vdm_purchaserequisitionitem Requisn. item
purchasingdocument bstnr Purchase order
purchasingdocumentitem bstpo Item
purreqnreleasestatus banpr Proc.state
purchaserequisitiontype bbsrt Document Type
purchasingdocumentitemcategory pstyp Item Category
purchaserequisitionitemtext txz01 Short Text
accountassignmentcategory knttp Acct Assgmt Cat
material matnr Material
manufacturermaterial ematn MPN: Material
manufacturerpartprofile mprof Mfr Part Profile
manufacturerpartnmbr mfrpn Mfr Part Number
materialgroup matkl Material Group
purchasingdocumentcategory bstyp Doc. Category
requestedquantity bamng Quantity
baseunit bamei Unit of Measure
purchaserequisitionprice bapre Valuation Price
purreqnpricequantity epein Price Unit
materialgoodsreceiptduration webaz GR proc. time
releasecode frgkz Release ind.
purchaserequisitionreleasedate frgdt Release Date
purchasingorganization ekorg Purchasing Org.
purchasinggroup ekgrp Purch. Group
plant ewerk Plant
sourceofsupplyisassigned dzugba Assigned
supplyingplant reswk Supplying Plant
orderedquantity bsmng Order quantity
purreqnlimitconsumptionamt mmpur_req_lmt_cnsmpn_value Consumption Value
deliverydate eindt Delivery Date
creationdate badat Requisn Date
processingstatus banst Processing stat
purchasinginforecord infnr Info Record
supplier wlief Desired Vendor
isdeleted eloek Del. Indicator
fixedsupplier flief Fixed Vendor
requisitionername afnam Requisitioner
purreqnssprequestor mmpur_req_d_requestor Requestor
createdbyuser ernam Created By
purreqcreationdate badat Requisn Date
manualdeliveryaddressid adrnr_mm Address
itemdeliveryaddressid adrn2 Address
deliveryaddressid adrnr Address
purreqnitemcurrency waers Currency
materialplanneddeliverydurn plifz Pl. Deliv. Time
delivdatecategory lpein Delivery Date
multipleacctassgmtdistribution vrtkz Distribution
partialinvoicedistribution twrkz Partial invoice
storagelocation lgort_d Location
purchasecontract konnr Agreement
purreqnsourceofsupplytype bstyp Doc. Category
purchasecontractitem ktpnr Agreement Item
consumptionposting kzvbr Consumption
purreqnorigin estkz Creation ind.
ispurreqnblocked blckd Blocking Ind.
language spras Language
isclosed ebakz Closed
releaseisnotcompleted frgrl Subj.to Release
serviceperformer serviceperformer Service Performer
producttype product_type Product Type Group
purchaserequisitionstatus frgzu Release State
releasestrategy frgst Rel. strategy
performanceperiodstartdate mmpur_servproc_period_start Start Date
performanceperiodenddate mmpur_servproc_period_end End Date
suppliermaterialnumber idnlf Supp. Mat. No.
batch charg_d Batch
materialrevisionlevel revlv Revision Level
minremainingshelflife mhdrz Rem. Shelf Life
goodsreceiptisexpected wepos Goods Receipt
invoiceisexpected repos Invoice Receipt
goodsreceiptisnonvaluated weunb GR Non-Valuated
requirementtracking bednr Tracking Number
mrpcontroller dispo MRP Controller
taxcode mwskz Tax Code
purchaserequisitionisfixed bafix "Fixed" ind.
purchasingdocumentsubtype bsakz Control
pfmtransdatafootprintuuid pfmtransdatafootprintuuid Transaction Data Footprint
purreqncatalog bbp_ws_service_id Web Service ID
purreqncatalogitem mmpur_req_d_catalogitem Catalog Item
purreqncrosscatalogitem mmpur_cat_d_itm_key Catalog Item Key
userdescription vdm_userdescription Description
expectedoveralllimitamount commitment Expected Value
overalllimitamount sumlimit Overall Limit
purcontractforoveralllimit ctr_for_limit Contract For Limit
purcontractitemforoveralllimit ctr_item_for_limit PurCon Itm for Limit
purchasereqnitemuniqueid mm_pur_pr_item_key PR Item
purchaseorderpricetype bpueb PO price
ispurreqnovrlrel gsfrg Overall req. rel.
itemnetamount abap.curr
externalapprovalstatus mmpur_req_extapprvlsts Ext Prcsng. Status
commitmentitem fipos Commitment item
fundscenter fistl Funds Center
fund bp_geber Fund
grantid gm_grant_nbr Grant
functionalarea fkber Functional Area
earmarkedfundsdocument kblnr Earmarked Funds
earmarkedfundsdocumentitem kblpos Document Item
budgetperiod fm_budget_period Budget Period
costcenter kostl Cost Center
glaccount saknr G/L Account
wbselement ps_psp_pnr WBS Element
fundedprogram abap.char
fundmgmtisactive abap_boolean Truth Value
purreqnreworkcommenttext mmpur_note_text Note Text
purreqnrejectioniscancelled abap_boolean Truth Value
purreqnisapplicableforrework mmpur_req_d_pr_rework_ind PR Rework Indicator
purreqnispfmfootprintvisible xfeld Checkbox
isoutline mmpur_req_is_outline Is Outline
purchasingparentitem mmpur_req_parent_item_no Parent Item No
purreqnitemoutlinetype mmpur_req_outline_type Outline Type
purgconfigurableitemnumber exlin Hierarchy Number
purgexternalsortnumber exsnr External Sort No.
hierarchynode rsnodeext Hier.node
hierarchyparentnode rsnodeext Hier.node
hierarchylevel abap.int4
hierarchynodesubtreesize abap.int4
hierarchydrillstate abap.char
hierarchynodeordinalnumber abap.int8
hasactiveentity sdraft_has_active Has active

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.

-- T_PURCHASEREQN T_PURCHASEREQNITEM
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PURREQNITM_D (
    MANDT,                           -- Client [mandt]
    DRAFTUUID,                       -- Key [/bobf/uuid]
    PARENTDRAFTUUID,                 -- Key [/bobf/uuid]
    PURCHASEREQUISITION,             -- Purch.Reqn. [vdm_purchaserequisition]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [vdm_purchaserequisitionitem]
    PURCHASEREQUISITIONITEMFOREDIT,  -- Requisn. item [vdm_purchaserequisitionitem]
    PURCHASINGDOCUMENT,              -- Purchase order [bstnr]
    PURCHASINGDOCUMENTITEM,          -- Item [bstpo]
    PURREQNRELEASESTATUS,            -- Proc.state [banpr]
    PURCHASEREQUISITIONTYPE,         -- Document Type [bbsrt]
    PURCHASINGDOCUMENTITEMCATEGORY,  -- Item Category [pstyp]
    PURCHASEREQUISITIONITEMTEXT,     -- Short Text [txz01]
    ACCOUNTASSIGNMENTCATEGORY,       -- Acct Assgmt Cat [knttp]
    MATERIAL,                        -- Material [matnr]
    MANUFACTURERMATERIAL,            -- MPN: Material [ematn]
    MANUFACTURERPARTPROFILE,         -- Mfr Part Profile [mprof]
    MANUFACTURERPARTNMBR,            -- Mfr Part Number [mfrpn]
    MATERIALGROUP,                   -- Material Group [matkl]
    PURCHASINGDOCUMENTCATEGORY,      -- Doc. Category [bstyp]
    REQUESTEDQUANTITY,               -- Quantity [bamng]
    BASEUNIT,                        -- Unit of Measure [bamei]
    PURCHASEREQUISITIONPRICE,        -- Valuation Price [bapre]
    PURREQNPRICEQUANTITY,            -- Price Unit [epein]
    MATERIALGOODSRECEIPTDURATION,    -- GR proc. time [webaz]
    RELEASECODE,                     -- Release ind. [frgkz]
    PURCHASEREQUISITIONRELEASEDATE,  -- Release Date [frgdt]
    PURCHASINGORGANIZATION,          -- Purchasing Org. [ekorg]
    PURCHASINGGROUP,                 -- Purch. Group [ekgrp]
    PLANT,                           -- Plant [ewerk]
    SOURCEOFSUPPLYISASSIGNED,        -- Assigned [dzugba]
    SUPPLYINGPLANT,                  -- Supplying Plant [reswk]
    ORDEREDQUANTITY,                 -- Order quantity [bsmng]
    PURREQNLIMITCONSUMPTIONAMT,      -- Consumption Value [mmpur_req_lmt_cnsmpn_value]
    DELIVERYDATE,                    -- Delivery Date [eindt]
    CREATIONDATE,                    -- Requisn Date [badat]
    PROCESSINGSTATUS,                -- Processing stat [banst]
    PURCHASINGINFORECORD,            -- Info Record [infnr]
    SUPPLIER,                        -- Desired Vendor [wlief]
    ISDELETED,                       -- Del. Indicator [eloek]
    FIXEDSUPPLIER,                   -- Fixed Vendor [flief]
    REQUISITIONERNAME,               -- Requisitioner [afnam]
    PURREQNSSPREQUESTOR,             -- Requestor [mmpur_req_d_requestor]
    CREATEDBYUSER,                   -- Created By [ernam]
    PURREQCREATIONDATE,              -- Requisn Date [badat]
    MANUALDELIVERYADDRESSID,         -- Address [adrnr_mm]
    ITEMDELIVERYADDRESSID,           -- Address [adrn2]
    DELIVERYADDRESSID,               -- Address [adrnr]
    PURREQNITEMCURRENCY,             -- Currency [waers]
    MATERIALPLANNEDDELIVERYDURN,     -- Pl. Deliv. Time [plifz]
    DELIVDATECATEGORY,               -- Delivery Date [lpein]
    MULTIPLEACCTASSGMTDISTRIBUTION,  -- Distribution [vrtkz]
    PARTIALINVOICEDISTRIBUTION,      -- Partial invoice [twrkz]
    STORAGELOCATION,                 -- Location [lgort_d]
    PURCHASECONTRACT,                -- Agreement [konnr]
    PURREQNSOURCEOFSUPPLYTYPE,       -- Doc. Category [bstyp]
    PURCHASECONTRACTITEM,            -- Agreement Item [ktpnr]
    CONSUMPTIONPOSTING,              -- Consumption [kzvbr]
    PURREQNORIGIN,                   -- Creation ind. [estkz]
    ISPURREQNBLOCKED,                -- Blocking Ind. [blckd]
    LANGUAGE,                        -- Language [spras]
    ISCLOSED,                        -- Closed [ebakz]
    RELEASEISNOTCOMPLETED,           -- Subj.to Release [frgrl]
    SERVICEPERFORMER,                -- Service Performer [serviceperformer]
    PRODUCTTYPE,                     -- Product Type Group [product_type]
    PURCHASEREQUISITIONSTATUS,       -- Release State [frgzu]
    RELEASESTRATEGY,                 -- Rel. strategy [frgst]
    PERFORMANCEPERIODSTARTDATE,      -- Start Date [mmpur_servproc_period_start]
    PERFORMANCEPERIODENDDATE,        -- End Date [mmpur_servproc_period_end]
    SUPPLIERMATERIALNUMBER,          -- Supp. Mat. No. [idnlf]
    BATCH,                           -- Batch [charg_d]
    MATERIALREVISIONLEVEL,           -- Revision Level [revlv]
    MINREMAININGSHELFLIFE,           -- Rem. Shelf Life [mhdrz]
    GOODSRECEIPTISEXPECTED,          -- Goods Receipt [wepos]
    INVOICEISEXPECTED,               -- Invoice Receipt [repos]
    GOODSRECEIPTISNONVALUATED,       -- GR Non-Valuated [weunb]
    REQUIREMENTTRACKING,             -- Tracking Number [bednr]
    MRPCONTROLLER,                   -- MRP Controller [dispo]
    TAXCODE,                         -- Tax Code [mwskz]
    PURCHASEREQUISITIONISFIXED,      -- "Fixed" ind. [bafix]
    PURCHASINGDOCUMENTSUBTYPE,       -- Control [bsakz]
    PFMTRANSDATAFOOTPRINTUUID,       -- Transaction Data Footprint [pfmtransdatafootprintuuid]
    PURREQNCATALOG,                  -- Web Service ID [bbp_ws_service_id]
    PURREQNCATALOGITEM,              -- Catalog Item [mmpur_req_d_catalogitem]
    PURREQNCROSSCATALOGITEM,         -- Catalog Item Key [mmpur_cat_d_itm_key]
    USERDESCRIPTION,                 -- Description [vdm_userdescription]
    EXPECTEDOVERALLLIMITAMOUNT,      -- Expected Value [commitment]
    OVERALLLIMITAMOUNT,              -- Overall Limit [sumlimit]
    PURCONTRACTFOROVERALLLIMIT,      -- Contract For Limit [ctr_for_limit]
    PURCONTRACTITEMFOROVERALLLIMIT,  -- PurCon Itm for Limit [ctr_item_for_limit]
    PURCHASEREQNITEMUNIQUEID,        -- PR Item [mm_pur_pr_item_key]
    PURCHASEORDERPRICETYPE,          -- PO price [bpueb]
    ISPURREQNOVRLREL,                -- Overall req. rel. [gsfrg]
    ITEMNETAMOUNT,                   -- abap.curr
    EXTERNALAPPROVALSTATUS,          -- Ext Prcsng. Status [mmpur_req_extapprvlsts]
    COMMITMENTITEM,                  -- Commitment item [fipos]
    FUNDSCENTER,                     -- Funds Center [fistl]
    FUND,                            -- Fund [bp_geber]
    GRANTID,                         -- Grant [gm_grant_nbr]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [kblnr]
    EARMARKEDFUNDSDOCUMENTITEM,      -- Document Item [kblpos]
    BUDGETPERIOD,                    -- Budget Period [fm_budget_period]
    COSTCENTER,                      -- Cost Center [kostl]
    GLACCOUNT,                       -- G/L Account [saknr]
    WBSELEMENT,                      -- WBS Element [ps_psp_pnr]
    FUNDEDPROGRAM,                   -- abap.char
    FUNDMGMTISACTIVE,                -- Truth Value [abap_boolean]
    PURREQNREWORKCOMMENTTEXT,        -- Note Text [mmpur_note_text]
    PURREQNREJECTIONISCANCELLED,     -- Truth Value [abap_boolean]
    PURREQNISAPPLICABLEFORREWORK,    -- PR Rework Indicator [mmpur_req_d_pr_rework_ind]
    PURREQNISPFMFOOTPRINTVISIBLE,    -- Checkbox [xfeld]
    ISOUTLINE,                       -- Is Outline [mmpur_req_is_outline]
    PURCHASINGPARENTITEM,            -- Parent Item No [mmpur_req_parent_item_no]
    PURREQNITEMOUTLINETYPE,          -- Outline Type [mmpur_req_outline_type]
    PURGCONFIGURABLEITEMNUMBER,      -- Hierarchy Number [exlin]
    PURGEXTERNALSORTNUMBER,          -- External Sort No. [exsnr]
    HIERARCHYNODE,                   -- Hier.node [rsnodeext]
    HIERARCHYPARENTNODE,             -- Hier.node [rsnodeext]
    HIERARCHYLEVEL,                  -- abap.int4
    HIERARCHYNODESUBTREESIZE,        -- abap.int4
    HIERARCHYDRILLSTATE,             -- abap.char
    HIERARCHYNODEORDINALNUMBER,      -- abap.int8
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    PRIMARY KEY (MANDT, DRAFTUUID)
);

Learn More