I_DeliveryDocumentType

DDL: I_DELIVERYDOCUMENTTYPE SQL: ILEDELIVDOCTYPE Type: view BASIC Package: VDM_LE_SHP_COMMON

Delivery Document Type

I_DeliveryDocumentType is a Basic CDS View (Dimension) that provides data about "Delivery Document Type" in SAP S/4HANA. It reads from 1 data source (tvlk) and exposes 29 fields with key field DeliveryDocumentType. It has 7 associations to related views. Part of development package VDM_LE_SHP_COMMON.

Data Sources (1)

SourceAliasJoin Type
tvlk tvlk from

Associations (7)

CardinalityTargetAliasCondition
[0..*] I_DeliveryDocumentTypeText _Text $projection.DeliveryDocumentType = _Text.DeliveryDocumentType
[1..1] I_SDDocumentCategory _SDDocumentCategory $projection.SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory
[0..1] I_SalesDocumentType _SDDocumentType $projection.DefaultOrderType = _SDDocumentType.SalesDocumentType
[0..1] I_TextDeterminationProcedure _TextDeterminationProcedure $projection.TextDeterminationProcedure = _TextDeterminationProcedure.TextDeterminationProcedure and _TextDeterminationProcedure.TextObjectCategory = 'VBBK'
[0..1] I_PartDeterminationProcedure _PartnerDeterminationProcedure $projection.PartnerDeterminationProcedure = _PartnerDeterminationProcedure.PartnerDeterminationProcedure
[0..1] I_UnitOfMeasure _ExtTransfOfCtrlDateOffsetUnit $projection.ExtTransfOfCtrlDateOffsetUnit = _ExtTransfOfCtrlDateOffsetUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _IntTransfOfCtrlDateOffsetUnit $projection.IntTransfOfCtrlDateOffsetUnit = _IntTransfOfCtrlDateOffsetUnit.UnitOfMeasure

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey DeliveryDocumentType view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Delivery Document Type view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName ILEDELIVDOCTYPE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name DeliveryDocumentType view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY DeliveryDocumentType lfart
SDDocumentCategory vbtyp
PrecedingDocumentRequirement aufer
TradeComplianceIsActive itmac
NumberRangeForIntIDAssignment numki
NumberRangeForExtIDAssignment numke
IncrementItemNumber incpo
DefaultOrderType daart
StorageLocationRule reglg
TextDeterminationProcedure txtgr
RouteDetermination routf
DeliveryIsSplitByWarehouse lnspl
DeliveryIsSplitByPartner dsfad
DeliveryIsPackedAutomatically averp
DelivItmsAreGnrtdForPackggMatl pm_item_gen
PartnerDeterminationProcedure pargr
RescheduleDeliveries neute
IntTransfOfControlDateOffset int_tocd_offset
IntTransfOfCtrlDateOffsetUnit int_tocd_offset_unit
ExtTransfOfControlDateOffset ext_tocd_offset
ExtTransfOfCtrlDateOffsetUnit ext_tocd_offset_unit
AR_ElectronicDocDocumentClass j_1adoccls
_SDDocumentCategory _SDDocumentCategory
_SDDocumentType _SDDocumentType
_TextDeterminationProcedure _TextDeterminationProcedure
_PartnerDeterminationProcedure _PartnerDeterminationProcedure
_ExtTransfOfCtrlDateOffsetUnit _ExtTransfOfCtrlDateOffsetUnit
_IntTransfOfCtrlDateOffsetUnit _IntTransfOfCtrlDateOffsetUnit
_Text _Text
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: 'DeliveryDocumentType'
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@EndUserText.label: 'Delivery Document Type'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck:#NOT_REQUIRED
@AbapCatalog.sqlViewName: 'ILEDELIVDOCTYPE'
@Metadata.allowExtensions: true
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [ #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #ANALYTICAL_DIMENSION ]
@ObjectModel.modelingPattern: [ #ANALYTICAL_DIMENSION ]
@ObjectModel.sapObjectNodeType.name: 'DeliveryDocumentType'

define view I_DeliveryDocumentType
  as select from tvlk

  association [0..*] to I_DeliveryDocumentTypeText   as _Text                          on  $projection.DeliveryDocumentType = _Text.DeliveryDocumentType
  association [1..1] to I_SDDocumentCategory         as _SDDocumentCategory            on  $projection.SDDocumentCategory = _SDDocumentCategory.SDDocumentCategory
  association [0..1] to I_SalesDocumentType          as _SDDocumentType                on  $projection.DefaultOrderType = _SDDocumentType.SalesDocumentType
  association [0..1] to I_TextDeterminationProcedure as _TextDeterminationProcedure    on  $projection.TextDeterminationProcedure         = _TextDeterminationProcedure.TextDeterminationProcedure
                                                                                       and _TextDeterminationProcedure.TextObjectCategory = 'VBBK'
  association [0..1] to I_PartDeterminationProcedure as _PartnerDeterminationProcedure on  $projection.PartnerDeterminationProcedure = _PartnerDeterminationProcedure.PartnerDeterminationProcedure
  association [0..1] to I_UnitOfMeasure              as _ExtTransfOfCtrlDateOffsetUnit on  $projection.ExtTransfOfCtrlDateOffsetUnit = _ExtTransfOfCtrlDateOffsetUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _IntTransfOfCtrlDateOffsetUnit on  $projection.IntTransfOfCtrlDateOffsetUnit = _IntTransfOfCtrlDateOffsetUnit.UnitOfMeasure
{
      @ObjectModel.text.association: '_Text'
  key lfart                as DeliveryDocumentType,

      @ObjectModel.foreignKey.association: '_SDDocumentCategory'
      vbtyp                as SDDocumentCategory,

      aufer                as PrecedingDocumentRequirement,

      @Semantics.booleanIndicator: true
      itmac                as TradeComplianceIsActive,

      numki                as NumberRangeForIntIDAssignment,

      numke                as NumberRangeForExtIDAssignment,

      incpo                as IncrementItemNumber,

      @ObjectModel.foreignKey.association: '_SDDocumentType'
      daart                as DefaultOrderType,

      reglg                as StorageLocationRule,

      @ObjectModel.foreignKey.association: '_TextDeterminationProcedure'
      txtgr                as TextDeterminationProcedure,

      routf                as RouteDetermination,

      @Semantics.booleanIndicator: true
      lnspl                as DeliveryIsSplitByWarehouse,

      @Semantics.booleanIndicator: true
      dsfad                as DeliveryIsSplitByPartner,

      @Semantics.booleanIndicator: true
      averp                as DeliveryIsPackedAutomatically,

      @Semantics.booleanIndicator: true
      pm_item_gen          as DelivItmsAreGnrtdForPackggMatl,

      @ObjectModel.foreignKey.association:'_PartnerDeterminationProcedure'
      pargr                as PartnerDeterminationProcedure,

      neute                as RescheduleDeliveries,

      @Semantics.quantity.unitOfMeasure: 'IntTransfOfCtrlDateOffsetUnit'
      int_tocd_offset      as IntTransfOfControlDateOffset,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association:'_IntTransfOfCtrlDateOffsetUnit'
      int_tocd_offset_unit as IntTransfOfCtrlDateOffsetUnit,

      @Semantics.quantity.unitOfMeasure: 'ExtTransfOfCtrlDateOffsetUnit'
      ext_tocd_offset      as ExtTransfOfControlDateOffset,

      @Semantics.unitOfMeasure: true
      @ObjectModel.foreignKey.association:'_ExtTransfOfCtrlDateOffsetUnit'
      ext_tocd_offset_unit as ExtTransfOfCtrlDateOffsetUnit,

      j_1adoccls           as AR_ElectronicDocDocumentClass,


      //Associations

      _SDDocumentCategory,
      _SDDocumentType,
      _TextDeterminationProcedure,
      _PartnerDeterminationProcedure,
      _ExtTransfOfCtrlDateOffsetUnit,
      _IntTransfOfCtrlDateOffsetUnit,
      _Text
};