I_PROJECTBILLINGDOCDETAILS

CDS View

Billing Document Details

I_PROJECTBILLINGDOCDETAILS is a CDS View in S/4HANA. Billing Document Details. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_ProjectBillingDocDetails view_entity from CONSUMPTION Billing Document Details 
@AbapCatalog.sqlViewName: 'IPROJBILLDETAILS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@EndUserText.label: 'Billing Document Details'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M


define view I_ProjectBillingDocDetails
  as select distinct from I_BillingDocumentItem as billingDocumentITem
    inner join            I_BillingDocument     as _BillingDocument on billingDocumentITem.BillingDocument = _BillingDocument.BillingDocument
    
    association [0..*] to I_SDDocumentCategoryText as _Text on $projection.SDDocumentCategory = _Text.SDDocumentCategory
                                                               and _Text.Language = $session.system_language                               
                                                               
  //  association [1..1] to I_BillingDocument as _BillingDocument on $projection.BillingDocument = _BillingDocument.BillingDocument

{
       // key  BillingDocumentItem,    // commented as this results in more entries per billing document item ID

       @UI.lineItem: [{position: 10 }]
  key  _BillingDocument.BillingDocument, // Billing ID

  key  WBSElementInternalID,
       
       //     @UI.hidden: true

       @Semantics.currencyCode: true
       _BillingDocument.TransactionCurrency,
       @Semantics: { amount : {currencyCode: 'TransactionCurrency'} }
       _BillingDocument.TotalNetAmount   as TotalNetAmount, // Total Bill Amount

       _BillingDocument.BillingDocumentDate, //Billing  date

//       cast(WBSElement as ps_posid_edit) as WBSElement,

        
      _BillingDocument.SDDocumentCategory,
//      _BillingDocument._SDDocumentCategory._Text.SDDocumentCategoryName

      _Text.SDDocumentCategoryName
} where _BillingDocument.AccountingTransferStatus = 'C' and _BillingDocument.BillingDocumentType <> 'CI02'

Learn More