I_PURGDOCACCOUNTASSIGNMENT

CDS View
65 Fields 39 CDS Views

Purchasing Document Account Assignment

I_PURGDOCACCOUNTASSIGNMENT is a CDS View in S/4HANA. Purchasing Document Account Assignment. It contains 65 fields. 39 CDS views read from this table.

CDS Views using this table (39)

ViewTypeJoinVDMDescription
C_Arberp_Ordrout_Accassignment view from CONSUMPTION View: purchase order account assignment
C_GB_StRpAuditMMFileC view_entity inner CONSUMPTION GB HRMC Audit File for MM - Cube
C_PurgDocAccountAssignmentObj view from CONSUMPTION Purchasing Document Account Assignments For Object Page
I_CFinPurgDocAccountAssignment view union_all COMPOSITE CFin Purchasing Doc: Account Assignment
I_MRPPurchaseOrder view left_outer COMPOSITE MRP Purchase Order
I_MstrProjPurchaseOrder view from COMPOSITE Purchase Order for Commercial Project
I_MstrProjPurchaseOrder view union COMPOSITE Purchase Order for Commercial Project
I_MstrProjPurOrdItemSimple view inner COMPOSITE Simplified PO Items for Master Project
I_PPSFundsRequestItemAcctAsgt view_entity from COMPOSITE PPS Purchasing Acc Assgnmt for Fund Req
I_PurchaseOrderQuickView view left_outer COMPOSITE Purchase Order Data
I_PurContrAccountAssgmt view from COMPOSITE Purchase Contract Account Assignment
I_PurCtrAccount view from COMPOSITE Account Assignment For Contracts
I_PurOrdAccountAssignment view from COMPOSITE Purchase Order Account Assignment
I_PurOrdAccrsCFinPurgDocAssgmt view union_all COMPOSITE PurOrdAccrs: CFin PO Item Assgmt
I_Schedagrmtacct view from COMPOSITE Scheduling Agreement Account Assignment
P_MaintBacklogNonStkCompUnion view inner CONSUMPTION Maintenance Backlog Non Stock Component Union
P_MaintBacklogServiceUnion view inner CONSUMPTION
P_MaintOrdDepdntRqmtStatus view union_all COMPOSITE
P_MaintOrdDirectProcmtViaPO view union_all COMPOSITE
P_MaintOrdDirectProcmtViaPO view left_outer COMPOSITE
P_MaintOrdNmbrOfOpenPO view from CONSUMPTION
P_MaintOrdNmbrOfOpenServices view from CONSUMPTION
P_MaintOrdNonStkCompFromPurOrd view from CONSUMPTION
P_Mpnwepurdoc view from COMPOSITE
P_Mpsopurdoc view from COMPOSITE
P_Mpwbspurdoc view from COMPOSITE
P_ProjPurDocItems view union_all COMPOSITE
P_PurchasingSpndComparison2 view left_outer CONSUMPTION Purchasing Spend Comparison 2
P_PurgSpndComprnAcctAssgmt view left_outer CONSUMPTION AccountAssignment for PurchasingSpend Comparison
P_PurOrdItemAcctAssgmt view left_outer CONSUMPTION Purchase Order Item Account Assignment
P_PurOrdItmAccountAssignment view from CONSUMPTION PO Item Account Assignment
P_PurOrdItmAcctAssgmt view inner CONSUMPTION
P_PurOrdItmAcctAssgmt1 view left_outer CONSUMPTION
P_PurOrdMaintainPdocAccAssHlpr view from CONSUMPTION
P_PurOrdMaintainPDocAccAssLine view from CONSUMPTION
P_RFM_SlsOrdPrgrsMntrPOSchLine view inner COMPOSITE
P_RSHMaintOrdCompCritltyCode view_entity union_all CONSUMPTION
P_RSHMaintOrdOpComponent view_entity union_all CONSUMPTION
P_SlsOrderInSupplyPurgIssue3 view inner COMPOSITE

