P_ConfirmationDate

DDL: P_CONFIRMATIONDATE SQL: PCONFDATE Type: view CONSUMPTION
4 Fields 1 Data Sources

Confirmation Date calculation

P_ConfirmationDate is a Consumption CDS View that provides data about "Confirmation Date calculation" in SAP S/4HANA. It reads from 1 data source (I_PurgDocSupplierConfirmation) and exposes 4 fields with key fields PurchasingDocument, PurchasingDocumentItem.

Data Sources (1)

SourceAliasJoin Type
I_PurgDocSupplierConfirmation PurgDocSupplierConfirmation1 from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCONFDATE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Confirmation Date calculation view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument I_PurgDocSupplierConfirmation PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem I_PurgDocSupplierConfirmation PurchasingDocumentItem Purchasing Doc. Item
SupplierConfirmationCategory I_PurgDocSupplierConfirmation SupplierConfirmationCategory Confirm. Cat.
OrderConfirmationDate

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_ConfirmationDate.
-- 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: PCONFDATE

CREATE VIEW P_ConfirmationDate AS
SELECT
  PurgDocSupplierConfirmation1.PurchasingDocument AS PurchasingDocument,
  PurgDocSupplierConfirmation1.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurgDocSupplierConfirmation1.SupplierConfirmationCategory AS SupplierConfirmationCategory,
  max(PurgDocSupplierConfirmation1.DeliveryDate) AS OrderConfirmationDate
FROM I_PurgDocSupplierConfirmation AS PurgDocSupplierConfirmation1
;

Learn More