A_BillingDocumentRequestItem

DDL: A_BILLINGDOCUMENTREQUESTITEM Type: view COMPOSITE

Billing Document Request Item

A_BillingDocumentRequestItem is a Composite CDS View that provides data about "Billing Document Request Item" in SAP S/4HANA. It reads from 1 data source (I_BillingDocumentRequestItem) and exposes 40 fields with key fields BillingDocumentRequest, BillingDocumentRequestItem. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentRequestItem I_BillingDocumentRequestItem from

Associations (4)

CardinalityTargetAliasCondition
[1..1] A_BillingDocumentRequest _BillingDocumentRequest $projection.BillingDocumentRequest = _BillingDocumentRequest.BillingDocumentRequest
[0..*] A_BillingDocReqItemPartner _Partner $projection.BillingDocumentRequest = _Partner.BillingDocumentRequest and $projection.BillingDocumentRequestItem = _Partner.BillingDocumentRequestItem
[0..*] A_BillingDocReqItemPrcgElmnt _PricingElement $projection.BillingDocumentRequest = _PricingElement.BillingDocumentRequest and $projection.BillingDocumentRequestItem = _PricingElement.BillingDocumentRequestItem
[0..1] E_BillingDocumentItem _Extension $projection.BillingDocumentRequest = _Extension.BillingDocument and $projection.BillingDocumentRequestItem = _Extension.BillingDocumentItem

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Billing Document Request Item view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ASDBDREQITEM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest BillingDocumentRequest
KEY BillingDocumentRequestItem BillingDocumentRequestItem
CreationDate CreationDate
CreationTime CreationTime
ReferenceLogicalSystem ReferenceLogicalSystem
Division Division
Material Material
ProductHierarchyNode ProductHierarchyNode
Plant Plant
BillingDocumentRequestItemText BillingDocumentRequestItemText
ServicesRenderedDate ServicesRenderedDate
BillingQuantity BillingQuantity
BillingQuantityUnit BillingQuantityUnit
NetAmount NetAmount
TransactionCurrency TransactionCurrency
GrossAmount GrossAmount
PricingDate PricingDate
AbsltPriceDetnExchangeRate
PriceDetnExchRateIsIndrctQtan
TaxAmount TaxAmount
DepartureCountry DepartureCountry
TaxJurisdiction TaxJurisdiction
ProductTaxClassification1 ProductTaxClassification1
BusinessArea BusinessArea
ProfitCenter ProfitCenter
WBSElement
ControllingArea ControllingArea
ProfitabilitySegment ProfitabilitySegment_2
OrderID OrderID
CostCenter CostCenter
MatlAccountAssignmentGroup MatlAccountAssignmentGroup
ReferenceDocument ReferenceDocument
ReferenceDocumentItem ReferenceDocumentItem
HigherLevelItem HigherLevelItem
BillgDocRequestItemInPartSgmt BillgDocRequestItemInPartSgmt
BillingDocumentRequestType _BillingDocumentRequest BillingDocumentRequestType
SalesOrganization _BillingDocumentRequest SalesOrganization
_BillingDocumentRequest _BillingDocumentRequest
_Partner _Partner
_PricingElement _PricingElement
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Billing Document Request Item'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ASDBDREQITEM',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: { 
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
  createEnabled: false,
  updateEnabled: false,
  deleteEnabled: false,
  usageType: {
    dataClass: #TRANSACTIONAL,
    serviceQuality: #C,
    sizeCategory: #XL
  }
} 
@Metadata: {
  ignorePropagatedAnnotations: true
}

define view A_BillingDocumentRequestItem as select from I_BillingDocumentRequestItem

  association [1..1] to A_BillingDocumentRequest     as _BillingDocumentRequest   on  $projection.BillingDocumentRequest     = _BillingDocumentRequest.BillingDocumentRequest 
  association [0..*] to A_BillingDocReqItemPartner   as _Partner                  on  $projection.BillingDocumentRequest     = _Partner.BillingDocumentRequest    
                                                                                  and $projection.BillingDocumentRequestItem = _Partner.BillingDocumentRequestItem 
  association [0..*] to A_BillingDocReqItemPrcgElmnt as _PricingElement           on  $projection.BillingDocumentRequest     = _PricingElement.BillingDocumentRequest     
                                                                                  and $projection.BillingDocumentRequestItem = _PricingElement.BillingDocumentRequestItem 

//Extensibility

  association [0..1] to E_BillingDocumentItem        as _Extension                on  $projection.BillingDocumentRequest     = _Extension.BillingDocument
                                                                                  and $projection.BillingDocumentRequestItem = _Extension.BillingDocumentItem
{

      //Key

  key BillingDocumentRequest,
  key BillingDocumentRequestItem,

      //Category

      //SalesDocumentItemCategory,

      
      //Admin

      CreationDate,
      CreationTime,
      ReferenceLogicalSystem,
      
      //Organization

      @ObjectModel.sapObjectNodeTypeReference: 'Division'          
      Division,
      
      //Product

      Material,
      ProductHierarchyNode,
      Plant,
      
      //Billing

      BillingDocumentRequestItemText,
      ServicesRenderedDate,
      @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
      BillingQuantity,
      @Semantics.unitOfMeasure: true
      BillingQuantityUnit,

      //Pricing

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      NetAmount,
      @Semantics.currencyCode: true
      @ObjectModel.sapObjectNodeTypeReference: 'Currency'                
      TransactionCurrency,
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      GrossAmount,
      PricingDate,
      cast(abs( PriceDetnExchangeRate ) as kursk_abs) as AbsltPriceDetnExchangeRate,
      cast(case when PriceDetnExchangeRate < 0 then 'X' else ' ' end  as kursk_quotatn_is_indirect) as PriceDetnExchRateIsIndrctQtan,     
      @Semantics.amount.currencyCode: 'TransactionCurrency'
      TaxAmount,
      
      //Tax

      DepartureCountry,
      @ObjectModel.sapObjectNodeTypeReference: 'TaxJurisdiction'                      
      TaxJurisdiction,
      ProductTaxClassification1,
      
      //Accounting

      BusinessArea,
      ProfitCenter,
      cast( WBSElementInternalID as ps_psp_pnr preserving type ) as WBSElement,
      ControllingArea,
      ProfitabilitySegment_2 as ProfitabilitySegment,      
      OrderID,
      CostCenter,
      @ObjectModel.sapObjectNodeTypeReference: 'MaterialAccountAssignmentGroup'                
      MatlAccountAssignmentGroup,
      
      //Reference

      ReferenceDocument,
      ReferenceDocumentItem,
      //ReferenceDocSDDocCategory,

      HigherLevelItem,
      BillgDocRequestItemInPartSgmt,

      //For Access control

      @Consumption.hidden: true
      _BillingDocumentRequest.BillingDocumentRequestType,
      @Consumption.hidden: true
      _BillingDocumentRequest.SalesOrganization,

          
      //Make associations public

      _BillingDocumentRequest,
      _Partner,
      _PricingElement  
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_BILLINGDOCUMENTREQUEST",
"I_BILLINGDOCUMENTREQUESTITEM"
],
"ASSOCIATED":
[
"A_BILLINGDOCREQITEMPARTNER",
"A_BILLINGDOCREQITEMPRCGELMNT",
"A_BILLINGDOCUMENTREQUEST",
"E_BILLINGDOCUMENTITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/