I_PURORDACCOUNTASSIGNMENT

CDS View
60 Fields 17 CDS Views

Purchase Order Account Assignment

I_PURORDACCOUNTASSIGNMENT is a CDS View in S/4HANA. Purchase Order Account Assignment. It contains 60 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
A_PurOrdAccountAssignment view from COMPOSITE Account Assignment
C_POAccountAssignmentFactSheet view from CONSUMPTION Purchase Order Account Assignment
C_PurOrdAcctAsgmntSolution view from CONSUMPTION Purchase Order Account Assignment
I_PPS_PurOrdItmAcctAsgtC view_entity from COMPOSITE PPS Pur Ord Itm Acc Assgn - Cube
I_PurOrdAccountAssignmentAPI01 view from COMPOSITE Account Assignment in Purchase Order
I_PurOrdAcctAssignmentTP view from TRANSACTIONAL Transactional View for PO Account Assignment
P_POItemAcctInvoiceTotalCalc view_entity from CONSUMPTION
P_PurchaseOrderItemAcctMntr view_entity from CONSUMPTION
P_RFM_SlsOrdPrgrsMntrPurOrd view from COMPOSITE
P_SalesOrderInSupplyPurgIssue1 view inner COMPOSITE
P_SalesOrderInSupplyPurgIssue2 view inner COMPOSITE
P_SalesOrderInSupplyPurgIssue4 view inner COMPOSITE
P_SlsDocFlfmtProcHierarchyD31 view from CONSUMPTION
P_SlsOrdFlfmtProcessFlow12 view inner COMPOSITE
P_SlsOrdProcFlow12 view inner CONSUMPTION
P_SOFAProcFlow12 view inner COMPOSITE
R_PurOrdAccountAssignmentTP view_entity from TRANSACTIONAL Purchase Order Accnt Assignment TP view

Fields (60)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 3
KEY PurchaseOrder PurchaseOrder 7
KEY PurchaseOrderItem PurchaseOrderItem 4
KEY SalesOrder SalesOrder 5
KEY SalesOrderItem SalesOrderItem 5
BudgetPeriod BudgetPeriod 2
BusinessArea BusinessArea 3
BusinessProcess BusinessProcess 1
ChartOfAccounts ChartOfAccounts 1
CommitmentItem CommitmentItem 3
CompanyCode CompanyCode 2
ControllingArea ControllingArea 3
CostCenter CostCenter 3
CostCtrActivityType CostCtrActivityType 1
CostObject CostObject 2
DocumentCurrency DocumentCurrency 2
EarmarkedFundsDocument EarmarkedFundsDocument 1
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem 1
EarmarkedFundsItem EarmarkedFundsItem 1
FixedAsset FixedAsset 2
FunctionalArea FunctionalArea 2
Fund Fund 3
FundsCenter FundsCenter 3
GLAccount GLAccount,PurchasingOrderGLAccount 4
GoodsRecipientName GoodsRecipientName 1
GrantID GrantID 2
IsDeleted IsDeleted 2
IsFinallyInvoiced IsFinallyInvoiced 1
JointVentureRecoveryCode JointVentureRecoveryCode 2
LastChangedDate LastChangedDate 1
MasterFixedAsset MasterFixedAsset 2
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 2
NetworkActivity NetworkActivity 1
NetworkActivityInternalID NetworkActivityInternalID 1
NonDeductibleInputTaxAmount NonDeductibleInputTaxAmount 1
OrderID OrderID 3
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 1
OrderInternalID OrderInternalID 1
OrderQuantityUnit OrderQuantityUnit 1
PartnerAccountNumber PartnerAccountNumber 2
ProfitabilitySegment ProfitabilitySegment 1
ProfitabilitySegment_2 ProfitabilitySegment 1
ProfitCenter ProfitCenter 3
ProjectNetwork ProjectNetwork 3
ProjectNetworkInternalID ProjectNetworkInternalID 1
PubSecSplitAuthznGroup PubSecSplitAuthznGroup 1
PubSecSplitBatchNumberID PubSecSplitBatchNumberID 1
PurgDocNetAmount PurgDocNetAmount 2
Quantity Quantity 3
RealEstateObject RealEstateObject 1
SalesOrderScheduleLine SalesOrderScheduleLine 3
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1
SettlementReferenceDate SettlementReferenceDate 2
TaxCode TaxCode 2
TaxJurisdiction TaxJurisdiction 2
UnloadingPointName UnloadingPointName 1
ValidityDate ValidityDate 1
WBSElementInternalID WBSElementInternalID 2

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.

-- Purchase Order Account Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURORDACCOUNTASSIGNMENT (
    ACCOUNTASSIGNMENTNUMBER,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    SALESORDER,
    SALESORDERITEM,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    COMMITMENTITEM,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTOBJECT,
    DOCUMENTCURRENCY,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    EARMARKEDFUNDSITEM,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    GRANTID,
    ISDELETED,
    ISFINALLYINVOICED,
    JOINTVENTURERECOVERYCODE,
    LASTCHANGEDDATE,
    MASTERFIXEDASSET,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    NETWORKACTIVITY,
    NETWORKACTIVITYINTERNALID,
    NONDEDUCTIBLEINPUTTAXAMOUNT,
    ORDERID,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALID,
    ORDERQUANTITYUNIT,
    PARTNERACCOUNTNUMBER,
    PROFITABILITYSEGMENT,
    PROFITABILITYSEGMENT_2,
    PROFITCENTER,
    PROJECTNETWORK,
    PROJECTNETWORKINTERNALID,
    PUBSECSPLITAUTHZNGROUP,
    PUBSECSPLITBATCHNUMBERID,
    PURGDOCNETAMOUNT,
    QUANTITY,
    REALESTATEOBJECT,
    SALESORDERSCHEDULELINE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SETTLEMENTREFERENCEDATE,
    TAXCODE,
    TAXJURISDICTION,
    UNLOADINGPOINTNAME,
    VALIDITYDATE,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, PURCHASEORDER, PURCHASEORDERITEM, SALESORDER, SALESORDERITEM)
);

Learn More