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

P_SuplrConfDelivDate

DDL: P_SUPLRCONFDELIVDATE SQL: PSCONFDELIVDATE Type: view CONSUMPTION Package: ODATA_MM_PUR_SUPLRCONF_MNTR
14 Fields 1 Data Sources

Private View for Delivery Date VF

P_SuplrConfDelivDate is a Consumption CDS View that provides data about "Private View for Delivery Date VF" in SAP S/4HANA. It reads from 1 data source (P_DELIVDATECALCU) and exposes 14 fields with key fields PurchasingDocument, PurchasingDocumentItem. Part of development package ODATA_MM_PUR_SUPLRCONF_MNTR.

Data Sources (1)

SourceAliasJoin Type
P_DELIVDATECALCU P_DELIVDATECALCU from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PSCONFDELIVDATE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Private View for Delivery Date VF view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.status #DEPRECATED view
VDM.lifecycle.successor P_purgdocconf view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY PurchasingDocument _DelivDateCalc PurchasingDocument Purchasing Document
KEY PurchasingDocumentItem _DelivDateCalc PurchasingDocumentItem Purchasing Doc. Item
ScheduleLineDeliveryDate _DelivDateCalc ScheduleLineDeliveryDate Delivery Date
SupplierConfirmationCategory _DelivDateCalc SupplierConfirmationCategory Confirm. Cat.
ScheduleLine _DelivDateCalc ScheduleLine Schedule Line
OrderedQuantity _DelivDateCalc OrderedQuantity Quantity
BalanceQuantity _DelivDateCalc BalanceQuantity Balance Quantity
Supplier _DelivDateCalc Supplier Supplier
_Supplier _DelivDateCalc _Supplier
char10asDurationToNextStatusInDays
syatemdate
SupplierAccountGroup SupplierAccountGroup Account group
AuthorizationGroup AuthorizationGroup AuthorizGroup
Plant Plant Valuation Area

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_SuplrConfDelivDate.
-- 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: PSCONFDELIVDATE

CREATE VIEW P_SuplrConfDelivDate AS
SELECT
  _DelivDateCalc.PurchasingDocument AS PurchasingDocument,
  _DelivDateCalc.PurchasingDocumentItem AS PurchasingDocumentItem,
  _DelivDateCalc.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _DelivDateCalc.SupplierConfirmationCategory AS SupplierConfirmationCategory,
  _DelivDateCalc.ScheduleLine AS ScheduleLine,
  _DelivDateCalc.OrderedQuantity AS OrderedQuantity,
  _DelivDateCalc.BalanceQuantity AS BalanceQuantity,
  _DelivDateCalc.Supplier AS Supplier,
  _DelivDateCalc._Supplier AS _Supplier,
  cast( case when _DelivDateCalc.DurationToNextStatusInDays < _DelivDateCalc.weekday1 and _DelivDateCalc.DurationToNextStatusInDays >= 0 then '2' when _DelivDateCalc.DurationToNextStatusInDays > _DelivDateCalc.weekday1 then '3' else '1' end as abap.char( 10 ) ) as DurationToNextStatusInDays AS char10asDurationToNextStatusInDays,
  $session.system_date AS syatemdate,
  SupplierAccountGroup,
  AuthorizationGroup,
  Plant
FROM P_DELIVDATECALCU
;

Learn More