I_ProjectBillingDocDetails

DDL: I_PROJECTBILLINGDOCDETAILS SQL: IPROJBILLDETAILS Type: view BASIC

Billing Document Details

I_ProjectBillingDocDetails is a Basic CDS View that provides data about "Billing Document Details" in SAP S/4HANA. It reads from 1 data source (I_BillingDocument) and exposes 7 fields with key fields BillingDocument, WBSElementInternalID. It has 1 association to related views. It is exposed through 3 OData services (MANAGEPROJBILLGREQUEST_SD, PROJECTBILLINGELEMENT_SD, PROJECTBILLINGREQUEST_SD).

1 data source(s) Exposed by 3 service(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocument _BillingDocument inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_SDDocumentCategoryText _Text $projection.SDDocumentCategory = _Text.SDDocumentCategory and _Text.Language = $session.system_language

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPROJBILLDETAILS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
EndUserText.label Billing Document Details view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view

OData Services (3)

ServiceBindingVersionContractRelease
MANAGEPROJBILLGREQUEST_SD UI_MNGPROJBILLGREQ_SB_V2 V2 C1 NOT_RELEASED
PROJECTBILLINGELEMENT_SD UI_PROJBILLGELMNT_SB_V2 V2 C1 NOT_RELEASED
PROJECTBILLINGREQUEST_SD UI_PROJBILLGREQUEST_SB_V2 V2 C1 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocument BillingDocument
KEY WBSElementInternalID WBSElementInternalID
TransactionCurrency I_BillingDocument TransactionCurrency
TotalNetAmount I_BillingDocument TotalNetAmount
BillingDocumentDate I_BillingDocument BillingDocumentDate
SDDocumentCategory I_BillingDocument SDDocumentCategory
SDDocumentCategoryName _Text SDDocumentCategoryName 
@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