Deprecated
This CDS view is deprecated in S/4HANA. Use C_ProductObjPgPurchaseOrder instead. View all deprecated CDS views →

C_Purchaseorders_Fs

DDL: C_PURCHASEORDERS_FS SQL: CPRCHORDERS Type: view CONSUMPTION
24 Fields 1 Data Sources 1 Associations

Consumption Factsheet-Purchase Ord Facet

C_Purchaseorders_Fs is a Consumption CDS View that provides data about "Consumption Factsheet-Purchase Ord Facet" in SAP S/4HANA. It reads from 1 data source (P_Purchaseorders_Fs) and exposes 24 fields with key field PurchasingDocument. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_Purchaseorders_Fs Purchaseorders from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_Product_Fs _Product $projection.Material = _Product.Material

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CPRCHORDERS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label Consumption Factsheet-Purchase Ord Facet view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName PurchaseOrd view
UI.headerInfo.typeNamePlural PurchaseOrds view
UI.headerInfo.title.value PurchasingDocument view
UI.headerInfo.title.label PurchaseOrder view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
Search.searchable true view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor C_ProductObjPgPurchaseOrder view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument P_Purchaseorders_Fs PurchasingDocument Purchasing Document
CompanyCode P_Purchaseorders_Fs CompanyCode Receiver Company Code
Material P_Purchaseorders_Fs Material Vehicle Model
CompanyCodeName P_Purchaseorders_Fs CompanyCodeName Company Name
PurchasingDocumentDeletionCode P_Purchaseorders_Fs PurchasingDocumentDeletionCode Del. Indicator
IncotermsClassification P_Purchaseorders_Fs IncotermsClassification Incoterms
IncotermsTransferLocation P_Purchaseorders_Fs IncotermsTransferLocation Incoterms 2
PurchasingGroup P_Purchaseorders_Fs PurchasingGroup Purchasing Group
PurchasingOrganization P_Purchaseorders_Fs PurchasingOrganization Purchasing Organization
Supplier P_Purchaseorders_Fs Supplier Supplier
SupplyingPlant P_Purchaseorders_Fs SupplyingPlant Supplying Plant
PaymentTerms P_Purchaseorders_Fs PaymentTerms Pyt Terms
PurchaseContract P_Purchaseorders_Fs PurchaseContract Purchasing Doc.
CreationDate P_Purchaseorders_Fs CreationDate Time Stamp
CreatedByUser P_Purchaseorders_Fs CreatedByUser User Name
DocumentCurrency P_Purchaseorders_Fs DocumentCurrency Document Currency
PurchasingDocumentOrderDate P_Purchaseorders_Fs PurchasingDocumentOrderDate PO Date
PurchasingGroupName P_Purchaseorders_Fs PurchasingGroupName Purchasing Grp. Name
PurchasingOrganizationName P_Purchaseorders_Fs PurchasingOrganizationName Purch. Org. Name
SupplierName P_Purchaseorders_Fs SupplierName Supplier Name
PersonFullName P_Purchaseorders_Fs PersonFullName Full Name
PurchasingDocumentTypeName P_Purchaseorders_Fs PurchasingDocumentTypeName Description
PlantName P_Purchaseorders_Fs PlantName Plant Name
_Product _Product

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_Purchaseorders_Fs.
-- 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: CPRCHORDERS

CREATE VIEW C_Purchaseorders_Fs AS
SELECT
  Purchaseorders.PurchasingDocument AS PurchasingDocument,
  Purchaseorders.CompanyCode AS CompanyCode,
  Purchaseorders.Material AS Material,
  Purchaseorders.CompanyCodeName AS CompanyCodeName,
  Purchaseorders.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Purchaseorders.IncotermsClassification AS IncotermsClassification,
  Purchaseorders.IncotermsTransferLocation AS IncotermsTransferLocation,
  Purchaseorders.PurchasingGroup AS PurchasingGroup,
  Purchaseorders.PurchasingOrganization AS PurchasingOrganization,
  Purchaseorders.Supplier AS Supplier,
  Purchaseorders.SupplyingPlant AS SupplyingPlant,
  Purchaseorders.PaymentTerms AS PaymentTerms,
  Purchaseorders.PurchaseContract AS PurchaseContract,
  Purchaseorders.CreationDate AS CreationDate,
  Purchaseorders.CreatedByUser AS CreatedByUser,
  Purchaseorders.DocumentCurrency AS DocumentCurrency,
  Purchaseorders.PurchasingDocumentOrderDate AS PurchasingDocumentOrderDate,
  Purchaseorders.PurchasingGroupName AS PurchasingGroupName,
  Purchaseorders.PurchasingOrganizationName AS PurchasingOrganizationName,
  Purchaseorders.SupplierName AS SupplierName,
  Purchaseorders.PersonFullName AS PersonFullName,
  Purchaseorders.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  Purchaseorders.PlantName AS PlantName
FROM P_Purchaseorders_Fs AS Purchaseorders
LEFT OUTER JOIN C_Product_Fs AS _Product ON Material = _Product.Material  -- association [1..1]
;

Learn More