P_SlsOrderInSupplyPurgIssue2

DDL: P_SLSORDERINSUPPLYPURGISSUE2 SQL: PSOFISSUESU012V2 Type: view COMPOSITE Package: VDM_SD_SOF
16 Fields 1 Data Sources

SOFM Purchasing Issue 2 V2

P_SlsOrderInSupplyPurgIssue2 is a Composite CDS View that provides data about "SOFM Purchasing Issue 2 V2" in SAP S/4HANA. It reads from 1 data source (P_SlsOrderInSupplyPurgIssue3) and exposes 16 fields with key fields PurchasingDocument, PurchasingDocumentItem. Part of development package VDM_SD_SOF.

Data Sources (1)

SourceAliasJoin Type
P_SlsOrderInSupplyPurgIssue3 P_SlsOrderInSupplyPurgIssue3 from

Annotations (10)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PSOFISSUESU012V2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem PurchasingDocumentItem Purchasing Doc. Item
SalesDocument SalesDocument SD Document
SalesDocumentItem SalesDocumentItem Sales Document Item
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
OrganizationDivision OrganizationDivision Org. Division
SalesDocumentType SalesDocumentType Sales Doc. Type
RequestedDeliveryDate RequestedDeliveryDate Requested Delivery Date
OverallSDProcessStatus OverallSDProcessStatus
SalesDocumentDate SalesDocumentDate Document Date
SalesGroup SalesGroup Sales Group
SalesOffice SalesOffice Sales Office
SoldToParty SoldToParty Sold-to Party
PurchaseOrderByCustomer
DeliveryDate DeliveryDate Delivery Date

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_SlsOrderInSupplyPurgIssue2.
-- 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: PSOFISSUESU012V2

CREATE VIEW P_SlsOrderInSupplyPurgIssue2 AS
SELECT
  PurchasingDocument,
  PurchasingDocumentItem,
  SalesDocument,
  SalesDocumentItem,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesDocumentType,
  RequestedDeliveryDate,
  OverallSDProcessStatus,
  SalesDocumentDate,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  DeliveryDate
FROM P_SlsOrderInSupplyPurgIssue3
;

Learn More