C_DeliveryItemOutputDetn

DDL: C_DELIVERYITEMOUTPUTDETN SQL: CDLVRYITEMOUTDET Type: view CONSUMPTION Package: ODATA_LE_SHP_FORMS
44 Fields 1 Data Sources 1 Associations

Delivery Item Output Determination

C_DeliveryItemOutputDetn is a Consumption CDS View that provides data about "Delivery Item Output Determination" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocumentItem) and exposes 44 fields with key fields DeliveryDocument, DeliveryDocumentItem. It has 1 association to related views. Part of development package ODATA_LE_SHP_FORMS.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocumentItem I_DeliveryDocumentItem from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_DeliveryDocumentItem _Extension $projection.DeliveryDocument = _Extension.DeliveryDocument and $projection.DeliveryDocumentItem = _Extension.DeliveryDocumentItem

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDLVRYITEMOUTDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Delivery Item Output Determination view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
DataAging.noAgingRestriction false view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument DeliveryDocument Outbound Delivery
KEY DeliveryDocumentItem DeliveryDocumentItem Outb. Delivery Item
SalesOrganization _DeliveryDocument SalesOrganization Sales Organization
ShippingPoint _DeliveryDocument ShippingPoint Shipping Point
ShipToParty _DeliveryDocument ShipToParty Ship-To Party (obsolete)
SoldToParty _DeliveryDocument SoldToParty Sold-to Party
DeliveryDocumentType _DeliveryDocument DeliveryDocumentType Delivery Type
OverallGoodsMovementStatus _DeliveryDocument OverallGoodsMovementStatus
OverallPickingStatus _DeliveryDocument OverallPickingStatus
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
MaterialGroup MaterialGroup Product Group
Material Material Vehicle Model
MaterialByCustomer MaterialByCustomer Customer Mat.
MaterialTypePrimary MaterialTypePrimary Product Type
SDDocumentCategory SDDocumentCategory Document Cat.
Plant Plant Valuation Area
DeliveryDocumentItemCategory DeliveryDocumentItemCategory Item Category
ActiveDepartureCountry
ProposedDeliveryRoute _DeliveryDocument ProposedDeliveryRoute
ShippingCondition _DeliveryDocument ShippingCondition Shipping Conditions
BaseUnit BaseUnit Unit of Measure
DestinationCountry
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
MaterialFreightGroup MaterialFreightGroup Mat.Freight Grp
Warehouse Warehouse Warehouse No.
LoadingPointForDelivery LoadingPointForDelivery Load./Unload. Pt
TransportationGroup TransportationGroup Trans. Group
_DeliveryDocument _DeliveryDocument
_SalesOrganization _DeliveryDocument _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_Material _Material
_MaterialGroup _MaterialGroup
_ShipToParty _DeliveryDocument _ShipToParty
_SoldToParty _DeliveryDocument _SoldToParty
_DeliveryDocumentType _DeliveryDocument _DeliveryDocumentType
_OverallGoodsMovementStatus _DeliveryDocument _OverallGoodsMovementStatus
_OverallPickingStatus _DeliveryDocument _OverallPickingStatus
_Plant _Plant
_ShippingPoint _DeliveryDocument _ShippingPoint
_SDDocumentCategory _SDDocumentCategory
_ItemCategory _ItemCategory

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_DeliveryItemOutputDetn.
-- 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: CDLVRYITEMOUTDET

CREATE VIEW C_DeliveryItemOutputDetn AS
SELECT
  DeliveryDocument,
  DeliveryDocumentItem,
  _DeliveryDocument.SalesOrganization AS SalesOrganization,
  _DeliveryDocument.ShippingPoint AS ShippingPoint,
  _DeliveryDocument.ShipToParty AS ShipToParty,
  _DeliveryDocument.SoldToParty AS SoldToParty,
  _DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  _DeliveryDocument.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  _DeliveryDocument.OverallPickingStatus AS OverallPickingStatus,
  DistributionChannel,
  Division,
  MaterialGroup,
  Material,
  MaterialByCustomer,
  MaterialTypePrimary,
  SDDocumentCategory,
  Plant,
  DeliveryDocumentItemCategory,
  _DeliveryDocument._ShippingPoint.ActiveDepartureCountry AS ActiveDepartureCountry,
  _DeliveryDocument.ProposedDeliveryRoute AS ProposedDeliveryRoute,
  _DeliveryDocument.ShippingCondition AS ShippingCondition,
  BaseUnit,
  _DeliveryDocument._ShipToParty.Country AS DestinationCountry,
  SalesOffice,
  SalesGroup,
  MaterialFreightGroup,
  Warehouse,
  LoadingPointForDelivery,
  TransportationGroup,
  _DeliveryDocument._SalesOrganization AS _SalesOrganization,
  _DeliveryDocument._ShipToParty AS _ShipToParty,
  _DeliveryDocument._SoldToParty AS _SoldToParty,
  _DeliveryDocument._DeliveryDocumentType AS _DeliveryDocumentType,
  _DeliveryDocument._OverallGoodsMovementStatus AS _OverallGoodsMovementStatus,
  _DeliveryDocument._OverallPickingStatus AS _OverallPickingStatus,
  _DeliveryDocument._ShippingPoint AS _ShippingPoint
FROM I_DeliveryDocumentItem
LEFT OUTER JOIN E_DeliveryDocumentItem AS _Extension ON DeliveryDocument = _Extension.DeliveryDocument AND DeliveryDocumentItem = _Extension.DeliveryDocumentItem  -- association [0..1]
;

Learn More