P_WrkDistrDoc

DDL: P_WRKDISTRDOC SQL: PWRKUNIDOC Type: view CONSUMPTION
21 Fields 2 Data Sources

P_WrkDistrDoc is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_WrkDistrPurDoc, P_WrkDistrPurReqn) and exposes 21 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (2)

SourceAliasJoin Type
P_WrkDistrPurDoc P_WrkDistrPurDoc from
P_WrkDistrPurReqn P_WrkDistrPurReqn union_all

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PWRKUNIDOC view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument P_WrkDistrPurDoc PurchasingDocument Purchasing Document
PurchasingDocumentItem P_WrkDistrPurDoc PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentType P_WrkDistrPurDoc PurchasingDocumentType RFQ Type
PurchasingDocumentCategory P_WrkDistrPurDoc PurchasingDocumentCategory Doc. Category
PurchasingOrganization P_WrkDistrPurDoc PurchasingOrganization Purchasing Organization
PurchasingGroup P_WrkDistrPurDoc PurchasingGroup Purchasing Group
PurchasingGroupName P_WrkDistrPurDoc PurchasingGroupName Purchasing Grp. Name
PurchasingOrganizationName P_WrkDistrPurDoc PurchasingOrganizationName Purch. Org. Name
CreationDate P_WrkDistrPurDoc CreationDate Time Stamp
PurchasingDocumentCategoryName
PurchasingDocumentasPurchasingDocument
KEY PurchasingDocumentItem P_WrkDistrPurReqn PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentType P_WrkDistrPurReqn PurchasingDocumentType RFQ Type
PurchasingDocumentCategory P_WrkDistrPurReqn PurchasingDocumentCategory Doc. Category
PurchasingOrganization P_WrkDistrPurReqn PurchasingOrganization Purchasing Organization
PurchasingGroup P_WrkDistrPurReqn PurchasingGroup Purchasing Group
PurchasingGroupName P_WrkDistrPurReqn PurchasingGroupName Purchasing Grp. Name
PurchasingOrganizationName P_WrkDistrPurReqn PurchasingOrganizationName Purch. Org. Name
CreationDate P_WrkDistrPurReqn CreationDate Time Stamp
PurchasingDocumentCategoryName
PurchasingDocumentTypeName

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_WrkDistrDoc.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: PWRKUNIDOC

CREATE VIEW P_WrkDistrDoc AS
SELECT
  P_WrkDistrPurDoc.PurchasingDocument AS PurchasingDocument,
  P_WrkDistrPurDoc.PurchasingDocumentItem AS PurchasingDocumentItem,
  P_WrkDistrPurDoc.PurchasingDocumentType AS PurchasingDocumentType,
  P_WrkDistrPurDoc.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  P_WrkDistrPurDoc.PurchasingOrganization AS PurchasingOrganization,
  P_WrkDistrPurDoc.PurchasingGroup AS PurchasingGroup,
  P_WrkDistrPurDoc.PurchasingGroupName AS PurchasingGroupName,
  P_WrkDistrPurDoc.PurchasingOrganizationName AS PurchasingOrganizationName,
  P_WrkDistrPurDoc.CreationDate AS CreationDate,
  P_WrkDistrPurDoc._PurchasingDocumentCatText.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  P_WrkDistrPurDoc._PurchasingDocumentTypeText.PurchasingDocumentTypeName as PurchasingDocumentTypeName AS PurchasingDocumentasPurchasingDocument,
  P_WrkDistrPurReqn._PurchasingDocumentTypeText.PurchasingDocumentTypeName AS PurchasingDocumentTypeName
FROM P_WrkDistrPurDoc
-- UNION ALL with additional select branch(es): P_WrkDistrPurReqn
;

Learn More