C_SlsOrdFlfmtPurchaseOrderQ

DDL: C_SLSORDFLFMTPURCHASEORDERQ SQL: CSOFPURORDQ Type: view CONSUMPTION Package: VDM_SD_SOF_OLD
12 Fields 1 Data Sources

SOFM Purchase Order Query

C_SlsOrdFlfmtPurchaseOrderQ is a Consumption CDS View that provides data about "SOFM Purchase Order Query" in SAP S/4HANA. It reads from 1 data source (I_SlsOrdFlfmtPurchaseOrder) and exposes 12 fields with key field PurchasingDocument. Part of development package VDM_SD_SOF_OLD.

Data Sources (1)

SourceAliasJoin Type
I_SlsOrdFlfmtPurchaseOrder I_SlsOrdFlfmtPurchaseOrder from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label SOFM Purchase Order Query view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.sqlViewName CSOFPURORDQ view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingDocumentTypeName
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName PurchasingGroupName Purchasing Grp. Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName PurchasingOrganizationName Purch. Org. Name
PurchasingDocumentOrderDate PurchaseOrderDate PO Date
Supplier Supplier Supplier
SupplierName SupplierName Supplier Name
PurchasingDocumentStatus PurchasingDocumentStatus Short Description
PurchasingDocumentStatusName

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 C_SlsOrdFlfmtPurchaseOrderQ.
-- 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: CSOFPURORDQ
-- Parameters: P_Language : sylangu

CREATE VIEW C_SlsOrdFlfmtPurchaseOrderQ AS
SELECT
  PurchasingDocument,
  PurchasingDocumentType,
  _PurchasingDocumentType._Text[1: Language=$parameters.P_Language].PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  PurchasingGroup,
  PurchasingGroupName,
  PurchasingOrganization,
  PurchasingOrganizationName,
  PurchaseOrderDate AS PurchasingDocumentOrderDate,
  Supplier,
  SupplierName,
  PurchasingDocumentStatus,
  _Status._Text[1: Language=$parameters.P_Language].PurchasingDocumentStatusName AS PurchasingDocumentStatusName
FROM I_SlsOrdFlfmtPurchaseOrder
;

Learn More