I_DelivWthoutRefQuickCreate

DDL: I_DELIVWTHOUTREFQUICKCREATE SQL: IDELIVWOREFQC Type: view BASIC
20 Fields 1 Data Sources

Quick Create Delivery w/o reference

I_DelivWthoutRefQuickCreate is a Basic CDS View that provides data about "Quick Create Delivery w/o reference" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 20 fields with key field OutboundDelivery.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument DeliveryDocument from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IDELIVWOREFQC 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 Delivery w/o reference view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery I_DeliveryDocument DeliveryDocument Outbound Delivery
ShippingPoint I_DeliveryDocument ShippingPoint Shipping Point
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType Delivery Type
SalesOrganization I_DeliveryDocument SalesOrganization Sales Organization
Division _DeliveryDocumentItem Division Internal Division ID
DistributionChannel _DeliveryDocumentItem DistributionChannel RefDistCh-Cust/Mat.
ShipToParty I_DeliveryDocument ShipToParty Ship-To Party (obsolete)
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate Planned Gds Mvmt
Plant _DeliveryDocumentItem Plant Valuation Area
StorageLocation _DeliveryDocumentItem StorageLocation StorageLocation
_DeliveryItemQuickCreate _DeliveryItemQuickCreate
_DeliveryDocumentType _DeliveryDocumentType
_SalesOrganization _SalesOrganization
_Division _Division
_DistributionChannel _DistributionChannel
_DeliveryDocumentItem _DeliveryDocumentItem
_ShippingPoint _ShippingPoint
_ShipToParty _ShipToParty
_Plant _Plant
_StorageLocation _StorageLocation

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_DelivWthoutRefQuickCreate.
-- 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: IDELIVWOREFQC

CREATE VIEW I_DelivWthoutRefQuickCreate AS
SELECT
  DeliveryDocument.DeliveryDocument AS OutboundDelivery,
  DeliveryDocument.ShippingPoint AS ShippingPoint,
  DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  DeliveryDocument.SalesOrganization AS SalesOrganization,
  _DeliveryDocumentItem.Division AS Division,
  _DeliveryDocumentItem.DistributionChannel AS DistributionChannel,
  DeliveryDocument.ShipToParty AS ShipToParty,
  DeliveryDocument.PlannedGoodsIssueDate AS PlannedGoodsIssueDate,
  _DeliveryDocumentItem.Plant AS Plant,
  _DeliveryDocumentItem.StorageLocation AS StorageLocation
FROM I_DeliveryDocument AS DeliveryDocument
;

Learn More