C_DelivWthRefQuickCreate

DDL: C_DELIVWTHREFQUICKCREATE Type: view CONSUMPTION
24 Fields 1 Data Sources

Quick Create Deliv with reference

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

Data Sources (1)

SourceAliasJoin Type
I_DelivWthRefQuickCreate I_DelivWthRefQuickCreate from

Annotations (21)

NameValueLevelField
AbapCatalog.sqlViewName CDELIVWREFQC view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
ClientHandling.type #CLIENT_DEPENDENT view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.allowExtensions true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.representativeKey OutboundDelivery view
ObjectModel.compositionRoot true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
UI.headerInfo.typeName Outbound Delivery view
UI.headerInfo.typeNamePlural Outbound Deliveries view
UI.headerInfo.title.value OutboundDelivery view
EndUserText.label Quick Create Deliv with reference view
Consumption.semanticObject OutboundDelivery view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery OutboundDelivery LE Delivery
ReferenceSDDocument ReferenceSDDocument Reference Doc.
ShippingPoint ShippingPoint Shipping Point
ShippingPointName
DeliveryDate DeliveryDate Delivery Date
DeliveryDocumentType DeliveryDocumentType Delivery Type
DeliveryDocumentTypeName
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationName
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName
Division Division Internal Division ID
DivisionName
ShipToParty ShipToParty Ship-To Party (obsolete)
CustomerName _ShipToParty CustomerName Name of Customer
PlannedGoodsIssueDate PlannedGoodsIssueDate
ReferenceDocument ReferenceDocument Reference Document
_ShippingPoint _ShippingPoint
_DeliveryDocumentType _DeliveryDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_ShipToParty _ShipToParty
_ReferenceSDDocument _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 C_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.

CREATE VIEW C_DelivWthRefQuickCreate AS
SELECT
  OutboundDelivery,
  ReferenceSDDocument,
  ShippingPoint,
  cast(_ShippingPoint._Text[1: Language=$session.system_language].ShippingPointName as vtext) AS ShippingPointName,
  DeliveryDate,
  DeliveryDocumentType,
  cast(_DeliveryDocumentType._Text[1: Language=$session.system_language].DeliveryDocumentTypeName as vtext) AS DeliveryDocumentTypeName,
  SalesOrganization,
  cast(_SalesOrganization._Text[1: Language=$session.system_language].SalesOrganizationName as vtext) AS SalesOrganizationName,
  DistributionChannel,
  cast(_DistributionChannel._Text[1: Language=$session.system_language].DistributionChannelName as vtext) AS DistributionChannelName,
  Division,
  cast(_Division._Text[1: Language=$session.system_language].DivisionName as vtext) AS DivisionName,
  ShipToParty,
  _ShipToParty.CustomerName AS CustomerName,
  PlannedGoodsIssueDate,
  ReferenceDocument
FROM I_DelivWthRefQuickCreate
;

Learn More