I_DelivWthoutRefQuickCreate

DDL: I_DELIVWTHOUTREFQUICKCREATE SQL: IDELIVWOREFQC Type: view BASIC Package: ODATA_LE_SHP_QC_DLVNOREF

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

1 data source(s) 20 fields

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
ShippingPoint I_DeliveryDocument ShippingPoint
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType
SalesOrganization I_DeliveryDocument SalesOrganization
Division _DeliveryDocumentItem Division
DistributionChannel _DeliveryDocumentItem DistributionChannel
ShipToParty I_DeliveryDocument ShipToParty
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate
Plant _DeliveryDocumentItem Plant
StorageLocation _DeliveryDocumentItem StorageLocation
_DeliveryItemQuickCreate _DeliveryItemQuickCreate
_DeliveryDocumentType _DeliveryDocumentType
_SalesOrganization _SalesOrganization
_Division _Division
_DistributionChannel _DistributionChannel
_DeliveryDocumentItem _DeliveryDocumentItem
_ShippingPoint _ShippingPoint
_ShipToParty _ShipToParty
_Plant _Plant
_StorageLocation _StorageLocation 
@AbapCatalog.sqlViewName: 'IDELIVWOREFQC'
@VDM.viewType: #BASIC
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED 

@ObjectModel: {
    compositionRoot:                true,
    semanticKey:                    ['OutboundDelivery'], 
    createEnabled:                  true,
    deleteEnabled:                  true,
    updateEnabled:                  true,
    usageType: { serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL }
} 


@EndUserText.label: 'Quick Create Delivery w/o reference'
define view I_DelivWthoutRefQuickCreate as select from I_DeliveryDocument as DeliveryDocument 

  association[0..*] to I_DelivItmWthoutRefQuickCrte as _DeliveryItemQuickCreate 
    on $projection.OutboundDelivery = _DeliveryItemQuickCreate.OutboundDelivery
  
  association[0..1] to I_DistributionChannel as _DistributionChannel 
    on $projection.distributionchannel = _DistributionChannel.DistributionChannel
    
  association[0..1] to I_Division as _Division 
    on $projection.division = _Division.Division
    
    association[0..1] to I_Plant as _Plant on $projection.plant = _Plant.Plant
  association[0..1] to I_StorageLocation as _StorageLocation 
    on  $projection.plant = _StorageLocation.Plant 
    and $projection.storagelocation = _StorageLocation.StorageLocation  
  
  // needed for distribution channel and division, plant and storageLocation

  association[0..*] to I_DeliveryDocumentItem as _DeliveryDocumentItem
    on $projection.OutboundDelivery = _DeliveryDocumentItem.DeliveryDocument

{
    
    key DeliveryDocument.DeliveryDocument as OutboundDelivery,
    
    @ObjectModel.mandatory: true
    DeliveryDocument.ShippingPoint,
    
    @ObjectModel.mandatory: true
    DeliveryDocument.DeliveryDocumentType,
    
    @ObjectModel.mandatory: true
    DeliveryDocument.SalesOrganization,
    
    @ObjectModel.mandatory: true
    _DeliveryDocumentItem.Division,
//    cast( ' ' as spart ) as Division,    

    
    @ObjectModel.mandatory: true
    _DeliveryDocumentItem.DistributionChannel,
//    cast( ' ' as vtweg ) as DistributionChannel,

    
    @ObjectModel.mandatory: true
    DeliveryDocument.ShipToParty,
    
    @ObjectModel.mandatory: true
    DeliveryDocument.PlannedGoodsIssueDate,
    
    _DeliveryDocumentItem.Plant,
    
    _DeliveryDocumentItem.StorageLocation,
    
    //Associations

    
     @ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ] 
    _DeliveryItemQuickCreate,
    _DeliveryDocumentType,
    _SalesOrganization,
    _Division,
    _DistributionChannel,
    _DeliveryDocumentItem,
    _ShippingPoint,
    _ShipToParty,
    _Plant,
    _StorageLocation
    
}
group by DeliveryDocument.DeliveryDocument,
         DeliveryDocument.ShippingPoint,
         DeliveryDocument.DeliveryDocumentType,
         DeliveryDocument.SalesOrganization,
         _DeliveryDocumentItem.Division, 
         _DeliveryDocumentItem.DistributionChannel,
         DeliveryDocument.ShipToParty,
         DeliveryDocument.PlannedGoodsIssueDate,
         _DeliveryDocumentItem.Plant,
         _DeliveryDocumentItem.StorageLocation

Learn More