P_BillingDocumentItemBasic

DDL: P_BILLINGDOCUMENTITEMBASIC Type: view_entity BASIC Package: VF_XPRA

Billing Document Basic Data Merge VDM Models

P_BillingDocumentItemBasic is a Basic CDS View that provides data about "Billing Document Basic Data Merge VDM Models" in SAP S/4HANA. It reads from 4 data sources (P_BillingDocumentItemBasic_1, P_BillingDocumentItemBasic_2, P_VBRP_SDM_PHASE_BADI_TF, P_VBRP_SDM_PHASE_BADI_TF) and exposes 371 fields with key fields BillingDocument, BillingDocumentItem, BillingDocumentItem. Part of development package VF_XPRA.

Data Sources (4)

SourceAliasJoin Type
P_BillingDocumentItemBasic_1 BillingDocumentItem from
P_BillingDocumentItemBasic_2 BillingDocumentItem union_all
P_VBRP_SDM_PHASE_BADI_TF SwitchState inner
P_VBRP_SDM_PHASE_BADI_TF SwitchState inner

Annotations (4)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view

Fields (371)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument P_BillingDocumentItemBasic_2 BillingDocument
KEY BillingDocumentItem P_BillingDocumentItemBasic_2 BillingDocumentItem
SalesDocumentItemCategory P_BillingDocumentItemBasic_2 SalesDocumentItemCategory
SalesDocumentItemType P_BillingDocumentItemBasic_2 SalesDocumentItemType
ReturnItemProcessingType P_BillingDocumentItemBasic_2 ReturnItemProcessingType
CreatedByUser P_BillingDocumentItemBasic_2 CreatedByUser
CreationDate P_BillingDocumentItemBasic_2 CreationDate
CreationTime P_BillingDocumentItemBasic_2 CreationTime
ReferenceLogicalSystem P_BillingDocumentItemBasic_2 ReferenceLogicalSystem
OrganizationDivision P_BillingDocumentItemBasic_2 OrganizationDivision
Division P_BillingDocumentItemBasic_2 Division
SalesOffice P_BillingDocumentItemBasic_2 SalesOffice
Product P_BillingDocumentItemBasic_2 Product
OriginallyRequestedMaterial P_BillingDocumentItemBasic_2 OriginallyRequestedMaterial
InternationalArticleNumber P_BillingDocumentItemBasic_2 InternationalArticleNumber
PricingReferenceMaterial P_BillingDocumentItemBasic_2 PricingReferenceMaterial
Batch P_BillingDocumentItemBasic_2 Batch
ProductHierarchyNode P_BillingDocumentItemBasic_2 ProductHierarchyNode
ProductGroup P_BillingDocumentItemBasic_2 ProductGroup
AdditionalMaterialGroup1 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup1
AdditionalMaterialGroup2 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup2
AdditionalMaterialGroup3 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup3
AdditionalMaterialGroup4 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup4
AdditionalMaterialGroup5 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup5
ProductConfiguration P_BillingDocumentItemBasic_2 ProductConfiguration
MaterialCommissionGroup P_BillingDocumentItemBasic_2 MaterialCommissionGroup
Plant P_BillingDocumentItemBasic_2 Plant
StorageLocation P_BillingDocumentItemBasic_2 StorageLocation
ReplacementPartType P_BillingDocumentItemBasic_2 ReplacementPartType
MaterialGroupHierarchy1 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy1
MaterialGroupHierarchy2 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy2
PlantRegion P_BillingDocumentItemBasic_2 PlantRegion
PlantCounty P_BillingDocumentItemBasic_2 PlantCounty
PlantCity P_BillingDocumentItemBasic_2 PlantCity
TransitPlant P_BillingDocumentItemBasic_2 TransitPlant
ValueChainCategory P_BillingDocumentItemBasic_2 ValueChainCategory
BOMExplosion P_BillingDocumentItemBasic_2 BOMExplosion
MaterialDeterminationType P_BillingDocumentItemBasic_2 MaterialDeterminationType
BillingDocumentItemText P_BillingDocumentItemBasic_2 BillingDocumentItemText
ServicesRenderedDate P_BillingDocumentItemBasic_2 ServicesRenderedDate
BillingQuantity P_BillingDocumentItemBasic_2 BillingQuantity
BillingQuantityUnit P_BillingDocumentItemBasic_2 BillingQuantityUnit
BillingQuantityInBaseUnit P_BillingDocumentItemBasic_2 BillingQuantityInBaseUnit
BaseUnit P_BillingDocumentItemBasic_2 BaseUnit
MRPRequiredQuantityInBaseUnit P_BillingDocumentItemBasic_2 MRPRequiredQuantityInBaseUnit
BillingToBaseQuantityDnmntr P_BillingDocumentItemBasic_2 BillingToBaseQuantityDnmntr
BillingToBaseQuantityNmrtr P_BillingDocumentItemBasic_2 BillingToBaseQuantityNmrtr
ItemGrossWeight P_BillingDocumentItemBasic_2 ItemGrossWeight
ItemNetWeight P_BillingDocumentItemBasic_2 ItemNetWeight
ItemWeightUnit P_BillingDocumentItemBasic_2 ItemWeightUnit
ItemVolume P_BillingDocumentItemBasic_2 ItemVolume
ItemVolumeUnit P_BillingDocumentItemBasic_2 ItemVolumeUnit
BillToPartyCountry P_BillingDocumentItemBasic_2 BillToPartyCountry
BillToPartyRegion P_BillingDocumentItemBasic_2 BillToPartyRegion
BillingPlanRule P_BillingDocumentItemBasic_2 BillingPlanRule
BillingPlan P_BillingDocumentItemBasic_2 BillingPlan
BillingPlanItem P_BillingDocumentItemBasic_2 BillingPlanItem
DocumentBillingStatus P_BillingDocumentItemBasic_2 DocumentBillingStatus
NetAmount P_BillingDocumentItemBasic_2 NetAmount
TransactionCurrency P_BillingDocumentItemBasic_2 TransactionCurrency
GrossAmount P_BillingDocumentItemBasic_2 GrossAmount
PricingDate P_BillingDocumentItemBasic_2 PricingDate
PriceDetnExchangeRate P_BillingDocumentItemBasic_2 PriceDetnExchangeRate
PricingScaleQuantityInBaseUnit P_BillingDocumentItemBasic_2 PricingScaleQuantityInBaseUnit
TaxAmount P_BillingDocumentItemBasic_2 TaxAmount
CostAmount P_BillingDocumentItemBasic_2 CostAmount
Subtotal1Amount P_BillingDocumentItemBasic_2 Subtotal1Amount
Subtotal2Amount P_BillingDocumentItemBasic_2 Subtotal2Amount
Subtotal3Amount P_BillingDocumentItemBasic_2 Subtotal3Amount
Subtotal4Amount P_BillingDocumentItemBasic_2 Subtotal4Amount
Subtotal5Amount P_BillingDocumentItemBasic_2 Subtotal5Amount
Subtotal6Amount P_BillingDocumentItemBasic_2 Subtotal6Amount
StatisticalValueControl P_BillingDocumentItemBasic_2 StatisticalValueControl
CashDiscountIsDeductible P_BillingDocumentItemBasic_2 CashDiscountIsDeductible
CustomerConditionGroup1 P_BillingDocumentItemBasic_2 CustomerConditionGroup1
CustomerConditionGroup2 P_BillingDocumentItemBasic_2 CustomerConditionGroup2
CustomerConditionGroup3 P_BillingDocumentItemBasic_2 CustomerConditionGroup3
CustomerConditionGroup4 P_BillingDocumentItemBasic_2 CustomerConditionGroup4
CustomerConditionGroup5 P_BillingDocumentItemBasic_2 CustomerConditionGroup5
ManualPriceChangeType P_BillingDocumentItemBasic_2 ManualPriceChangeType
MaterialPricingGroup P_BillingDocumentItemBasic_2 MaterialPricingGroup
StatisticsExchangeRate P_BillingDocumentItemBasic_2 StatisticsExchangeRate
MainItemPricingRefMaterial P_BillingDocumentItemBasic_2 MainItemPricingRefMaterial
MainItemMaterialPricingGroup P_BillingDocumentItemBasic_2 MainItemMaterialPricingGroup
TimeSheetOvertimeCategory P_BillingDocumentItemBasic_2 TimeSheetOvertimeCategory
PricingRelevance P_BillingDocumentItemBasic_2 PricingRelevance
DepartureCountry P_BillingDocumentItemBasic_2 DepartureCountry
TaxJurisdiction P_BillingDocumentItemBasic_2 TaxJurisdiction
ProductTaxClassification1 P_BillingDocumentItemBasic_2 ProductTaxClassification1
ProductTaxClassification2 P_BillingDocumentItemBasic_2 ProductTaxClassification2
ProductTaxClassification3 P_BillingDocumentItemBasic_2 ProductTaxClassification3
ProductTaxClassification4 P_BillingDocumentItemBasic_2 ProductTaxClassification4
ProductTaxClassification5 P_BillingDocumentItemBasic_2 ProductTaxClassification5
ProductTaxClassification6 P_BillingDocumentItemBasic_2 ProductTaxClassification6
ProductTaxClassification7 P_BillingDocumentItemBasic_2 ProductTaxClassification7
ProductTaxClassification8 P_BillingDocumentItemBasic_2 ProductTaxClassification8
ProductTaxClassification9 P_BillingDocumentItemBasic_2 ProductTaxClassification9
ZeroVATRsn P_BillingDocumentItemBasic_2 ZeroVATRsn
TaxCode P_BillingDocumentItemBasic_2 TaxCode
TaxRateValidityStartDate P_BillingDocumentItemBasic_2 TaxRateValidityStartDate
CountryOfOrigin P_BillingDocumentItemBasic_2 CountryOfOrigin
RegionOfOrigin P_BillingDocumentItemBasic_2 RegionOfOrigin
CommodityCode P_BillingDocumentItemBasic_2 CommodityCode
EligibleAmountForCashDiscount P_BillingDocumentItemBasic_2 EligibleAmountForCashDiscount
BusinessArea P_BillingDocumentItemBasic_2 BusinessArea
ProfitCenter P_BillingDocumentItemBasic_2 ProfitCenter
WBSElementInternalID P_BillingDocumentItemBasic_2 WBSElementInternalID
ProviderContract P_BillingDocumentItemBasic_2 ProviderContract
ProviderContractItem P_BillingDocumentItemBasic_2 ProviderContractItem
BillingPerformancePeriodStrDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodStrDte
BillingPerformancePeriodEndDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodEndDte
ControllingArea P_BillingDocumentItemBasic_2 ControllingArea
ProfitabilitySegment_2 P_BillingDocumentItemBasic_2 ProfitabilitySegment_2
OrderID P_BillingDocumentItemBasic_2 OrderID
CostCenter P_BillingDocumentItemBasic_2 CostCenter
OriginSDDocument P_BillingDocumentItemBasic_2 OriginSDDocument
OriginSDDocumentItem P_BillingDocumentItemBasic_2 OriginSDDocumentItem
PriceDetnExchangeRateDate P_BillingDocumentItemBasic_2 PriceDetnExchangeRateDate
MatlAccountAssignmentGroup P_BillingDocumentItemBasic_2 MatlAccountAssignmentGroup
ReferenceSDDocument P_BillingDocumentItemBasic_2 ReferenceSDDocument
ReferenceSDDocumentItem P_BillingDocumentItemBasic_2 ReferenceSDDocumentItem
ReferenceSDDocumentCategory P_BillingDocumentItemBasic_2 ReferenceSDDocumentCategory
SalesDocument P_BillingDocumentItemBasic_2 SalesDocument
SalesDocumentItem P_BillingDocumentItemBasic_2 SalesDocumentItem
SalesSDDocumentCategory P_BillingDocumentItemBasic_2 SalesSDDocumentCategory
HigherLevelItem P_BillingDocumentItemBasic_2 HigherLevelItem
HigherLvlItmOfBatSpltItm P_BillingDocumentItemBasic_2 HigherLvlItmOfBatSpltItm
BillingDocumentItemInPartSgmt P_BillingDocumentItemBasic_2 BillingDocumentItemInPartSgmt
ExternalReferenceDocument P_BillingDocumentItemBasic_2 ExternalReferenceDocument
BillingDocExtReferenceDocItem P_BillingDocumentItemBasic_2 BillingDocExtReferenceDocItem
PrelimBillingDocument P_BillingDocumentItemBasic_2 PrelimBillingDocument
PrelimBillingDocumentItem P_BillingDocumentItemBasic_2 PrelimBillingDocumentItem
SalesGroup P_BillingDocumentItemBasic_2 SalesGroup
AdditionalCustomerGroup1 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup1
AdditionalCustomerGroup2 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup2
AdditionalCustomerGroup3 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup3
AdditionalCustomerGroup4 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup4
AdditionalCustomerGroup5 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup5
SDDocumentReason P_BillingDocumentItemBasic_2 SDDocumentReason
RetailPromotion P_BillingDocumentItemBasic_2 RetailPromotion
RebateBasisAmount P_BillingDocumentItemBasic_2 RebateBasisAmount
VolumeRebateGroup P_BillingDocumentItemBasic_2 VolumeRebateGroup
ItemIsRelevantForCredit P_BillingDocumentItemBasic_2 ItemIsRelevantForCredit
CreditRelatedPrice P_BillingDocumentItemBasic_2 CreditRelatedPrice
SalesDeal P_BillingDocumentItemBasic_2 SalesDeal
SalesPromotion P_BillingDocumentItemBasic_2 SalesPromotion
SalesOrderSalesDistrict P_BillingDocumentItemBasic_2 SalesOrderSalesDistrict
SalesOrderCustomerGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerGroup
SalesOrderCustomerPriceGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerPriceGroup
SalesOrderPriceListType P_BillingDocumentItemBasic_2 SalesOrderPriceListType
SalesOrderSalesOrganization P_BillingDocumentItemBasic_2 SalesOrderSalesOrganization
SalesOrderDistributionChannel P_BillingDocumentItemBasic_2 SalesOrderDistributionChannel
SalesDocIsCreatedFromReference P_BillingDocumentItemBasic_2 SalesDocIsCreatedFromReference
ShippingPoint P_BillingDocumentItemBasic_2 ShippingPoint
ServiceDocumentType P_BillingDocumentItemBasic_2 ServiceDocumentType
ServiceDocument P_BillingDocumentItemBasic_2 ServiceDocument
ServiceDocumentItem P_BillingDocumentItemBasic_2 ServiceDocumentItem
BusinessSolutionOrder P_BillingDocumentItemBasic_2 BusinessSolutionOrder
BusinessSolutionOrderItem P_BillingDocumentItemBasic_2 BusinessSolutionOrderItem
HigherLevelItemUsage P_BillingDocumentItemBasic_2 HigherLevelItemUsage
BillingDocumentIsTemporary P_BillingDocumentItemBasic_2 BillingDocumentIsTemporary
SDDocumentCategory P_BillingDocumentItemBasic_2 SDDocumentCategory
BillingDocumentType P_BillingDocumentItemBasic_2 BillingDocumentType
SalesOrganization P_BillingDocumentItemBasic_2 SalesOrganization
DistributionChannel P_BillingDocumentItemBasic_2 DistributionChannel
CustomerPriceGroup P_BillingDocumentItemBasic_2 CustomerPriceGroup
CustomerGroup P_BillingDocumentItemBasic_2 CustomerGroup
Country P_BillingDocumentItemBasic_2 Country
Region P_BillingDocumentItemBasic_2 Region
CityCode P_BillingDocumentItemBasic_2 CityCode
SalesDistrict P_BillingDocumentItemBasic_2 SalesDistrict
OverallSDProcessStatus P_BillingDocumentItemBasic_2 OverallSDProcessStatus
OverallBillingStatus P_BillingDocumentItemBasic_2 OverallBillingStatus
SoldToParty P_BillingDocumentItemBasic_2 SoldToParty
PayerParty P_BillingDocumentItemBasic_2 PayerParty
BillingDocumentDate P_BillingDocumentItemBasic_2 BillingDocumentDate
CompanyCode P_BillingDocumentItemBasic_2 CompanyCode
County P_BillingDocumentItemBasic_2 County
CustomerRebateAgreement P_BillingDocumentItemBasic_2 CustomerRebateAgreement
BillingDocumentCategory P_BillingDocumentItemBasic_2 BillingDocumentCategory
ShipToParty P_BillingDocumentItemBasic_2 ShipToParty
BillToParty P_BillingDocumentItemBasic_2 BillToParty
SalesEmployee P_BillingDocumentItemBasic_2 SalesEmployee
ResponsibleEmployee P_BillingDocumentItemBasic_2 ResponsibleEmployee
PricingDocument P_BillingDocumentItemBasic_2 PricingDocument
BillingDocument
KEY BillingDocumentItem P_BillingDocumentItemBasic_2 BillingDocumentItem
SalesDocumentItemCategory P_BillingDocumentItemBasic_2 SalesDocumentItemCategory
SalesDocumentItemType P_BillingDocumentItemBasic_2 SalesDocumentItemType
ReturnItemProcessingType P_BillingDocumentItemBasic_2 ReturnItemProcessingType
CreatedByUser P_BillingDocumentItemBasic_2 CreatedByUser
CreationDate P_BillingDocumentItemBasic_2 CreationDate
CreationTime P_BillingDocumentItemBasic_2 CreationTime
ReferenceLogicalSystem P_BillingDocumentItemBasic_2 ReferenceLogicalSystem
OrganizationDivision P_BillingDocumentItemBasic_2 OrganizationDivision
Division P_BillingDocumentItemBasic_2 Division
SalesOffice P_BillingDocumentItemBasic_2 SalesOffice
Product P_BillingDocumentItemBasic_2 Product
OriginallyRequestedMaterial P_BillingDocumentItemBasic_2 OriginallyRequestedMaterial
InternationalArticleNumber P_BillingDocumentItemBasic_2 InternationalArticleNumber
PricingReferenceMaterial P_BillingDocumentItemBasic_2 PricingReferenceMaterial
Batch P_BillingDocumentItemBasic_2 Batch
ProductHierarchyNode P_BillingDocumentItemBasic_2 ProductHierarchyNode
ProductGroup P_BillingDocumentItemBasic_2 ProductGroup
AdditionalMaterialGroup1 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup1
AdditionalMaterialGroup2 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup2
AdditionalMaterialGroup3 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup3
AdditionalMaterialGroup4 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup4
AdditionalMaterialGroup5 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup5
ProductConfiguration P_BillingDocumentItemBasic_2 ProductConfiguration
MaterialCommissionGroup P_BillingDocumentItemBasic_2 MaterialCommissionGroup
Plant P_BillingDocumentItemBasic_2 Plant
StorageLocation P_BillingDocumentItemBasic_2 StorageLocation
ReplacementPartType P_BillingDocumentItemBasic_2 ReplacementPartType
MaterialGroupHierarchy1 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy1
MaterialGroupHierarchy2 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy2
PlantRegion P_BillingDocumentItemBasic_2 PlantRegion
PlantCounty P_BillingDocumentItemBasic_2 PlantCounty
PlantCity P_BillingDocumentItemBasic_2 PlantCity
TransitPlant P_BillingDocumentItemBasic_2 TransitPlant
ValueChainCategory P_BillingDocumentItemBasic_2 ValueChainCategory
BOMExplosion P_BillingDocumentItemBasic_2 BOMExplosion
MaterialDeterminationType P_BillingDocumentItemBasic_2 MaterialDeterminationType
BillingDocumentItemText P_BillingDocumentItemBasic_2 BillingDocumentItemText
ServicesRenderedDate P_BillingDocumentItemBasic_2 ServicesRenderedDate
BillingQuantity P_BillingDocumentItemBasic_2 BillingQuantity
BillingQuantityUnit P_BillingDocumentItemBasic_2 BillingQuantityUnit
BillingQuantityInBaseUnit P_BillingDocumentItemBasic_2 BillingQuantityInBaseUnit
BaseUnit P_BillingDocumentItemBasic_2 BaseUnit
MRPRequiredQuantityInBaseUnit P_BillingDocumentItemBasic_2 MRPRequiredQuantityInBaseUnit
BillingToBaseQuantityDnmntr P_BillingDocumentItemBasic_2 BillingToBaseQuantityDnmntr
BillingToBaseQuantityNmrtr P_BillingDocumentItemBasic_2 BillingToBaseQuantityNmrtr
ItemGrossWeight P_BillingDocumentItemBasic_2 ItemGrossWeight
ItemNetWeight P_BillingDocumentItemBasic_2 ItemNetWeight
ItemWeightUnit P_BillingDocumentItemBasic_2 ItemWeightUnit
ItemVolume P_BillingDocumentItemBasic_2 ItemVolume
ItemVolumeUnit P_BillingDocumentItemBasic_2 ItemVolumeUnit
BillToPartyCountry P_BillingDocumentItemBasic_2 BillToPartyCountry
BillToPartyRegion P_BillingDocumentItemBasic_2 BillToPartyRegion
BillingPlanRule P_BillingDocumentItemBasic_2 BillingPlanRule
BillingPlan P_BillingDocumentItemBasic_2 BillingPlan
BillingPlanItem P_BillingDocumentItemBasic_2 BillingPlanItem
DocumentBillingStatus P_BillingDocumentItemBasic_2 DocumentBillingStatus
NetAmount P_BillingDocumentItemBasic_2 NetAmount
TransactionCurrency P_BillingDocumentItemBasic_2 TransactionCurrency
GrossAmount P_BillingDocumentItemBasic_2 GrossAmount
PricingDate P_BillingDocumentItemBasic_2 PricingDate
PriceDetnExchangeRate P_BillingDocumentItemBasic_2 PriceDetnExchangeRate
PricingScaleQuantityInBaseUnit P_BillingDocumentItemBasic_2 PricingScaleQuantityInBaseUnit
TaxAmount P_BillingDocumentItemBasic_2 TaxAmount
CostAmount P_BillingDocumentItemBasic_2 CostAmount
Subtotal1Amount P_BillingDocumentItemBasic_2 Subtotal1Amount
Subtotal2Amount P_BillingDocumentItemBasic_2 Subtotal2Amount
Subtotal3Amount P_BillingDocumentItemBasic_2 Subtotal3Amount
Subtotal4Amount P_BillingDocumentItemBasic_2 Subtotal4Amount
Subtotal5Amount P_BillingDocumentItemBasic_2 Subtotal5Amount
Subtotal6Amount P_BillingDocumentItemBasic_2 Subtotal6Amount
StatisticalValueControl P_BillingDocumentItemBasic_2 StatisticalValueControl
CashDiscountIsDeductible P_BillingDocumentItemBasic_2 CashDiscountIsDeductible
CustomerConditionGroup1 P_BillingDocumentItemBasic_2 CustomerConditionGroup1
CustomerConditionGroup2 P_BillingDocumentItemBasic_2 CustomerConditionGroup2
CustomerConditionGroup3 P_BillingDocumentItemBasic_2 CustomerConditionGroup3
CustomerConditionGroup4 P_BillingDocumentItemBasic_2 CustomerConditionGroup4
CustomerConditionGroup5 P_BillingDocumentItemBasic_2 CustomerConditionGroup5
ManualPriceChangeType P_BillingDocumentItemBasic_2 ManualPriceChangeType
MaterialPricingGroup P_BillingDocumentItemBasic_2 MaterialPricingGroup
StatisticsExchangeRate P_BillingDocumentItemBasic_2 StatisticsExchangeRate
MainItemPricingRefMaterial P_BillingDocumentItemBasic_2 MainItemPricingRefMaterial
MainItemMaterialPricingGroup P_BillingDocumentItemBasic_2 MainItemMaterialPricingGroup
TimeSheetOvertimeCategory P_BillingDocumentItemBasic_2 TimeSheetOvertimeCategory
PricingRelevance P_BillingDocumentItemBasic_2 PricingRelevance
DepartureCountry P_BillingDocumentItemBasic_2 DepartureCountry
TaxJurisdiction P_BillingDocumentItemBasic_2 TaxJurisdiction
ProductTaxClassification1 P_BillingDocumentItemBasic_2 ProductTaxClassification1
ProductTaxClassification2 P_BillingDocumentItemBasic_2 ProductTaxClassification2
ProductTaxClassification3 P_BillingDocumentItemBasic_2 ProductTaxClassification3
ProductTaxClassification4 P_BillingDocumentItemBasic_2 ProductTaxClassification4
ProductTaxClassification5 P_BillingDocumentItemBasic_2 ProductTaxClassification5
ProductTaxClassification6 P_BillingDocumentItemBasic_2 ProductTaxClassification6
ProductTaxClassification7 P_BillingDocumentItemBasic_2 ProductTaxClassification7
ProductTaxClassification8 P_BillingDocumentItemBasic_2 ProductTaxClassification8
ProductTaxClassification9 P_BillingDocumentItemBasic_2 ProductTaxClassification9
ZeroVATRsn P_BillingDocumentItemBasic_2 ZeroVATRsn
TaxCode P_BillingDocumentItemBasic_2 TaxCode
TaxRateValidityStartDate P_BillingDocumentItemBasic_2 TaxRateValidityStartDate
CountryOfOrigin P_BillingDocumentItemBasic_2 CountryOfOrigin
RegionOfOrigin P_BillingDocumentItemBasic_2 RegionOfOrigin
CommodityCode P_BillingDocumentItemBasic_2 CommodityCode
EligibleAmountForCashDiscount P_BillingDocumentItemBasic_2 EligibleAmountForCashDiscount
BusinessArea P_BillingDocumentItemBasic_2 BusinessArea
ProfitCenter P_BillingDocumentItemBasic_2 ProfitCenter
WBSElementInternalID P_BillingDocumentItemBasic_2 WBSElementInternalID
ProviderContract P_BillingDocumentItemBasic_2 ProviderContract
ProviderContractItem P_BillingDocumentItemBasic_2 ProviderContractItem
BillingPerformancePeriodStrDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodStrDte
BillingPerformancePeriodEndDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodEndDte
ControllingArea P_BillingDocumentItemBasic_2 ControllingArea
ProfitabilitySegment_2 P_BillingDocumentItemBasic_2 ProfitabilitySegment_2
OrderID P_BillingDocumentItemBasic_2 OrderID
CostCenter P_BillingDocumentItemBasic_2 CostCenter
OriginSDDocument P_BillingDocumentItemBasic_2 OriginSDDocument
OriginSDDocumentItem P_BillingDocumentItemBasic_2 OriginSDDocumentItem
PriceDetnExchangeRateDate P_BillingDocumentItemBasic_2 PriceDetnExchangeRateDate
MatlAccountAssignmentGroup P_BillingDocumentItemBasic_2 MatlAccountAssignmentGroup
ReferenceSDDocument P_BillingDocumentItemBasic_2 ReferenceSDDocument
ReferenceSDDocumentItem P_BillingDocumentItemBasic_2 ReferenceSDDocumentItem
ReferenceSDDocumentCategory P_BillingDocumentItemBasic_2 ReferenceSDDocumentCategory
SalesDocument P_BillingDocumentItemBasic_2 SalesDocument
SalesDocumentItem P_BillingDocumentItemBasic_2 SalesDocumentItem
SalesSDDocumentCategory P_BillingDocumentItemBasic_2 SalesSDDocumentCategory
HigherLevelItem P_BillingDocumentItemBasic_2 HigherLevelItem
HigherLvlItmOfBatSpltItm P_BillingDocumentItemBasic_2 HigherLvlItmOfBatSpltItm
BillingDocumentItemInPartSgmt P_BillingDocumentItemBasic_2 BillingDocumentItemInPartSgmt
ExternalReferenceDocument P_BillingDocumentItemBasic_2 ExternalReferenceDocument
BillingDocExtReferenceDocItem P_BillingDocumentItemBasic_2 BillingDocExtReferenceDocItem
PrelimBillingDocument P_BillingDocumentItemBasic_2 PrelimBillingDocument
PrelimBillingDocumentItem P_BillingDocumentItemBasic_2 PrelimBillingDocumentItem
SalesGroup P_BillingDocumentItemBasic_2 SalesGroup
AdditionalCustomerGroup1 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup1
AdditionalCustomerGroup2 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup2
AdditionalCustomerGroup3 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup3
AdditionalCustomerGroup4 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup4
AdditionalCustomerGroup5 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup5
SDDocumentReason P_BillingDocumentItemBasic_2 SDDocumentReason
RetailPromotion P_BillingDocumentItemBasic_2 RetailPromotion
RebateBasisAmount P_BillingDocumentItemBasic_2 RebateBasisAmount
VolumeRebateGroup P_BillingDocumentItemBasic_2 VolumeRebateGroup
ItemIsRelevantForCredit P_BillingDocumentItemBasic_2 ItemIsRelevantForCredit
CreditRelatedPrice P_BillingDocumentItemBasic_2 CreditRelatedPrice
SalesDeal P_BillingDocumentItemBasic_2 SalesDeal
SalesPromotion P_BillingDocumentItemBasic_2 SalesPromotion
SalesOrderSalesDistrict P_BillingDocumentItemBasic_2 SalesOrderSalesDistrict
SalesOrderCustomerGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerGroup
SalesOrderCustomerPriceGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerPriceGroup
SalesOrderPriceListType P_BillingDocumentItemBasic_2 SalesOrderPriceListType
SalesOrderSalesOrganization P_BillingDocumentItemBasic_2 SalesOrderSalesOrganization
SalesOrderDistributionChannel P_BillingDocumentItemBasic_2 SalesOrderDistributionChannel
SalesDocIsCreatedFromReference P_BillingDocumentItemBasic_2 SalesDocIsCreatedFromReference
ShippingPoint P_BillingDocumentItemBasic_2 ShippingPoint
ServiceDocumentType P_BillingDocumentItemBasic_2 ServiceDocumentType
ServiceDocument P_BillingDocumentItemBasic_2 ServiceDocument
ServiceDocumentItem P_BillingDocumentItemBasic_2 ServiceDocumentItem
BusinessSolutionOrder P_BillingDocumentItemBasic_2 BusinessSolutionOrder
BusinessSolutionOrderItem P_BillingDocumentItemBasic_2 BusinessSolutionOrderItem
HigherLevelItemUsage P_BillingDocumentItemBasic_2 HigherLevelItemUsage
BillingDocumentIsTemporary P_BillingDocumentItemBasic_2 BillingDocumentIsTemporary
SDDocumentCategory P_BillingDocumentItemBasic_2 SDDocumentCategory
BillingDocumentType P_BillingDocumentItemBasic_2 BillingDocumentType
SalesOrganization P_BillingDocumentItemBasic_2 SalesOrganization
DistributionChannel P_BillingDocumentItemBasic_2 DistributionChannel
CustomerPriceGroup P_BillingDocumentItemBasic_2 CustomerPriceGroup
CustomerGroup P_BillingDocumentItemBasic_2 CustomerGroup
Country P_BillingDocumentItemBasic_2 Country
Region P_BillingDocumentItemBasic_2 Region
CityCode P_BillingDocumentItemBasic_2 CityCode
SalesDistrict P_BillingDocumentItemBasic_2 SalesDistrict
OverallSDProcessStatus P_BillingDocumentItemBasic_2 OverallSDProcessStatus
OverallBillingStatus P_BillingDocumentItemBasic_2 OverallBillingStatus
SoldToParty P_BillingDocumentItemBasic_2 SoldToParty
PayerParty P_BillingDocumentItemBasic_2 PayerParty
BillingDocumentDate P_BillingDocumentItemBasic_2 BillingDocumentDate
CompanyCode P_BillingDocumentItemBasic_2 CompanyCode
County P_BillingDocumentItemBasic_2 County
CustomerRebateAgreement P_BillingDocumentItemBasic_2 CustomerRebateAgreement
BillingDocumentCategory P_BillingDocumentItemBasic_2 BillingDocumentCategory
ShipToParty P_BillingDocumentItemBasic_2 ShipToParty
BillToParty P_BillingDocumentItemBasic_2 BillToParty
SalesEmployee P_BillingDocumentItemBasic_2 SalesEmployee
ResponsibleEmployee P_BillingDocumentItemBasic_2 ResponsibleEmployee
PricingDocument P_BillingDocumentItemBasic_2 PricingDocument
CancelledBillingDocument P_BillingDocumentItemBasic_2 CancelledBillingDocument
@VDM.viewType: #BASIC
@VDM.private:true
@AccessControl: {
  authorizationCheck: #NOT_REQUIRED
}
@Metadata.ignorePropagatedAnnotations: true
define view entity P_BillingDocumentItemBasic
  as select from P_BillingDocumentItemBasic_1 as BillingDocumentItem
    inner join   P_VBRP_SDM_PHASE_BADI_TF     as SwitchState on SwitchState.SDMPhase = 'F'

