I_DelivWthRefQuickCreate

DDL: I_DELIVWTHREFQUICKCREATE SQL: IDELIVWREFQC Type: view BASIC

Quick Create Deliv with reference TP

I_DelivWthRefQuickCreate is a Basic CDS View that provides data about "Quick Create Deliv with reference TP" in SAP S/4HANA. It reads from 1 data source (I_DeliveryDocument) and exposes 18 fields with key field OutboundDelivery.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_DeliveryDocument DeliveryDocument from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IDELIVWREFQC 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 Deliv with reference TP view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY OutboundDelivery I_DeliveryDocument DeliveryDocument
ReferenceSDDocument
ShippingPoint I_DeliveryDocument ShippingPoint
DeliveryDate
DeliveryDocumentType I_DeliveryDocument DeliveryDocumentType
SalesOrganization I_DeliveryDocument SalesOrganization
DistributionChannel _DeliveryDocumentItem DistributionChannel
Division _DeliveryDocumentItem Division
ShipToParty I_DeliveryDocument ShipToParty
PlannedGoodsIssueDate I_DeliveryDocument PlannedGoodsIssueDate
ReferenceDocument _DeliveryDocumentItem ReferenceSDDocument
_ShippingPoint _ShippingPoint
_DeliveryDocumentType _DeliveryDocumentType
_SalesOrganization _SalesOrganization
_DistributionChannel _DeliveryDocumentItem _DistributionChannel
_Division _DeliveryDocumentItem _Division
_ShipToParty _ShipToParty
_ReferenceSDDocument _DeliveryDocumentItem _ReferenceSDDocument 
@AbapCatalog.sqlViewName: 'IDELIVWREFQC'
@VDM.viewType: #BASIC
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE

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

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


@EndUserText.label: 'Quick Create Deliv with reference TP'
define view I_DelivWthRefQuickCreate as select from I_DeliveryDocument as DeliveryDocument

  // needed for distribution channel and division

  association[0..*] to I_DeliveryDocumentItem as _DeliveryDocumentItem
    on $projection.OutboundDelivery = _DeliveryDocumentItem.DeliveryDocument
{
   key DeliveryDocument.DeliveryDocument as OutboundDelivery,
   
   @ObjectModel.mandatory: true
   cast ('' as vgbel) as ReferenceSDDocument,  
   
   @ObjectModel.mandatory: true
     @EndUserText: { label:  'Filter by Shipping Point', 
  quickInfo: 'Filter Schedule Lines by Shipping Point' }
   DeliveryDocument.ShippingPoint,

  @EndUserText: { label:  'Filter by Date', 
  quickInfo: 'Filter Schedule Lines by Date' }
   cast ($session.system_date as datum) as DeliveryDate,
   
   //Quick View

   @UI.textArrangement: #TEXT_FIRST
   DeliveryDocument.DeliveryDocumentType,
   DeliveryDocument.SalesOrganization,
   _DeliveryDocumentItem.DistributionChannel,
   _DeliveryDocumentItem.Division,
   DeliveryDocument.ShipToParty,
   @EndUserText: { label:  'Planned GI Date', 
    quickInfo: 'Planned GI Date' }
   DeliveryDocument.PlannedGoodsIssueDate,
    _DeliveryDocumentItem.ReferenceSDDocument as ReferenceDocument,
    
    
    //Associations

    _ShippingPoint,
    _DeliveryDocumentType,
    _SalesOrganization,
    _DeliveryDocumentItem._DistributionChannel as _DistributionChannel,
    _DeliveryDocumentItem._Division as _Division,
    _ShipToParty,
    _DeliveryDocumentItem._ReferenceSDDocument as _ReferenceSDDocument
    
    
}  group by 

//multiplicity of items >1..1 document crashes in quick view

  _DeliveryDocumentItem.DistributionChannel,
  _DeliveryDocumentItem.Division,
  _DeliveryDocumentItem.ReferenceSDDocument,
  DeliveryDocument.DeliveryDocument,
  DeliveryDocument.ShippingPoint,
  DeliveryDocument.DeliveryDocumentType,
  DeliveryDocument.SalesOrganization,
  DeliveryDocument.ShipToParty,
  DeliveryDocument.PlannedGoodsIssueDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_CUSTOMER",
"I_DELIVERYDOCUMENTITEM",
"I_DELIVERYDOCUMENTTYPE",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_SALESDOCUMENT",
"I_SALESORGANIZATION",
"I_SHIPPINGPOINT"
],
"BASE":
[
"I_DELIVERYDOCUMENT",
"I_DELIVERYDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More