PPS_PC_ACCOUNT_D

Transparent Table Application Table
61 Fields 1 CDS Views

Draft table for entity R_PPS_PURCONTRACCTASSIGNMENTTP

PPS_PC_ACCOUNT_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURCONTRACCTASSIGNMENTTP. It contains 61 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_PPS_PurContrAcctAssgmtDraft view_entity from BASIC Purchase Contract Acct Assgmt - Draft

Fields (61)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY accountassignmentnumber dzekkn Account Assgmt No.
KEY purchasecontractitem ebelp Item
KEY purchasecontract ebeln Purchasing Doc.
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
costcenter kostl Cost Center
masterfixedasset anln1 Asset
projectnetwork nplnr Network
quantity menge_d Quantity
orderquantityunit bstme Order Unit
multipleacctassgmtdistrpercent vproz Distribution
purgdocnetamount bwert Net Value
documentcurrency waers Currency
isdeleted kloek Deletion Ind.
glaccount saknr G/L Account
businessarea gsber Business Area
salesorder vbeln_co SD Document
salesorderitem posnr_co Item
salesorderscheduleline etenr Schedule Line
fixedasset anln2 Sub-number
orderid aufnr Order
unloadingpointname ablad Unloading Point
controllingarea kokrs CO Area
costobject kstrg Cost Object
profitcenter prctr Profit Center
wbselementinternalid ps_s4_pspnr WBS Internal ID
wbselementexternalid ps_posid_edit WBS Element
wbsdescription ps_s4_post1 WBS Element Name
projectnetworkinternalid co_aufpl Plan No.f.Oper.
commitmentitemshortid fmis_ci_internalname Commitment Item Short ID
commitmentitem fm_fipex Commitment Item
networkactivity ps_s4_vornr Oper./Act.
fundscenter fistl Funds Center
fund bp_geber Fund
functionalarea fkber Functional Area
lastchangeddate abap.dats
goodsrecipientname wempf Recipient
isfinallyinvoiced erekz Final Invoice
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
taxcode mwskz Tax Code
taxjurisdiction txjcd Tax Jur.
nondeductibleinputtaxamount navnw Non-deductible
costctractivitytype lstar Activity Type
businessprocess co_prznr Business Process
grantid gm_grant_nbr Grant
budgetperiod fm_budget_period Budget Period
earmarkedfundsdocument kblnr Earmarked Funds
validitydate abap.dats
lastchangedatetime changedatetime Last Changed
ppsfieldchangeindicatorbinary pps_e_control_flag Control
accountassignmentsmartnumber char60 Logical System
ppsaccountassignmentisunfunded pps_e_account_asgn_is_unfunded Acc. Asg is Unfunded
companycode bukrs Company Code
financialmanagementarea fikrs FM Area
purchasecontractdraftuuid 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_PURCONTRACCTASSIGNMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PC_ACCOUNT_D (
    MANDT,                           -- Client [mandt]
    ACCOUNTASSIGNMENTNUMBER,         -- Account Assgmt No. [dzekkn]
    PURCHASECONTRACTITEM,            -- Item [ebelp]
    PURCHASECONTRACT,                -- Purchasing Doc. [ebeln]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    COSTCENTER,                      -- Cost Center [kostl]
    MASTERFIXEDASSET,                -- Asset [anln1]
    PROJECTNETWORK,                  -- Network [nplnr]
    QUANTITY,                        -- Quantity [menge_d]
    ORDERQUANTITYUNIT,               -- Order Unit [bstme]
    MULTIPLEACCTASSGMTDISTRPERCENT,  -- Distribution [vproz]
    PURGDOCNETAMOUNT,                -- Net Value [bwert]
    DOCUMENTCURRENCY,                -- Currency [waers]
    ISDELETED,                       -- Deletion Ind. [kloek]
    GLACCOUNT,                       -- G/L Account [saknr]
    BUSINESSAREA,                    -- Business Area [gsber]
    SALESORDER,                      -- SD Document [vbeln_co]
    SALESORDERITEM,                  -- Item [posnr_co]
    SALESORDERSCHEDULELINE,          -- Schedule Line [etenr]
    FIXEDASSET,                      -- Sub-number [anln2]
    ORDERID,                         -- Order [aufnr]
    UNLOADINGPOINTNAME,              -- Unloading Point [ablad]
    CONTROLLINGAREA,                 -- CO Area [kokrs]
    COSTOBJECT,                      -- Cost Object [kstrg]
    PROFITCENTER,                    -- Profit Center [prctr]
    WBSELEMENTINTERNALID,            -- WBS Internal ID [ps_s4_pspnr]
    WBSELEMENTEXTERNALID,            -- WBS Element [ps_posid_edit]
    WBSDESCRIPTION,                  -- WBS Element Name [ps_s4_post1]
    PROJECTNETWORKINTERNALID,        -- Plan No.f.Oper. [co_aufpl]
    COMMITMENTITEMSHORTID,           -- Commitment Item Short ID [fmis_ci_internalname]
    COMMITMENTITEM,                  -- Commitment Item [fm_fipex]
    NETWORKACTIVITY,                 -- Oper./Act. [ps_s4_vornr]
    FUNDSCENTER,                     -- Funds Center [fistl]
    FUND,                            -- Fund [bp_geber]
    FUNCTIONALAREA,                  -- Functional Area [fkber]
    LASTCHANGEDDATE,                 -- abap.dats
    GOODSRECIPIENTNAME,              -- Recipient [wempf]
    ISFINALLYINVOICED,               -- Final Invoice [erekz]
    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]
    TAXCODE,                         -- Tax Code [mwskz]
    TAXJURISDICTION,                 -- Tax Jur. [txjcd]
    NONDEDUCTIBLEINPUTTAXAMOUNT,     -- Non-deductible [navnw]
    COSTCTRACTIVITYTYPE,             -- Activity Type [lstar]
    BUSINESSPROCESS,                 -- Business Process [co_prznr]
    GRANTID,                         -- Grant [gm_grant_nbr]
    BUDGETPERIOD,                    -- Budget Period [fm_budget_period]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked Funds [kblnr]
    VALIDITYDATE,                    -- abap.dats
    LASTCHANGEDATETIME,              -- Last Changed [changedatetime]
    PPSFIELDCHANGEINDICATORBINARY,   -- Control [pps_e_control_flag]
    ACCOUNTASSIGNMENTSMARTNUMBER,    -- Logical System [char60]
    PPSACCOUNTASSIGNMENTISUNFUNDED,  -- Acc. Asg is Unfunded [pps_e_account_asgn_is_unfunded]
    COMPANYCODE,                     -- Company Code [bukrs]
    FINANCIALMANAGEMENTAREA,         -- FM Area [fikrs]
    PURCHASECONTRACTDRAFTUUID,       -- Draft Document ID [sdraft_uuid]
    PRIMARY KEY (MANDT, ACCOUNTASSIGNMENTNUMBER, PURCHASECONTRACTITEM, PURCHASECONTRACT, DRAFTUUID)
);

Learn More