R_BillingDocumentRequestItemTP

DDL: R_BILLINGDOCUMENTREQUESTITEMTP Type: view_entity TRANSACTIONAL

Billing Document Request Item - TP

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

1 data source(s) 146 fields

Data Sources (1)

SourceAliasJoin Type
I_BillingDocumentRequestItem I_BillingDocumentRequestItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Batch _Batch $projection.Plant = _Batch.Plant and $projection.Product = _Batch.Material and $projection.Batch = _Batch.Batch
[0..1] E_BillingDocumentItem _Extension $projection.BillingDocumentRequest = _Extension.BillingDocument and $projection.BillingDocumentRequestItem = _Extension.BillingDocumentItem

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Billing Document Request Item - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XL view

Fields (146)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest BillingDocumentRequest
KEY BillingDocumentRequestItem BillingDocumentRequestItem
SalesDocumentItemCategory SalesDocumentItemCategory
SalesDocumentItemType SalesDocumentItemType
ReturnItemProcessingType ReturnItemProcessingType
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
ReferenceLogicalSystem ReferenceLogicalSystem
OrganizationDivision OrganizationDivision
Division Division
SalesOffice SalesOffice
Product Product
OriginallyRequestedMaterial OriginallyRequestedMaterial
InternationalArticleNumber InternationalArticleNumber
PricingReferenceMaterial PricingReferenceMaterial
Batch Batch
ProductHierarchyNode ProductHierarchyNode
ProductGroup ProductGroup
AdditionalMaterialGroup1 AdditionalMaterialGroup1
AdditionalMaterialGroup2 AdditionalMaterialGroup2
AdditionalMaterialGroup3 AdditionalMaterialGroup3
AdditionalMaterialGroup4 AdditionalMaterialGroup4
AdditionalMaterialGroup5 AdditionalMaterialGroup5
MaterialCommissionGroup MaterialCommissionGroup
Plant Plant
StorageLocation StorageLocation
BillingDocumentRequestItemText BillingDocumentRequestItemText
BillingQuantity BillingQuantity
BillingQuantityUnit BillingQuantityUnit
BillingQuantityInBaseUnit BillingQuantityInBaseUnit
BaseUnit BaseUnit
MRPRequiredQuantityInBaseUnit MRPRequiredQuantityInBaseUnit
BillingToBaseQuantityDnmntr BillingToBaseQuantityDnmntr
BillingToBaseQuantityNmrtr BillingToBaseQuantityNmrtr
ItemGrossWeight ItemGrossWeight
ItemNetWeight ItemNetWeight
ItemWeightUnit ItemWeightUnit
ItemVolume ItemVolume
ItemVolumeUnit ItemVolumeUnit
NetAmount NetAmount
TransactionCurrency TransactionCurrency
GrossAmount GrossAmount
PricingDate PricingDate
PriceDetnExchangeRate PriceDetnExchangeRate
PricingScaleQuantityInBaseUnit PricingScaleQuantityInBaseUnit
TaxAmount TaxAmount
CostAmount CostAmount
Subtotal1Amount Subtotal1Amount
Subtotal2Amount Subtotal2Amount
Subtotal3Amount Subtotal3Amount
Subtotal4Amount Subtotal4Amount
Subtotal5Amount Subtotal5Amount
Subtotal6Amount Subtotal6Amount
StatisticalValueControl StatisticalValueControl
CashDiscountIsDeductible CashDiscountIsDeductible
TimeSheetOvertimeCategory TimeSheetOvertimeCategory
DepartureCountry DepartureCountry
TaxJurisdiction TaxJurisdiction
ProductTaxClassification1 ProductTaxClassification1
ProductTaxClassification2 ProductTaxClassification2
ProductTaxClassification3 ProductTaxClassification3
ProductTaxClassification4 ProductTaxClassification4
ProductTaxClassification5 ProductTaxClassification5
ProductTaxClassification6 ProductTaxClassification6
ProductTaxClassification7 ProductTaxClassification7
ProductTaxClassification8 ProductTaxClassification8
ProductTaxClassification9 ProductTaxClassification9
ZeroVATRsn ZeroVATRsn
BillgDocReqBillgSts BillgDocReqBillgSts
BusinessArea BusinessArea
ProfitCenter ProfitCenter
OrderID OrderID
WBSElementInternalID WBSElementInternalID
ProviderContract ProviderContract
ProviderContractItem ProviderContractItem
ControllingArea ControllingArea
CostCenter CostCenter
OriginSDDocument OriginSDDocument
OriginSDDocumentItem OriginSDDocumentItem
PriceDetnExchangeRateDate PriceDetnExchangeRateDate
MatlAccountAssignmentGroup MatlAccountAssignmentGroup
ReferenceDocument ReferenceDocument
ReferenceDocumentItem ReferenceDocumentItem
ReferenceDocSDDocCategory ReferenceDocSDDocCategory
SalesDocument SalesDocument
SalesDocumentItem SalesDocumentItem
SalesSDDocumentCategory SalesSDDocumentCategory
HigherLevelItem HigherLevelItem
BillgDocRequestItemInPartSgmt BillgDocRequestItemInPartSgmt
SalesGroup SalesGroup
ItemIsRelevantForCredit ItemIsRelevantForCredit
CreditRelatedPrice CreditRelatedPrice
ServiceDocumentType ServiceDocumentType
ServiceDocument ServiceDocument
ServiceDocumentItem ServiceDocumentItem
BusinessSolutionOrder BusinessSolutionOrder
BusinessSolutionOrderItem BusinessSolutionOrderItem
BillingDocumentRequestType BillingDocumentRequestType
SalesOrganization SalesOrganization
_BillingDocumentRequest _BillingDocumentRequest
_SalesDocumentItemCategory _SalesDocumentItemCategory
_SalesDocumentItemType _SalesDocumentItemType
_CreatedByUser _CreatedByUser
_ReferenceLogicalSystem _ReferenceLogicalSystem
_OrganizationDivision _OrganizationDivision
_Division _Division
_SalesOffice _SalesOffice
_Product _Product
_OriginallyRequestedMaterial _OriginallyRequestedMaterial
_PricingReferenceMaterial _PricingReferenceMaterial
_Batch _Batch
_ProductHierarchyNode _ProductHierarchyNode
_ProductGroup _ProductGroup
_AdditionalMaterialGroup1 _AdditionalMaterialGroup1
_AdditionalMaterialGroup2 _AdditionalMaterialGroup2
_AdditionalMaterialGroup3 _AdditionalMaterialGroup3
_AdditionalMaterialGroup4 _AdditionalMaterialGroup4
_AdditionalMaterialGroup5 _AdditionalMaterialGroup5
_MaterialCommissionGroup _MaterialCommissionGroup
_Plant _Plant
_StorageLocation _StorageLocation
_BillingQuantityUnit _BillingQuantityUnit
_BaseUnit _BaseUnit
_ItemWeightUnit _ItemWeightUnit
_ItemVolumeUnit _ItemVolumeUnit
_TransactionCurrency _TransactionCurrency
_StatisticalValueControl _StatisticalValueControl
_TimeSheetOvertimeCat _TimeSheetOvertimeCat
_DepartureCountry _DepartureCountry
_BusinessArea _BusinessArea
_ProfitCenter _ProfitCenter
_WBSElementBasicData _WBSElementBasicData
_ControllingArea _ControllingArea
_CostCenter _CostCenter_2
_ReferenceDocSDDocCategory _ReferenceDocSDDocCategory
_SalesDocument _SalesDocument
_SalesDocumentItem _SalesDocumentItem
_SalesSDDocumentCategory _SalesSDDocumentCategory
_HigherLevelItem _HigherLevelItem
_BillgDocReqBillgSts _BillgDocReqBillgSts
_SalesGroup _SalesGroup
_MatlAccountAssignmentGroup _MatlAccountAssignmentGroup
_ServiceDocumentType _ServiceDocumentType
_ProviderContract _ProviderContract
_ProviderContractItem _ProviderContractItem 
@AccessControl: { authorizationCheck: #MANDATORY, personalData.blocking: #('TRANSACTIONAL_DATA') }

@EndUserText.label: 'Billing Document Request Item - TP'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #XL }
@ObjectModel.semanticKey: ['BillingDocumentRequest','BillingDocumentRequestItem']
  
define view entity R_BillingDocumentRequestItemTP as select from I_BillingDocumentRequestItem
  association to parent R_BillingDocumentRequestTP as _BillingDocumentRequest
   
  on $projection.BillingDocumentRequest = _BillingDocumentRequest.BillingDocumentRequest 
  association [0..1] to I_Batch                      as _Batch                         on  $projection.Plant   = _Batch.Plant
                                                                                       and $projection.Product = _Batch.Material
                                                                                       and $projection.Batch   = _Batch.Batch 
   //Extensibility

  association [0..1] to E_BillingDocumentItem        as _Extension                on  $projection.BillingDocumentRequest     = _Extension.BillingDocument
                                                                                  and $projection.BillingDocumentRequestItem = _Extension.BillingDocumentItem                                                                                      
{
      key BillingDocumentRequest,
      key BillingDocumentRequestItem,
      SalesDocumentItemCategory,
      SalesDocumentItemType,
      ReturnItemProcessingType,
      CreatedByUser,
      CreationDate,
      CreationTime,
      ReferenceLogicalSystem,
      OrganizationDivision,
      Division,
      SalesOffice,
      Product,
      OriginallyRequestedMaterial,
      InternationalArticleNumber,
      PricingReferenceMaterial,
      @ObjectModel.foreignKey.association: '_Batch'
      Batch,
      ProductHierarchyNode,
      ProductGroup,
      AdditionalMaterialGroup1,
      AdditionalMaterialGroup2,
      AdditionalMaterialGroup3,
      AdditionalMaterialGroup4,
      AdditionalMaterialGroup5,
      MaterialCommissionGroup,
      Plant,
      StorageLocation,
      BillingDocumentRequestItemText,
      BillingQuantity,
      BillingQuantityUnit,
      BillingQuantityInBaseUnit,
      BaseUnit,
      MRPRequiredQuantityInBaseUnit,
      BillingToBaseQuantityDnmntr,
      BillingToBaseQuantityNmrtr,
      ItemGrossWeight,
      ItemNetWeight,
      ItemWeightUnit,
      ItemVolume,
      ItemVolumeUnit,
      NetAmount,
      TransactionCurrency,
      GrossAmount,
      PricingDate,
      PriceDetnExchangeRate,
      PricingScaleQuantityInBaseUnit,
      TaxAmount,
      CostAmount,
      Subtotal1Amount,
      Subtotal2Amount,
      Subtotal3Amount,
      Subtotal4Amount,
      Subtotal5Amount,
      Subtotal6Amount,
      StatisticalValueControl,
      CashDiscountIsDeductible,
      TimeSheetOvertimeCategory,
      DepartureCountry,
      TaxJurisdiction,
      ProductTaxClassification1,
      ProductTaxClassification2,
      ProductTaxClassification3,
      ProductTaxClassification4,
      ProductTaxClassification5,
      ProductTaxClassification6,
      ProductTaxClassification7,
      ProductTaxClassification8,
      ProductTaxClassification9,
      ZeroVATRsn,
      BillgDocReqBillgSts,
      BusinessArea,
      ProfitCenter,
      OrderID,
      WBSElementInternalID,
      ProviderContract,
      ProviderContractItem,
      ControllingArea,
      @ObjectModel.foreignKey.association: '_CostCenter'            
      CostCenter,
      OriginSDDocument,
      OriginSDDocumentItem,
      PriceDetnExchangeRateDate,
      MatlAccountAssignmentGroup,
      ReferenceDocument,
      ReferenceDocumentItem,
      ReferenceDocSDDocCategory,
      SalesDocument,
      SalesDocumentItem,
      SalesSDDocumentCategory,
      HigherLevelItem,
      BillgDocRequestItemInPartSgmt,
      SalesGroup,
      ItemIsRelevantForCredit,
      CreditRelatedPrice,
      ServiceDocumentType,
      ServiceDocument,
      ServiceDocumentItem,
      BusinessSolutionOrder,
      BusinessSolutionOrderItem,
      // The following two fields are only required for the DCL  

      @Consumption.hidden: true
      @ObjectModel.foreignKey.association: null      
      BillingDocumentRequestType,
      @Consumption.hidden: true
      @ObjectModel.foreignKey.association: null      
      SalesOrganization,      
      _BillingDocumentRequest,
      _SalesDocumentItemCategory,
      _SalesDocumentItemType,
      _CreatedByUser,
      _ReferenceLogicalSystem,
      _OrganizationDivision,
      _Division,
      _SalesOffice,
      _Product,
      _OriginallyRequestedMaterial,
      _PricingReferenceMaterial,
      _Batch,
      _ProductHierarchyNode,
      _ProductGroup,
      _AdditionalMaterialGroup1,
      _AdditionalMaterialGroup2,
      _AdditionalMaterialGroup3,
      _AdditionalMaterialGroup4,
      _AdditionalMaterialGroup5,
      _MaterialCommissionGroup,
      _Plant,
      _StorageLocation,
      _BillingQuantityUnit,
      _BaseUnit,
       _ItemWeightUnit,
      _ItemVolumeUnit,
      _TransactionCurrency,
      _StatisticalValueControl,
      _TimeSheetOvertimeCat,
      _DepartureCountry,
      _BusinessArea,
      _ProfitCenter,
      _WBSElementBasicData,
      _ControllingArea,
      _CostCenter_2 as _CostCenter,
      _ReferenceDocSDDocCategory,
      _SalesDocument,
      _SalesDocumentItem,
      _SalesSDDocumentCategory,
      _HigherLevelItem,
      _BillgDocReqBillgSts,
      _SalesGroup,
      _MatlAccountAssignmentGroup,
      _ServiceDocumentType,
      _ProviderContract,
      _ProviderContractItem
//      _ProductText,

//      _BusinessAreaText,

//      _PricingReferenceMaterialText,

//      _OriginallyRequestedMatlText


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTREQUESTITEM"
],
"ASSOCIATED":
[
"I_ADDITIONALMATERIALGROUP1",
"I_ADDITIONALMATERIALGROUP2",
"I_ADDITIONALMATERIALGROUP3",
"I_ADDITIONALMATERIALGROUP4",
"I_ADDITIONALMATERIALGROUP5",
"I_BATCH",
"I_BILLGDOCREQBILLGSTS",
"I_BILLINGDOCUMENTREQUESTITEM",
"I_BUSINESSAREA",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COUNTRY",
"I_CURRENCY",
"I_DIVISION",
"I_LOGICALSYSTEM",
"I_MATERIAL",
"I_MATERIALCOMMISSIONGROUP",
"I_MATLACCOUNTASSIGNMENTGROUP",
"I_PLANT",
"I_PRODUCT",
"I_PRODUCTGROUP_2",
"I_PRODUCTHIERARCHYNODE",
"I_PROFITCENTER",
"I_PROVIDERCONTRACT",
"I_PROVIDERCONTRACTITEM",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESDOCUMENTITEMTYPE",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SDDOCUMENTCATEGORY",
"I_SERVICEDOCUMENTTYPE",
"I_STATISTICALVALUECONTROL",
"I_STORAGELOCATION",
"I_TIMESHEETOVERTIMECAT",
"I_UNITOFMEASURE",
"I_USER",
"I_WBSELEMENTBASICDATA",
"R_BILLINGDOCUMENTREQUESTTP"
],
"BASE":
[
"I_BILLINGDOCUMENTREQUESTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More