Fields (65)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 13
KEY PurchasingDocument PurchaseDocument,PurchaseOrder,PurchasingDocument 9
KEY PurchasingDocumentItem PurchaseItem,PurchaseOrderItem,PurchasingDocumentItem 11
KEY SalesOrder CentralFinanceSalesDocument,SalesDocument,SalesOrder 7
KEY SalesOrderItem CFinSalesDocumentItem,SalesDocumentItem,SalesOrderItem 7
_SalesOrder _SalesOrder 1
_SalesOrderItem _SalesOrderItem 1
_WBSElementByInternalKey _WBSElementByInternalKey 1
AcctLineFinalReason AcctLineFinalReason 1
BudgetPeriod BudgetPeriod 3
BusinessArea BusinessArea 3
BusinessProcess BusinessProcess 1
ChartOfAccounts ChartOfAccounts 3
CommitmentItem CommitmentItem,CommitmentItemShortID 3
CommitmentItemShortID CommitmentItemShortID 1
ControllingArea ControllingArea 7
CostCenter CostCenter 11
CostCtrActivityType CostCtrActivityType 3
CostObject CostObject 2
CreationDate CreationDate 1
DocumentCurrency DocumentCurrency 3
EarmarkedFundsDocument EarmarkedFundsDocument 1
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem 1
EarmarkedFundsItem EarmarkedFundsItem 1
FixedAsset FixedAsset 4
FunctionalArea FunctionalArea 4
Fund Fund 3
FundsCenter FundsCenter 3
GLAccount GLAccount 9
GoodsRecepientName GoodsRecepientName,GoodsRecipientName 3
GrantID GrantID 3
IsAcctLineFinal IsAcctLineFinal 1
IsDeleted IsDeleted 4
IsFinallyInvoiced IsFinallyInvoiced 1
JointVentureRecoveryCode JointVentureRecoveryCode 1
LastChangedDate LastChangedDate 1
MasterFixedAsset FixedAsset,MasterFixedAsset 6
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 9
NetworkActivityInternalID MaintOrderOperationCounter,NetworkActivityInternalID 6
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 3
OrderID MaintenanceOrder,OrderID 7
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 2
OrderInternalID MaintOrderRoutingNumber,OrderInternalID 2
OrderQuantityUnit OrderQuantityUnit 2
PartnerAccountNumber PartnerAccountNumber 1
ProfitabilitySegment_2 ProfitabilitySegment,ProfitabilitySegment_2 1
ProfitCenter ProfitCenter 7
ProjectNetwork ProjectNetwork 4
ProjectNetworkInternalID ProjectNetworkInternalID 5
PubSecSplitAuthznGroup PubSecSplitAuthznGroup 1
PubSecSplitBatchNumberID PubSecSplitBatchNumberID 1
PurgDocNetAmount PurgDocNetAmount 6
Quantity Quantity 6
RealEstateObject RealEstateObject 2
REInternalFinNumber REInternalFinNumber 1
SalesOrderScheduleLine CFinRpldSalesDocScheduleLine,SalesOrderScheduleLine 3
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1
SettlementReferenceDate SettlementReferenceDate 3
TaxCode TaxCode 4
TaxJurisdiction TaxJurisdiction 2
UnloadingPointName UnloadingPointName 1
ValidityDate ValidityDate 3
WBSElementInternalID WBSElementInternalID 12

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.

-- Purchasing Document Account Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURGDOCACCOUNTASSIGNMENT (
    ACCOUNTASSIGNMENTNUMBER,
    PURCHASINGDOCUMENT,
    PURCHASINGDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    _SALESORDER,
    _SALESORDERITEM,
    _WBSELEMENTBYINTERNALKEY,
    ACCTLINEFINALREASON,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    COMMITMENTITEM,
    COMMITMENTITEMSHORTID,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTOBJECT,
    CREATIONDATE,
    DOCUMENTCURRENCY,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    EARMARKEDFUNDSITEM,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECEPIENTNAME,
    GRANTID,
    ISACCTLINEFINAL,
    ISDELETED,
    ISFINALLYINVOICED,
    JOINTVENTURERECOVERYCODE,
    LASTCHANGEDDATE,
    MASTERFIXEDASSET,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    NETWORKACTIVITYINTERNALID,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    ORDERID,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALID,
    ORDERQUANTITYUNIT,
    PARTNERACCOUNTNUMBER,
    PROFITABILITYSEGMENT_2,
    PROFITCENTER,
    PROJECTNETWORK,
    PROJECTNETWORKINTERNALID,
    PUBSECSPLITAUTHZNGROUP,
    PUBSECSPLITBATCHNUMBERID,
    PURGDOCNETAMOUNT,
    QUANTITY,
    REALESTATEOBJECT,
    REINTERNALFINNUMBER,
    SALESORDERSCHEDULELINE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SETTLEMENTREFERENCEDATE,
    TAXCODE,
    TAXJURISDICTION,
    UNLOADINGPOINTNAME,
    VALIDITYDATE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, PURCHASINGDOCUMENT, PURCHASINGDOCUMENTITEM, SALESORDER, SALESORDERITEM)
);

Learn More