A_OutbDeliveryHeader

DDL: A_OUTBDELIVERYHEADER SQL: AOUTBDELIVERYH Type: view BASIC Package: VDM_LE_SHP_OBD_API_V1

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. Part of development package VDM_LE_SHP_OBD_API_V1.

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
SDDocumentCategory I_DeliveryDocument SDDocumentCategory
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType
CreatedByUser I_DeliveryDocument CreatedByUser
CreationDate I_DeliveryDocument CreationDate
CreationTime I_DeliveryDocument CreationTime
LastChangedByUser I_DeliveryDocument LastChangedByUser
LastChangeDate I_DeliveryDocument LastChangeDate
ShippingPoint I_DeliveryDocument ShippingPoint
SalesOrganization I_DeliveryDocument SalesOrganization
SalesOffice I_DeliveryDocument SalesOffice
CompleteDeliveryIsDefined I_DeliveryDocument CompleteDeliveryIsDefined
OrderCombinationIsAllowed I_DeliveryDocument OrderCombinationIsAllowed
DeliveryPriority I_DeliveryDocument DeliveryPriority
DeliveryBlockReason I_DeliveryDocument DeliveryBlockReason
Supplier I_DeliveryDocument Supplier
DeliveryDocumentBySupplier I_DeliveryDocument DeliveryDocumentBySupplier
DeliveryIsInPlant I_DeliveryDocument DeliveryIsInPlant
ReceivingPlant I_DeliveryDocument ReceivingPlant
Warehouse I_DeliveryDocument Warehouse
IsExportDelivery I_DeliveryDocument IsExportDelivery
OrderID I_DeliveryDocument OrderID
HeaderGrossWeight I_DeliveryDocument HeaderGrossWeight
HeaderNetWeight I_DeliveryDocument HeaderNetWeight
HeaderWeightUnit I_DeliveryDocument HeaderWeightUnit
HeaderVolume I_DeliveryDocument HeaderVolume
HeaderVolumeUnit I_DeliveryDocument HeaderVolumeUnit
IsDeliveryForSingleWarehouse I_DeliveryDocument IsDeliveryForSingleWarehouse
GoodsIssueOrReceiptSlipNumber I_DeliveryDocument GoodsIssueOrReceiptSlipNumber
WarehouseGate I_DeliveryDocument WarehouseGate
WarehouseStagingArea I_DeliveryDocument WarehouseStagingArea
MeansOfTransportRefMaterial I_DeliveryDocument MeansOfTransportRefMaterial
SpecialProcessingCode I_DeliveryDocument SpecialProcessingCode
ExternalIdentificationType I_DeliveryDocument ExternalIdentificationType
DeliveryVersion I_DeliveryDocument DeliveryVersion
PickedItemsLocation I_DeliveryDocument PickedItemsLocation
DocumentDate I_DeliveryDocument DocumentDate
PickingDate I_DeliveryDocument PickingDate
PickingTime I_DeliveryDocument PickingTime
TotalNumberOfPackage I_DeliveryDocument TotalNumberOfPackage
LoadingPoint I_DeliveryDocument LoadingPoint
LoadingDate I_DeliveryDocument LoadingDate
LoadingTime I_DeliveryDocument LoadingTime
BillOfLading I_DeliveryDocument BillOfLading
HandlingUnitInStock I_DeliveryDocument HandlingUnitInStock
ShipToParty I_DeliveryDocument ShipToParty
ShippingType I_DeliveryDocument ShippingType
DeliveryDate I_DeliveryDocument DeliveryDate
DeliveryTime I_DeliveryDocument DeliveryTime
ShippingCondition I_DeliveryDocument ShippingCondition
ShipmentBlockReason I_DeliveryDocument ShipmentBlockReason
TransportationPlanningDate I_DeliveryDocument TransportationPlanningDate
TransportationPlanningTime I_DeliveryDocument TransportationPlanningTime
ProposedDeliveryRoute I_DeliveryDocument ProposedDeliveryRoute
ActualDeliveryRoute I_DeliveryDocument ActualDeliveryRoute
RouteSchedule I_DeliveryDocument RouteSchedule
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate
GoodsIssueTime I_DeliveryDocument GoodsIssueTime
ActualGoodsMovementDate I_DeliveryDocument ActualGoodsMovementDate
ActualGoodsMovementTime I_DeliveryDocument ActualGoodsMovementTime
IncotermsClassification I_DeliveryDocument IncotermsClassification
IncotermsTransferLocation I_DeliveryDocument IncotermsTransferLocation
ExternalTransportSystem I_DeliveryDocument ExternalTransportSystem
TransportationGroup I_DeliveryDocument TransportationGroup
MeansOfTransport I_DeliveryDocument MeansOfTransport
MeansOfTransportType I_DeliveryDocument MeansOfTransportType
UnloadingPointName I_DeliveryDocument UnloadingPointName
ProofOfDeliveryDate I_DeliveryDocument ProofOfDeliveryDate
ConfirmationTime I_DeliveryDocument ConfirmationTime
FactoryCalendarByCustomer I_DeliveryDocument FactoryCalendarByCustomer
IntercompanyBillingDate I_DeliveryDocument IntercompanyBillingDate
BillingDocumentDate I_DeliveryDocument BillingDocumentDate
HeaderBillingBlockReason I_DeliveryDocument HeaderBillingBlockReason
InternalFinancialDocument I_DeliveryDocument InternalFinancialDocument
PaymentGuaranteeProcedure I_DeliveryDocument PaymentGuaranteeProcedure
DepreciationPercentage I_DeliveryDocument DepreciationPercentage
SoldToParty I_DeliveryDocument SoldToParty
CustomerGroup I_DeliveryDocument CustomerGroup
SalesDistrict I_DeliveryDocument SalesDistrict
TransactionCurrency I_DeliveryDocument TransactionCurrency
StatisticsCurrency I_DeliveryDocument StatisticsCurrency
OverallIntcoBillingStatus I_DeliveryDocument OverallIntcoBillingStatus
OverallSDProcessStatus I_DeliveryDocument OverallSDProcessStatus
TotalBlockStatus I_DeliveryDocument TotalBlockStatus
OverallDelivConfStatus I_DeliveryDocument OverallDelivConfStatus
TransportationPlanningStatus I_DeliveryDocument TransportationPlanningStatus
OverallPickingConfStatus I_DeliveryDocument OverallPickingConfStatus
OverallPickingStatus I_DeliveryDocument OverallPickingStatus
OverallPackingStatus I_DeliveryDocument OverallPackingStatus
OverallWarehouseActivityStatus I_DeliveryDocument OverallWarehouseActivityStatus
DistrStatusByDecentralizedWrhs I_DeliveryDocument DistrStatusByDecentralizedWrhs
OverallGoodsMovementStatus I_DeliveryDocument OverallGoodsMovementStatus
OverallDelivReltdBillgStatus I_DeliveryDocument OverallDelivReltdBillgStatus
OverallProofOfDeliveryStatus I_DeliveryDocument OverallProofOfDeliveryStatus
HdrGeneralIncompletionStatus I_DeliveryDocument HdrGeneralIncompletionStatus
HeaderDelivIncompletionStatus I_DeliveryDocument HeaderDelivIncompletionStatus
HeaderPickgIncompletionStatus I_DeliveryDocument HeaderPickgIncompletionStatus
HeaderPackingIncompletionSts I_DeliveryDocument HeaderPackingIncompletionSts
HdrGoodsMvtIncompletionStatus I_DeliveryDocument HdrGoodsMvtIncompletionStatus
HeaderBillgIncompletionStatus I_DeliveryDocument HeaderBillgIncompletionStatus
OvrlItmGeneralIncompletionSts I_DeliveryDocument OvrlItmGeneralIncompletionSts
OvrlItmPackingIncompletionSts I_DeliveryDocument OvrlItmPackingIncompletionSts
OvrlItmPickingIncompletionSts I_DeliveryDocument OvrlItmPickingIncompletionSts
OvrlItmDelivIncompletionSts I_DeliveryDocument OvrlItmDelivIncompletionSts
OvrlItmGdsMvtIncompletionSts I_DeliveryDocument OvrlItmGdsMvtIncompletionSts
TotalCreditCheckStatus I_DeliveryDocument TotalCreditCheckStatus
ShippingLocationTimeZone I_DeliveryDocument ShippingLocationTimeZone
ReceivingLocationTimeZone I_DeliveryDocument ReceivingLocationTimeZone
_DeliveryDocumentItem _DeliveryDocumentItem
_DeliveryDocumentPartner _DeliveryDocumentPartner
_AuthSupplier _AuthSupplier
@AbapCatalog.sqlViewName: 'AOUTBDELIVERYH'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API

