I_PURCHASEREQNACCTASSGMT

CDS View
55 Fields 5 CDS Views

Pur Reqn Acct Assgmt Basic View

I_PURCHASEREQNACCTASSGMT is a CDS View in S/4HANA. Pur Reqn Acct Assgmt Basic View. It contains 55 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_PPS_PurReqnAcctAsgtC view_entity from COMPOSITE PR Account Assignment - Cube
I_PurchaseReqnAcctAssgmtCount view from COMPOSITE Purchase Reqn Acct Assgmt Count
P_ProjProcmtPurReqnOrd view from COMPOSITE
P_RFM_SlsOrdPrgrsMntrPurReqn view from COMPOSITE
T_PurchaseReqnAcctAssgmt view from TRANSACTIONAL Pur Reqn Acct Assgmt Basic View

Fields (55)

KeyField CDS FieldsUsed in Views
KEY PurchaseRequisition PurchaseRequisition 3
KEY PurchaseRequisitionItem PurchaseRequisitionItem 3
KEY PurReqnAcctAssgmtNmbr PurReqnAcctAssgmtNmbr,PurReqnAcctAssgmtNmbrForEdit 1
KEY SalesOrder SalesOrder 2
KEY SalesOrderItem SalesOrderItem 2
BaseUnit BaseUnit 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 1
BusinessProcess BusinessProcess 1
ChartOfAccounts ChartOfAccounts 1
CommitmentItem CommitmentItem 1
CompanyCode CompanyCode 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostCtrActivityType CostCtrActivityType 1
CostElement CostElement 1
CostObject CostObject 1
CreationDate CreationDate 1
EarmarkedFundsDocument EarmarkedFundsDocument 1
EarmarkedFundsDocumentItem EarmarkedFundsDocumentItem 1
FixedAsset FixedAsset 1
FunctionalArea FunctionalArea 1
Fund Fund 1
FundedProgram FundedProgram 1
FundsCenter FundsCenter 1
GLAccount GLAccount 1
GoodsRecipientName GoodsRecipientName 1
GrantID GrantID 1
IsDeleted IsDeleted 1
JointVentureRecoveryCode JointVentureRecoveryCode 1
MasterFixedAsset MasterFixedAsset 1
MultipleAcctAssgmtDistrPercent MultipleAcctAssgmtDistrPercent 1
NetworkActivityInternalID NetworkActivityInternalID 1
OrderID OrderID 1
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 1
OrderInternalID OrderInternalID 1
PartnerAccountNumber PartnerAccountNumber 1
ProcessOrder ProcessOrder 1
ProfitabilitySegment ProfitabilitySegment 1
ProfitCenter ProfitCenter 2
ProjectNetwork ProjectNetwork 1
ProjectNetworkInternalID ProjectNetworkInternalID 1
PubSecSplitAuthznGroup PubSecSplitAuthznGroup 1
PubSecSplitBatchNumberID PubSecSplitBatchNumberID 1
PurReqnItemCurrency PurReqnItemCurrency 1
PurReqnNetAmount PurReqnNetAmount 1
Quantity Quantity 1
SalesDocumentItem SalesDocumentItem 1
SalesOrderScheduleLine SalesOrderScheduleLine 1
ScheduleLine ScheduleLine 1
SDDocument SDDocument 1
SettlementReferenceDate SettlementReferenceDate 1
UnloadingPointName UnloadingPointName 1
ValidityDate ValidityDate 1
WBSElement WBSElement 1

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.

-- Pur Reqn Acct Assgmt Basic View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURCHASEREQNACCTASSGMT (
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    PURREQNACCTASSGMTNMBR,
    SALESORDER,
    SALESORDERITEM,
    BASEUNIT,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    CHARTOFACCOUNTS,
    COMMITMENTITEM,
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    COSTELEMENT,
    COSTOBJECT,
    CREATIONDATE,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    GRANTID,
    ISDELETED,
    JOINTVENTURERECOVERYCODE,
    MASTERFIXEDASSET,
    MULTIPLEACCTASSGMTDISTRPERCENT,
    NETWORKACTIVITYINTERNALID,
    ORDERID,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALID,
    PARTNERACCOUNTNUMBER,
    PROCESSORDER,
    PROFITABILITYSEGMENT,
    PROFITCENTER,
    PROJECTNETWORK,
    PROJECTNETWORKINTERNALID,
    PUBSECSPLITAUTHZNGROUP,
    PUBSECSPLITBATCHNUMBERID,
    PURREQNITEMCURRENCY,
    PURREQNNETAMOUNT,
    QUANTITY,
    SALESDOCUMENTITEM,
    SALESORDERSCHEDULELINE,
    SCHEDULELINE,
    SDDOCUMENT,
    SETTLEMENTREFERENCEDATE,
    UNLOADINGPOINTNAME,
    VALIDITYDATE,
    WBSELEMENT,
    PRIMARY KEY (PURCHASEREQUISITION, PURCHASEREQUISITIONITEM, PURREQNACCTASSGMTNMBR, SALESORDER, SALESORDERITEM)
);

Learn More