DRAFT_PR_ACC

Transparent Table Application Table
46 Fields 1 CDS Views

SSP requisition Accounting

DRAFT_PR_ACC is an SAP database table in S/4HANA. SSP requisition Accounting. It contains 46 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
E_Purreqnaccassigndraft view from EXTENSION PurReqn Account Assignment Draft Extensibility View

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purreqnacctdraftuuid sysuuid_x UUID
purreqnitemdraftuuid sysuuid_x UUID
purreqndraftuuid sysuuid_x UUID
purchaserequisition banfn Purchase Req.
purchaserequisitionitem bnfpo Requisn. item
accountassignmentnumber dzekkn Account Assgmt No.
glaccount saknr G/L Account
multipleacctassgmtdistrpercent vproz Distribution
quantity menge_d Quantity
hasactiveentity sdraft_has_active Has active
costcenter kostl Cost Center
masterfixedasset anln1 Asset
fixedasset anln2 Sub-number
mainassetnumber anln1 Asset
assetsubnumber anln2 Sub-number
salesorder vbeln SD Document
salersorderitem posnr_va Item
network nplnr Network
businessarea gsber Business Area
controllingarea kokrs CO Area
costobject kstrg Cost Object
profitcenter prctr Profit Center
fund bp_geber Fund
fundscenter fistl Funds Center
functionalarea fkber Functional Area
commitmentitem fipos Commitment item
purreqnnetamount netwr Net Value
sddocument vbeln SD Document
salesdocumentitem posnr_va Item
scheduleline etenr Schedule Line
orderid aufnr Order
projectnetwork nplnr Network
unloadingpointname ablad Unloading Point
profitabilitysegment rkeobjnr Profit. segment
wbselementinternalid ps_psp_pnr WBS Element
projectnetworkinternalid co_aufpl Plan No.f.Oper.
goodsrecipientname wempf Recipient
networkactivityinternalid cim_count Counter
orderinternalid co_aufpl Plan No.f.Oper.
orderintbillofoperationsitem co_aplzl Counter
earmarkedfundsdocument kblnr Earmarked Funds
costctractivitytype lstar Activity Type
businessprocess co_prznr Business Process
grantid gm_grant_nbr Grant
networkactivity vornr Activity

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 Accounting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE DRAFT_PR_ACC (
    MANDT,                           -- Client [mandt]
    PURREQNACCTDRAFTUUID,            -- UUID [sysuuid_x]
    PURREQNITEMDRAFTUUID,            -- UUID [sysuuid_x]
    PURREQNDRAFTUUID,                -- UUID [sysuuid_x]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    ACCOUNTASSIGNMENTNUMBER,         -- Account Assgmt No. [dzekkn]
    GLACCOUNT,                       -- G/L Account [saknr]
    MULTIPLEACCTASSGMTDISTRPERCENT,  -- Distribution [vproz]
    QUANTITY,                        -- Quantity [menge_d]
    HASACTIVEENTITY,                 -- Has active [sdraft_has_active]
    COSTCENTER,                      -- Cost Center [kostl]
    MASTERFIXEDASSET,                -- Asset [anln1]
    FIXEDASSET,                      -- Sub-number [anln2]
    MAINASSETNUMBER,                 -- Asset [anln1]
    ASSETSUBNUMBER,                  -- Sub-number [anln2]
    SALESORDER,                      -- SD Document [vbeln]
    SALERSORDERITEM,                 -- Item [posnr_va]
    NETWORK,                         -- Network [nplnr]
    BUSINESSAREA,                    -- Business Area [gsber]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    COSTOBJECT,                      -- Cost Object [kstrg]
    PROFITCENTER,                    -- Profit Center [prctr]
    FUND,                            -- Fund [bp_geber]
    FUNDSCENTER,                     -- Funds Center [fistl]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    COMMITMENTITEM,                  -- Commitment item [fipos]
    PURREQNNETAMOUNT,                -- Net Value [netwr]
    SDDOCUMENT,                      -- SD Document [vbeln]
    SALESDOCUMENTITEM,               -- Item [posnr_va]
    SCHEDULELINE,                    -- Schedule Line [etenr]
    ORDERID,                         -- Order [aufnr]
    PROJECTNETWORK,                  -- Network [nplnr]
    UNLOADINGPOINTNAME,              -- Unloading Point [ablad]
    PROFITABILITYSEGMENT,            -- Profit. segment [rkeobjnr]
    WBSELEMENTINTERNALID,            -- WBS Element [ps_psp_pnr]
    PROJECTNETWORKINTERNALID,        -- Plan No.f.Oper. [co_aufpl]
    GOODSRECIPIENTNAME,              -- Recipient [wempf]
    NETWORKACTIVITYINTERNALID,       -- Counter [cim_count]
    ORDERINTERNALID,                 -- Plan No.f.Oper. [co_aufpl]
    ORDERINTBILLOFOPERATIONSITEM,    -- Counter [co_aplzl]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [kblnr]
    COSTCTRACTIVITYTYPE,             -- Activity Type [lstar]
    BUSINESSPROCESS,                 -- Business Process [co_prznr]
    GRANTID,                         -- Grant [gm_grant_nbr]
    NETWORKACTIVITY,                 -- Activity [vornr]
    PRIMARY KEY (MANDT, PURREQNACCTDRAFTUUID)
);

Learn More