A_OutbDeliveryHeader

DDL: A_OUTBDELIVERYHEADER SQL: AOUTBDELIVERYH Type: view BASIC
111 Fields 1 Data Sources 4 Associations

CDS view for API exposure

A_OutbDeliveryHeader is a Basic CDS View that provides data about "CDS view for API exposure" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 111 fields with key field DeliveryDocument. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument I_DeliveryDocument from

Associations (4)

CardinalityTargetAliasCondition
[0..*] A_OutbDeliveryItem _DeliveryDocumentItem _DeliveryDocumentItem.DeliveryDocument = $projection.DeliveryDocument
[1..*] A_OutbDeliveryPartner _DeliveryDocumentPartner _DeliveryDocumentPartner.SDDocument = $projection.DeliveryDocument
[0..1] A_Supplier _AuthSupplier $projection.Supplier = _AuthSupplier.Supplier
[0..1] E_DeliveryDocument _Extension $projection.DeliveryDocument = _Extension.DeliveryDocument

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName AOUTBDELIVERYH view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label CDS view for API exposure view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view

Fields (111)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocument I_DeliveryDocument DeliveryDocument Outbound Delivery
SDDocumentCategory I_DeliveryDocument SDDocumentCategory Document Cat.
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType Delivery Type
CreatedByUser I_DeliveryDocument CreatedByUser User Name
CreationDate I_DeliveryDocument CreationDate Time Stamp
CreationTime I_DeliveryDocument CreationTime Time of Change
LastChangedByUser I_DeliveryDocument LastChangedByUser User Name
LastChangeDate I_DeliveryDocument LastChangeDate Time Stamp
ShippingPoint I_DeliveryDocument ShippingPoint Shipping Point
SalesOrganization I_DeliveryDocument SalesOrganization Sales Organization
SalesOffice I_DeliveryDocument SalesOffice Sales Office
CompleteDeliveryIsDefined I_DeliveryDocument CompleteDeliveryIsDefined Complete Dlv.
OrderCombinationIsAllowed I_DeliveryDocument OrderCombinationIsAllowed Order Combinat.
DeliveryPriority I_DeliveryDocument DeliveryPriority Delivery Prior.
DeliveryBlockReason I_DeliveryDocument DeliveryBlockReason Delivery Block
Supplier I_DeliveryDocument Supplier Supplier
DeliveryDocumentBySupplier I_DeliveryDocument DeliveryDocumentBySupplier Lifex
DeliveryIsInPlant I_DeliveryDocument DeliveryIsInPlant In Plant
ReceivingPlant I_DeliveryDocument ReceivingPlant Receiving Plant
Warehouse I_DeliveryDocument Warehouse Warehouse No.
IsExportDelivery I_DeliveryDocument IsExportDelivery Export
OrderID I_DeliveryDocument OrderID Order ID
HeaderGrossWeight I_DeliveryDocument HeaderGrossWeight Total Weight
HeaderNetWeight I_DeliveryDocument HeaderNetWeight Net Weight
HeaderWeightUnit I_DeliveryDocument HeaderWeightUnit Weight Unit
HeaderVolume I_DeliveryDocument HeaderVolume Volume
HeaderVolumeUnit I_DeliveryDocument HeaderVolumeUnit Volume Unit
IsDeliveryForSingleWarehouse I_DeliveryDocument IsDeliveryForSingleWarehouse Whse no. split
GoodsIssueOrReceiptSlipNumber I_DeliveryDocument GoodsIssueOrReceiptSlipNumber GR/GI Slip No.
WarehouseGate I_DeliveryDocument WarehouseGate Door for Whse
WarehouseStagingArea I_DeliveryDocument WarehouseStagingArea Staging Area
MeansOfTransportRefMaterial I_DeliveryDocument MeansOfTransportRefMaterial MeansTransp.
SpecialProcessingCode I_DeliveryDocument SpecialProcessingCode Spec.Processing
ExternalIdentificationType I_DeliveryDocument ExternalIdentificationType Type Ext. Ident
DeliveryVersion I_DeliveryDocument DeliveryVersion DLV.Version
PickedItemsLocation I_DeliveryDocument PickedItemsLocation PickedItmLocat.
DocumentDate I_DeliveryDocument DocumentDate Journal Entry Date
PickingDate I_DeliveryDocument PickingDate Pick Date
PickingTime I_DeliveryDocument PickingTime Picking Time
TotalNumberOfPackage I_DeliveryDocument TotalNumberOfPackage No. of Packages
LoadingPoint I_DeliveryDocument LoadingPoint Loading Point
LoadingDate I_DeliveryDocument LoadingDate Loading Date
LoadingTime I_DeliveryDocument LoadingTime Loading Time
BillOfLading I_DeliveryDocument BillOfLading Bill of Lading
HandlingUnitInStock I_DeliveryDocument HandlingUnitInStock HU in Stock
ShipToParty I_DeliveryDocument ShipToParty Ship-To Party (obsolete)
ShippingType I_DeliveryDocument ShippingType Shipping Type
DeliveryDate I_DeliveryDocument DeliveryDate Delivery Date
DeliveryTime I_DeliveryDocument DeliveryTime TimeOfDelivery
ShippingCondition I_DeliveryDocument ShippingCondition Shipping Conditions
ShipmentBlockReason I_DeliveryDocument ShipmentBlockReason ShpmtBlReason
TransportationPlanningDate I_DeliveryDocument TransportationPlanningDate TranspPlngDate
TransportationPlanningTime I_DeliveryDocument TransportationPlanningTime Tr. Plan. Time
ProposedDeliveryRoute I_DeliveryDocument ProposedDeliveryRoute Vehicle route
ActualDeliveryRoute I_DeliveryDocument ActualDeliveryRoute Route
RouteSchedule I_DeliveryDocument RouteSchedule Route Schedule
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate Planned Gds Mvmt
GoodsIssueTime I_DeliveryDocument GoodsIssueTime GI Time
ActualGoodsMovementDate I_DeliveryDocument ActualGoodsMovementDate Actual GI Date
ActualGoodsMovementTime I_DeliveryDocument ActualGoodsMovementTime GI Time
IncotermsClassification I_DeliveryDocument IncotermsClassification Incoterms
IncotermsTransferLocation I_DeliveryDocument IncotermsTransferLocation Incoterms 2
ExternalTransportSystem I_DeliveryDocument ExternalTransportSystem ID Transp.Syst.
TransportationGroup I_DeliveryDocument TransportationGroup Trans. Group
MeansOfTransport I_DeliveryDocument MeansOfTransport Shipment ID
MeansOfTransportType I_DeliveryDocument MeansOfTransportType Packag.Mat.Type
UnloadingPointName I_DeliveryDocument UnloadingPointName Unloading Point Name
ProofOfDeliveryDate I_DeliveryDocument ProofOfDeliveryDate POD Date
ConfirmationTime I_DeliveryDocument ConfirmationTime Confirm. Time
FactoryCalendarByCustomer I_DeliveryDocument FactoryCalendarByCustomer FactoryCalendar
IntercompanyBillingDate I_DeliveryDocument IntercompanyBillingDate Intco Bill Date
BillingDocumentDate I_DeliveryDocument BillingDocumentDate Billing Date
HeaderBillingBlockReason I_DeliveryDocument HeaderBillingBlockReason Billing Block
InternalFinancialDocument I_DeliveryDocument InternalFinancialDocument Financ.Doc.No.
PaymentGuaranteeProcedure I_DeliveryDocument PaymentGuaranteeProcedure Paym.Guar.Proc.
DepreciationPercentage I_DeliveryDocument DepreciationPercentage Depreciation
SoldToParty I_DeliveryDocument SoldToParty Sold-to Party
CustomerGroup I_DeliveryDocument CustomerGroup Customer Group
SalesDistrict I_DeliveryDocument SalesDistrict Sales District
TransactionCurrency I_DeliveryDocument TransactionCurrency Transaction Currency
StatisticsCurrency I_DeliveryDocument StatisticsCurrency Stats. Currency
OverallIntcoBillingStatus I_DeliveryDocument OverallIntcoBillingStatus
OverallSDProcessStatus I_DeliveryDocument OverallSDProcessStatus Overall Status
TotalBlockStatus I_DeliveryDocument TotalBlockStatus Ovrl Block Sts
OverallDelivConfStatus I_DeliveryDocument OverallDelivConfStatus Deliv. Conf.Sts
TransportationPlanningStatus I_DeliveryDocument TransportationPlanningStatus Transp.Plng Sts
OverallPickingConfStatus I_DeliveryDocument OverallPickingConfStatus Confirmation
OverallPickingStatus I_DeliveryDocument OverallPickingStatus Picking Status
OverallPackingStatus I_DeliveryDocument OverallPackingStatus Packing Status
OverallWarehouseActivityStatus I_DeliveryDocument OverallWarehouseActivityStatus WM Activity Sts
DistrStatusByDecentralizedWrhs I_DeliveryDocument DistrStatusByDecentralizedWrhs StatDecntrlWhse
OverallGoodsMovementStatus I_DeliveryDocument OverallGoodsMovementStatus Goods Mvmnt Sts
OverallDelivReltdBillgStatus I_DeliveryDocument OverallDelivReltdBillgStatus Del.Rel.BillgSt
OverallProofOfDeliveryStatus I_DeliveryDocument OverallProofOfDeliveryStatus POD Status
HdrGeneralIncompletionStatus I_DeliveryDocument HdrGeneralIncompletionStatus Overall Header
HeaderDelivIncompletionStatus I_DeliveryDocument HeaderDelivIncompletionStatus Delivery – Item
HeaderPickgIncompletionStatus I_DeliveryDocument HeaderPickgIncompletionStatus Picking/Putaway–Item
HeaderPackingIncompletionSts I_DeliveryDocument HeaderPackingIncompletionSts Packing – Item
HdrGoodsMvtIncompletionStatus I_DeliveryDocument HdrGoodsMvtIncompletionStatus GoodsMvt–Header
HeaderBillgIncompletionStatus I_DeliveryDocument HeaderBillgIncompletionStatus Billing Doc.
OvrlItmGeneralIncompletionSts I_DeliveryDocument OvrlItmGeneralIncompletionSts All Items
OvrlItmPackingIncompletionSts I_DeliveryDocument OvrlItmPackingIncompletionSts Packing – Items
OvrlItmPickingIncompletionSts I_DeliveryDocument OvrlItmPickingIncompletionSts Picking/Ptwy – Items
OvrlItmDelivIncompletionSts I_DeliveryDocument OvrlItmDelivIncompletionSts Deliv–All Itms
OvrlItmGdsMvtIncompletionSts I_DeliveryDocument OvrlItmGdsMvtIncompletionSts GdsMvt–All Itms
TotalCreditCheckStatus I_DeliveryDocument TotalCreditCheckStatus OverallCredStat
ShippingLocationTimeZone I_DeliveryDocument ShippingLocationTimeZone Del. loc. tzone
ReceivingLocationTimeZone I_DeliveryDocument ReceivingLocationTimeZone Rec. time zone
_DeliveryDocumentItem _DeliveryDocumentItem
_DeliveryDocumentPartner _DeliveryDocumentPartner
_AuthSupplier _AuthSupplier

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 A_OutbDeliveryHeader.
-- 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: AOUTBDELIVERYH

