A_BillingDocumentItem_2

DDL: A_BILLINGDOCUMENTITEM_2 Type: view_entity CONSUMPTION Package: ODATA_SD_BIL_BD_API
132 Fields 1 Data Sources 1 OData Services

Items

A_BillingDocumentItem_2 is a Consumption CDS View that provides data about "Items" in SAP S/4HANA. It reads from 1 data source (R_BillingDocumentItemTP) and exposes 132 fields with key fields BillingDocument, BillingDocumentItem. It is exposed through 1 OData service (API_BILLINGDOCUMENT). Part of development package ODATA_SD_BIL_BD_API.

Data Sources (1)

SourceAliasJoin Type
R_BillingDocumentItemTP R_BillingDocumentItemTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Items view
AccessControl.authorizationCheck #MANDATORY view
OData.entityType.name BillingDocumentItem_Type view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_BILLINGDOCUMENT API_BILLINGDOCUMENT V4 C2 C1

Fields (132)

KeyFieldSource TableSource FieldDescription
KEY BillingDocument BillingDocumentItem BillingDocument SD Document
KEY BillingDocumentItem BillingDocumentItem BillingDocumentItem Item
SalesDocumentItemCategory BillingDocumentItem SalesDocumentItemCategory Item Category
SalesDocumentItemType BillingDocumentItem SalesDocumentItemType
ReturnItemProcessingType BillingDocumentItem ReturnItemProcessingType Returns
CreatedByUser BillingDocumentItem CreatedByUser User Name
CreationDate BillingDocumentItem CreationDate Time Stamp
CreationTime BillingDocumentItem CreationTime Time of Change
ReferenceLogicalSystem BillingDocumentItem ReferenceLogicalSystem
OrganizationDivision BillingDocumentItem OrganizationDivision Org. Division
Division BillingDocumentItem Division Internal Division ID
SalesOffice BillingDocumentItem SalesOffice Sales Office
Product BillingDocumentItem Product Product Sold
OriginallyRequestedMaterial BillingDocumentItem OriginallyRequestedMaterial
InternationalArticleNumber BillingDocumentItem InternationalArticleNumber EAN/UPC
PricingReferenceMaterial BillingDocumentItem PricingReferenceMaterial Pr. Ref. Matl
Batch BillingDocumentItem Batch Lot No.
ProductGroup BillingDocumentItem ProductGroup Product Sold Group
AdditionalMaterialGroup1 BillingDocumentItem AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 BillingDocumentItem AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 BillingDocumentItem AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 BillingDocumentItem AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 BillingDocumentItem AdditionalMaterialGroup5 MaterialGroup 5
ProductConfiguration BillingDocumentItem ProductConfiguration
Plant BillingDocumentItem Plant Valuation Area
StorageLocation BillingDocumentItem StorageLocation StorageLocation
PlantRegion BillingDocumentItem PlantRegion Region-Dlv.Plnt
PlantCounty BillingDocumentItem PlantCounty County-Dlv.Plnt
PlantCity BillingDocumentItem PlantCity City-Dlv.Plant
MaterialDeterminationType BillingDocumentItem MaterialDeterminationType
SoldProduct BillingDocumentItem SoldProduct Product Sold
BillingDocumentItemText BillingDocumentItem BillingDocumentItemText Item Descr.
ServicesRenderedDate BillingDocumentItem ServicesRenderedDate Services Rendered Date
BillingQuantity BillingDocumentItem BillingQuantity Invoiced Qty
BillingQuantityUnitSAPCode BillingDocumentItem BillingQuantityUnit Sales Unit
BillingQuantityUnitISOCode
BillingQuantityInBaseUnit BillingDocumentItem BillingQuantityInBaseUnit Bill.Qty in SKU
BaseUnitSAPCode BillingDocumentItem BaseUnit Unit of Measure
BaseUnitISOCode
MRPRequiredQuantityInBaseUnit BillingDocumentItem MRPRequiredQuantityInBaseUnit Open Quantity
BillingToBaseQuantityDnmntr BillingDocumentItem BillingToBaseQuantityDnmntr
BillingToBaseQuantityNmrtr BillingDocumentItem BillingToBaseQuantityNmrtr
ItemGrossWeight BillingDocumentItem ItemGrossWeight Gross Weight
ItemNetWeight BillingDocumentItem ItemNetWeight Net Weight
ItemWeightUnitSAPCode BillingDocumentItem ItemWeightUnit Unit of Weight
ItemWeightUnitISOCode
ItemVolume BillingDocumentItem ItemVolume Volume
ItemVolumeUnitSAPCode BillingDocumentItem ItemVolumeUnit Volume Unit
ItemVolumeUnitISOCode
BillingPlanRule BillingDocumentItem BillingPlanRule
BillingPlan BillingDocumentItem BillingPlan Bill. Plan No.
BillingPlanItem BillingDocumentItem BillingPlanItem Item
NetAmount BillingDocumentItem NetAmount Stated Amount
TransactionCurrency BillingDocumentItem TransactionCurrency Transaction Currency
GrossAmount BillingDocumentItem GrossAmount Gross value
PricingDate BillingDocumentItem PricingDate Pricing Date
AbsltPriceDetnExchangeRate BillingDocumentItem AbsltPriceDetnExchangeRate
PriceDetnExchRateIsIndrctQtan BillingDocumentItem PriceDetnExchRateIsIndrctQtan
PriceDetnExchangeRateDate BillingDocumentItem PriceDetnExchangeRateDate
PricingScaleQuantityInBaseUnit BillingDocumentItem PricingScaleQuantityInBaseUnit
TaxAmount BillingDocumentItem TaxAmount Tax Amt in Rptg Crcy
CostAmount BillingDocumentItem CostAmount
Subtotal1Amount BillingDocumentItem Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount BillingDocumentItem Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount BillingDocumentItem Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount BillingDocumentItem Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount BillingDocumentItem Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount BillingDocumentItem Subtotal6Amount Subtotal 6 Amount
StatisticalValueControl BillingDocumentItem StatisticalValueControl
CashDiscountIsDeductible BillingDocumentItem CashDiscountIsDeductible Cash Discount
CustomerConditionGroup1 BillingDocumentItem CustomerConditionGroup1 Condition grp 1
CustomerConditionGroup2 BillingDocumentItem CustomerConditionGroup2 Condition grp 2
CustomerConditionGroup3 BillingDocumentItem CustomerConditionGroup3 Condition grp 3
CustomerConditionGroup4 BillingDocumentItem CustomerConditionGroup4 Condition grp 4
CustomerConditionGroup5 BillingDocumentItem CustomerConditionGroup5 Condition grp 5
ManualPriceChangeType BillingDocumentItem ManualPriceChangeType
MaterialPricingGroup BillingDocumentItem MaterialPricingGroup
AbsltStatisticsExchangeRate BillingDocumentItem AbsltStatisticsExchangeRate
StatisticsExchRateIsIndrctQtan BillingDocumentItem StatisticsExchRateIsIndrctQtan
MainItemPricingRefMaterial BillingDocumentItem MainItemPricingRefMaterial
MainItemMaterialPricingGroup BillingDocumentItem MainItemMaterialPricingGroup
TimeSheetOvertimeCategory BillingDocumentItem TimeSheetOvertimeCategory
DepartureCountry BillingDocumentItem DepartureCountry Departure Country / Region
TaxJurisdiction BillingDocumentItem TaxJurisdiction Tax Jurisdiction
ProductTaxClassification1 BillingDocumentItem ProductTaxClassification1
ProductTaxClassification2 BillingDocumentItem ProductTaxClassification2
ProductTaxClassification3 BillingDocumentItem ProductTaxClassification3
ProductTaxClassification4 BillingDocumentItem ProductTaxClassification4
ProductTaxClassification5 BillingDocumentItem ProductTaxClassification5
ProductTaxClassification6 BillingDocumentItem ProductTaxClassification6
ProductTaxClassification7 BillingDocumentItem ProductTaxClassification7
ProductTaxClassification8 BillingDocumentItem ProductTaxClassification8
ProductTaxClassification9 BillingDocumentItem ProductTaxClassification9
TaxCode BillingDocumentItem TaxCode Tax Code
TaxRateValidityStartDate BillingDocumentItem TaxRateValidityStartDate Tax Rate Validity Start Date
EligibleAmountForCashDiscount BillingDocumentItem EligibleAmountForCashDiscount
BusinessArea BillingDocumentItem BusinessArea Business Area
ProfitCenter BillingDocumentItem ProfitCenter Profit Center
WBSElementExternalID BillingDocumentItem WBSElementExternalID WBS Element External ID
ProviderContract BillingDocumentItem ProviderContract Contract
ProviderContractItem BillingDocumentItem ProviderContractItem Contract Item
BillingPeriodOfPerfStartDate BillingDocumentItem BillingPeriodOfPerfStartDate
BillingPeriodOfPerfEndDate BillingDocumentItem BillingPeriodOfPerfEndDate
ControllingArea BillingDocumentItem ControllingArea Controlling Area
CostCenter BillingDocumentItem CostCenter Cost Center
MatlAccountAssignmentGroup BillingDocumentItem MatlAccountAssignmentGroup
ReferenceSDDocument BillingDocumentItem ReferenceSDDocument Reference Doc.
ReferenceSDDocumentItem BillingDocumentItem ReferenceSDDocumentItem Reference Item
ReferenceSDDocumentCategory BillingDocumentItem ReferenceSDDocumentCategory Prec.Doc.Categ.
SalesDocument BillingDocumentItem SalesDocument SD Document
SalesDocumentItem BillingDocumentItem SalesDocumentItem Sales Document Item
SalesSDDocumentCategory BillingDocumentItem SalesSDDocumentCategory Document Cat.
HigherLevelItem BillingDocumentItem HigherLevelItem Higher-Lev.Item
BillingDocumentItemInPartSgmt BillingDocumentItem BillingDocumentItemInPartSgmt
SalesGroup BillingDocumentItem SalesGroup Sales Group
AdditionalCustomerGroup1 BillingDocumentItem AdditionalCustomerGroup1 Customer Grp 1
AdditionalCustomerGroup2 BillingDocumentItem AdditionalCustomerGroup2 Customer Grp 2
AdditionalCustomerGroup3 BillingDocumentItem AdditionalCustomerGroup3 Customer Grp 3
AdditionalCustomerGroup4 BillingDocumentItem AdditionalCustomerGroup4 Customer Grp 4
AdditionalCustomerGroup5 BillingDocumentItem AdditionalCustomerGroup5 Customer Grp 5
SDDocumentReason BillingDocumentItem SDDocumentReason Order Reason
ItemIsRelevantForCredit BillingDocumentItem ItemIsRelevantForCredit
CreditRelatedPrice BillingDocumentItem CreditRelatedPrice
ShippingPoint BillingDocumentItem ShippingPoint Shipping Point
ServiceDocumentType BillingDocumentItem ServiceDocumentType Transaction Type
ServiceDocument BillingDocumentItem ServiceDocument Transaction ID
ServiceDocumentItem BillingDocumentItem ServiceDocumentItem Service Document
BusinessSolutionOrder BillingDocumentItem BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem BillingDocumentItem BusinessSolutionOrderItem Solution Order Item
HigherLevelItemUsage BillingDocumentItem HigherLevelItemUsage
BillingDocumentType BillingDocumentItem BillingDocumentType Billing Type
SalesOrganization BillingDocumentItem SalesOrganization Sales Organization

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 A_BillingDocumentItem_2.
-- 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 A_BillingDocumentItem_2 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.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.Plant AS Plant,
  BillingDocumentItem.StorageLocation AS StorageLocation,
  BillingDocumentItem.PlantRegion AS PlantRegion,
  BillingDocumentItem.PlantCounty AS PlantCounty,
  BillingDocumentItem.PlantCity AS PlantCity,
  BillingDocumentItem.MaterialDeterminationType AS MaterialDeterminationType,
  BillingDocumentItem.SoldProduct AS SoldProduct,
  BillingDocumentItem.BillingDocumentItemText AS BillingDocumentItemText,
  BillingDocumentItem.ServicesRenderedDate AS ServicesRenderedDate,
  BillingDocumentItem.BillingQuantity AS BillingQuantity,
  BillingDocumentItem.BillingQuantityUnit AS BillingQuantityUnitSAPCode,
  cast(_BillingQuantityUnit.UnitOfMeasureISOCode as billg_qty_unit_isocode preserving type) AS BillingQuantityUnitISOCode,
  BillingDocumentItem.BillingQuantityInBaseUnit AS BillingQuantityInBaseUnit,
  BillingDocumentItem.BaseUnit AS BaseUnitSAPCode,
  cast(_BaseUnit.UnitOfMeasureISOCode as meins_iso preserving type) AS BaseUnitISOCode,
  BillingDocumentItem.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  BillingDocumentItem.BillingToBaseQuantityDnmntr AS BillingToBaseQuantityDnmntr,
  BillingDocumentItem.BillingToBaseQuantityNmrtr AS BillingToBaseQuantityNmrtr,
  BillingDocumentItem.ItemGrossWeight AS ItemGrossWeight,
  BillingDocumentItem.ItemNetWeight AS ItemNetWeight,
  BillingDocumentItem.ItemWeightUnit AS ItemWeightUnitSAPCode,
  cast(_ItemWeightUnit.UnitOfMeasureISOCode as gewei_iso preserving type) AS ItemWeightUnitISOCode,
  BillingDocumentItem.ItemVolume AS ItemVolume,
  BillingDocumentItem.ItemVolumeUnit AS ItemVolumeUnitSAPCode,
  cast(_ItemVolumeUnit.UnitOfMeasureISOCode as voleh_iso preserving type) AS ItemVolumeUnitISOCode,
  BillingDocumentItem.BillingPlanRule AS BillingPlanRule,
  BillingDocumentItem.BillingPlan AS BillingPlan,
  BillingDocumentItem.BillingPlanItem AS BillingPlanItem,
  BillingDocumentItem.NetAmount AS NetAmount,
  BillingDocumentItem.TransactionCurrency AS TransactionCurrency,
  BillingDocumentItem.GrossAmount AS GrossAmount,
  BillingDocumentItem.PricingDate AS PricingDate,
  BillingDocumentItem.AbsltPriceDetnExchangeRate AS AbsltPriceDetnExchangeRate,
  BillingDocumentItem.PriceDetnExchRateIsIndrctQtan AS PriceDetnExchRateIsIndrctQtan,
  BillingDocumentItem.PriceDetnExchangeRateDate AS PriceDetnExchangeRateDate,
  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.AbsltStatisticsExchangeRate AS AbsltStatisticsExchangeRate,
  BillingDocumentItem.StatisticsExchRateIsIndrctQtan AS StatisticsExchRateIsIndrctQtan,
  BillingDocumentItem.MainItemPricingRefMaterial AS MainItemPricingRefMaterial,
  BillingDocumentItem.MainItemMaterialPricingGroup AS MainItemMaterialPricingGroup,
  BillingDocumentItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  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.TaxCode AS TaxCode,
  BillingDocumentItem.TaxRateValidityStartDate AS TaxRateValidityStartDate,
  BillingDocumentItem.EligibleAmountForCashDiscount AS EligibleAmountForCashDiscount,
  BillingDocumentItem.BusinessArea AS BusinessArea,
  BillingDocumentItem.ProfitCenter AS ProfitCenter,
  BillingDocumentItem.WBSElementExternalID AS WBSElementExternalID,
  BillingDocumentItem.ProviderContract AS ProviderContract,
  BillingDocumentItem.ProviderContractItem AS ProviderContractItem,
  BillingDocumentItem.BillingPeriodOfPerfStartDate AS BillingPeriodOfPerfStartDate,
  BillingDocumentItem.BillingPeriodOfPerfEndDate AS BillingPeriodOfPerfEndDate,
  BillingDocumentItem.ControllingArea AS ControllingArea,
  BillingDocumentItem.CostCenter AS CostCenter,
  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.BillingDocumentItemInPartSgmt AS BillingDocumentItemInPartSgmt,
  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.ItemIsRelevantForCredit AS ItemIsRelevantForCredit,
  BillingDocumentItem.CreditRelatedPrice AS CreditRelatedPrice,
  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.BillingDocumentType AS BillingDocumentType,
  BillingDocumentItem.SalesOrganization AS SalesOrganization
FROM R_BillingDocumentItemTP
;

Learn More