I_DelivWthRefQuickCreate

DDL: I_DELIVWTHREFQUICKCREATE SQL: IDELIVWREFQC Type: view BASIC
18 Fields 1 Data Sources

Quick Create Deliv with reference TP

I_DelivWthRefQuickCreate is a Basic CDS View that provides data about "Quick Create Deliv with reference TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 18 fields with key field OutboundDelivery.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument DeliveryDocument from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IDELIVWREFQC view
VDM.viewType #BASIC view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.compositionRoot true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Quick Create Deliv with reference TP view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery I_DeliveryDocument DeliveryDocument Outbound Delivery
ReferenceSDDocument
ShippingPoint I_DeliveryDocument ShippingPoint Shipping Point
DeliveryDate
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType Delivery Type
SalesOrganization I_DeliveryDocument SalesOrganization Sales Organization
DistributionChannel _DeliveryDocumentItem DistributionChannel RefDistCh-Cust/Mat.
Division _DeliveryDocumentItem Division Internal Division ID
ShipToParty I_DeliveryDocument ShipToParty Ship-To Party (obsolete)
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate Planned Gds Mvmt
ReferenceDocument _DeliveryDocumentItem ReferenceSDDocument Reference Doc.
_ShippingPoint _ShippingPoint
_DeliveryDocumentType _DeliveryDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DeliveryDocumentItem _DistributionChannel
_Division _DeliveryDocumentItem _Division
_ShipToParty _ShipToParty
_ReferenceSDDocument _DeliveryDocumentItem _ReferenceSDDocument

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 I_DelivWthRefQuickCreate.
-- 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: IDELIVWREFQC

CREATE VIEW I_DelivWthRefQuickCreate AS
SELECT
  DeliveryDocument.DeliveryDocument AS OutboundDelivery,
  cast ('' as vgbel) AS ReferenceSDDocument,
  DeliveryDocument.ShippingPoint AS ShippingPoint,
  cast ($session.system_date as datum) AS DeliveryDate,
  DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  DeliveryDocument.SalesOrganization AS SalesOrganization,
  _DeliveryDocumentItem.DistributionChannel AS DistributionChannel,
  _DeliveryDocumentItem.Division AS Division,
  DeliveryDocument.ShipToParty AS ShipToParty,
  DeliveryDocument.PlannedGoodsIssueDate AS PlannedGoodsIssueDate,
  _DeliveryDocumentItem.ReferenceSDDocument AS ReferenceDocument,
  _DeliveryDocumentItem._DistributionChannel AS _DistributionChannel,
  _DeliveryDocumentItem._Division AS _Division,
  _DeliveryDocumentItem._ReferenceSDDocument AS _ReferenceSDDocument
FROM I_DeliveryDocument AS DeliveryDocument
;

Learn More