I_PURREQNSSPACCTASSGMT

CDS View
43 Fields 1 CDS Views

Purchase Requisition Account Assignment

I_PURREQNSSPACCTASSGMT is a CDS View in S/4HANA. Purchase Requisition Account Assignment. It contains 43 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PurReqnAccAssignment_WD view from TRANSACTIONAL Pur Reqn Account Assignment BO View

Fields (43)

KeyField CDS FieldsUsed in Views
KEY PurchaseReqnAcctAssgmtNumber AccountAssignmentNumber 1
KEY PurchaseRequisition PurchaseRequisition 1
KEY PurchaseRequisitionItem PurchaseRequisitionItem 1
BaseUnit BaseUnit 1
BudgetPeriod BudgetPeriod 1
BusinessArea BusinessArea 1
BusinessProcess BusinessProcess 1
CommitmentItem CommitmentItem 1
CommitmentItemShortID CommitmentItemShortID 1
ControllingArea ControllingArea 1
CostCenter CostCenter 1
CostCtrActivityType CostCtrActivityType 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
MasterFixedAsset MasterFixedAsset 1
NetworkActivityInternalID NetworkActivityInternalID 1
OrderID OrderID 1
OrderIntBillOfOperationsItem OrderIntBillOfOperationsItem 1
OrderInternalID OrderInternalID 1
ProcmtHubWBSElementExternalID ProcmtHubWBSElementExternalID 1
ProfitabilitySegment ProfitabilitySegment 1
ProfitCenter ProfitCenter 1
ProjectNetwork ProjectNetwork 1
ProjectNetworkInternalID ProjectNetworkInternalID 1
PurReqnItemCurrency PurReqnItemCurrency 1
PurReqnNetAmount PurReqnNetAmount 1
Quantity Quantity 1
SalesDocumentItem SalesDocumentItem 1
ScheduleLine ScheduleLine 1
SDDocument SDDocument 1
ServiceDocID ServiceDocID 1
ServiceDocItemID ServiceDocItemID 1
ServiceDocumentType ServiceDocumentType 1
UnloadingPointName UnloadingPointName 1
WBSElementInternalID WBSElementInternalID 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.

-- Purchase Requisition Account Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PURREQNSSPACCTASSGMT (
    PURCHASEREQNACCTASSGMTNUMBER,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    BASEUNIT,
    BUDGETPERIOD,
    BUSINESSAREA,
    BUSINESSPROCESS,
    COMMITMENTITEM,
    COMMITMENTITEMSHORTID,
    CONTROLLINGAREA,
    COSTCENTER,
    COSTCTRACTIVITYTYPE,
    EARMARKEDFUNDSDOCUMENT,
    EARMARKEDFUNDSDOCUMENTITEM,
    FIXEDASSET,
    FUNCTIONALAREA,
    FUND,
    FUNDEDPROGRAM,
    FUNDSCENTER,
    GLACCOUNT,
    GOODSRECIPIENTNAME,
    GRANTID,
    MASTERFIXEDASSET,
    NETWORKACTIVITYINTERNALID,
    ORDERID,
    ORDERINTBILLOFOPERATIONSITEM,
    ORDERINTERNALID,
    PROCMTHUBWBSELEMENTEXTERNALID,
    PROFITABILITYSEGMENT,
    PROFITCENTER,
    PROJECTNETWORK,
    PROJECTNETWORKINTERNALID,
    PURREQNITEMCURRENCY,
    PURREQNNETAMOUNT,
    QUANTITY,
    SALESDOCUMENTITEM,
    SCHEDULELINE,
    SDDOCUMENT,
    SERVICEDOCID,
    SERVICEDOCITEMID,
    SERVICEDOCUMENTTYPE,
    UNLOADINGPOINTNAME,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (PURCHASEREQNACCTASSGMTNUMBER, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More