P_BillingDocumentItemBasic

DDL: P_BILLINGDOCUMENTITEMBASIC Type: view_entity BASIC
371 Fields 4 Data Sources

P_BillingDocumentItemBasic is a Basic CDS View 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.

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 SD Document
KEY BillingDocumentItem P_BillingDocumentItemBasic_2 BillingDocumentItem Item
SalesDocumentItemCategory P_BillingDocumentItemBasic_2 SalesDocumentItemCategory Item Category
SalesDocumentItemType P_BillingDocumentItemBasic_2 SalesDocumentItemType Item Type
ReturnItemProcessingType P_BillingDocumentItemBasic_2 ReturnItemProcessingType Returns
CreatedByUser P_BillingDocumentItemBasic_2 CreatedByUser User Name
CreationDate P_BillingDocumentItemBasic_2 CreationDate Time Stamp
CreationTime P_BillingDocumentItemBasic_2 CreationTime Time of Change
ReferenceLogicalSystem P_BillingDocumentItemBasic_2 ReferenceLogicalSystem Source system
OrganizationDivision P_BillingDocumentItemBasic_2 OrganizationDivision Org. Division
Division P_BillingDocumentItemBasic_2 Division Internal Division ID
SalesOffice P_BillingDocumentItemBasic_2 SalesOffice Sales Office
Product P_BillingDocumentItemBasic_2 Product Product Sold
OriginallyRequestedMaterial P_BillingDocumentItemBasic_2 OriginallyRequestedMaterial MaterialEntered
InternationalArticleNumber P_BillingDocumentItemBasic_2 InternationalArticleNumber EAN/UPC
PricingReferenceMaterial P_BillingDocumentItemBasic_2 PricingReferenceMaterial Pr. Ref. Matl
Batch P_BillingDocumentItemBasic_2 Batch Lot No.
ProductHierarchyNode P_BillingDocumentItemBasic_2 ProductHierarchyNode Prod. Hierarchy
ProductGroup P_BillingDocumentItemBasic_2 ProductGroup Product Sold Group
AdditionalMaterialGroup1 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup5 MaterialGroup 5
ProductConfiguration P_BillingDocumentItemBasic_2 ProductConfiguration Object Number
MaterialCommissionGroup P_BillingDocumentItemBasic_2 MaterialCommissionGroup Time intvl key
Plant P_BillingDocumentItemBasic_2 Plant Valuation Area
StorageLocation P_BillingDocumentItemBasic_2 StorageLocation StorageLocation
ReplacementPartType P_BillingDocumentItemBasic_2 ReplacementPartType Replacemt Part
MaterialGroupHierarchy1 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy1 MatGroup 1
MaterialGroupHierarchy2 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy2 MatGroup 2
PlantRegion P_BillingDocumentItemBasic_2 PlantRegion Region-Dlv.Plnt
PlantCounty P_BillingDocumentItemBasic_2 PlantCounty County-Dlv.Plnt
PlantCity P_BillingDocumentItemBasic_2 PlantCity City-Dlv.Plant
TransitPlant P_BillingDocumentItemBasic_2 TransitPlant Transit Plant
ValueChainCategory P_BillingDocumentItemBasic_2 ValueChainCategory Value Chain Category
BOMExplosion P_BillingDocumentItemBasic_2 BOMExplosion Serial Number
MaterialDeterminationType P_BillingDocumentItemBasic_2 MaterialDeterminationType MatDetermActive
BillingDocumentItemText P_BillingDocumentItemBasic_2 BillingDocumentItemText Item Descr.
ServicesRenderedDate P_BillingDocumentItemBasic_2 ServicesRenderedDate Services Rendered Date
BillingQuantity P_BillingDocumentItemBasic_2 BillingQuantity Invoiced Qty
BillingQuantityUnit P_BillingDocumentItemBasic_2 BillingQuantityUnit Sales Unit
BillingQuantityInBaseUnit P_BillingDocumentItemBasic_2 BillingQuantityInBaseUnit Bill.Qty in SKU
BaseUnit P_BillingDocumentItemBasic_2 BaseUnit Unit of Measure
MRPRequiredQuantityInBaseUnit P_BillingDocumentItemBasic_2 MRPRequiredQuantityInBaseUnit Open Quantity
BillingToBaseQuantityDnmntr P_BillingDocumentItemBasic_2 BillingToBaseQuantityDnmntr Denominator
BillingToBaseQuantityNmrtr P_BillingDocumentItemBasic_2 BillingToBaseQuantityNmrtr Numerator
ItemGrossWeight P_BillingDocumentItemBasic_2 ItemGrossWeight Gross Weight
ItemNetWeight P_BillingDocumentItemBasic_2 ItemNetWeight Net Weight
ItemWeightUnit P_BillingDocumentItemBasic_2 ItemWeightUnit Unit of Weight
ItemVolume P_BillingDocumentItemBasic_2 ItemVolume Volume
ItemVolumeUnit P_BillingDocumentItemBasic_2 ItemVolumeUnit Volume Unit
BillToPartyCountry P_BillingDocumentItemBasic_2 BillToPartyCountry Dst.CtryRg.Ord.
BillToPartyRegion P_BillingDocumentItemBasic_2 BillToPartyRegion Region Order
BillingPlanRule P_BillingDocumentItemBasic_2 BillingPlanRule Billing Rule
BillingPlan P_BillingDocumentItemBasic_2 BillingPlan Bill. Plan No.
BillingPlanItem P_BillingDocumentItemBasic_2 BillingPlanItem Item
DocumentBillingStatus P_BillingDocumentItemBasic_2 DocumentBillingStatus PBEE BDR Status
NetAmount P_BillingDocumentItemBasic_2 NetAmount Stated Amount
TransactionCurrency P_BillingDocumentItemBasic_2 TransactionCurrency Transaction Currency
GrossAmount P_BillingDocumentItemBasic_2 GrossAmount Gross value
PricingDate P_BillingDocumentItemBasic_2 PricingDate Pricing Date
PriceDetnExchangeRate P_BillingDocumentItemBasic_2 PriceDetnExchangeRate Exchange Rate
PricingScaleQuantityInBaseUnit P_BillingDocumentItemBasic_2 PricingScaleQuantityInBaseUnit Scale Quantity
TaxAmount P_BillingDocumentItemBasic_2 TaxAmount Tax Amt in Rptg Crcy
CostAmount P_BillingDocumentItemBasic_2 CostAmount Cost
Subtotal1Amount P_BillingDocumentItemBasic_2 Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount P_BillingDocumentItemBasic_2 Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount P_BillingDocumentItemBasic_2 Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount P_BillingDocumentItemBasic_2 Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount P_BillingDocumentItemBasic_2 Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount P_BillingDocumentItemBasic_2 Subtotal6Amount Subtotal 6 Amount
StatisticalValueControl P_BillingDocumentItemBasic_2 StatisticalValueControl Stat. Value
CashDiscountIsDeductible P_BillingDocumentItemBasic_2 CashDiscountIsDeductible Cash Discount
CustomerConditionGroup1 P_BillingDocumentItemBasic_2 CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 P_BillingDocumentItemBasic_2 CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 P_BillingDocumentItemBasic_2 CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 P_BillingDocumentItemBasic_2 CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 P_BillingDocumentItemBasic_2 CustomerConditionGroup5 Condition grp 5
ManualPriceChangeType P_BillingDocumentItemBasic_2 ManualPriceChangeType Manual Price
MaterialPricingGroup P_BillingDocumentItemBasic_2 MaterialPricingGroup Mat. Price Grp
StatisticsExchangeRate P_BillingDocumentItemBasic_2 StatisticsExchangeRate
MainItemPricingRefMaterial P_BillingDocumentItemBasic_2 MainItemPricingRefMaterial Single-Character Flag
MainItemMaterialPricingGroup P_BillingDocumentItemBasic_2 MainItemMaterialPricingGroup MnItem MatPrcGr
TimeSheetOvertimeCategory P_BillingDocumentItemBasic_2 TimeSheetOvertimeCategory Overtime Category
PricingRelevance P_BillingDocumentItemBasic_2 PricingRelevance Pricing Relev.
DepartureCountry P_BillingDocumentItemBasic_2 DepartureCountry Departure Country / Region
TaxJurisdiction P_BillingDocumentItemBasic_2 TaxJurisdiction Tax Jurisdiction
ProductTaxClassification1 P_BillingDocumentItemBasic_2 ProductTaxClassification1 Tax Classifica.
ProductTaxClassification2 P_BillingDocumentItemBasic_2 ProductTaxClassification2 Tax Classifica.
ProductTaxClassification3 P_BillingDocumentItemBasic_2 ProductTaxClassification3 Tax Classifica.
ProductTaxClassification4 P_BillingDocumentItemBasic_2 ProductTaxClassification4 Tax Classifica.
ProductTaxClassification5 P_BillingDocumentItemBasic_2 ProductTaxClassification5 Tax Classifica.
ProductTaxClassification6 P_BillingDocumentItemBasic_2 ProductTaxClassification6 Tax Classifica.
ProductTaxClassification7 P_BillingDocumentItemBasic_2 ProductTaxClassification7 Tax Classifica.
ProductTaxClassification8 P_BillingDocumentItemBasic_2 ProductTaxClassification8 Tax Classifica.
ProductTaxClassification9 P_BillingDocumentItemBasic_2 ProductTaxClassification9 Tax Classifica.
ZeroVATRsn P_BillingDocumentItemBasic_2 ZeroVATRsn Reason for Zero VAT
TaxCode P_BillingDocumentItemBasic_2 TaxCode Tax Code
TaxRateValidityStartDate P_BillingDocumentItemBasic_2 TaxRateValidityStartDate Tax Rate Validity Start Date
CountryOfOrigin P_BillingDocumentItemBasic_2 CountryOfOrigin Country/Region of Origin
RegionOfOrigin P_BillingDocumentItemBasic_2 RegionOfOrigin Reg. of Origin
CommodityCode P_BillingDocumentItemBasic_2 CommodityCode Commodity Code
EligibleAmountForCashDiscount P_BillingDocumentItemBasic_2 EligibleAmountForCashDiscount Csh.Disc.Bas
BusinessArea P_BillingDocumentItemBasic_2 BusinessArea Business Area
ProfitCenter P_BillingDocumentItemBasic_2 ProfitCenter Profit Center
WBSElementInternalID P_BillingDocumentItemBasic_2 WBSElementInternalID WBS Internal ID
ProviderContract P_BillingDocumentItemBasic_2 ProviderContract Contract
ProviderContractItem P_BillingDocumentItemBasic_2 ProviderContractItem Contract Item
BillingPerformancePeriodStrDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodStrDte PEROP Start
BillingPerformancePeriodEndDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodEndDte PEROP End
ControllingArea P_BillingDocumentItemBasic_2 ControllingArea Controlling Area
ProfitabilitySegment_2 P_BillingDocumentItemBasic_2 ProfitabilitySegment_2 Profit. segment
OrderID P_BillingDocumentItemBasic_2 OrderID Order ID
CostCenter P_BillingDocumentItemBasic_2 CostCenter Cost Center
OriginSDDocument P_BillingDocumentItemBasic_2 OriginSDDocument Originating Doc
OriginSDDocumentItem P_BillingDocumentItemBasic_2 OriginSDDocumentItem Origin. Item
PriceDetnExchangeRateDate P_BillingDocumentItemBasic_2 PriceDetnExchangeRateDate Translatn Date
MatlAccountAssignmentGroup P_BillingDocumentItemBasic_2 MatlAccountAssignmentGroup AcctAssmtGrpMat
ReferenceSDDocument P_BillingDocumentItemBasic_2 ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem P_BillingDocumentItemBasic_2 ReferenceSDDocumentItem Reference Item
ReferenceSDDocumentCategory P_BillingDocumentItemBasic_2 ReferenceSDDocumentCategory Prec.Doc.Categ.
SalesDocument P_BillingDocumentItemBasic_2 SalesDocument SD Document
SalesDocumentItem P_BillingDocumentItemBasic_2 SalesDocumentItem Sales Document Item
SalesSDDocumentCategory P_BillingDocumentItemBasic_2 SalesSDDocumentCategory Document Cat.
HigherLevelItem P_BillingDocumentItemBasic_2 HigherLevelItem Higher-Lev.Item
HigherLvlItmOfBatSpltItm P_BillingDocumentItemBasic_2 HigherLvlItmOfBatSpltItm HghLevItmBatch
BillingDocumentItemInPartSgmt P_BillingDocumentItemBasic_2 BillingDocumentItemInPartSgmt Partner Item
ExternalReferenceDocument P_BillingDocumentItemBasic_2 ExternalReferenceDocument Ext. Ref. Document
BillingDocExtReferenceDocItem P_BillingDocumentItemBasic_2 BillingDocExtReferenceDocItem
PrelimBillingDocument P_BillingDocumentItemBasic_2 PrelimBillingDocument Prelimin. Bill. Doc.
PrelimBillingDocumentItem P_BillingDocumentItemBasic_2 PrelimBillingDocumentItem Prelimin. Doc. Item
SalesGroup P_BillingDocumentItemBasic_2 SalesGroup Sales Group
AdditionalCustomerGroup1 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup5 Customer Grp 5
SDDocumentReason P_BillingDocumentItemBasic_2 SDDocumentReason Order Reason
RetailPromotion P_BillingDocumentItemBasic_2 RetailPromotion Promotion
RebateBasisAmount P_BillingDocumentItemBasic_2 RebateBasisAmount Rebate Basis Amount
VolumeRebateGroup P_BillingDocumentItemBasic_2 VolumeRebateGroup Vol. Rebate Grp
ItemIsRelevantForCredit P_BillingDocumentItemBasic_2 ItemIsRelevantForCredit Credit Active
CreditRelatedPrice P_BillingDocumentItemBasic_2 CreditRelatedPrice Credit Price
SalesDeal P_BillingDocumentItemBasic_2 SalesDeal Sales Deal
SalesPromotion P_BillingDocumentItemBasic_2 SalesPromotion Promotion
SalesOrderSalesDistrict P_BillingDocumentItemBasic_2 SalesOrderSalesDistrict Sls Dist. Order
SalesOrderCustomerGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerGroup CustGrpOrder
SalesOrderCustomerPriceGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerPriceGroup PriceGroupOrder
SalesOrderPriceListType P_BillingDocumentItemBasic_2 SalesOrderPriceListType Price List Ord.
SalesOrderSalesOrganization P_BillingDocumentItemBasic_2 SalesOrderSalesOrganization SOrg of Order
SalesOrderDistributionChannel P_BillingDocumentItemBasic_2 SalesOrderDistributionChannel Dist. Chan. Or.
SalesDocIsCreatedFromReference P_BillingDocumentItemBasic_2 SalesDocIsCreatedFromReference SalesDocumentRefer
ShippingPoint P_BillingDocumentItemBasic_2 ShippingPoint Shipping Point
ServiceDocumentType P_BillingDocumentItemBasic_2 ServiceDocumentType Transaction Type
ServiceDocument P_BillingDocumentItemBasic_2 ServiceDocument Transaction ID
ServiceDocumentItem P_BillingDocumentItemBasic_2 ServiceDocumentItem Service Document
BusinessSolutionOrder P_BillingDocumentItemBasic_2 BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem P_BillingDocumentItemBasic_2 BusinessSolutionOrderItem Solution Order Item
HigherLevelItemUsage P_BillingDocumentItemBasic_2 HigherLevelItemUsage Usage HL Item
BillingDocumentIsTemporary P_BillingDocumentItemBasic_2 BillingDocumentIsTemporary
SDDocumentCategory P_BillingDocumentItemBasic_2 SDDocumentCategory Document Cat.
BillingDocumentType P_BillingDocumentItemBasic_2 BillingDocumentType Billing Type
SalesOrganization P_BillingDocumentItemBasic_2 SalesOrganization Sales Organization
DistributionChannel P_BillingDocumentItemBasic_2 DistributionChannel RefDistCh-Cust/Mat.
CustomerPriceGroup P_BillingDocumentItemBasic_2 CustomerPriceGroup CustPrice Group
CustomerGroup P_BillingDocumentItemBasic_2 CustomerGroup Customer Group
Country P_BillingDocumentItemBasic_2 Country Venue: Ctry/Reg
Region P_BillingDocumentItemBasic_2 Region Venue Region
CityCode P_BillingDocumentItemBasic_2 CityCode IATA: City
SalesDistrict P_BillingDocumentItemBasic_2 SalesDistrict Sales District
OverallSDProcessStatus P_BillingDocumentItemBasic_2 OverallSDProcessStatus Overall Status
OverallBillingStatus P_BillingDocumentItemBasic_2 OverallBillingStatus Status
SoldToParty P_BillingDocumentItemBasic_2 SoldToParty Sold-to Party
PayerParty P_BillingDocumentItemBasic_2 PayerParty Payer
BillingDocumentDate P_BillingDocumentItemBasic_2 BillingDocumentDate Billing Date
CompanyCode P_BillingDocumentItemBasic_2 CompanyCode Receiver Company Code
County P_BillingDocumentItemBasic_2 County Wyoming County
CustomerRebateAgreement P_BillingDocumentItemBasic_2 CustomerRebateAgreement Agreement
BillingDocumentCategory P_BillingDocumentItemBasic_2 BillingDocumentCategory BillingCategory
ShipToParty P_BillingDocumentItemBasic_2 ShipToParty Ship-To Party (obsolete)
BillToParty P_BillingDocumentItemBasic_2 BillToParty Inv. Recipient
SalesEmployee P_BillingDocumentItemBasic_2 SalesEmployee Sales Employee
ResponsibleEmployee P_BillingDocumentItemBasic_2 ResponsibleEmployee Employee Resp.
PricingDocument P_BillingDocumentItemBasic_2 PricingDocument Document Condition
BillingDocument SD Document
KEY BillingDocumentItem P_BillingDocumentItemBasic_2 BillingDocumentItem Item
SalesDocumentItemCategory P_BillingDocumentItemBasic_2 SalesDocumentItemCategory Item Category
SalesDocumentItemType P_BillingDocumentItemBasic_2 SalesDocumentItemType Item Type
ReturnItemProcessingType P_BillingDocumentItemBasic_2 ReturnItemProcessingType Returns
CreatedByUser P_BillingDocumentItemBasic_2 CreatedByUser User Name
CreationDate P_BillingDocumentItemBasic_2 CreationDate Time Stamp
CreationTime P_BillingDocumentItemBasic_2 CreationTime Time of Change
ReferenceLogicalSystem P_BillingDocumentItemBasic_2 ReferenceLogicalSystem Source system
OrganizationDivision P_BillingDocumentItemBasic_2 OrganizationDivision Org. Division
Division P_BillingDocumentItemBasic_2 Division Internal Division ID
SalesOffice P_BillingDocumentItemBasic_2 SalesOffice Sales Office
Product P_BillingDocumentItemBasic_2 Product Product Sold
OriginallyRequestedMaterial P_BillingDocumentItemBasic_2 OriginallyRequestedMaterial MaterialEntered
InternationalArticleNumber P_BillingDocumentItemBasic_2 InternationalArticleNumber EAN/UPC
PricingReferenceMaterial P_BillingDocumentItemBasic_2 PricingReferenceMaterial Pr. Ref. Matl
Batch P_BillingDocumentItemBasic_2 Batch Lot No.
ProductHierarchyNode P_BillingDocumentItemBasic_2 ProductHierarchyNode Prod. Hierarchy
ProductGroup P_BillingDocumentItemBasic_2 ProductGroup Product Sold Group
AdditionalMaterialGroup1 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 P_BillingDocumentItemBasic_2 AdditionalMaterialGroup5 MaterialGroup 5
ProductConfiguration P_BillingDocumentItemBasic_2 ProductConfiguration Object Number
MaterialCommissionGroup P_BillingDocumentItemBasic_2 MaterialCommissionGroup Time intvl key
Plant P_BillingDocumentItemBasic_2 Plant Valuation Area
StorageLocation P_BillingDocumentItemBasic_2 StorageLocation StorageLocation
ReplacementPartType P_BillingDocumentItemBasic_2 ReplacementPartType Replacemt Part
MaterialGroupHierarchy1 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy1 MatGroup 1
MaterialGroupHierarchy2 P_BillingDocumentItemBasic_2 MaterialGroupHierarchy2 MatGroup 2
PlantRegion P_BillingDocumentItemBasic_2 PlantRegion Region-Dlv.Plnt
PlantCounty P_BillingDocumentItemBasic_2 PlantCounty County-Dlv.Plnt
PlantCity P_BillingDocumentItemBasic_2 PlantCity City-Dlv.Plant
TransitPlant P_BillingDocumentItemBasic_2 TransitPlant Transit Plant
ValueChainCategory P_BillingDocumentItemBasic_2 ValueChainCategory Value Chain Category
BOMExplosion P_BillingDocumentItemBasic_2 BOMExplosion Serial Number
MaterialDeterminationType P_BillingDocumentItemBasic_2 MaterialDeterminationType MatDetermActive
BillingDocumentItemText P_BillingDocumentItemBasic_2 BillingDocumentItemText Item Descr.
ServicesRenderedDate P_BillingDocumentItemBasic_2 ServicesRenderedDate Services Rendered Date
BillingQuantity P_BillingDocumentItemBasic_2 BillingQuantity Invoiced Qty
BillingQuantityUnit P_BillingDocumentItemBasic_2 BillingQuantityUnit Sales Unit
BillingQuantityInBaseUnit P_BillingDocumentItemBasic_2 BillingQuantityInBaseUnit Bill.Qty in SKU
BaseUnit P_BillingDocumentItemBasic_2 BaseUnit Unit of Measure
MRPRequiredQuantityInBaseUnit P_BillingDocumentItemBasic_2 MRPRequiredQuantityInBaseUnit Open Quantity
BillingToBaseQuantityDnmntr P_BillingDocumentItemBasic_2 BillingToBaseQuantityDnmntr Denominator
BillingToBaseQuantityNmrtr P_BillingDocumentItemBasic_2 BillingToBaseQuantityNmrtr Numerator
ItemGrossWeight P_BillingDocumentItemBasic_2 ItemGrossWeight Gross Weight
ItemNetWeight P_BillingDocumentItemBasic_2 ItemNetWeight Net Weight
ItemWeightUnit P_BillingDocumentItemBasic_2 ItemWeightUnit Unit of Weight
ItemVolume P_BillingDocumentItemBasic_2 ItemVolume Volume
ItemVolumeUnit P_BillingDocumentItemBasic_2 ItemVolumeUnit Volume Unit
BillToPartyCountry P_BillingDocumentItemBasic_2 BillToPartyCountry Dst.CtryRg.Ord.
BillToPartyRegion P_BillingDocumentItemBasic_2 BillToPartyRegion Region Order
BillingPlanRule P_BillingDocumentItemBasic_2 BillingPlanRule Billing Rule
BillingPlan P_BillingDocumentItemBasic_2 BillingPlan Bill. Plan No.
BillingPlanItem P_BillingDocumentItemBasic_2 BillingPlanItem Item
DocumentBillingStatus P_BillingDocumentItemBasic_2 DocumentBillingStatus PBEE BDR Status
NetAmount P_BillingDocumentItemBasic_2 NetAmount Stated Amount
TransactionCurrency P_BillingDocumentItemBasic_2 TransactionCurrency Transaction Currency
GrossAmount P_BillingDocumentItemBasic_2 GrossAmount Gross value
PricingDate P_BillingDocumentItemBasic_2 PricingDate Pricing Date
PriceDetnExchangeRate P_BillingDocumentItemBasic_2 PriceDetnExchangeRate Exchange Rate
PricingScaleQuantityInBaseUnit P_BillingDocumentItemBasic_2 PricingScaleQuantityInBaseUnit Scale Quantity
TaxAmount P_BillingDocumentItemBasic_2 TaxAmount Tax Amt in Rptg Crcy
CostAmount P_BillingDocumentItemBasic_2 CostAmount Cost
Subtotal1Amount P_BillingDocumentItemBasic_2 Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount P_BillingDocumentItemBasic_2 Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount P_BillingDocumentItemBasic_2 Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount P_BillingDocumentItemBasic_2 Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount P_BillingDocumentItemBasic_2 Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount P_BillingDocumentItemBasic_2 Subtotal6Amount Subtotal 6 Amount
StatisticalValueControl P_BillingDocumentItemBasic_2 StatisticalValueControl Stat. Value
CashDiscountIsDeductible P_BillingDocumentItemBasic_2 CashDiscountIsDeductible Cash Discount
CustomerConditionGroup1 P_BillingDocumentItemBasic_2 CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 P_BillingDocumentItemBasic_2 CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 P_BillingDocumentItemBasic_2 CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 P_BillingDocumentItemBasic_2 CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 P_BillingDocumentItemBasic_2 CustomerConditionGroup5 Condition grp 5
ManualPriceChangeType P_BillingDocumentItemBasic_2 ManualPriceChangeType Manual Price
MaterialPricingGroup P_BillingDocumentItemBasic_2 MaterialPricingGroup Mat. Price Grp
StatisticsExchangeRate P_BillingDocumentItemBasic_2 StatisticsExchangeRate
MainItemPricingRefMaterial P_BillingDocumentItemBasic_2 MainItemPricingRefMaterial Single-Character Flag
MainItemMaterialPricingGroup P_BillingDocumentItemBasic_2 MainItemMaterialPricingGroup MnItem MatPrcGr
TimeSheetOvertimeCategory P_BillingDocumentItemBasic_2 TimeSheetOvertimeCategory Overtime Category
PricingRelevance P_BillingDocumentItemBasic_2 PricingRelevance Pricing Relev.
DepartureCountry P_BillingDocumentItemBasic_2 DepartureCountry Departure Country / Region
TaxJurisdiction P_BillingDocumentItemBasic_2 TaxJurisdiction Tax Jurisdiction
ProductTaxClassification1 P_BillingDocumentItemBasic_2 ProductTaxClassification1 Tax Classifica.
ProductTaxClassification2 P_BillingDocumentItemBasic_2 ProductTaxClassification2 Tax Classifica.
ProductTaxClassification3 P_BillingDocumentItemBasic_2 ProductTaxClassification3 Tax Classifica.
ProductTaxClassification4 P_BillingDocumentItemBasic_2 ProductTaxClassification4 Tax Classifica.
ProductTaxClassification5 P_BillingDocumentItemBasic_2 ProductTaxClassification5 Tax Classifica.
ProductTaxClassification6 P_BillingDocumentItemBasic_2 ProductTaxClassification6 Tax Classifica.
ProductTaxClassification7 P_BillingDocumentItemBasic_2 ProductTaxClassification7 Tax Classifica.
ProductTaxClassification8 P_BillingDocumentItemBasic_2 ProductTaxClassification8 Tax Classifica.
ProductTaxClassification9 P_BillingDocumentItemBasic_2 ProductTaxClassification9 Tax Classifica.
ZeroVATRsn P_BillingDocumentItemBasic_2 ZeroVATRsn Reason for Zero VAT
TaxCode P_BillingDocumentItemBasic_2 TaxCode Tax Code
TaxRateValidityStartDate P_BillingDocumentItemBasic_2 TaxRateValidityStartDate Tax Rate Validity Start Date
CountryOfOrigin P_BillingDocumentItemBasic_2 CountryOfOrigin Country/Region of Origin
RegionOfOrigin P_BillingDocumentItemBasic_2 RegionOfOrigin Reg. of Origin
CommodityCode P_BillingDocumentItemBasic_2 CommodityCode Commodity Code
EligibleAmountForCashDiscount P_BillingDocumentItemBasic_2 EligibleAmountForCashDiscount Csh.Disc.Bas
BusinessArea P_BillingDocumentItemBasic_2 BusinessArea Business Area
ProfitCenter P_BillingDocumentItemBasic_2 ProfitCenter Profit Center
WBSElementInternalID P_BillingDocumentItemBasic_2 WBSElementInternalID WBS Internal ID
ProviderContract P_BillingDocumentItemBasic_2 ProviderContract Contract
ProviderContractItem P_BillingDocumentItemBasic_2 ProviderContractItem Contract Item
BillingPerformancePeriodStrDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodStrDte PEROP Start
BillingPerformancePeriodEndDte P_BillingDocumentItemBasic_2 BillingPerformancePeriodEndDte PEROP End
ControllingArea P_BillingDocumentItemBasic_2 ControllingArea Controlling Area
ProfitabilitySegment_2 P_BillingDocumentItemBasic_2 ProfitabilitySegment_2 Profit. segment
OrderID P_BillingDocumentItemBasic_2 OrderID Order ID
CostCenter P_BillingDocumentItemBasic_2 CostCenter Cost Center
OriginSDDocument P_BillingDocumentItemBasic_2 OriginSDDocument Originating Doc
OriginSDDocumentItem P_BillingDocumentItemBasic_2 OriginSDDocumentItem Origin. Item
PriceDetnExchangeRateDate P_BillingDocumentItemBasic_2 PriceDetnExchangeRateDate Translatn Date
MatlAccountAssignmentGroup P_BillingDocumentItemBasic_2 MatlAccountAssignmentGroup AcctAssmtGrpMat
ReferenceSDDocument P_BillingDocumentItemBasic_2 ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem P_BillingDocumentItemBasic_2 ReferenceSDDocumentItem Reference Item
ReferenceSDDocumentCategory P_BillingDocumentItemBasic_2 ReferenceSDDocumentCategory Prec.Doc.Categ.
SalesDocument P_BillingDocumentItemBasic_2 SalesDocument SD Document
SalesDocumentItem P_BillingDocumentItemBasic_2 SalesDocumentItem Sales Document Item
SalesSDDocumentCategory P_BillingDocumentItemBasic_2 SalesSDDocumentCategory Document Cat.
HigherLevelItem P_BillingDocumentItemBasic_2 HigherLevelItem Higher-Lev.Item
HigherLvlItmOfBatSpltItm P_BillingDocumentItemBasic_2 HigherLvlItmOfBatSpltItm HghLevItmBatch
BillingDocumentItemInPartSgmt P_BillingDocumentItemBasic_2 BillingDocumentItemInPartSgmt Partner Item
ExternalReferenceDocument P_BillingDocumentItemBasic_2 ExternalReferenceDocument Ext. Ref. Document
BillingDocExtReferenceDocItem P_BillingDocumentItemBasic_2 BillingDocExtReferenceDocItem
PrelimBillingDocument P_BillingDocumentItemBasic_2 PrelimBillingDocument Prelimin. Bill. Doc.
PrelimBillingDocumentItem P_BillingDocumentItemBasic_2 PrelimBillingDocumentItem Prelimin. Doc. Item
SalesGroup P_BillingDocumentItemBasic_2 SalesGroup Sales Group
AdditionalCustomerGroup1 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 P_BillingDocumentItemBasic_2 AdditionalCustomerGroup5 Customer Grp 5
SDDocumentReason P_BillingDocumentItemBasic_2 SDDocumentReason Order Reason
RetailPromotion P_BillingDocumentItemBasic_2 RetailPromotion Promotion
RebateBasisAmount P_BillingDocumentItemBasic_2 RebateBasisAmount Rebate Basis Amount
VolumeRebateGroup P_BillingDocumentItemBasic_2 VolumeRebateGroup Vol. Rebate Grp
ItemIsRelevantForCredit P_BillingDocumentItemBasic_2 ItemIsRelevantForCredit Credit Active
CreditRelatedPrice P_BillingDocumentItemBasic_2 CreditRelatedPrice Credit Price
SalesDeal P_BillingDocumentItemBasic_2 SalesDeal Sales Deal
SalesPromotion P_BillingDocumentItemBasic_2 SalesPromotion Promotion
SalesOrderSalesDistrict P_BillingDocumentItemBasic_2 SalesOrderSalesDistrict Sls Dist. Order
SalesOrderCustomerGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerGroup CustGrpOrder
SalesOrderCustomerPriceGroup P_BillingDocumentItemBasic_2 SalesOrderCustomerPriceGroup PriceGroupOrder
SalesOrderPriceListType P_BillingDocumentItemBasic_2 SalesOrderPriceListType Price List Ord.
SalesOrderSalesOrganization P_BillingDocumentItemBasic_2 SalesOrderSalesOrganization SOrg of Order
SalesOrderDistributionChannel P_BillingDocumentItemBasic_2 SalesOrderDistributionChannel Dist. Chan. Or.
SalesDocIsCreatedFromReference P_BillingDocumentItemBasic_2 SalesDocIsCreatedFromReference SalesDocumentRefer
ShippingPoint P_BillingDocumentItemBasic_2 ShippingPoint Shipping Point
ServiceDocumentType P_BillingDocumentItemBasic_2 ServiceDocumentType Transaction Type
ServiceDocument P_BillingDocumentItemBasic_2 ServiceDocument Transaction ID
ServiceDocumentItem P_BillingDocumentItemBasic_2 ServiceDocumentItem Service Document
BusinessSolutionOrder P_BillingDocumentItemBasic_2 BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem P_BillingDocumentItemBasic_2 BusinessSolutionOrderItem Solution Order Item
HigherLevelItemUsage P_BillingDocumentItemBasic_2 HigherLevelItemUsage Usage HL Item
BillingDocumentIsTemporary P_BillingDocumentItemBasic_2 BillingDocumentIsTemporary
SDDocumentCategory P_BillingDocumentItemBasic_2 SDDocumentCategory Document Cat.
BillingDocumentType P_BillingDocumentItemBasic_2 BillingDocumentType Billing Type
SalesOrganization P_BillingDocumentItemBasic_2 SalesOrganization Sales Organization
DistributionChannel P_BillingDocumentItemBasic_2 DistributionChannel RefDistCh-Cust/Mat.
CustomerPriceGroup P_BillingDocumentItemBasic_2 CustomerPriceGroup CustPrice Group
CustomerGroup P_BillingDocumentItemBasic_2 CustomerGroup Customer Group
Country P_BillingDocumentItemBasic_2 Country Venue: Ctry/Reg
Region P_BillingDocumentItemBasic_2 Region Venue Region
CityCode P_BillingDocumentItemBasic_2 CityCode IATA: City
SalesDistrict P_BillingDocumentItemBasic_2 SalesDistrict Sales District
OverallSDProcessStatus P_BillingDocumentItemBasic_2 OverallSDProcessStatus Overall Status
OverallBillingStatus P_BillingDocumentItemBasic_2 OverallBillingStatus Status
SoldToParty P_BillingDocumentItemBasic_2 SoldToParty Sold-to Party
PayerParty P_BillingDocumentItemBasic_2 PayerParty Payer
BillingDocumentDate P_BillingDocumentItemBasic_2 BillingDocumentDate Billing Date
CompanyCode P_BillingDocumentItemBasic_2 CompanyCode Receiver Company Code
County P_BillingDocumentItemBasic_2 County Wyoming County
CustomerRebateAgreement P_BillingDocumentItemBasic_2 CustomerRebateAgreement Agreement
BillingDocumentCategory P_BillingDocumentItemBasic_2 BillingDocumentCategory BillingCategory
ShipToParty P_BillingDocumentItemBasic_2 ShipToParty Ship-To Party (obsolete)
BillToParty P_BillingDocumentItemBasic_2 BillToParty Inv. Recipient
SalesEmployee P_BillingDocumentItemBasic_2 SalesEmployee Sales Employee
ResponsibleEmployee P_BillingDocumentItemBasic_2 ResponsibleEmployee Employee Resp.
PricingDocument P_BillingDocumentItemBasic_2 PricingDocument Document Condition
CancelledBillingDocument P_BillingDocumentItemBasic_2 CancelledBillingDocument Canceld Bill.Dc

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_BillingDocumentItemBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_BillingDocumentItemBasic AS
SELECT
  BillingDocumentItem.BillingDocument AS BillingDocument,
  BillingDocumentItem.BillingDocumentItem AS BillingDocumentItem,
  BillingDocumentItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  BillingDocumentItem.SalesDocumentItemType AS SalesDocumentItemType,
  BillingDocumentItem.ReturnItemProcessingType AS ReturnItemProcessingType,
  BillingDocumentItem.CreatedByUser AS CreatedByUser,
  BillingDocumentItem.CreationDate AS CreationDate,
  BillingDocumentItem.CreationTime AS CreationTime,
  BillingDocumentItem.ReferenceLogicalSystem AS ReferenceLogicalSystem,
  BillingDocumentItem.OrganizationDivision AS OrganizationDivision,
  BillingDocumentItem.Division AS Division,
  BillingDocumentItem.SalesOffice AS SalesOffice,
  BillingDocumentItem.Product AS Product,
  BillingDocumentItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  BillingDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  BillingDocumentItem.PricingReferenceMaterial AS PricingReferenceMaterial,
  BillingDocumentItem.Batch AS Batch,
  BillingDocumentItem.ProductHierarchyNode AS ProductHierarchyNode,
  BillingDocumentItem.ProductGroup AS ProductGroup,
  BillingDocumentItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  BillingDocumentItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  BillingDocumentItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  BillingDocumentItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  BillingDocumentItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  BillingDocumentItem.ProductConfiguration AS ProductConfiguration,
  BillingDocumentItem.MaterialCommissionGroup AS MaterialCommissionGroup,
  BillingDocumentItem.Plant AS Plant,
  BillingDocumentItem.StorageLocation AS StorageLocation,
  BillingDocumentItem.ReplacementPartType AS ReplacementPartType,
  BillingDocumentItem.MaterialGroupHierarchy1 AS MaterialGroupHierarchy1,
  BillingDocumentItem.MaterialGroupHierarchy2 AS MaterialGroupHierarchy2,
  BillingDocumentItem.PlantRegion AS PlantRegion,
  BillingDocumentItem.PlantCounty AS PlantCounty,
  BillingDocumentItem.PlantCity AS PlantCity,
  BillingDocumentItem.TransitPlant AS TransitPlant,
  BillingDocumentItem.ValueChainCategory AS ValueChainCategory,
  BillingDocumentItem.BOMExplosion AS BOMExplosion,
  BillingDocumentItem.MaterialDeterminationType AS MaterialDeterminationType,
  BillingDocumentItem.BillingDocumentItemText AS BillingDocumentItemText,
  BillingDocumentItem.ServicesRenderedDate AS ServicesRenderedDate,
  BillingDocumentItem.BillingQuantity AS BillingQuantity,
  BillingDocumentItem.BillingQuantityUnit AS BillingQuantityUnit,
  BillingDocumentItem.BillingQuantityInBaseUnit AS BillingQuantityInBaseUnit,
  BillingDocumentItem.BaseUnit AS BaseUnit,
  BillingDocumentItem.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  BillingDocumentItem.BillingToBaseQuantityDnmntr AS BillingToBaseQuantityDnmntr,
  BillingDocumentItem.BillingToBaseQuantityNmrtr AS BillingToBaseQuantityNmrtr,
  BillingDocumentItem.ItemGrossWeight AS ItemGrossWeight,
  BillingDocumentItem.ItemNetWeight AS ItemNetWeight,
  BillingDocumentItem.ItemWeightUnit AS ItemWeightUnit,
  BillingDocumentItem.ItemVolume AS ItemVolume,
  BillingDocumentItem.ItemVolumeUnit AS ItemVolumeUnit,
  BillingDocumentItem.BillToPartyCountry AS BillToPartyCountry,
  BillingDocumentItem.BillToPartyRegion AS BillToPartyRegion,
  BillingDocumentItem.BillingPlanRule AS BillingPlanRule,
  BillingDocumentItem.BillingPlan AS BillingPlan,
  BillingDocumentItem.BillingPlanItem AS BillingPlanItem,
  BillingDocumentItem.DocumentBillingStatus AS DocumentBillingStatus,
  BillingDocumentItem.NetAmount AS NetAmount,
  BillingDocumentItem.TransactionCurrency AS TransactionCurrency,
  BillingDocumentItem.GrossAmount AS GrossAmount,
  BillingDocumentItem.PricingDate AS PricingDate,
  BillingDocumentItem.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  BillingDocumentItem.PricingScaleQuantityInBaseUnit AS PricingScaleQuantityInBaseUnit,
  BillingDocumentItem.TaxAmount AS TaxAmount,
  BillingDocumentItem.CostAmount AS CostAmount,
  BillingDocumentItem.Subtotal1Amount AS Subtotal1Amount,
  BillingDocumentItem.Subtotal2Amount AS Subtotal2Amount,
  BillingDocumentItem.Subtotal3Amount AS Subtotal3Amount,
  BillingDocumentItem.Subtotal4Amount AS Subtotal4Amount,
  BillingDocumentItem.Subtotal5Amount AS Subtotal5Amount,
  BillingDocumentItem.Subtotal6Amount AS Subtotal6Amount,
  BillingDocumentItem.StatisticalValueControl AS StatisticalValueControl,
  BillingDocumentItem.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  BillingDocumentItem.CustomerConditionGroup1 AS CustomerConditionGroup1,
  BillingDocumentItem.CustomerConditionGroup2 AS CustomerConditionGroup2,
  BillingDocumentItem.CustomerConditionGroup3 AS CustomerConditionGroup3,
  BillingDocumentItem.CustomerConditionGroup4 AS CustomerConditionGroup4,
  BillingDocumentItem.CustomerConditionGroup5 AS CustomerConditionGroup5,
  BillingDocumentItem.ManualPriceChangeType AS ManualPriceChangeType,
  BillingDocumentItem.MaterialPricingGroup AS MaterialPricingGroup,
  BillingDocumentItem.StatisticsExchangeRate AS StatisticsExchangeRate,
  BillingDocumentItem.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
  BillingDocumentItem.MainItemMaterialPricingGroup AS MainItemMaterialPricingGroup,
  BillingDocumentItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  BillingDocumentItem.PricingRelevance AS PricingRelevance,
  BillingDocumentItem.DepartureCountry AS DepartureCountry,
  BillingDocumentItem.TaxJurisdiction AS TaxJurisdiction,
  BillingDocumentItem.ProductTaxClassification1 AS ProductTaxClassification1,
  BillingDocumentItem.ProductTaxClassification2 AS ProductTaxClassification2,
  BillingDocumentItem.ProductTaxClassification3 AS ProductTaxClassification3,
  BillingDocumentItem.ProductTaxClassification4 AS ProductTaxClassification4,
  BillingDocumentItem.ProductTaxClassification5 AS ProductTaxClassification5,
  BillingDocumentItem.ProductTaxClassification6 AS ProductTaxClassification6,
  BillingDocumentItem.ProductTaxClassification7 AS ProductTaxClassification7,
  BillingDocumentItem.ProductTaxClassification8 AS ProductTaxClassification8,
  BillingDocumentItem.ProductTaxClassification9 AS ProductTaxClassification9,
  BillingDocumentItem.ZeroVATRsn AS ZeroVATRsn,
  BillingDocumentItem.TaxCode AS TaxCode,
  BillingDocumentItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  BillingDocumentItem.CountryOfOrigin AS CountryOfOrigin,
  BillingDocumentItem.RegionOfOrigin AS RegionOfOrigin,
  BillingDocumentItem.CommodityCode AS CommodityCode,
  BillingDocumentItem.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
  BillingDocumentItem.BusinessArea AS BusinessArea,
  BillingDocumentItem.ProfitCenter AS ProfitCenter,
  BillingDocumentItem.WBSElementInternalID AS WBSElementInternalID,
  BillingDocumentItem.ProviderContract AS ProviderContract,
  BillingDocumentItem.ProviderContractItem AS ProviderContractItem,
  BillingDocumentItem.BillingPerformancePeriodStrDte AS BillingPerformancePeriodStrDte,
  BillingDocumentItem.BillingPerformancePeriodEndDte AS BillingPerformancePeriodEndDte,
  BillingDocumentItem.ControllingArea AS ControllingArea,
  BillingDocumentItem.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  BillingDocumentItem.OrderID AS OrderID,
  BillingDocumentItem.CostCenter AS CostCenter,
  BillingDocumentItem.OriginSDDocument AS OriginSDDocument,
  BillingDocumentItem.OriginSDDocumentItem AS OriginSDDocumentItem,
  BillingDocumentItem.PriceDetnExchangeRateDate AS PriceDetnExchangeRateDate,
  BillingDocumentItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  BillingDocumentItem.ReferenceSDDocument AS ReferenceSDDocument,
  BillingDocumentItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  BillingDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  BillingDocumentItem.SalesDocument AS SalesDocument,
  BillingDocumentItem.SalesDocumentItem AS SalesDocumentItem,
  BillingDocumentItem.SalesSDDocumentCategory AS SalesSDDocumentCategory,
  BillingDocumentItem.HigherLevelItem AS HigherLevelItem,
  BillingDocumentItem.HigherLvlItmOfBatSpltItm AS HigherLvlItmOfBatSpltItm,
  BillingDocumentItem.BillingDocumentItemInPartSgmt AS BillingDocumentItemInPartSgmt,
  BillingDocumentItem.ExternalReferenceDocument AS ExternalReferenceDocument,
  BillingDocumentItem.BillingDocExtReferenceDocItem AS BillingDocExtReferenceDocItem,
  BillingDocumentItem.PrelimBillingDocument AS PrelimBillingDocument,
  BillingDocumentItem.PrelimBillingDocumentItem AS PrelimBillingDocumentItem,
  BillingDocumentItem.SalesGroup AS SalesGroup,
  BillingDocumentItem.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  BillingDocumentItem.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  BillingDocumentItem.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  BillingDocumentItem.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  BillingDocumentItem.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  BillingDocumentItem.SDDocumentReason AS SDDocumentReason,
  BillingDocumentItem.RetailPromotion AS RetailPromotion,
  BillingDocumentItem.RebateBasisAmount AS RebateBasisAmount,
  BillingDocumentItem.VolumeRebateGroup AS VolumeRebateGroup,
  BillingDocumentItem.ItemIsRelevantForCredit AS ItemIsRelevantForCredit,
  BillingDocumentItem.CreditRelatedPrice AS CreditRelatedPrice,
  BillingDocumentItem.SalesDeal AS SalesDeal,
  BillingDocumentItem.SalesPromotion AS SalesPromotion,
  BillingDocumentItem.SalesOrderSalesDistrict AS SalesOrderSalesDistrict,
  BillingDocumentItem.SalesOrderCustomerGroup AS SalesOrderCustomerGroup,
  BillingDocumentItem.SalesOrderCustomerPriceGroup AS SalesOrderCustomerPriceGroup,
  BillingDocumentItem.SalesOrderPriceListType AS SalesOrderPriceListType,
  BillingDocumentItem.SalesOrderSalesOrganization AS SalesOrderSalesOrganization,
  BillingDocumentItem.SalesOrderDistributionChannel AS SalesOrderDistributionChannel,
  BillingDocumentItem.SalesDocIsCreatedFromReference AS SalesDocIsCreatedFromReference,
  BillingDocumentItem.ShippingPoint AS ShippingPoint,
  BillingDocumentItem.ServiceDocumentType AS ServiceDocumentType,
  BillingDocumentItem.ServiceDocument AS ServiceDocument,
  BillingDocumentItem.ServiceDocumentItem AS ServiceDocumentItem,
  BillingDocumentItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  BillingDocumentItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  BillingDocumentItem.HigherLevelItemUsage AS HigherLevelItemUsage,
  BillingDocumentItem.BillingDocumentIsTemporary AS BillingDocumentIsTemporary,
  BillingDocumentItem.SDDocumentCategory AS SDDocumentCategory,
  BillingDocumentItem.BillingDocumentType AS BillingDocumentType,
  BillingDocumentItem.SalesOrganization AS SalesOrganization,
  BillingDocumentItem.DistributionChannel AS DistributionChannel,
  BillingDocumentItem.CustomerPriceGroup AS CustomerPriceGroup,
  BillingDocumentItem.CustomerGroup AS CustomerGroup,
  BillingDocumentItem.Country AS Country,
  BillingDocumentItem.Region AS Region,
  BillingDocumentItem.CityCode AS CityCode,
  BillingDocumentItem.SalesDistrict AS SalesDistrict,
  BillingDocumentItem.OverallSDProcessStatus AS OverallSDProcessStatus,
  BillingDocumentItem.OverallBillingStatus AS OverallBillingStatus,
  BillingDocumentItem.SoldToParty AS SoldToParty,
  BillingDocumentItem.PayerParty AS PayerParty,
  BillingDocumentItem.BillingDocumentDate AS BillingDocumentDate,
  BillingDocumentItem.CompanyCode AS CompanyCode,
  BillingDocumentItem.County AS County,
  BillingDocumentItem.CustomerRebateAgreement AS CustomerRebateAgreement,
  BillingDocumentItem.BillingDocumentCategory AS BillingDocumentCategory,
  BillingDocumentItem.ShipToParty AS ShipToParty,
  BillingDocumentItem.BillToParty AS BillToParty,
  BillingDocumentItem.SalesEmployee AS SalesEmployee,
  BillingDocumentItem.ResponsibleEmployee AS ResponsibleEmployee,
  BillingDocumentItem.PricingDocument AS PricingDocument,
  BillingDocumentItem.CancelledBillingDocument AS CancelledBillingDocument
FROM P_BillingDocumentItemBasic_1 AS BillingDocumentItem
INNER JOIN P_VBRP_SDM_PHASE_BADI_TF AS SwitchState ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_BillingDocumentItemBasic_2
;

Learn More