I_PURORDACCTASSIGNMENTTP

CDS View
65 Fields 3 CDS Views

Transactional View for PO Account Assignment

I_PURORDACCTASSIGNMENTTP is a CDS View in S/4HANA. Transactional View for PO Account Assignment. It contains 65 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_PurOrdAcctAssignmentTP view from CONSUMPTION Purchase Order Account Assignment
C_PurOrdRefDocPC view left_outer CONSUMPTION Reference Documents PO Creation - Purchase Contract Items
C_PurOrdRefDocPO view left_outer CONSUMPTION Reference Documents for PO Creation - Purchase Order Items

Fields (65)

KeyField CDS FieldsUsed in Views
KEY AccountAssignmentNumber AccountAssignmentNumber 3
KEY PurchaseOrder PurchaseOrder 1
KEY PurchaseOrderItem PurchaseOrderItem 1
_BusinessArea _BusinessArea 1
_BusinessProcess _BusinessProcess 1
_CostCenterText _CostCenterText 1
_FunctionalArea _FunctionalArea 1
_FunctionalAreaText _FunctionalAreaText 1
_ProfitCenterText _ProfitCenterText 1
_TaxCode _TaxCode 1
_TaxJurisdiction _TaxJurisdiction 1
AccountAssignmentCategory AccountAssignmentCategory 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 1
BusinessProcess BusinessProcess 1
ChartOfAccounts ChartOfAccounts 1
CommitmentItem CommitmentItem 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 3
CostCenter CostCenter 3
CostCtrActivityType CostCtrActivityType 1
CostObject CostObject 1
EarmarkedFundsDocument EarmarkedFundsDocument 1
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem 1
FinancialManagementArea FinancialManagementArea 1
FixedAsset FixedAsset 1
FunctionalArea FunctionalArea 3
Fund Fund 1
FundedProgram FundedProgram 1
FundsCenter FundsCenter 1
GLAccount GLAccount 3
GoodsRecipientName GoodsRecipientName 1
GrantID GrantID 1
HighestMessageSeverityLevel HighestMessageSeverityLevel 1
IsDeleted IsDeleted 1
IsFinallyInvoiced IsFinallyInvoiced 1
JointVentureRecoveryCode JointVentureRecoveryCode 1
LastChangedDate LastChangedDate 1
MasterFixedAsset MasterFixedAsset 1
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 1
NetworkActivity NetworkActivity 1
NetworkActivityInternalID NetworkActivityInternalID 1
OrderID OrderID 1
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 1
OrderInternalID OrderInternalID 1
OrderOperation OrderOperation 1
PartnerAccountNumber PartnerAccountNumber 1
ProfitabilitySegment ProfitabilitySegment 1
ProfitCenter ProfitCenter 2
ProjectNetwork ProjectNetwork 1
ProjectNetworkInternalID ProjectNetworkInternalID 1
RealEstateObject RealEstateObject 1
SalesOrder SalesOrder 3
SalesOrderItem SalesOrderItem 3
SalesOrderScheduleLine SalesOrderScheduleLine 1
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentType ServiceDocumentType 1
SettlementReferenceDate SettlementReferenceDate 1
TaxCode TaxCode 1
TaxJurisdiction TaxJurisdiction 1
UnloadingPointName UnloadingPointName 1
ValidityDate ValidityDate 1
WBSElementExternalID WBSElementExternalID 1
WBSElementInternalID WBSElementInternalID 3

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.

-- Transactional View for PO Account Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURORDACCTASSIGNMENTTP (
    ACCOUNTASSIGNMENTNUMBER,
    PURCHASEORDER,
    PURCHASEORDERITEM,
    _BUSINESSAREA,
    _BUSINESSPROCESS,
    _COSTCENTERTEXT,
    _FUNCTIONALAREA,
    _FUNCTIONALAREATEXT,
    _PROFITCENTERTEXT,
    _TAXCODE,
    _TAXJURISDICTION,
    ACCOUNTASSIGNMENTCATEGORY,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    COMMITMENTITEM,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTOBJECT,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    FINANCIALMANAGEMENTAREA,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    GRANTID,
    HIGHESTMESSAGESEVERITYLEVEL,
    ISDELETED,
    ISFINALLYINVOICED,
    JOINTVENTURERECOVERYCODE,
    LASTCHANGEDDATE,
    MASTERFIXEDASSET,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    NETWORKACTIVITY,
    NETWORKACTIVITYINTERNALID,
    ORDERID,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALID,
    ORDEROPERATION,
    PARTNERACCOUNTNUMBER,
    PROFITABILITYSEGMENT,
    PROFITCENTER,
    PROJECTNETWORK,
    PROJECTNETWORKINTERNALID,
    REALESTATEOBJECT,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERSCHEDULELINE,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTTYPE,
    SETTLEMENTREFERENCEDATE,
    TAXCODE,
    TAXJURISDICTION,
    UNLOADINGPOINTNAME,
    VALIDITYDATE,
    WBSELEMENTEXTERNALID,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (ACCOUNTASSIGNMENTNUMBER, PURCHASEORDER, PURCHASEORDERITEM)
);

Learn More