I_PURREQNACCTASSGMT

CDS View
68 Fields 17 CDS Views

Purchase Requisition Account Assignment

I_PURREQNACCTASSGMT is a CDS View in S/4HANA. Purchase Requisition Account Assignment. It contains 68 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
A_PurReqnAcctAssgmt view from COMPOSITE Account Assignment
C_PurReqnAccountAssignment view from CONSUMPTION Purchase Requisition Account Assignment
I_MstrProjPurchaseRequisition view from COMPOSITE Purchase Requisition for Commercial Proj
I_MstrProjPurchaseRequisition view union COMPOSITE Purchase Requisition for Commercial Proj
I_MstrProjPurReqItemSimple view inner COMPOSITE Simplified PR Items for Master Project
I_PurchaseReqnAcctAssgmt view from COMPOSITE Pur Reqn Acct Assgmt Basic View
I_PurReqnAcctAssgmt_Api01 view from COMPOSITE Account Assgmt in Purchase Requisition
I_PurReqnAcctAssgmtAPI01 view from COMPOSITE Account Assgmt in Purchase Requisition
I_PurReqnAcctAssignmentWrkItm view from COMPOSITE Pur Reqn Account Assignment Basic view
I_PurReqnHdrItmAcAsWrkItm view from COMPOSITE PR Header Approval Account Assignment
I_PurReqnSSPAcctAssgmt view from COMPOSITE Purchase Requisition Account Assignment
P_MaintBacklogNonStkCompUnion view inner CONSUMPTION Maintenance Backlog Non Stock Component Union
P_MaintBacklogServiceUnion view inner CONSUMPTION
P_MaintOrdDirectProcmtViaPR view union_all COMPOSITE
P_MaintOrdNonStkCompFrmPurReqn view from CONSUMPTION
P_ProjPurDocItems view from COMPOSITE
R_PurchaseReqnAcctAssgmtTP view_entity from TRANSACTIONAL Purchase Requisition Account Assignment

Fields (68)

KeyField CDS FieldsUsed in Views
KEY MasterProject MasterProject 1
KEY PurchaseReqnAcctAssgmtNumber AccountAssignmentNumber,PurchaseReqnAcctAssgmtNumber 8
KEY PurchaseRequisition PurchaseRequisition,PurchasingDocument 13
KEY PurchaseRequisitionItem PurchaseRequisitionItem,PurchasingDocumentItem 14
_BusinessArea _BusinessArea 1
_BusinessAreaText _BusinessAreaText 1
BudgetPeriod BudgetPeriod 2
BusinessArea BusinessArea 6
BusinessProcess BusinessProcess 5
ChartOfAccounts ChartOfAccounts 5
CommitmentItem CommitmentItem 1
CommitmentItemShortID CommitmentItemShortID 3
ControllingArea ControllingArea 6
ControllingObjectDescription ControllingObjectDescription 1
CostCenter CostCenter 6
CostCtrActivityType CostCtrActivityType 6
CostElement CostElement 4
CostObject CostObject 6
CreationDate CreationDate 6
EarmarkedFundsDocument EarmarkedFundsDocument 6
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem 3
ExtNetworkActivityForPurg ExtNetworkActivityForPurg 2
FixedAsset FixedAsset 6
FunctionalArea FunctionalArea 6
Fund Fund 6
FundsCenter FundsCenter 6
GLAccount GLAccount 6
GoodsRecipientName GoodsRecipientName 6
GrantID GrantID 6
IsDeleted IsDeleted 6
JointVentureRecoveryCode JointVentureRecoveryCode 6
MasterFixedAsset MasterFixedAsset 6
MasterProjectName MasterProjectName 1
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent,PurReqnAcctAssgmtDistrPct 6
NetworkActivity NetworkActivity 4
NetworkActivityDescription NetworkActivityDescription 1
NetworkActivityInternalID MaintOrderOperationCounter,NetworkActivityInternalID 10
OrderID MaintenanceOrder,OrderID 7
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 7
OrderInternalID MaintOrderRoutingNumber,OrderInternalID 7
PartnerAccountNumber PartnerAccountNumber 6
ProcessOrder ProcessOrder 5
ProcmtHubWBSElementExternalID AssignedWBSElementExternalID,ProcmtHubWBSElementExternalID 4
ProfitabilitySegment PrmtHbProfitabilitySegment,ProfitabilitySegment 3
ProfitCenter ProfitCenter 6
ProjectNetwork ProjectNetwork 7
ProjectNetworkDescription ProjectNetworkDescription 1
ProjectNetworkInternalID ProjectNetworkInternalID 9
PurReqnNetAmount PurReqnNetAmount 5
Quantity Quantity 6
RealEstateObject RealEstateObject 1
SalesDocumentItem SalesDocumentItem 4
SalesOrder SalesOrder 6
SalesOrderItem SalesOrderItem 6
SalesOrderScheduleLine SalesOrderScheduleLine 6
ScheduleLine ScheduleLine 4
SDDocument SDDocument 4
ServiceDocID ServiceDocID 3
ServiceDocItemID ServiceDocItemID 3
ServiceDocumentType ServiceDocumentType 3
SettlementReferenceDate SettlementReferenceDate 6
UnloadingPointName UnloadingPointName 6
ValidityDate ValidityDate 6
WBSDescription WBSDescription 1
WBSElement WBSElement 3
WBSElementExternalID_2 WBSElementExternalID,WBSElementExternalID_2 2
WBSElementInternalID WBSElementInternalID 4
WBSElementInternalID_2 WBSElementInternalID,WBSElementInternalID_2 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_PURREQNACCTASSGMT (
    MASTERPROJECT,
    PURCHASEREQNACCTASSGMTNUMBER,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    _BUSINESSAREA,
    _BUSINESSAREATEXT,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    COMMITMENTITEM,
    COMMITMENTITEMSHORTID,
    CONTROLLINGAREA,
    CONTROLLINGOBJECTDESCRIPTION,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTELEMENT,
    COSTOBJECT,
    CREATIONDATE,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    EXTNETWORKACTIVITYFORPURG,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    GRANTID,
    ISDELETED,
    JOINTVENTURERECOVERYCODE,
    MASTERFIXEDASSET,
    MASTERPROJECTNAME,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    NETWORKACTIVITY,
    NETWORKACTIVITYDESCRIPTION,
    NETWORKACTIVITYINTERNALID,
    ORDERID,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALID,
    PARTNERACCOUNTNUMBER,
    PROCESSORDER,
    PROCMTHUBWBSELEMENTEXTERNALID,
    PROFITABILITYSEGMENT,
    PROFITCENTER,
    PROJECTNETWORK,
    PROJECTNETWORKDESCRIPTION,
    PROJECTNETWORKINTERNALID,
    PURREQNNETAMOUNT,
    QUANTITY,
    REALESTATEOBJECT,
    SALESDOCUMENTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESORDERSCHEDULELINE,
    SCHEDULELINE,
    SDDOCUMENT,
    SERVICEDOCID,
    SERVICEDOCITEMID,
    SERVICEDOCUMENTTYPE,
    SETTLEMENTREFERENCEDATE,
    UNLOADINGPOINTNAME,
    VALIDITYDATE,
    WBSDESCRIPTION,
    WBSELEMENT,
    WBSELEMENTEXTERNALID_2,
    WBSELEMENTINTERNALID,
    WBSELEMENTINTERNALID_2,
    PRIMARY KEY (MASTERPROJECT, PURCHASEREQNACCTASSGMTNUMBER, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More