P_BSQPMBILLGDOCSDTOCAINVCGDOC

CDS View

P_BSQPMBILLGDOCSDTOCAINVCGDOC is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_BSQPMSolnQtanItmProcFlw view_entity union COMPOSITE
P_BSQPMSolnQtanProcFlw view_entity union COMPOSITE 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #B,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_BSQPMBillgDocSDToCAInvcgDoc
  as select from I_CAInvcgDocItem as _CAInvcgDocItem
{
  key    _CAInvcgDocItem.CAInvoicingDocument                                                             as SubsequentDocument,
  key    _CAInvcgDocItem.CAInvcgDocItem                                                                  as SubsequentDocumentItem,
         'CAID'                                                                                          as SubsequentDocumentCategory,
         cast( lpad( ltrim( _CAInvcgDocItem.CAInvcgSourceDocumentNumber, '0' ), 10, '0' ) as vbeln_vl  ) as PrecedingDocument,
         cast( lpad( ltrim( _CAInvcgDocItem.CAInvcgSourceDocumentItem, '0' ), 6, '0' ) as posnr )        as PrecedingDocumentItem,
         'M'                                                                                             as PrecedingDocumentCategory

}
where
      _CAInvcgDocItem.CAInvcgSourceDocumentCat    = 'VBRK'
  and _CAInvcgDocItem.CAInvcgSourceDocumentNumber is not initial
  and _CAInvcgDocItem.CAInvcgSourceDocumentItem   is not initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAINVCGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More