P_BSQPMBILLGDOCTOCAINVCGDOC

CDS View

P_BSQPMBILLGDOCTOCAINVCGDOC 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
//@EndUserText.label: 'Provider Contract to CA Billing Document'

@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
    sizeCategory: #XL,
    dataClass: #TRANSACTIONAL
}
@VDM.private: true
@VDM.viewType: #COMPOSITE
define view entity P_BSQPMBillgDocToCAInvcgDoc
  as select from I_CAInvcgDocItem as CAInvcgDocItem
{

  key  cast( lpad( ltrim( CAInvcgDocItem.CAInvcgSourceDocumentNumber, '0'), 12, '0' ) as billdocno_kk preserving type ) as PrecedingDocument,
  key  cast( lpad( ltrim( CAInvcgDocItem.CAInvcgSourceDocumentItem, '0'), 8, '0' ) as numc08 )                          as PrecedingDocumentItem,
       'CABD'                                                                                                           as PrecedingDocumentCategory,
       CAInvcgDocItem.CAInvoicingDocument                                                                               as SubsequentDocument,
       CAInvcgDocItem.CAInvcgDocItem                                                                                    as SubsequentDocumentItem,
       'CAID'                                                                                                           as SubsequentDocumentCategory
}
where
  CAInvcgDocItem.CAInvcgSourceDocumentCat = 'INVBI';
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CAINVCGDOCITEM"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More