I_SDDOCUMENTINCOMPLETIONLOG

CDS View

SD Document Incompletion Log

I_SDDOCUMENTINCOMPLETIONLOG is a CDS View in S/4HANA. SD Document Incompletion Log. It contains 1 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
C_RFM_MngSlsDocHdrIncompltn view from CONSUMPTION Header Details for Mass Incompletion
C_RFM_MngSlsDocItmIncompltn view from CONSUMPTION Item Details for Mass Incompletion
P_CustExpPriceIncompletionLog view from CONSUMPTION Sales Doc w. Cust-Expd Price IncLog
P_NmbrOfIncmpltFldForSDDoc view from CONSUMPTION Number of Incomplete Fields for SD Document

Fields (1)

KeyField CDS FieldsUsed in Views
KEY SDDocumentTable SDDocumentTable 2
@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
}