{

  key BillingDocumentItem.BillingDocument,
  key BillingDocumentItem.BillingDocumentItem,
      BillingDocumentItem.SalesDocumentItemCategory,
      BillingDocumentItem.SalesDocumentItemType,
      BillingDocumentItem.ReturnItemProcessingType,
      BillingDocumentItem.CreatedByUser,
      @Semantics.systemDate.createdAt: true
      BillingDocumentItem.CreationDate,
      @Semantics.systemTime.createdAt
      BillingDocumentItem.CreationTime,
      BillingDocumentItem.ReferenceLogicalSystem,
      BillingDocumentItem.OrganizationDivision,
      BillingDocumentItem.Division,
      BillingDocumentItem.SalesOffice,
      BillingDocumentItem.Product,
      BillingDocumentItem.OriginallyRequestedMaterial,
      BillingDocumentItem.InternationalArticleNumber,
      BillingDocumentItem.PricingReferenceMaterial,
      BillingDocumentItem.Batch,
      BillingDocumentItem.ProductHierarchyNode,
      BillingDocumentItem.ProductGroup,
      BillingDocumentItem.AdditionalMaterialGroup1,
      BillingDocumentItem.AdditionalMaterialGroup2,
      BillingDocumentItem.AdditionalMaterialGroup3,
      BillingDocumentItem.AdditionalMaterialGroup4,
      BillingDocumentItem.AdditionalMaterialGroup5,
      BillingDocumentItem.ProductConfiguration,
      BillingDocumentItem.MaterialCommissionGroup,
      BillingDocumentItem.Plant,
      BillingDocumentItem.StorageLocation,
      BillingDocumentItem.ReplacementPartType,
      BillingDocumentItem.MaterialGroupHierarchy1,
      BillingDocumentItem.MaterialGroupHierarchy2,
      BillingDocumentItem.PlantRegion,
      BillingDocumentItem.PlantCounty,
      BillingDocumentItem.PlantCity,
      BillingDocumentItem.TransitPlant,
      BillingDocumentItem.ValueChainCategory,
      BillingDocumentItem.BOMExplosion,
      BillingDocumentItem.MaterialDeterminationType,


      //Billing

      @Semantics.text: true
      BillingDocumentItem.BillingDocumentItemText,
      BillingDocumentItem.ServicesRenderedDate,
      @Semantics.quantity.unitOfMeasure: 'BillingQuantityUnit'
      BillingDocumentItem.BillingQuantity,

      BillingDocumentItem.BillingQuantityUnit,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      BillingDocumentItem.BillingQuantityInBaseUnit,

      BillingDocumentItem.BaseUnit,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      BillingDocumentItem.MRPRequiredQuantityInBaseUnit,
      BillingDocumentItem.BillingToBaseQuantityDnmntr,
      BillingDocumentItem.BillingToBaseQuantityNmrtr,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      BillingDocumentItem.ItemGrossWeight,

      @Semantics.quantity.unitOfMeasure: 'ItemWeightUnit'
      BillingDocumentItem.ItemNetWeight,

      BillingDocumentItem.ItemWeightUnit,

      @Semantics.quantity.unitOfMeasure: 'ItemVolumeUnit'
      BillingDocumentItem.ItemVolume,

      BillingDocumentItem.ItemVolumeUnit,
      BillingDocumentItem.BillToPartyCountry,
      BillingDocumentItem.BillToPartyRegion,
      BillingDocumentItem.BillingPlanRule,
      BillingDocumentItem.BillingPlan,
      BillingDocumentItem.BillingPlanItem,

      //Status

      // foreign key association has to be defined (in next release (?)), target: I_DocBillingStatus

      BillingDocumentItem.DocumentBillingStatus,

      //Pricing


      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.NetAmount,

      BillingDocumentItem.TransactionCurrency,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.GrossAmount,
      BillingDocumentItem.PricingDate,
      BillingDocumentItem.PriceDetnExchangeRate,

      @Semantics.quantity.unitOfMeasure: 'BaseUnit'
      BillingDocumentItem.PricingScaleQuantityInBaseUnit,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.TaxAmount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.CostAmount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.Subtotal1Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.Subtotal2Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.Subtotal3Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.Subtotal4Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.Subtotal5Amount,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.Subtotal6Amount,
      BillingDocumentItem.StatisticalValueControl,
      BillingDocumentItem.CashDiscountIsDeductible,
      BillingDocumentItem.CustomerConditionGroup1,
      BillingDocumentItem.CustomerConditionGroup2,
      BillingDocumentItem.CustomerConditionGroup3,
      BillingDocumentItem.CustomerConditionGroup4,
      BillingDocumentItem.CustomerConditionGroup5,
      BillingDocumentItem.ManualPriceChangeType,
      BillingDocumentItem.MaterialPricingGroup,
      BillingDocumentItem.StatisticsExchangeRate,
      BillingDocumentItem.MainItemPricingRefMaterial,
      BillingDocumentItem.MainItemMaterialPricingGroup,
      BillingDocumentItem.TimeSheetOvertimeCategory,
      BillingDocumentItem.PricingRelevance,

      // Tax

      BillingDocumentItem.DepartureCountry,
      BillingDocumentItem.TaxJurisdiction,
      BillingDocumentItem.ProductTaxClassification1,
      BillingDocumentItem.ProductTaxClassification2,
      BillingDocumentItem.ProductTaxClassification3,
      BillingDocumentItem.ProductTaxClassification4,
      BillingDocumentItem.ProductTaxClassification5,
      BillingDocumentItem.ProductTaxClassification6,
      BillingDocumentItem.ProductTaxClassification7,
      BillingDocumentItem.ProductTaxClassification8,
      BillingDocumentItem.ProductTaxClassification9,
      BillingDocumentItem.ZeroVATRsn,
      BillingDocumentItem.TaxCode,
      BillingDocumentItem.TaxRateValidityStartDate,

      // Foreign trade

      BillingDocumentItem.CountryOfOrigin,
      BillingDocumentItem.RegionOfOrigin,
      BillingDocumentItem.CommodityCode,

      //Payment

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.EligibleAmountForCashDiscount,

      //Accounting

      BillingDocumentItem.BusinessArea,
      BillingDocumentItem.ProfitCenter,

      BillingDocumentItem.WBSElementInternalID,

      BillingDocumentItem.ProviderContract,
      BillingDocumentItem.ProviderContractItem,
      BillingDocumentItem.BillingPerformancePeriodStrDte,
      BillingDocumentItem.BillingPerformancePeriodEndDte,

      BillingDocumentItem.ControllingArea,
      BillingDocumentItem.ProfitabilitySegment_2,

      BillingDocumentItem.OrderID,
      BillingDocumentItem.CostCenter,
      BillingDocumentItem.OriginSDDocument,
      BillingDocumentItem.OriginSDDocumentItem,
      BillingDocumentItem.PriceDetnExchangeRateDate,

      BillingDocumentItem.MatlAccountAssignmentGroup,

      //Reference

      BillingDocumentItem.ReferenceSDDocument,
      BillingDocumentItem.ReferenceSDDocumentItem,
      BillingDocumentItem.ReferenceSDDocumentCategory,
      BillingDocumentItem.SalesDocument,
      BillingDocumentItem.SalesDocumentItem,
      BillingDocumentItem.SalesSDDocumentCategory,


      BillingDocumentItem.HigherLevelItem,
      BillingDocumentItem.HigherLvlItmOfBatSpltItm,
      BillingDocumentItem.BillingDocumentItemInPartSgmt,
      BillingDocumentItem.ExternalReferenceDocument,
      BillingDocumentItem.BillingDocExtReferenceDocItem,
      BillingDocumentItem.PrelimBillingDocument,
      BillingDocumentItem.PrelimBillingDocumentItem,

      //Sales

      BillingDocumentItem.SalesGroup,
      BillingDocumentItem.AdditionalCustomerGroup1,
      BillingDocumentItem.AdditionalCustomerGroup2,
      BillingDocumentItem.AdditionalCustomerGroup3,
      BillingDocumentItem.AdditionalCustomerGroup4,
      BillingDocumentItem.AdditionalCustomerGroup5,
      BillingDocumentItem.SDDocumentReason,
      BillingDocumentItem.RetailPromotion,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.RebateBasisAmount,
      BillingDocumentItem.VolumeRebateGroup,
      BillingDocumentItem.ItemIsRelevantForCredit,

      @Semantics.amount.currencyCode: 'TransactionCurrency'
      BillingDocumentItem.CreditRelatedPrice,
      BillingDocumentItem.SalesDeal,
      BillingDocumentItem.SalesPromotion,
      BillingDocumentItem.SalesOrderSalesDistrict,
      BillingDocumentItem.SalesOrderCustomerGroup,
      BillingDocumentItem.SalesOrderCustomerPriceGroup,
      BillingDocumentItem.SalesOrderPriceListType,
      BillingDocumentItem.SalesOrderSalesOrganization,
      BillingDocumentItem.SalesOrderDistributionChannel,
      BillingDocumentItem.SalesDocIsCreatedFromReference,

      BillingDocumentItem.ShippingPoint,

      // CRM

      BillingDocumentItem.ServiceDocumentType,
      BillingDocumentItem.ServiceDocument,
      BillingDocumentItem.ServiceDocumentItem,

      BillingDocumentItem.BusinessSolutionOrder,
      BillingDocumentItem.BusinessSolutionOrderItem,

      //Other fields

      BillingDocumentItem.HigherLevelItemUsage,
      BillingDocumentItem.BillingDocumentIsTemporary,

      //Added Analytics fields

      BillingDocumentItem.SDDocumentCategory,
      BillingDocumentItem.BillingDocumentType,
      BillingDocumentItem.SalesOrganization,
      BillingDocumentItem.DistributionChannel,
      BillingDocumentItem.CustomerPriceGroup,
      BillingDocumentItem.CustomerGroup,
      BillingDocumentItem.Country,
      BillingDocumentItem.Region,
      BillingDocumentItem.CityCode,
      BillingDocumentItem.SalesDistrict,
      BillingDocumentItem.OverallSDProcessStatus,
      BillingDocumentItem.OverallBillingStatus,
      //sales

      BillingDocumentItem.SoldToParty,
      //payment

      BillingDocumentItem.PayerParty,
      BillingDocumentItem.BillingDocumentDate,
      BillingDocumentItem.CompanyCode,
      BillingDocumentItem.County,
      BillingDocumentItem.CustomerRebateAgreement,
      BillingDocumentItem.BillingDocumentCategory,
      //ship-to

      BillingDocumentItem.ShipToParty,
      //bill-to

      BillingDocumentItem.BillToParty,
      BillingDocumentItem.SalesEmployee,
      BillingDocumentItem.ResponsibleEmployee,
      BillingDocumentItem.PricingDocument,
      BillingDocumentItem.CancelledBillingDocument
}
union all select from P_BillingDocumentItemBasic_2 as BillingDocumentItem
  inner join          P_VBRP_SDM_PHASE_BADI_TF     as SwitchState on SwitchState.SDMPhase = 'N'

