C_BillgDocItemRedacted

DDL: C_BILLGDOCITEMREDACTED Type: view CONSUMPTION

C_BillgDocItemRedacted is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentItem) and exposes 41 fields with key fields BillingDocument, BillingDocumentItem. It has 3 associations to related views.

1 data source(s) 41 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentItem Item from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_BillgDocRedacted _BillingDocument $projection.BillingDocument = _BillingDocument.BillingDocument
[0..1] I_ProductStdVH _Product $projection.Product = _Product.Product
[0..1] I_TaxCode _TaxCode $projection.taxcalculationprocedure = _TaxCode.TaxCalculationProcedure and $projection.TaxCode = _TaxCode.TaxCode

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CBDIREDACTED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.compositionRoot false view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
VDM.viewType #CONSUMPTION view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument I_BillingDocumentItem BillingDocument
KEY BillingDocumentItem I_BillingDocumentItem BillingDocumentItem
Product I_BillingDocumentItem Product
BillingDocumentItemText I_BillingDocumentItem BillingDocumentItemText
BillingQuantity I_BillingDocumentItem BillingQuantity
BillingQuantityUnit I_BillingDocumentItem BillingQuantityUnit
NetAmount I_BillingDocumentItem NetAmount
TaxAmount I_BillingDocumentItem TaxAmount
GrossAmount I_BillingDocumentItem GrossAmount
TransactionCurrency I_BillingDocumentItem TransactionCurrency
SalesDocumentItemCategory
PricingDate I_BillingDocumentItem PricingDate
StatisticalValueControl I_BillingDocumentItem StatisticalValueControl
ServicesRenderedDate I_BillingDocumentItem ServicesRenderedDate
DepartureCountry I_BillingDocumentItem DepartureCountry
TaxJurisdiction I_BillingDocumentItem TaxJurisdiction
ProductTaxClassification1 I_BillingDocumentItem ProductTaxClassification1
ProductTaxClassification2 I_BillingDocumentItem ProductTaxClassification2
ProductTaxClassification3 I_BillingDocumentItem ProductTaxClassification3
ProductTaxClassification4 I_BillingDocumentItem ProductTaxClassification4
ProductTaxClassification5 I_BillingDocumentItem ProductTaxClassification5
ProductTaxClassification6 I_BillingDocumentItem ProductTaxClassification6
ProductTaxClassification7 I_BillingDocumentItem ProductTaxClassification7
ProductTaxClassification8 I_BillingDocumentItem ProductTaxClassification8
ProductTaxClassification9 I_BillingDocumentItem ProductTaxClassification9
TaxCode I_BillingDocumentItem TaxCode
TaxDepartureCountry _BillingDocument TaxDepartureCountry
TaxCalculationProcedure
TaxRateValidityStartDate I_BillingDocumentItem TaxRateValidityStartDate
ZeroVATRsn I_BillingDocumentItem ZeroVATRsn
HigherLevelItem I_BillingDocumentItem HigherLevelItem
_BillingQuantityUnit I_BillingDocumentItem _BillingQuantityUnit
_TransactionCurrency I_BillingDocumentItem _TransactionCurrency
_HigherLevelItem I_BillingDocumentItem _HigherLevelItem
_Product _Product
_SalesDocumentItemCategory I_BillingDocumentItem _SalesDocumentItemCategory
_StatisticalValueControl I_BillingDocumentItem _StatisticalValueControl
_DepartureCountry I_BillingDocumentItem _DepartureCountry
_TaxDepartureCountry _BillingDocument _TaxDepartureCountry
_TaxCode _TaxCode
_BillingDocument _BillingDocument 
@AbapCatalog: { 
  sqlViewName: 'CBDIREDACTED',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.allowExtensions: true

@ObjectModel: {
  compositionRoot: false,
  semanticKey:     ['BillingDocument', 'BillingDocumentItem'],
  usageType: {
    serviceQuality:#D,
    sizeCategory: #XL,
    dataClass: #MIXED
  }
}

@Search.searchable: true

@VDM.viewType: #CONSUMPTION
define view C_BillgDocItemRedacted as select from I_BillingDocumentItem as Item 

  association [1..1] to C_BillgDocRedacted as _BillingDocument on $projection.BillingDocument = _BillingDocument.BillingDocument
  association [0..1] to I_ProductStdVH as _Product on $projection.Product = _Product.Product
  association [0..1] to I_TaxCode as _TaxCode on $projection.taxcalculationprocedure = _TaxCode.TaxCalculationProcedure and 
                                                 $projection.TaxCode = _TaxCode.TaxCode                                                 
{
  
  key Item.BillingDocument,

  key Item.BillingDocumentItem,

      @ObjectModel.foreignKey.association: '_Product'
      Item.Product,      
      Item.BillingDocumentItemText,
      Item.BillingQuantity,
      Item.BillingQuantityUnit,
      Item.NetAmount,
      Item.TaxAmount,
      Item.GrossAmount,
      Item.TransactionCurrency,
      @ObjectModel.foreignKey.association: '_SalesDocumentItemCategory'
      cast (Item.SalesDocumentItemCategory as pstyv preserving type ) as SalesDocumentItemCategory,
      Item.PricingDate,
      Item.StatisticalValueControl,
      Item.ServicesRenderedDate,
      Item.DepartureCountry,
      Item.TaxJurisdiction,
      Item.ProductTaxClassification1,
      Item.ProductTaxClassification2,
      Item.ProductTaxClassification3,
      Item.ProductTaxClassification4,
      Item.ProductTaxClassification5,
      Item.ProductTaxClassification6,
      Item.ProductTaxClassification7,
      Item.ProductTaxClassification8,
      Item.ProductTaxClassification9,
      @ObjectModel.foreignKey.association: '_TaxCode'
      Item.TaxCode,
      _BillingDocument.TaxDepartureCountry, // only required for foreign key assocatiation '_TaxCode'      

      _BillingDocument._TaxDepartureCountry.TaxCalculationProcedure, // only required for foreign key assocatiation '_TaxCode'   

      Item.TaxRateValidityStartDate,    
      Item.ZeroVATRsn,
      Item.HigherLevelItem,
     
      @Search.defaultSearchElement: false
      Item._BillingQuantityUnit,
      @Search.defaultSearchElement: false
      Item._TransactionCurrency,
      @Search.defaultSearchElement: false
      Item._HigherLevelItem,
      @Search.defaultSearchElement: false
      _Product,
      @Search.defaultSearchElement: false
      Item._SalesDocumentItemCategory,
      @Search.defaultSearchElement: false
      Item._StatisticalValueControl,
      @Search.defaultSearchElement: false
      Item._DepartureCountry,
      @Search.defaultSearchElement: false
      _BillingDocument._TaxDepartureCountry,
      @Search.defaultSearchElement: false
      _TaxCode,
      @Search.defaultSearchElement: false            
      _BillingDocument  
}
where Item._BillingDocument.BillingDocumentIsTemporary = ' ' and 
      Item._BillingDocument.BillingDocumentCategory <> 'R'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_BILLGDOCREDACTED",
"I_BILLINGDOCUMENT",
"I_BILLINGDOCUMENTITEM",
"I_COUNTRY"
],
"ASSOCIATED":
[
"C_BILLGDOCREDACTED",
"I_BILLINGDOCUMENTITEM",
"I_COUNTRY",
"I_CURRENCY",
"I_PRODUCTSTDVH",
"I_SALESDOCUMENTITEMCATEGORY",
"I_STATISTICALVALUECONTROL",
"I_TAXCODE",
"I_UNITOFMEASURE"
],
"BASE":
[
"C_BILLGDOCREDACTED",
"I_BILLINGDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More