PPS_PO_ACCT_D
Draft table for entity R_PPS_PURORDACCTASSIGNMENTTP
PPS_PO_ACCT_D is an SAP database table in S/4HANA. Draft table for entity R_PPS_PURORDACCTASSIGNMENTTP. It contains 74 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_PPS_PurOrdAcctAssgmtDrft | view_entity | from | BASIC | PurchaseOrder AcctAssgmt - Draft |
Fields (74)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | purchaseorder | ebeln | Purchasing Doc. | |||
| KEY | purchaseorderitem | ebelp | Item | |||
| KEY | accountassignmentnumber | dzekkn | Account Assgmt No. | |||
| KEY | draftuuid | sdraft_uuid | Draft Document ID | |||
| parentdraftuuid | sdraft_uuid | Draft Document ID | ||||
| accountassignmentcategory | knttp | Acct Assgmt Cat | ||||
| purchasingdocument | ebeln | Purchasing Doc. | ||||
| purchasingdocumentitem | ebelp | Item | ||||
| costcenter | kostl | Cost Center | ||||
| masterfixedasset | anln1 | Asset | ||||
| projectnetwork | nplnr | Network | ||||
| networkactivity | ps_s4_vornr | Oper./Act. | ||||
| orderquantityunit | bstme | Order Unit | ||||
| quantity | menge_d | Quantity | ||||
| multipleacctassgmtdistrpercent | vproz | Distribution | ||||
| ismultipleaccountassignment | char1 | Single-Character Flag | ||||
| documentcurrency | waers | Currency | ||||
| purgdocnetamount | bwert | Net Value | ||||
| 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 | ||||
| orderoperation | vdm_vornr | Operation or Phase | ||||
| 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 | ||||
| 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 | ||||
| lastchangeddate | erdat | Created On | ||||
| goodsrecipientname | wempf | Recipient | ||||
| isfinallyinvoiced | erekz | Final Invoice | ||||
| 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 | ||||
| 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 | ||||
| earmarkedfundsdocumentitem | kblpos | Document Item | ||||
| validitydate | abap.dats | |||||
| ppsfieldchangeindicatorbinary | pps_e_control_flag | Control | ||||
| chartofaccounts | fis_ktopl | Chart of Accounts | ||||
| servicedocumenttype | fco_srvdoc_type | Service Doc. Type | ||||
| servicedocument | fco_srvdoc_id | Service Document | ||||
| servicedocumentitem | fco_srvdoc_item_id | Service Doc. Item | ||||
| highestmessageseveritylevel | hghstmsgsvrtylvl | Highest Message Severity Level | ||||
| financialmanagementarea | fikrs | FM Area | ||||
| creationdate | erdat | Created On | ||||
| isacctlinefinal | aa_final_ind | Final AA | ||||
| acctlinefinalreason | aa_final_reason | Final AA Reason | ||||
| companycode | bukrs | Company Code | ||||
| ppsaccountassignmentisunfunded | pps_e_account_asgn_is_unfunded | Acc. Asg is Unfunded | ||||
| purchaseorderdraftuuid | 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_PURORDACCTASSIGNMENTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PPS_PO_ACCT_D (
MANDT, -- Client [mandt]
PURCHASEORDER, -- Purchasing Doc. [ebeln]
PURCHASEORDERITEM, -- Item [ebelp]
ACCOUNTASSIGNMENTNUMBER, -- Account Assgmt No. [dzekkn]
DRAFTUUID, -- Draft Document ID [sdraft_uuid]
PARENTDRAFTUUID, -- Draft Document ID [sdraft_uuid]
ACCOUNTASSIGNMENTCATEGORY, -- Acct Assgmt Cat [knttp]
PURCHASINGDOCUMENT, -- Purchasing Doc. [ebeln]
PURCHASINGDOCUMENTITEM, -- Item [ebelp]
COSTCENTER, -- Cost Center [kostl]
MASTERFIXEDASSET, -- Asset [anln1]
PROJECTNETWORK, -- Network [nplnr]
NETWORKACTIVITY, -- Oper./Act. [ps_s4_vornr]
ORDERQUANTITYUNIT, -- Order Unit [bstme]
QUANTITY, -- Quantity [menge_d]
MULTIPLEACCTASSGMTDISTRPERCENT, -- Distribution [vproz]
ISMULTIPLEACCOUNTASSIGNMENT, -- Single-Character Flag [char1]
DOCUMENTCURRENCY, -- Currency [waers]
PURGDOCNETAMOUNT, -- Net Value [bwert]
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]
ORDEROPERATION, -- Operation or Phase [vdm_vornr]
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]
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]
LASTCHANGEDDATE, -- Created On [erdat]
GOODSRECIPIENTNAME, -- Recipient [wempf]
ISFINALLYINVOICED, -- Final Invoice [erekz]
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]
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]
EARMARKEDFUNDSDOCUMENTITEM, -- Document Item [kblpos]
VALIDITYDATE, -- abap.dats
PPSFIELDCHANGEINDICATORBINARY, -- Control [pps_e_control_flag]
CHARTOFACCOUNTS, -- Chart of Accounts [fis_ktopl]
SERVICEDOCUMENTTYPE, -- Service Doc. Type [fco_srvdoc_type]
SERVICEDOCUMENT, -- Service Document [fco_srvdoc_id]
SERVICEDOCUMENTITEM, -- Service Doc. Item [fco_srvdoc_item_id]
HIGHESTMESSAGESEVERITYLEVEL, -- Highest Message Severity Level [hghstmsgsvrtylvl]
FINANCIALMANAGEMENTAREA, -- FM Area [fikrs]
CREATIONDATE, -- Created On [erdat]
ISACCTLINEFINAL, -- Final AA [aa_final_ind]
ACCTLINEFINALREASON, -- Final AA Reason [aa_final_reason]
COMPANYCODE, -- Company Code [bukrs]
PPSACCOUNTASSIGNMENTISUNFUNDED, -- Acc. Asg is Unfunded [pps_e_account_asgn_is_unfunded]
PURCHASEORDERDRAFTUUID, -- Draft Document ID [sdraft_uuid]
PRIMARY KEY (MANDT, PURCHASEORDER, PURCHASEORDERITEM, ACCOUNTASSIGNMENTNUMBER, DRAFTUUID)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA