C_SALESDOCUMENTBILLINGSTATUS

CDS View

Billing Status of a Sales Document

C_SALESDOCUMENTBILLINGSTATUS is a CDS View in S/4HANA. Billing Status of a Sales Document. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_SalesOrderAgedDebtDetails view inner CONSUMPTION Aged Debt Details for a Sales Order 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CSDBILLSTAT'
@EndUserText.label: 'Billing Status of a Sales Document'
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.authorizationCheck:#CHECK
define view C_SalesDocumentBillingStatus
  as select from I_BillingDocumentItem as BillingDocumentItem
  association [0..*] to I_ReceivablesPayablesItem as _PayableItems on BillingDocumentItem.BillingDocument = _PayableItems.BillingDocument

{
  key BillingDocumentItem.BillingDocument          as  BillingDocument,
  key _PayableItems.ClearingAccountingDocument     as  ClearingAccountingDocument,
      case _PayableItems.ClearingAccountingDocument
          when '' then 'I001'
          else 'I002'
      end                                          as  AccountingDocumentStatus,
      _BillingDocument                             as  _BillingDoc,
      _PayableItems
}
group by
  BillingDocumentItem.BillingDocument,
  _PayableItems.ClearingAccountingDocument
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTITEM",
"I_RECEIVABLESPAYABLESITEM"
],
"ASSOCIATED":
[
"I_BILLINGDOCUMENT",
"I_RECEIVABLESPAYABLESITEM"
],
"BASE":
[
"I_BILLINGDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More