C_DspDocFlwPurOrdAttrib

DDL: C_DSPDOCFLWPURORDATTRIB SQL: CDDFPURORDAT Type: view CONSUMPTION
12 Fields 1 Data Sources 2 Associations

Purchase Orders Attributes for DDF

C_DspDocFlwPurOrdAttrib is a Consumption CDS View that provides data about "Purchase Orders Attributes for DDF" in SAP S/4HANA. It reads from 1 data source (I_PurchasingDocument) and exposes 12 fields with key field PurchasingDocument. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_PurchasingDocument I_PurchasingDocument from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_PurchasingDocument _PurchasingDocument _PurchasingDocument.PurchasingDocument = $projection.PurchasingDocument
[0..1] I_PurchaseOrderNetAmount _PurchaseOrderNetAmount _PurchaseOrderNetAmount.PurchaseOrder = $projection.PurchasingDocument

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CDDFPURORDAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Orders Attributes for DDF view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument PurchasingDocument Purchasing Document
PurchasingDocumentType PurchasingDocumentType RFQ Type
PurchasingDocumentOrderDate PurchasingDocumentOrderDate PO Date
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
Supplier Supplier Supplier
CompanyCode CompanyCode Receiver Company Code
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
DocumentCurrency DocumentCurrency Document Currency
UI5NetworkGraphDescription
IsBusinessPurposeCompleted _Supplier IsBusinessPurposeCompleted Purpose Completed
_PurchasingDocument _PurchasingDocument

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_DspDocFlwPurOrdAttrib.
-- 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: CDDFPURORDAT

CREATE VIEW C_DspDocFlwPurOrdAttrib AS
SELECT
  PurchasingDocument,
  PurchasingDocumentType,
  PurchasingDocumentOrderDate,
  PurchasingGroup,
  PurchasingOrganization,
  Supplier,
  CompanyCode,
  PurchasingDocumentCategory,
  DocumentCurrency,
  cast ( _PurchasingDocumentType._Text[1:Language = $session.system_language].PurchasingDocumentTypeName as fac_network_graph_description) AS UI5NetworkGraphDescription,
  _Supplier.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_PurchasingDocument
LEFT OUTER JOIN I_PurchasingDocument AS _PurchasingDocument ON _PurchasingDocument.PurchasingDocument = PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderNetAmount AS _PurchaseOrderNetAmount ON _PurchaseOrderNetAmount.PurchaseOrder = PurchasingDocument  -- association [0..1]
;

Learn More