@EndUserText.label: 'CDS view for API exposure'
@AccessControl.authorizationCheck:#CHECK
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@VDM.viewType: #BASIC
@ObjectModel: {
  compositionRoot:true,
  usageType.dataClass: #TRANSACTIONAL,
  usageType.serviceQuality: #B,
  usageType.sizeCategory: #L
}

define view A_OutbDeliveryHeader
    as select from I_DeliveryDocument
  
association [0..*] to A_OutbDeliveryItem as _DeliveryDocumentItem on _DeliveryDocumentItem.DeliveryDocument = $projection.DeliveryDocument
association [1..*] to A_OutbDeliveryPartner as _DeliveryDocumentPartner on _DeliveryDocumentPartner.SDDocument = $projection.DeliveryDocument
association [0..1] to A_Supplier as _AuthSupplier on $projection.Supplier = _AuthSupplier.Supplier

//Extensibility

association [0..1] to E_DeliveryDocument as _Extension         on $projection.DeliveryDocument = _Extension.DeliveryDocument


{
    key I_DeliveryDocument.DeliveryDocument, 
    I_DeliveryDocument.SDDocumentCategory, 
    I_DeliveryDocument.DeliveryDocumentType, 
    I_DeliveryDocument.CreatedByUser, 
    I_DeliveryDocument.CreationDate, 
    I_DeliveryDocument.CreationTime, 
    I_DeliveryDocument.LastChangedByUser, 
    I_DeliveryDocument.LastChangeDate, 
    I_DeliveryDocument.ShippingPoint, 
    I_DeliveryDocument.SalesOrganization, 
    I_DeliveryDocument.SalesOffice, 
    I_DeliveryDocument.CompleteDeliveryIsDefined, 
    I_DeliveryDocument.OrderCombinationIsAllowed, 
    I_DeliveryDocument.DeliveryPriority, 
    I_DeliveryDocument.DeliveryBlockReason, 
    I_DeliveryDocument.Supplier, 
    I_DeliveryDocument.DeliveryDocumentBySupplier, 
    I_DeliveryDocument.DeliveryIsInPlant, 
    I_DeliveryDocument.ReceivingPlant, 
    I_DeliveryDocument.Warehouse, 
    I_DeliveryDocument.IsExportDelivery, 
    I_DeliveryDocument.OrderID,
    @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
    I_DeliveryDocument.HeaderGrossWeight, 
    @Semantics.quantity.unitOfMeasure: 'HeaderWeightUnit'
    I_DeliveryDocument.HeaderNetWeight, 
    @Semantics.unitOfMeasure: true
    I_DeliveryDocument.HeaderWeightUnit, 
     @Semantics.quantity.unitOfMeasure: 'HeaderVolumeUnit'
    I_DeliveryDocument.HeaderVolume, 
    @Semantics.unitOfMeasure: true
    I_DeliveryDocument.HeaderVolumeUnit, 
    I_DeliveryDocument.IsDeliveryForSingleWarehouse, 
    I_DeliveryDocument.GoodsIssueOrReceiptSlipNumber, 
    I_DeliveryDocument.WarehouseGate, 
    I_DeliveryDocument.WarehouseStagingArea, 
    I_DeliveryDocument.MeansOfTransportRefMaterial, 
    I_DeliveryDocument.SpecialProcessingCode, 
    I_DeliveryDocument.ExternalIdentificationType, 
    I_DeliveryDocument.DeliveryVersion, 
    I_DeliveryDocument.PickedItemsLocation, 
    I_DeliveryDocument.DocumentDate, 
    I_DeliveryDocument.PickingDate, 
    I_DeliveryDocument.PickingTime, 
    I_DeliveryDocument.TotalNumberOfPackage, 
    I_DeliveryDocument.LoadingPoint, 
    I_DeliveryDocument.LoadingDate, 
    I_DeliveryDocument.LoadingTime, 
    I_DeliveryDocument.BillOfLading, 
    I_DeliveryDocument.HandlingUnitInStock, 
    I_DeliveryDocument.ShipToParty, 
    I_DeliveryDocument.ShippingType, 
    I_DeliveryDocument.DeliveryDate, 
    I_DeliveryDocument.DeliveryTime, 
    I_DeliveryDocument.ShippingCondition, 
    I_DeliveryDocument.ShipmentBlockReason, 
    I_DeliveryDocument.TransportationPlanningDate, 
    I_DeliveryDocument.TransportationPlanningTime, 
    I_DeliveryDocument.ProposedDeliveryRoute, 
    I_DeliveryDocument.ActualDeliveryRoute, 
    I_DeliveryDocument.RouteSchedule, 
    I_DeliveryDocument.PlannedGoodsIssueDate, 
    I_DeliveryDocument.GoodsIssueTime, 
    I_DeliveryDocument.ActualGoodsMovementDate, 
    I_DeliveryDocument.ActualGoodsMovementTime, 
    I_DeliveryDocument.IncotermsClassification, 
    I_DeliveryDocument.IncotermsTransferLocation, 
    I_DeliveryDocument.ExternalTransportSystem, 
    I_DeliveryDocument.TransportationGroup, 
    I_DeliveryDocument.MeansOfTransport, 
    I_DeliveryDocument.MeansOfTransportType, 
    I_DeliveryDocument.UnloadingPointName, 
    I_DeliveryDocument.ProofOfDeliveryDate, 
    I_DeliveryDocument.ConfirmationTime, 
    I_DeliveryDocument.FactoryCalendarByCustomer, 
    I_DeliveryDocument.IntercompanyBillingDate, 
    I_DeliveryDocument.BillingDocumentDate, 
    I_DeliveryDocument.HeaderBillingBlockReason, 
    I_DeliveryDocument.InternalFinancialDocument, 
    I_DeliveryDocument.PaymentGuaranteeProcedure, 
    I_DeliveryDocument.DepreciationPercentage, 
    I_DeliveryDocument.SoldToParty, 
    I_DeliveryDocument.CustomerGroup, 
    I_DeliveryDocument.SalesDistrict, 
    @Semantics.currencyCode: true
    I_DeliveryDocument.TransactionCurrency, 
    @Semantics.currencyCode: true
    I_DeliveryDocument.StatisticsCurrency, 
    I_DeliveryDocument.OverallIntcoBillingStatus, 
    I_DeliveryDocument.OverallSDProcessStatus, 
    I_DeliveryDocument.TotalBlockStatus, 
    I_DeliveryDocument.OverallDelivConfStatus, 
    I_DeliveryDocument.TransportationPlanningStatus, 
    I_DeliveryDocument.OverallPickingConfStatus, 
    I_DeliveryDocument.OverallPickingStatus, 
    I_DeliveryDocument.OverallPackingStatus, 
    I_DeliveryDocument.OverallWarehouseActivityStatus, 
    I_DeliveryDocument.DistrStatusByDecentralizedWrhs, 
    I_DeliveryDocument.OverallGoodsMovementStatus, 
    I_DeliveryDocument.OverallDelivReltdBillgStatus, 
    I_DeliveryDocument.OverallProofOfDeliveryStatus, 
    I_DeliveryDocument.HdrGeneralIncompletionStatus, 
    I_DeliveryDocument.HeaderDelivIncompletionStatus, 
    I_DeliveryDocument.HeaderPickgIncompletionStatus, 
    I_DeliveryDocument.HeaderPackingIncompletionSts, 
    I_DeliveryDocument.HdrGoodsMvtIncompletionStatus, 
    I_DeliveryDocument.HeaderBillgIncompletionStatus, 
    I_DeliveryDocument.OvrlItmGeneralIncompletionSts, 
    I_DeliveryDocument.OvrlItmPackingIncompletionSts, 
    I_DeliveryDocument.OvrlItmPickingIncompletionSts, 
    I_DeliveryDocument.OvrlItmDelivIncompletionSts, 
    I_DeliveryDocument.OvrlItmGdsMvtIncompletionSts, 
    I_DeliveryDocument.TotalCreditCheckStatus,
    I_DeliveryDocument.ShippingLocationTimeZone,
    I_DeliveryDocument.ReceivingLocationTimeZone,
    
    /* Associations */
    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
    _DeliveryDocumentItem,
    @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
    _DeliveryDocumentPartner,
    
     //only for DCL

    @Consumption.hidden: true
    _AuthSupplier
    
} where I_DeliveryDocument.SDDocumentCategory = 'J' ;