{
  key BillingDocumentItem.BillingDocument,
  key BillingDocumentItem.BillingDocumentItem,
      BillingDocumentItem.SalesDocumentItemCategory,
      BillingDocumentItem.SalesDocumentItemType,
      BillingDocumentItem.ReturnItemProcessingType,
      BillingDocumentItem.CreatedByUser,
      BillingDocumentItem.CreationDate,
      BillingDocumentItem.CreationTime,
      BillingDocumentItem.ReferenceLogicalSystem,
      BillingDocumentItem.OrganizationDivision,
      BillingDocumentItem.Division,
      BillingDocumentItem.SalesOffice,
      BillingDocumentItem.Product,
      BillingDocumentItem.OriginallyRequestedMaterial,
      BillingDocumentItem.InternationalArticleNumber,
      BillingDocumentItem.PricingReferenceMaterial,
      BillingDocumentItem.Batch,
      BillingDocumentItem.ProductHierarchyNode,
      BillingDocumentItem.ProductGroup,
      BillingDocumentItem.AdditionalMaterialGroup1,
      BillingDocumentItem.AdditionalMaterialGroup2,
      BillingDocumentItem.AdditionalMaterialGroup3,
      BillingDocumentItem.AdditionalMaterialGroup4,
      BillingDocumentItem.AdditionalMaterialGroup5,
      BillingDocumentItem.ProductConfiguration,
      BillingDocumentItem.MaterialCommissionGroup,
      BillingDocumentItem.Plant,
      BillingDocumentItem.StorageLocation,
      BillingDocumentItem.ReplacementPartType,
      BillingDocumentItem.MaterialGroupHierarchy1,
      BillingDocumentItem.MaterialGroupHierarchy2,
      BillingDocumentItem.PlantRegion,
      BillingDocumentItem.PlantCounty,
      BillingDocumentItem.PlantCity,
      BillingDocumentItem.TransitPlant,
      BillingDocumentItem.ValueChainCategory,
      BillingDocumentItem.BOMExplosion,
      BillingDocumentItem.MaterialDeterminationType,


      //Billing

      BillingDocumentItem.BillingDocumentItemText,
      BillingDocumentItem.ServicesRenderedDate,
      BillingDocumentItem.BillingQuantity,
      BillingDocumentItem.BillingQuantityUnit,

      BillingDocumentItem.BillingQuantityInBaseUnit,
      BillingDocumentItem.BaseUnit,

      BillingDocumentItem.MRPRequiredQuantityInBaseUnit,
      BillingDocumentItem.BillingToBaseQuantityDnmntr,
      BillingDocumentItem.BillingToBaseQuantityNmrtr,

      BillingDocumentItem.ItemGrossWeight,

      BillingDocumentItem.ItemNetWeight,
      BillingDocumentItem.ItemWeightUnit,

      BillingDocumentItem.ItemVolume,
      BillingDocumentItem.ItemVolumeUnit,
      BillingDocumentItem.BillToPartyCountry,
      BillingDocumentItem.BillToPartyRegion,
      BillingDocumentItem.BillingPlanRule,
      BillingDocumentItem.BillingPlan,
      BillingDocumentItem.BillingPlanItem,

      //Status

      // foreign key association has to be defined (in next release (?)), target: I_DocBillingStatus

      BillingDocumentItem.DocumentBillingStatus,

      //Pricing


      BillingDocumentItem.NetAmount,
      BillingDocumentItem.TransactionCurrency,

      BillingDocumentItem.GrossAmount,
      BillingDocumentItem.PricingDate,
      BillingDocumentItem.PriceDetnExchangeRate,

      BillingDocumentItem.PricingScaleQuantityInBaseUnit,

      BillingDocumentItem.TaxAmount,

      BillingDocumentItem.CostAmount,

      BillingDocumentItem.Subtotal1Amount,

      BillingDocumentItem.Subtotal2Amount,

      BillingDocumentItem.Subtotal3Amount,

      BillingDocumentItem.Subtotal4Amount,

      BillingDocumentItem.Subtotal5Amount,

      BillingDocumentItem.Subtotal6Amount,
      BillingDocumentItem.StatisticalValueControl,
      BillingDocumentItem.CashDiscountIsDeductible,
      BillingDocumentItem.CustomerConditionGroup1,
      BillingDocumentItem.CustomerConditionGroup2,
      BillingDocumentItem.CustomerConditionGroup3,
      BillingDocumentItem.CustomerConditionGroup4,
      BillingDocumentItem.CustomerConditionGroup5,
      BillingDocumentItem.ManualPriceChangeType,
      BillingDocumentItem.MaterialPricingGroup,
      BillingDocumentItem.StatisticsExchangeRate,
      BillingDocumentItem.MainItemPricingRefMaterial,
      BillingDocumentItem.MainItemMaterialPricingGroup,
      BillingDocumentItem.TimeSheetOvertimeCategory,
      BillingDocumentItem.PricingRelevance,

      // Tax

      BillingDocumentItem.DepartureCountry,
      BillingDocumentItem.TaxJurisdiction,
      BillingDocumentItem.ProductTaxClassification1,
      BillingDocumentItem.ProductTaxClassification2,
      BillingDocumentItem.ProductTaxClassification3,
      BillingDocumentItem.ProductTaxClassification4,
      BillingDocumentItem.ProductTaxClassification5,
      BillingDocumentItem.ProductTaxClassification6,
      BillingDocumentItem.ProductTaxClassification7,
      BillingDocumentItem.ProductTaxClassification8,
      BillingDocumentItem.ProductTaxClassification9,
      BillingDocumentItem.ZeroVATRsn,
      BillingDocumentItem.TaxCode,
      BillingDocumentItem.TaxRateValidityStartDate,

      // Foreign trade

      BillingDocumentItem.CountryOfOrigin,
      BillingDocumentItem.RegionOfOrigin,
      BillingDocumentItem.CommodityCode,

      //Payment

      BillingDocumentItem.EligibleAmountForCashDiscount,

      //Accounting

      BillingDocumentItem.BusinessArea,
      BillingDocumentItem.ProfitCenter,

      BillingDocumentItem.WBSElementInternalID,

      BillingDocumentItem.ProviderContract,
      BillingDocumentItem.ProviderContractItem,
      BillingDocumentItem.BillingPerformancePeriodStrDte,
      BillingDocumentItem.BillingPerformancePeriodEndDte,

      BillingDocumentItem.ControllingArea,
      BillingDocumentItem.ProfitabilitySegment_2,

      BillingDocumentItem.OrderID,
      BillingDocumentItem.CostCenter,
      BillingDocumentItem.OriginSDDocument,
      BillingDocumentItem.OriginSDDocumentItem,
      BillingDocumentItem.PriceDetnExchangeRateDate,

      BillingDocumentItem.MatlAccountAssignmentGroup,

      //Reference

      BillingDocumentItem.ReferenceSDDocument,
      BillingDocumentItem.ReferenceSDDocumentItem,
      BillingDocumentItem.ReferenceSDDocumentCategory,
      BillingDocumentItem.SalesDocument,
      BillingDocumentItem.SalesDocumentItem,
      BillingDocumentItem.SalesSDDocumentCategory,


      BillingDocumentItem.HigherLevelItem,
      BillingDocumentItem.HigherLvlItmOfBatSpltItm,
      BillingDocumentItem.BillingDocumentItemInPartSgmt,
      BillingDocumentItem.ExternalReferenceDocument,
      BillingDocumentItem.BillingDocExtReferenceDocItem,
      BillingDocumentItem.PrelimBillingDocument,
      BillingDocumentItem.PrelimBillingDocumentItem,

      //Sales

      BillingDocumentItem.SalesGroup,
      BillingDocumentItem.AdditionalCustomerGroup1,
      BillingDocumentItem.AdditionalCustomerGroup2,
      BillingDocumentItem.AdditionalCustomerGroup3,
      BillingDocumentItem.AdditionalCustomerGroup4,
      BillingDocumentItem.AdditionalCustomerGroup5,
      BillingDocumentItem.SDDocumentReason,
      BillingDocumentItem.RetailPromotion,

      BillingDocumentItem.RebateBasisAmount,
      BillingDocumentItem.VolumeRebateGroup,
      BillingDocumentItem.ItemIsRelevantForCredit,

      BillingDocumentItem.CreditRelatedPrice,
      BillingDocumentItem.SalesDeal,
      BillingDocumentItem.SalesPromotion,
      BillingDocumentItem.SalesOrderSalesDistrict,
      BillingDocumentItem.SalesOrderCustomerGroup,
      BillingDocumentItem.SalesOrderCustomerPriceGroup,
      BillingDocumentItem.SalesOrderPriceListType,
      BillingDocumentItem.SalesOrderSalesOrganization,
      BillingDocumentItem.SalesOrderDistributionChannel,
      BillingDocumentItem.SalesDocIsCreatedFromReference,

      BillingDocumentItem.ShippingPoint,

      // CRM

      BillingDocumentItem.ServiceDocumentType,
      BillingDocumentItem.ServiceDocument,
      BillingDocumentItem.ServiceDocumentItem,

      BillingDocumentItem.BusinessSolutionOrder,
      BillingDocumentItem.BusinessSolutionOrderItem,

      //Other fields

      BillingDocumentItem.HigherLevelItemUsage,
      BillingDocumentItem.BillingDocumentIsTemporary,

      //Added Analytics fields

      BillingDocumentItem.SDDocumentCategory,
      BillingDocumentItem.BillingDocumentType,
      BillingDocumentItem.SalesOrganization,
      BillingDocumentItem.DistributionChannel,
      BillingDocumentItem.CustomerPriceGroup,
      BillingDocumentItem.CustomerGroup,
      BillingDocumentItem.Country,
      BillingDocumentItem.Region,
      BillingDocumentItem.CityCode,
      BillingDocumentItem.SalesDistrict,
      BillingDocumentItem.OverallSDProcessStatus,
      BillingDocumentItem.OverallBillingStatus,
      //sales

      BillingDocumentItem.SoldToParty,
      //payment

      BillingDocumentItem.PayerParty,
      BillingDocumentItem.BillingDocumentDate,
      BillingDocumentItem.CompanyCode,
      BillingDocumentItem.County,
      BillingDocumentItem.CustomerRebateAgreement,
      BillingDocumentItem.BillingDocumentCategory,
      //ship-to

      BillingDocumentItem.ShipToParty,
      //bill-to

      BillingDocumentItem.BillToParty,
      BillingDocumentItem.SalesEmployee,
      BillingDocumentItem.ResponsibleEmployee,
      BillingDocumentItem.PricingDocument,
      BillingDocumentItem.CancelledBillingDocument

}