I_SDDocumentIncompletionLog

DDL: I_SDDOCUMENTINCOMPLETIONLOG Type: view BASIC Package: VDM_SD_SLS

SD Document Incompletion Log

I_SDDocumentIncompletionLog is a Basic CDS View that provides data about "SD Document Incompletion Log" in SAP S/4HANA. It reads from 1 data source (vbuv) and exposes 11 fields with key fields SDDocument, SDDocumentItem, ScheduleLine, PartnerFunction, SDDocumentTextID. It has 2 associations to related views. Part of development package VDM_SD_SLS.

Data Sources (1)

SourceAliasJoin Type
vbuv vbuv from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_SalesDocumentScheduleLine _ScheduleLine $projection.SDDocument = _ScheduleLine.SalesDocument and $projection.SDDocumentItem = _ScheduleLine.SalesDocumentItem and $projection.ScheduleLine = _ScheduleLine.ScheduleLine
[0..1] I_PartnerFunction _PartnerFunction $projection.PartnerFunction = _PartnerFunction.PartnerFunction

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.sqlViewName ISDDOCINCMPLTLOG view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label SD Document Incompletion Log view
VDM.viewType #BASIC view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SDDocument vbeln
KEY SDDocumentItem posnr
KEY ScheduleLine etenr
KEY PartnerFunction parvw
KEY SDDocumentTextID tdid
KEY SDDocumentTable tbnam
KEY SDDocumentTableField fdnam
IncompletionProcedure fehgr
IncompletionStatusGroup statg
_ScheduleLine _ScheduleLine
_PartnerFunction _PartnerFunction
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck:#PRIVILEGED_ONLY

@AbapCatalog: {
  sqlViewName: 'ISDDOCINCMPLTLOG',
  preserveKey:true,
  compiler.compareFilter: true
}

@ObjectModel: {
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #B,
    sizeCategory: #L
  },
  supportedCapabilities: [ #SQL_DATA_SOURCE,
                           #CDS_MODELING_DATA_SOURCE,
                           #CDS_MODELING_ASSOCIATION_TARGET ]
}

@EndUserText.label: 'SD Document Incompletion Log'
@VDM.viewType: #BASIC
@Metadata.ignorePropagatedAnnotations:true

define view I_SDDocumentIncompletionLog
  as select from vbuv
  association [1..1] to I_SalesDocumentScheduleLine as _ScheduleLine  on $projection.SDDocument      = _ScheduleLine.SalesDocument
                                                                     and $projection.SDDocumentItem  = _ScheduleLine.SalesDocumentItem
                                                                     and $projection.ScheduleLine    = _ScheduleLine.ScheduleLine
  association [0..1] to I_PartnerFunction as _PartnerFunction         on $projection.PartnerFunction = _PartnerFunction.PartnerFunction

{
      //Key

  key vbeln     as SDDocument,
  key posnr     as SDDocumentItem,
  key etenr     as ScheduleLine,
      @ObjectModel.foreignKey.association: '_PartnerFunction'
  key parvw     as PartnerFunction,
  key tdid      as SDDocumentTextID,
  key tbnam     as SDDocumentTable,
  key fdnam     as SDDocumentTableField,

      fehgr     as IncompletionProcedure,
      statg     as IncompletionStatusGroup,

      //Association

      _ScheduleLine,
      _PartnerFunction
}