R_BillingDocumentItemTP

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

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

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

@ObjectModel.usageType: { dataClass: #TRANSACTIONAL, serviceQuality: #A, sizeCategory: #XL }
 
define view entity R_BillingDocumentItemTP as select from I_BillingDocumentItem

  association to parent R_BillingDocumentTP as _BillingDocument on $projection.BillingDocument = _BillingDocument.BillingDocument 

  // Correction should be done in interface views

  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.BillingDocument     = _Extension.BillingDocument
                                                                                  and $projection.BillingDocumentItem = _Extension.BillingDocumentItem                                                                                                                                                                           
{
  key BillingDocument,
  key BillingDocumentItem,
  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,
  ProductConfiguration,
  MaterialCommissionGroup,
  Plant,
  StorageLocation,
  ReplacementPartType,
  MaterialGroupHierarchy1,
  MaterialGroupHierarchy2,
  PlantRegion,
  PlantCounty,
  PlantCity,
  BOMExplosion,
  MaterialDeterminationType,
  BillingDocumentItemText,
  ServicesRenderedDate,
  BillingQuantity,
  BillingQuantityUnit,
  BillingQuantityInBaseUnit,
  BaseUnit,
  MRPRequiredQuantityInBaseUnit,
  BillingToBaseQuantityDnmntr,
  BillingToBaseQuantityNmrtr,
  ItemGrossWeight,
  ItemNetWeight,
  ItemWeightUnit,
  ItemVolume,
  ItemVolumeUnit,
  BillToPartyCountry,
  BillToPartyRegion,
  BillingPlanRule,
  BillingPlan,
  BillingPlanItem,
  NetAmount,
  TransactionCurrency,
  GrossAmount,
  PricingDate,
  PriceDetnExchangeRate,
  PricingScaleQuantityInBaseUnit,
  TaxAmount,
  CostAmount,
  Subtotal1Amount,
  Subtotal2Amount,
  Subtotal3Amount,
  Subtotal4Amount,
  Subtotal5Amount,
  Subtotal6Amount,
  StatisticalValueControl,
  CashDiscountIsDeductible,
  CustomerConditionGroup1,
  CustomerConditionGroup2,
  CustomerConditionGroup3,
  CustomerConditionGroup4,
  CustomerConditionGroup5,
  ManualPriceChangeType,
  MaterialPricingGroup,
  StatisticsExchangeRate,
  MainItemPricingRefMaterial,
  MainItemMaterialPricingGroup,
  TimeSheetOvertimeCategory,
  DepartureCountry,
  TaxJurisdiction,
  ProductTaxClassification1,
  ProductTaxClassification2,
  ProductTaxClassification3,
  ProductTaxClassification4,
  ProductTaxClassification5,
  ProductTaxClassification6,
  ProductTaxClassification7,
  ProductTaxClassification8,
  ProductTaxClassification9,
  ZeroVATRsn,
  TaxCode,
  TaxRateValidityStartDate,
  EligibleAmountForCashDiscount,
  BusinessArea,
  ProfitCenter,
  OrderID,
  WBSElementInternalID,
  ProviderContract,
  ProviderContractItem,
  BillingPerformancePeriodStrDte,
  BillingPerformancePeriodEndDte,
  ControllingArea,
  @ObjectModel.foreignKey.association: '_CostCenter'
  CostCenter,
  OriginSDDocument,
  OriginSDDocumentItem,
  PriceDetnExchangeRateDate,
  MatlAccountAssignmentGroup,
  ReferenceSDDocument,
  ReferenceSDDocumentItem,
  ReferenceSDDocumentCategory,
  SalesDocument,
  SalesDocumentItem,
  SalesSDDocumentCategory,
  HigherLevelItem,
  BillingDocumentItemInPartSgmt,
  ExternalReferenceDocument,
  BillingDocExtReferenceDocItem,
  PrelimBillingDocument,
  PrelimBillingDocumentItem,
  SalesGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  SDDocumentReason,
  RetailPromotion,
  RebateBasisAmount,
  VolumeRebateGroup,
  ItemIsRelevantForCredit,
  CreditRelatedPrice,
  SalesDeal,
  SalesPromotion,
  SalesOrderSalesDistrict,
  SalesOrderCustomerGroup,
  SalesOrderCustomerPriceGroup,
  SalesOrderPriceListType,
  SalesOrderSalesOrganization,
  SalesOrderDistributionChannel,
  SalesDocIsCreatedFromReference,
  ShippingPoint,
  ServiceDocumentType,
  ServiceDocument,
  ServiceDocumentItem,
  BusinessSolutionOrder,
  BusinessSolutionOrderItem,
  HigherLevelItemUsage,
  // The following two fields are only required for the DCL  

  // Note: Correction will be done with the flush release  

  // @Consumption.hidden: true

  // @ObjectModel.foreignKey.association: null

  // BillingDocumentType,

  // @Consumption.hidden: true

  // @ObjectModel.foreignKey.association: null

  // SalesOrganization,  

  /* Associations */
  _AdditionalCustomerGroup1,
  _AdditionalCustomerGroup2,
  _AdditionalCustomerGroup3,
  _AdditionalCustomerGroup4,
  _AdditionalCustomerGroup5,
  _AdditionalMaterialGroup1,
  _AdditionalMaterialGroup2,
  _AdditionalMaterialGroup3,
  _AdditionalMaterialGroup4,
  _AdditionalMaterialGroup5,
  _BaseUnit,
  _Batch,
  _BillingDocument,
  _BillingPlanRule,
  _BillingQuantityUnit,
  _BillToPartyCountry,
  _BillToPartyRegion,
  _BusinessArea,
  //_BusinessAreaText,

  _ControllingArea,
  _ProfitCenter,
  _CostCenter_2 as _CostCenter,
  _CreatedByUser,
  _DepartureCountry,
  _Division,
  _HigherLevelItem,
  _ItemVolumeUnit,
  _ItemWeightUnit,
  _MainItemMaterialPricingGroup,
  _MainItemPricingRefMaterial,
  //_MainItemPricingRefMatlText,

  _MaterialCommissionGroup,
  //_MaterialGroupText,

  _MaterialPricingGroup,
  //_MaterialText,

  _MatlAccountAssignmentGroup,
  _OrganizationDivision,
  _OriginallyRequestedMaterial,
  //_OriginallyRequestedMatlText,

  //_Partner,

  _Plant,
  _PlantRegion,
  _PrelimBillingDocument,
  _PrelimBillingDocumentItem,
  //_PricingElement,

  _PricingReferenceMaterial,
  //_PricingReferenceMaterialText,

  _Product,
  _ProductGroup,
  _ProductHierarchyNode,
  //_ProductText,

  _ProviderContract,
  _ProviderContractItem,
  _ReferenceBillingDocItemBasic,
  _ReferenceDeliveryDocumentItem,
  _ReferenceLogicalSystem,
  _ReferenceSalesDocumentItem,
  _ReferenceSDDocumentCategory,
  _RetailPromotion,
  _SalesDeal,
  _SalesDocument,
  _SalesDocumentItem,
  _SalesDocumentItemCategory,
  _SalesDocumentItemType,
  _SalesGroup,
  _SalesOffice,
  _SalesOrderCustomerGroup,
  _SalesOrderCustomerPriceGroup,
  _SalesOrderDistributionChannel,
  _SalesOrderPriceListType,
  _SalesOrderSalesDistrict,
  _SalesOrderSalesOrganization,
  _SalesSDDocumentCategory,
  _SDDocumentReason,
  _ServiceDocumentType,
  _ShippingPoint,
  //_ShippingPointText,

  _StatisticalValueControl,
  _StorageLocation,
  _TimeSheetOvertimeCat,
  _TransactionCurrency,
  _WBSElementBasicData
  //_WBSElementText

}
where BillingDocumentIsTemporary = ' '
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BILLINGDOCUMENTITEM"
],
"ASSOCIATED":
[
"I_ADDITIONALCUSTOMERGROUP1",
"I_ADDITIONALCUSTOMERGROUP2",
"I_ADDITIONALCUSTOMERGROUP3",
"I_ADDITIONALCUSTOMERGROUP4",
"I_ADDITIONALCUSTOMERGROUP5",
"I_ADDITIONALMATERIALGROUP1",
"I_ADDITIONALMATERIALGROUP2",
"I_ADDITIONALMATERIALGROUP3",
"I_ADDITIONALMATERIALGROUP4",
"I_ADDITIONALMATERIALGROUP5",
"I_BATCH",
"I_BILLINGDOCUMENTITEM",
"I_BILLINGDOCUMENTITEMBASIC",
"I_BILLINGPLANRULE",
"I_BUSINESSAREA",
"I_CONTROLLINGAREA",
"I_COSTCENTER",
"I_COUNTRY",
"I_CURRENCY",
"I_CUSTOMERGROUP",
"I_CUSTOMERPRICEGROUP",
"I_DELIVERYDOCUMENTITEM",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_LOGICALSYSTEM",
"I_MATERIAL",
"I_MATERIALCOMMISSIONGROUP",
"I_MATERIALPRICINGGROUP",
"I_MATLACCOUNTASSIGNMENTGROUP",
"I_PLANT",
"I_PRELIMBILLINGDOCUMENT",
"I_PRELIMBILLINGDOCUMENTITEM",
"I_PRICELISTTYPE",
"I_PRODUCT",
"I_PRODUCTGROUP_2",
"I_PRODUCTHIERARCHYNODE",
"I_PROFITCENTER",
"I_PROVIDERCONTRACT",
"I_PROVIDERCONTRACTITEM",
"I_REGION",
"I_RETAILPROMOTION",
"I_SALESDEAL",
"I_SALESDISTRICT",
"I_SALESDOCUMENT",
"I_SALESDOCUMENTITEM",
"I_SALESDOCUMENTITEMCATEGORY",
"I_SALESDOCUMENTITEMTYPE",
"I_SALESGROUP",
"I_SALESOFFICE",
"I_SALESORGANIZATION",
"I_SDDOCUMENTCATEGORY",
"I_SDDOCUMENTREASON",
"I_SERVICEDOCUMENTTYPE",
"I_SHIPPINGPOINT",
"I_STATISTICALVALUECONTROL",
"I_STORAGELOCATION",
"I_TIMESHEETOVERTIMECAT",
"I_UNITOFMEASURE",
"I_USER",
"I_WBSELEMENTBASICDATA",
"R_BILLINGDOCUMENTTP"
],
"BASE":
[
"I_BILLINGDOCUMENTITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/