P_PURREQNITMACCOUNTASSIGNMENT

CDS View
6 Fields 2 CDS Views

PR Item Account Assignment

P_PURREQNITMACCOUNTASSIGNMENT is a CDS View in S/4HANA. PR Item Account Assignment. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_PurReqnItm view from CONSUMPTION Purchase Requisition Item details
P_PurReqnItmOverview view from CONSUMPTION Purchase Requisition Item Overview

Fields (6)

KeyField CDS FieldsUsed in Views
KEY PurchaseReqnAcctAssgmtNumber PurchaseReqnAcctAssgmtNumber 2
KEY PurchaseRequisition PurchaseRequisition 1
KEY PurchaseRequisitionItem PurchaseRequisitionItem 1
CostCenter CostCenter 2
SalesOrder SalesOrder 2
WBSElementExternalID WBSElementExternalID 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.

-- PR Item Account Assignment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_PURREQNITMACCOUNTASSIGNMENT (
    PURCHASEREQNACCTASSGMTNUMBER,
    PURCHASEREQUISITION,
    PURCHASEREQUISITIONITEM,
    COSTCENTER,
    SALESORDER,
    WBSELEMENTEXTERNALID,
    PRIMARY KEY (PURCHASEREQNACCTASSGMTNUMBER, PURCHASEREQUISITION, PURCHASEREQUISITIONITEM)
);

Learn More