C_DisplayDocumentFlowBilling

DDL: C_DISPLAYDOCUMENTFLOWBILLING Type: view_entity CONSUMPTION Package: ODATA_GL_DSP_DOC_FLW

Billing Document and Invoice List

C_DisplayDocumentFlowBilling is a Consumption CDS View that provides data about "Billing Document and Invoice List" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentBasic) and exposes 20 fields with key field BillingDocument. Part of development package ODATA_GL_DSP_DOC_FLW.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentBasic Billing from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
EndUserText.label Billing Document and Invoice List view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocument
CompanyCode CompanyCode
BillingDocumentType BillingDocumentType
BillingDocumentDate BillingDocumentDate
SalesOrganization SalesOrganization
SoldToParty SoldToParty
CustomerName
AuthorizationGroup
CustomerAccountGroup
IsBusinessPurposeCompleted
PayerParty I_BillingDocumentBasic PayerParty
TotalNetAmount TotalNetAmount
TransactionCurrency TransactionCurrency
_PartnerBasic _PartnerBasic
_TransactionCurrency _TransactionCurrency
_BillingDocumentType _BillingDocumentType
_CompanyCode _CompanyCode
_SalesOrganization _SalesOrganization
_SoldToParty _SoldToParty
_PayerParty _PayerParty 
@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

@ObjectModel.usageType:{ serviceQuality: #C, sizeCategory: #L, dataClass: #MIXED }

@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Billing Document and Invoice List'
define view entity C_DisplayDocumentFlowBilling 
 as select from I_BillingDocumentBasic as Billing
 
{
  key BillingDocument,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      @ObjectModel.foreignKey.association: '_BillingDocumentType'
      BillingDocumentType,
      BillingDocumentDate,
      @ObjectModel.foreignKey.association: '_SalesOrganization'
      SalesOrganization,
      @ObjectModel.foreignKey.association: '_SoldToParty'
      SoldToParty,
      Billing._SoldToParty.CustomerName,
      Billing._SoldToParty.AuthorizationGroup,    
      Billing._SoldToParty.CustomerAccountGroup,    
      Billing._SoldToParty.IsBusinessPurposeCompleted,
      Billing.PayerParty,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TotalNetAmount,
      TransactionCurrency,
      
      _PartnerBasic,
      _TransactionCurrency,
      _BillingDocumentType,
      _CompanyCode,
      _SalesOrganization,
      _SoldToParty,
      _PayerParty    
}
where
     SDDocumentCategory = '3' // Invoice List

  or SDDocumentCategory = '4' // Credit Memo List

  or SDDocumentCategory = 'M' // Invoice

  or SDDocumentCategory = 'N' // Invoice Canceled

  or SDDocumentCategory = 'O' // Credit Memo

  or SDDocumentCategory = 'P' // Debit Memo

  or SDDocumentCategory = 'S' // Credit Memo Canceled

  or SDDocumentCategory = 'U' // Pro Forma Invoice

  or SDDocumentCategory = '5' // Intercompany Invoice

  or SDDocumentCategory = '6' // Intercompany Credit Memo

Learn More