CREATE VIEW A_OutbDeliveryHeader AS
SELECT
  I_DeliveryDocument.DeliveryDocument AS DeliveryDocument,
  I_DeliveryDocument.SDDocumentCategory AS SDDocumentCategory,
  I_DeliveryDocument.DeliveryDocumentType AS DeliveryDocumentType,
  I_DeliveryDocument.CreatedByUser AS CreatedByUser,
  I_DeliveryDocument.CreationDate AS CreationDate,
  I_DeliveryDocument.CreationTime AS CreationTime,
  I_DeliveryDocument.LastChangedByUser AS LastChangedByUser,
  I_DeliveryDocument.LastChangeDate AS LastChangeDate,
  I_DeliveryDocument.ShippingPoint AS ShippingPoint,
  I_DeliveryDocument.SalesOrganization AS SalesOrganization,
  I_DeliveryDocument.SalesOffice AS SalesOffice,
  I_DeliveryDocument.CompleteDeliveryIsDefined AS CompleteDeliveryIsDefined,
  I_DeliveryDocument.OrderCombinationIsAllowed AS OrderCombinationIsAllowed,
  I_DeliveryDocument.DeliveryPriority AS DeliveryPriority,
  I_DeliveryDocument.DeliveryBlockReason AS DeliveryBlockReason,
  I_DeliveryDocument.Supplier AS Supplier,
  I_DeliveryDocument.DeliveryDocumentBySupplier AS DeliveryDocumentBySupplier,
  I_DeliveryDocument.DeliveryIsInPlant AS DeliveryIsInPlant,
  I_DeliveryDocument.ReceivingPlant AS ReceivingPlant,
  I_DeliveryDocument.Warehouse AS Warehouse,
  I_DeliveryDocument.IsExportDelivery AS IsExportDelivery,
  I_DeliveryDocument.OrderID AS OrderID,
  I_DeliveryDocument.HeaderGrossWeight AS HeaderGrossWeight,
  I_DeliveryDocument.HeaderNetWeight AS HeaderNetWeight,
  I_DeliveryDocument.HeaderWeightUnit AS HeaderWeightUnit,
  I_DeliveryDocument.HeaderVolume AS HeaderVolume,
  I_DeliveryDocument.HeaderVolumeUnit AS HeaderVolumeUnit,
  I_DeliveryDocument.IsDeliveryForSingleWarehouse AS IsDeliveryForSingleWarehouse,
  I_DeliveryDocument.GoodsIssueOrReceiptSlipNumber AS GoodsIssueOrReceiptSlipNumber,
  I_DeliveryDocument.WarehouseGate AS WarehouseGate,
  I_DeliveryDocument.WarehouseStagingArea AS WarehouseStagingArea,
  I_DeliveryDocument.MeansOfTransportRefMaterial AS MeansOfTransportRefMaterial,
  I_DeliveryDocument.SpecialProcessingCode AS SpecialProcessingCode,
  I_DeliveryDocument.ExternalIdentificationType AS ExternalIdentificationType,
  I_DeliveryDocument.DeliveryVersion AS DeliveryVersion,
  I_DeliveryDocument.PickedItemsLocation AS PickedItemsLocation,
  I_DeliveryDocument.DocumentDate AS DocumentDate,
  I_DeliveryDocument.PickingDate AS PickingDate,
  I_DeliveryDocument.PickingTime AS PickingTime,
  I_DeliveryDocument.TotalNumberOfPackage AS TotalNumberOfPackage,
  I_DeliveryDocument.LoadingPoint AS LoadingPoint,
  I_DeliveryDocument.LoadingDate AS LoadingDate,
  I_DeliveryDocument.LoadingTime AS LoadingTime,
  I_DeliveryDocument.BillOfLading AS BillOfLading,
  I_DeliveryDocument.HandlingUnitInStock AS HandlingUnitInStock,
  I_DeliveryDocument.ShipToParty AS ShipToParty,
  I_DeliveryDocument.ShippingType AS ShippingType,
  I_DeliveryDocument.DeliveryDate AS DeliveryDate,
  I_DeliveryDocument.DeliveryTime AS DeliveryTime,
  I_DeliveryDocument.ShippingCondition AS ShippingCondition,
  I_DeliveryDocument.ShipmentBlockReason AS ShipmentBlockReason,
  I_DeliveryDocument.TransportationPlanningDate AS TransportationPlanningDate,
  I_DeliveryDocument.TransportationPlanningTime AS TransportationPlanningTime,
  I_DeliveryDocument.ProposedDeliveryRoute AS ProposedDeliveryRoute,
  I_DeliveryDocument.ActualDeliveryRoute AS ActualDeliveryRoute,
  I_DeliveryDocument.RouteSchedule AS RouteSchedule,
  I_DeliveryDocument.PlannedGoodsIssueDate AS PlannedGoodsIssueDate,
  I_DeliveryDocument.GoodsIssueTime AS GoodsIssueTime,
  I_DeliveryDocument.ActualGoodsMovementDate AS ActualGoodsMovementDate,
  I_DeliveryDocument.ActualGoodsMovementTime AS ActualGoodsMovementTime,
  I_DeliveryDocument.IncotermsClassification AS IncotermsClassification,
  I_DeliveryDocument.IncotermsTransferLocation AS IncotermsTransferLocation,
  I_DeliveryDocument.ExternalTransportSystem AS ExternalTransportSystem,
  I_DeliveryDocument.TransportationGroup AS TransportationGroup,
  I_DeliveryDocument.MeansOfTransport AS MeansOfTransport,
  I_DeliveryDocument.MeansOfTransportType AS MeansOfTransportType,
  I_DeliveryDocument.UnloadingPointName AS UnloadingPointName,
  I_DeliveryDocument.ProofOfDeliveryDate AS ProofOfDeliveryDate,
  I_DeliveryDocument.ConfirmationTime AS ConfirmationTime,
  I_DeliveryDocument.FactoryCalendarByCustomer AS FactoryCalendarByCustomer,
  I_DeliveryDocument.IntercompanyBillingDate AS IntercompanyBillingDate,
  I_DeliveryDocument.BillingDocumentDate AS BillingDocumentDate,
  I_DeliveryDocument.HeaderBillingBlockReason AS HeaderBillingBlockReason,
  I_DeliveryDocument.InternalFinancialDocument AS InternalFinancialDocument,
  I_DeliveryDocument.PaymentGuaranteeProcedure AS PaymentGuaranteeProcedure,
  I_DeliveryDocument.DepreciationPercentage AS DepreciationPercentage,
  I_DeliveryDocument.SoldToParty AS SoldToParty,
  I_DeliveryDocument.CustomerGroup AS CustomerGroup,
  I_DeliveryDocument.SalesDistrict AS SalesDistrict,
  I_DeliveryDocument.TransactionCurrency AS TransactionCurrency,
  I_DeliveryDocument.StatisticsCurrency AS StatisticsCurrency,
  I_DeliveryDocument.OverallIntcoBillingStatus AS OverallIntcoBillingStatus,
  I_DeliveryDocument.OverallSDProcessStatus AS OverallSDProcessStatus,
  I_DeliveryDocument.TotalBlockStatus AS TotalBlockStatus,
  I_DeliveryDocument.OverallDelivConfStatus AS OverallDelivConfStatus,
  I_DeliveryDocument.TransportationPlanningStatus AS TransportationPlanningStatus,
  I_DeliveryDocument.OverallPickingConfStatus AS OverallPickingConfStatus,
  I_DeliveryDocument.OverallPickingStatus AS OverallPickingStatus,
  I_DeliveryDocument.OverallPackingStatus AS OverallPackingStatus,
  I_DeliveryDocument.OverallWarehouseActivityStatus AS OverallWarehouseActivityStatus,
  I_DeliveryDocument.DistrStatusByDecentralizedWrhs AS DistrStatusByDecentralizedWrhs,
  I_DeliveryDocument.OverallGoodsMovementStatus AS OverallGoodsMovementStatus,
  I_DeliveryDocument.OverallDelivReltdBillgStatus AS OverallDelivReltdBillgStatus,
  I_DeliveryDocument.OverallProofOfDeliveryStatus AS OverallProofOfDeliveryStatus,
  I_DeliveryDocument.HdrGeneralIncompletionStatus AS HdrGeneralIncompletionStatus,
  I_DeliveryDocument.HeaderDelivIncompletionStatus AS HeaderDelivIncompletionStatus,
  I_DeliveryDocument.HeaderPickgIncompletionStatus AS HeaderPickgIncompletionStatus,
  I_DeliveryDocument.HeaderPackingIncompletionSts AS HeaderPackingIncompletionSts,
  I_DeliveryDocument.HdrGoodsMvtIncompletionStatus AS HdrGoodsMvtIncompletionStatus,
  I_DeliveryDocument.HeaderBillgIncompletionStatus AS HeaderBillgIncompletionStatus,
  I_DeliveryDocument.OvrlItmGeneralIncompletionSts AS OvrlItmGeneralIncompletionSts,
  I_DeliveryDocument.OvrlItmPackingIncompletionSts AS OvrlItmPackingIncompletionSts,
  I_DeliveryDocument.OvrlItmPickingIncompletionSts AS OvrlItmPickingIncompletionSts,
  I_DeliveryDocument.OvrlItmDelivIncompletionSts AS OvrlItmDelivIncompletionSts,
  I_DeliveryDocument.OvrlItmGdsMvtIncompletionSts AS OvrlItmGdsMvtIncompletionSts,
  I_DeliveryDocument.TotalCreditCheckStatus AS TotalCreditCheckStatus,
  I_DeliveryDocument.ShippingLocationTimeZone AS ShippingLocationTimeZone,
  I_DeliveryDocument.ReceivingLocationTimeZone AS ReceivingLocationTimeZone
FROM I_DeliveryDocument
LEFT OUTER JOIN A_OutbDeliveryItem AS _DeliveryDocumentItem ON _DeliveryDocumentItem.DeliveryDocument = DeliveryDocument  -- association [0..*]
LEFT OUTER JOIN A_OutbDeliveryPartner AS _DeliveryDocumentPartner ON _DeliveryDocumentPartner.SDDocument = DeliveryDocument  -- association [1..*]
LEFT OUTER JOIN A_Supplier AS _AuthSupplier ON Supplier = _AuthSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN E_DeliveryDocument AS _Extension ON DeliveryDocument = _Extension.DeliveryDocument  -- association [0..1]
;

Learn More