P_SalesOrdersDeliveryDate

DDL: P_SALESORDERSDELIVERYDATE SQL: PGRCSODD Type: view COMPOSITE Package: FINS_FIS_GRC_APPS
34 Fields 1 Data Sources 1 Associations

Delivery Date for Sales Order

P_SalesOrdersDeliveryDate is a Composite CDS View that provides data about "Delivery Date for Sales Order" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentScheduleLine) and exposes 34 fields with key fields SalesDocument, SalesDocumentItem, ScheduleLine. It has 1 association to related views. Part of development package FINS_FIS_GRC_APPS.

Data Sources (1)

SourceAliasJoin Type
I_SalesDocumentScheduleLine I_SalesDocumentScheduleLine from

Parameters (1)

NameTypeDefault
P_StartDate edatu

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SalesDocumentItem _SalesDocumentItem $projection.SalesDocument = _SalesDocumentItem.SalesDocument and $projection.SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName PGRCSODD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Delivery Date for Sales Order view
VDM.viewType #COMPOSITE view
VDM.private true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY SalesDocument SalesDocument SD Document
KEY SalesDocumentItem SalesDocumentItem Sales Document Item
KEY ScheduleLine ScheduleLine Schedule Line
SalesDocumentItemText _SalesDocumentItem SalesDocumentItemText Item Descr.
SalesDocumentItemUUID _SalesDocumentItem SalesDocumentItemUUID
SDDocumentCategory _SalesDocumentItem SDDocumentCategory Document Cat.
SalesDocumentItemCategory _SalesDocumentItem SalesDocumentItemCategory Item Category
SalesDocumentItemType _SalesDocumentItem SalesDocumentItemType
IsReturnsItem _SalesDocumentItem IsReturnsItem Returns Item
CompletionRule _SalesDocumentItem CompletionRule
CreatedByUser _SalesDocumentItem CreatedByUser User Name
CreationDate _SalesDocumentItem CreationDate Time Stamp
CreationTime _SalesDocumentItem CreationTime Time of Change
LastChangeDate _SalesDocumentItem LastChangeDate Time Stamp
Division _SalesDocumentItem Division Internal Division ID
Product _SalesDocumentItem Product Product Sold
SalesDocumentType _SalesDocumentItem SalesDocumentType Sales Doc. Type
OrganizationDivision _SalesDocumentItem OrganizationDivision Org. Division
SalesOrganization _SalesDocumentItem SalesOrganization Sales Organization
DistributionChannel _SalesDocumentItem DistributionChannel RefDistCh-Cust/Mat.
DeliveryDate DeliveryDate Delivery Date
CurrentDate
DeliveryDateOffsetInDays
_SalesDocumentItem _SalesDocumentItem
_Product _SalesDocumentItem _Product
_SalesDocument _SalesDocument
_SDDocumentCategory _SalesDocumentItem _SDDocumentCategory
_ItemCategory _SalesDocumentItem _ItemCategory
_Division _SalesDocumentItem _Division
_SalesDocumentType _SalesDocumentItem _SalesDocumentType
_OrganizationDivision _SalesDocumentItem _OrganizationDivision
_SalesOrganization _SalesDocumentItem _SalesOrganization
_DistributionChannel _SalesDocumentItem _DistributionChannel
_ProductText _SalesDocumentItem _ProductText

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_SalesOrdersDeliveryDate.
-- 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: PGRCSODD
-- Parameters: P_StartDate : edatu

CREATE VIEW P_SalesOrdersDeliveryDate AS
SELECT
  SalesDocument,
  SalesDocumentItem,
  ScheduleLine,
  _SalesDocumentItem.SalesDocumentItemText AS SalesDocumentItemText,
  _SalesDocumentItem.SalesDocumentItemUUID AS SalesDocumentItemUUID,
  _SalesDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  _SalesDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  _SalesDocumentItem.SalesDocumentItemType AS SalesDocumentItemType,
  _SalesDocumentItem.IsReturnsItem AS IsReturnsItem,
  _SalesDocumentItem.CompletionRule AS CompletionRule,
  _SalesDocumentItem.CreatedByUser AS CreatedByUser,
  _SalesDocumentItem.CreationDate AS CreationDate,
  _SalesDocumentItem.CreationTime AS CreationTime,
  _SalesDocumentItem.LastChangeDate AS LastChangeDate,
  _SalesDocumentItem.Division AS Division,
  _SalesDocumentItem.Product AS Product,
  _SalesDocumentItem.SalesDocumentType AS SalesDocumentType,
  _SalesDocumentItem.OrganizationDivision AS OrganizationDivision,
  _SalesDocumentItem.SalesOrganization AS SalesOrganization,
  _SalesDocumentItem.DistributionChannel AS DistributionChannel,
  DeliveryDate,
  $parameters.P_StartDate AS CurrentDate,
  dats_days_between (DeliveryDate, $parameters.P_StartDate) AS DeliveryDateOffsetInDays,
  _SalesDocumentItem._Product AS _Product,
  _SalesDocumentItem._SDDocumentCategory AS _SDDocumentCategory,
  _SalesDocumentItem._ItemCategory AS _ItemCategory,
  _SalesDocumentItem._Division AS _Division,
  _SalesDocumentItem._SalesDocumentType AS _SalesDocumentType,
  _SalesDocumentItem._OrganizationDivision AS _OrganizationDivision,
  _SalesDocumentItem._SalesOrganization AS _SalesOrganization,
  _SalesDocumentItem._DistributionChannel AS _DistributionChannel,
  _SalesDocumentItem._ProductText AS _ProductText
FROM I_SalesDocumentScheduleLine
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesDocument = _SalesDocumentItem.SalesDocument AND SalesDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
;

Learn More