I_PURREQNACCOUNTASSIGNMENT

CDS View
39 Fields 8 CDS Views

Purchase Requisition Account Assignment

I_PURREQNACCOUNTASSIGNMENT is a CDS View in S/4HANA. Purchase Requisition Account Assignment. It contains 39 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
I_MRPPurchaseRequisition view left_outer COMPOSITE MRP Purchase Requisition
I_PurReqnQuickView view left_outer COMPOSITE Purchase Requisition Details
P_PurReqItemAcctmntr view from CONSUMPTION PR Items by Account Assignment
P_PurReqnAvgApprvlCrcyConvrsn view left_outer CONSUMPTION Purchase requisiton currency conversion
P_PurReqnCurrencyConvrsn view left_outer CONSUMPTION
P_PurReqnItemTypeAnalysis view left_outer CONSUMPTION Purchase Requistion No Touch for OVP
P_PurReqnItmAccountAssignment view from CONSUMPTION PR Item Account Assignment
P_PurRequisitionNoTouch1 view left_outer CONSUMPTION Purchase Requisition No Touch1

Fields (39)

KeyField CDS FieldsUsed in Views
KEY CostCenter CostCenter 5
KEY PurchaseReqnAcctAssgmtNumber AccountAssignmentNumber,PurchaseReqnAcctAssgmtNumber 3
KEY PurchaseRequisition PurchaseRequisition 1
KEY PurchaseRequisitionItem PurchaseRequisitionItem 1
_BusinessArea _BusinessArea 1
_ControllingArea _ControllingArea 1
_CostCenter _CostCenter 1
_GLAccount _GLAccount 1
_ProfitCenter _ProfitCenter 1
_SalesOrder _SalesOrder 1
_SalesOrderItem _SalesOrderItem 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 1
CommitmentItemShortID CommitmentItemShortID 1
ControllingArea ControllingArea 1
CostObject CostObject 1
EarmarkedFunds EarmarkedFunds 1
EarmarkedFundsItem EarmarkedFundsItem 1
FixedAsset FixedAsset 1
FunctionalArea FunctionalArea 1
Fund Fund 1
FundsCenter FundsCenter 1
GLAccount GLAccount 1
GrantID GrantID 1
MasterFixedAsset MasterFixedAsset 1
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 1
ProcessOrder ProcessOrder 1
ProfitabilitySegment ProfitabilitySegment 1
ProfitabilitySegment_2 ProfitabilitySegment_2 1
ProfitCenter ProfitCenter 1
ProjectNetwork ProjectNetwork 1
ProjectNetworkInternalID ProjectNetworkInternalID 1
PurReqnNetAmount PurReqnNetAmount 1
Quantity Quantity 1
SalesOrder SalesDocument,SalesOrder 3
SalesOrderItem SalesDocumentItem,SalesOrderItem 3
SalesOrderScheduleLine SalesOrderScheduleLine 1
UnloadingPointName UnloadingPointName 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 Requisition Account Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURREQNACCOUNTASSIGNMENT (
    COSTCENTER,
    PURCHASEREQNACCTASSGMTNUMBER,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    _BUSINESSAREA,
    _CONTROLLINGAREA,
    _COSTCENTER,
    _GLACCOUNT,
    _PROFITCENTER,
    _SALESORDER,
    _SALESORDERITEM,
    BUDGETPERIOD,
    BUSINESSAREA,
    COMMITMENTITEMSHORTID,
    CONTROLLINGAREA,
    COSTOBJECT,
    EARMARKEDFUNDS,
    EARMARKEDFUNDSITEM,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GRANTID,
    MASTERFIXEDASSET,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    PROCESSORDER,
    PROFITABILITYSEGMENT,
    PROFITABILITYSEGMENT_2,
    PROFITCENTER,
    PROJECTNETWORK,
    PROJECTNETWORKINTERNALID,
    PURREQNNETAMOUNT,
    QUANTITY,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERSCHEDULELINE,
    UNLOADINGPOINTNAME,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (COSTCENTER, PURCHASEREQNACCTASSGMTNUMBER, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More