PPS_PR_ACCT_D

Transparent Table Application Table
69 Fields 1 CDS Views

Draft table for entity R_PPS_PURCHASEREQNACCTASSGMTTP

PPS_PR_ACCT_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCHASEREQNACCTASSGMTTP. It contains 69 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurReqAcctAssgmtDraft view_entity from BASIC Purchase Requisition Draft

Fields (69)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY purreqnacctassgmtnmbr dzebkn Ser.no.acc.ass.
KEY purchaserequisition banfn Purchase Req.
KEY purchaserequisitionitem bnfpo Requisn. item
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
costcenter kostl Cost Center
masterfixedasset anln1 Asset
projectnetwork nplnr Network
quantity bamng Quantity
baseunit bamei Unit of Measure
multipleacctassgmtdistrpercent vproz Distribution
purreqnitemcurrency waers Currency
purreqnnetamount bwert Net Value
isdeleted eloek Del. Indicator
costelement saknr G/L Account
glaccount saknr G/L Account
glaccountlongname fis_txt50_skat G/L Account Long Name
businessarea gsber Business Area
sddocument vbeln SD Document
salesorder vbeln SD Document
salesdocumentitem posnr_va Item
salesorderitem posnr_va Item
scheduleline etenr Schedule Line
salesorderscheduleline etenr Schedule Line
fixedasset anln2 Sub-number
processorder aufnr Order
orderid aufnr Order
unloadingpointname ablad Unloading Point
controllingarea kokrs CO Area
costobject kstrg Cost Object
profitabilitysegment rkeobjnr_char Profitability Segment
profitcenter prctr Profit Center
wbselementinternalid ps_s4_pspnr WBS Internal ID
wbselementexternalid ps_posid_edit WBS Element
wbselement ps_posid_edit WBS Element
projectnetworkinternalid co_aufpl Plan No.f.Oper.
commitmentitem fm_fipex Commitment Item
commitmentitemshortid fmis_ci_internalname Commitment Item Short ID
fundscenter fistl Funds Center
fund bp_geber Fund
functionalarea fkber Functional Area
creationdate erdat Created On
goodsrecipientname wempf Recipient
realestateobject recaimkeyfi Real Estate Key
networkactivityinternalid cim_count Counter
partneraccountnumber jv_part Partner
jointventurerecoverycode jv_recind Recovery Ind.
settlementreferencedate dabrbez Reference date
orderinternalid co_aufpl Plan No.f.Oper.
orderintbillofoperationsitem co_aplzl Counter
earmarkedfundsdocument kblnr Earmarked Funds
earmarkedfundsdocumentitem kblpos Document Item
costctractivitytype lstar Activity Type
businessprocess co_prznr Business Process
grantid gm_grant_nbr Grant
validitydate abap.dats
chartofaccounts fis_ktopl Chart of Accounts
budgetperiod fm_budget_period Budget Period
fundedprogram abap.char
networkactivity ps_s4_vornr Oper./Act.
purreqnnetworkactivityfordsp vdm_vornr Operation or Phase
companycode bukrs Company Code
financialmanagementarea fikrs FM Area
pubsecsplitbatchnumberid fmsp_split_batch Dist.Batch No.
pubsecsplitauthzngroup fmsp_split_autg Auth.Group
accountassignmentsmartnumber char60 Logical System
ppsaccountassignmentisunfunded pps_e_account_asgn_is_unfunded Acc. Asg is Unfunded
purchasereqndraftuuid sdraft_uuid Draft Document ID

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_PURCHASEREQNACCTASSGMTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PR_ACCT_D (
    MANDT,                           -- Client [mandt]
    PURREQNACCTASSGMTNMBR,           -- Ser.no.acc.ass. [dzebkn]
    PURCHASEREQUISITION,             -- Purchase Req. [banfn]
    PURCHASEREQUISITIONITEM,         -- Requisn. item [bnfpo]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    COSTCENTER,                      -- Cost Center [kostl]
    MASTERFIXEDASSET,                -- Asset [anln1]
    PROJECTNETWORK,                  -- Network [nplnr]
    QUANTITY,                        -- Quantity [bamng]
    BASEUNIT,                        -- Unit of Measure [bamei]
    MULTIPLEACCTASSGMTDISTRPERCENT,  -- Distribution [vproz]
    PURREQNITEMCURRENCY,             -- Currency [waers]
    PURREQNNETAMOUNT,                -- Net Value [bwert]
    ISDELETED,                       -- Del. Indicator [eloek]
    COSTELEMENT,                     -- G/L Account [saknr]
    GLACCOUNT,                       -- G/L Account [saknr]
    GLACCOUNTLONGNAME,               -- G/L Account Long Name [fis_txt50_skat]
    BUSINESSAREA,                    -- Business Area [gsber]
    SDDOCUMENT,                      -- SD Document [vbeln]
    SALESORDER,                      -- SD Document [vbeln]
    SALESDOCUMENTITEM,               -- Item [posnr_va]
    SALESORDERITEM,                  -- Item [posnr_va]
    SCHEDULELINE,                    -- Schedule Line [etenr]
    SALESORDERSCHEDULELINE,          -- Schedule Line [etenr]
    FIXEDASSET,                      -- Sub-number [anln2]
    PROCESSORDER,                    -- Order [aufnr]
    ORDERID,                         -- Order [aufnr]
    UNLOADINGPOINTNAME,              -- Unloading Point [ablad]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    COSTOBJECT,                      -- Cost Object [kstrg]
    PROFITABILITYSEGMENT,            -- Profitability Segment [rkeobjnr_char]
    PROFITCENTER,                    -- Profit Center [prctr]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [ps_s4_pspnr]
    WBSELEMENTEXTERNALID,            -- WBS Element [ps_posid_edit]
    WBSELEMENT,                      -- WBS Element [ps_posid_edit]
    PROJECTNETWORKINTERNALID,        -- Plan No.f.Oper. [co_aufpl]
    COMMITMENTITEM,                  -- Commitment Item [fm_fipex]
    COMMITMENTITEMSHORTID,           -- Commitment Item Short ID [fmis_ci_internalname]
    FUNDSCENTER,                     -- Funds Center [fistl]
    FUND,                            -- Fund [bp_geber]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    CREATIONDATE,                    -- Created On [erdat]
    GOODSRECIPIENTNAME,              -- Recipient [wempf]
    REALESTATEOBJECT,                -- Real Estate Key [recaimkeyfi]
    NETWORKACTIVITYINTERNALID,       -- Counter [cim_count]
    PARTNERACCOUNTNUMBER,            -- Partner [jv_part]
    JOINTVENTURERECOVERYCODE,        -- Recovery Ind. [jv_recind]
    SETTLEMENTREFERENCEDATE,         -- Reference date [dabrbez]
    ORDERINTERNALID,                 -- Plan No.f.Oper. [co_aufpl]
    ORDERINTBILLOFOPERATIONSITEM,    -- Counter [co_aplzl]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [kblnr]
    EARMARKEDFUNDSDOCUMENTITEM,      -- Document Item [kblpos]
    COSTCTRACTIVITYTYPE,             -- Activity Type [lstar]
    BUSINESSPROCESS,                 -- Business Process [co_prznr]
    GRANTID,                         -- Grant [gm_grant_nbr]
    VALIDITYDATE,                    -- abap.dats
    CHARTOFACCOUNTS,                 -- Chart of Accounts [fis_ktopl]
    BUDGETPERIOD,                    -- Budget Period [fm_budget_period]
    FUNDEDPROGRAM,                   -- abap.char
    NETWORKACTIVITY,                 -- Oper./Act. [ps_s4_vornr]
    PURREQNNETWORKACTIVITYFORDSP,    -- Operation or Phase [vdm_vornr]
    COMPANYCODE,                     -- Company Code [bukrs]
    FINANCIALMANAGEMENTAREA,         -- FM Area [fikrs]
    PUBSECSPLITBATCHNUMBERID,        -- Dist.Batch No. [fmsp_split_batch]
    PUBSECSPLITAUTHZNGROUP,          -- Auth.Group [fmsp_split_autg]
    ACCOUNTASSIGNMENTSMARTNUMBER,    -- Logical System [char60]
    PPSACCOUNTASSIGNMENTISUNFUNDED,  -- Acc. Asg is Unfunded [pps_e_account_asgn_is_unfunded]
    PURCHASEREQNDRAFTUUID,           -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, PURREQNACCTASSGMTNMBR, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, DRAFTUUID)
);

Learn More