A_BillingDocumentRequestItem_2

DDL: A_BILLINGDOCUMENTREQUESTITEM_2 Type: view_entity CONSUMPTION
100 Fields 1 Data Sources

Billing Document Request Item

A_BillingDocumentRequestItem_2 is a Consumption CDS View that provides data about "Billing Document Request Item" in SAP S/4HANA. It reads from 1 data source (R_BillingDocumentRequestItemTP) and exposes 100 fields with key fields BillingDocumentRequest, BillingDocumentRequestItem.

Data Sources (1)

SourceAliasJoin Type
R_BillingDocumentRequestItemTP R_BillingDocumentRequestItemTP projection

Annotations (10)

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

Fields (100)

KeyFieldSource TableSource FieldDescription
KEY BillingDocumentRequest BillingDocumentRequestItem BillingDocumentRequest
KEY BillingDocumentRequestItem BillingDocumentRequestItem BillingDocumentRequestItem
SalesDocumentItemCategory BillingDocumentRequestItem SalesDocumentItemCategory Item Category
SalesDocumentItemType BillingDocumentRequestItem SalesDocumentItemType
ReturnItemProcessingType BillingDocumentRequestItem ReturnItemProcessingType Returns
CreatedByUser BillingDocumentRequestItem CreatedByUser User Name
CreationDate BillingDocumentRequestItem CreationDate Time Stamp
CreationTime BillingDocumentRequestItem CreationTime Time of Change
ReferenceLogicalSystem BillingDocumentRequestItem ReferenceLogicalSystem
OrganizationDivision BillingDocumentRequestItem OrganizationDivision Org. Division
Division BillingDocumentRequestItem Division Internal Division ID
SalesOffice BillingDocumentRequestItem SalesOffice Sales Office
Product BillingDocumentRequestItem Product Product Sold
OriginallyRequestedMaterial BillingDocumentRequestItem OriginallyRequestedMaterial
InternationalArticleNumber BillingDocumentRequestItem InternationalArticleNumber EAN/UPC
PricingReferenceMaterial BillingDocumentRequestItem PricingReferenceMaterial Pr. Ref. Matl
Batch BillingDocumentRequestItem Batch Lot No.
ProductHierarchyNode BillingDocumentRequestItem ProductHierarchyNode Prod. Hierarchy
ProductGroup BillingDocumentRequestItem ProductGroup Product Sold Group
AdditionalMaterialGroup1 BillingDocumentRequestItem AdditionalMaterialGroup1 MaterialGroup 1
AdditionalMaterialGroup2 BillingDocumentRequestItem AdditionalMaterialGroup2 MaterialGroup 2
AdditionalMaterialGroup3 BillingDocumentRequestItem AdditionalMaterialGroup3 MaterialGroup 3
AdditionalMaterialGroup4 BillingDocumentRequestItem AdditionalMaterialGroup4 MaterialGroup 4
AdditionalMaterialGroup5 BillingDocumentRequestItem AdditionalMaterialGroup5 MaterialGroup 5
MaterialCommissionGroup BillingDocumentRequestItem MaterialCommissionGroup
Plant BillingDocumentRequestItem Plant Valuation Area
StorageLocation BillingDocumentRequestItem StorageLocation StorageLocation
BillingDocumentRequestItemText BillingDocumentRequestItem BillingDocumentRequestItemText
BillingQuantity BillingDocumentRequestItem BillingQuantity Invoiced Qty
BillingQuantityUnit BillingDocumentRequestItem BillingQuantityUnit Sales Unit
BillingQuantityInBaseUnit BillingDocumentRequestItem BillingQuantityInBaseUnit Bill.Qty in SKU
BaseUnit BillingDocumentRequestItem BaseUnit Unit of Measure
MRPRequiredQuantityInBaseUnit BillingDocumentRequestItem MRPRequiredQuantityInBaseUnit Open Quantity
BillingToBaseQuantityDnmntr BillingDocumentRequestItem BillingToBaseQuantityDnmntr
BillingToBaseQuantityNmrtr BillingDocumentRequestItem BillingToBaseQuantityNmrtr
ItemGrossWeight BillingDocumentRequestItem ItemGrossWeight Gross Weight
ItemNetWeight BillingDocumentRequestItem ItemNetWeight Net Weight
ItemWeightUnit BillingDocumentRequestItem ItemWeightUnit Unit of Weight
ItemVolume BillingDocumentRequestItem ItemVolume Volume
ItemVolumeUnit BillingDocumentRequestItem ItemVolumeUnit Volume Unit
NetAmount BillingDocumentRequestItem NetAmount Stated Amount
TransactionCurrency BillingDocumentRequestItem TransactionCurrency Transaction Currency
GrossAmount BillingDocumentRequestItem GrossAmount Gross value
PricingDate BillingDocumentRequestItem PricingDate Pricing Date
PriceDetnExchangeRate BillingDocumentRequestItem PriceDetnExchangeRate Exchange Rate
PricingScaleQuantityInBaseUnit BillingDocumentRequestItem PricingScaleQuantityInBaseUnit
TaxAmount BillingDocumentRequestItem TaxAmount Tax Amt in Rptg Crcy
CostAmount BillingDocumentRequestItem CostAmount
Subtotal1Amount BillingDocumentRequestItem Subtotal1Amount Subtotal 1 Amount
Subtotal2Amount BillingDocumentRequestItem Subtotal2Amount Subtotal 2 Amount
Subtotal3Amount BillingDocumentRequestItem Subtotal3Amount Subtotal 3 Amount
Subtotal4Amount BillingDocumentRequestItem Subtotal4Amount Subtotal 4 Amount
Subtotal5Amount BillingDocumentRequestItem Subtotal5Amount Subtotal 5 Amount
Subtotal6Amount BillingDocumentRequestItem Subtotal6Amount Subtotal 6 Amount
StatisticalValueControl BillingDocumentRequestItem StatisticalValueControl
CashDiscountIsDeductible BillingDocumentRequestItem CashDiscountIsDeductible Cash Discount
TimeSheetOvertimeCategory BillingDocumentRequestItem TimeSheetOvertimeCategory
DepartureCountry BillingDocumentRequestItem DepartureCountry Departure Country / Region
TaxJurisdiction BillingDocumentRequestItem TaxJurisdiction Tax Jurisdiction
ProductTaxClassification1 BillingDocumentRequestItem ProductTaxClassification1
ProductTaxClassification2 BillingDocumentRequestItem ProductTaxClassification2
ProductTaxClassification3 BillingDocumentRequestItem ProductTaxClassification3
ProductTaxClassification4 BillingDocumentRequestItem ProductTaxClassification4
ProductTaxClassification5 BillingDocumentRequestItem ProductTaxClassification5
ProductTaxClassification6 BillingDocumentRequestItem ProductTaxClassification6
ProductTaxClassification7 BillingDocumentRequestItem ProductTaxClassification7
ProductTaxClassification8 BillingDocumentRequestItem ProductTaxClassification8
ProductTaxClassification9 BillingDocumentRequestItem ProductTaxClassification9
ZeroVATRsn BillingDocumentRequestItem ZeroVATRsn Reason for Zero VAT
BillgDocReqBillgSts BillingDocumentRequestItem BillgDocReqBillgSts
BusinessArea BillingDocumentRequestItem BusinessArea Business Area
ProfitCenter BillingDocumentRequestItem ProfitCenter Profit Center
OrderID BillingDocumentRequestItem OrderID Order ID
WBSElementInternalID BillingDocumentRequestItem WBSElementInternalID WBS Internal ID
ProviderContract BillingDocumentRequestItem ProviderContract Contract
ProviderContractItem BillingDocumentRequestItem ProviderContractItem Contract Item
ControllingArea BillingDocumentRequestItem ControllingArea Controlling Area
CostCenter BillingDocumentRequestItem CostCenter Cost Center
OriginSDDocument BillingDocumentRequestItem OriginSDDocument Originating Doc
OriginSDDocumentItem BillingDocumentRequestItem OriginSDDocumentItem Origin. Item
PriceDetnExchangeRateDate BillingDocumentRequestItem PriceDetnExchangeRateDate
MatlAccountAssignmentGroup BillingDocumentRequestItem MatlAccountAssignmentGroup
ReferenceDocument BillingDocumentRequestItem ReferenceDocument Reference Document
ReferenceDocumentItem BillingDocumentRequestItem ReferenceDocumentItem Reference item
ReferenceDocSDDocCategory BillingDocumentRequestItem ReferenceDocSDDocCategory
SalesDocument BillingDocumentRequestItem SalesDocument SD Document
SalesDocumentItem BillingDocumentRequestItem SalesDocumentItem Sales Document Item
SalesSDDocumentCategory BillingDocumentRequestItem SalesSDDocumentCategory Document Cat.
HigherLevelItem BillingDocumentRequestItem HigherLevelItem Higher-Lev.Item
BillgDocRequestItemInPartSgmt BillingDocumentRequestItem BillgDocRequestItemInPartSgmt
SalesGroup BillingDocumentRequestItem SalesGroup Sales Group
ItemIsRelevantForCredit BillingDocumentRequestItem ItemIsRelevantForCredit
CreditRelatedPrice BillingDocumentRequestItem CreditRelatedPrice
ServiceDocumentType BillingDocumentRequestItem ServiceDocumentType Transaction Type
ServiceDocument BillingDocumentRequestItem ServiceDocument Transaction ID
ServiceDocumentItem BillingDocumentRequestItem ServiceDocumentItem Service Document
BusinessSolutionOrder BillingDocumentRequestItem BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem BillingDocumentRequestItem BusinessSolutionOrderItem Solution Order Item
BillingDocumentRequestType BillingDocumentRequestItem BillingDocumentRequestType
SalesOrganization BillingDocumentRequestItem 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_BillingDocumentRequestItem_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_BillingDocumentRequestItem_2 AS
SELECT
  BillingDocumentRequestItem.BillingDocumentRequest AS BillingDocumentRequest,
  BillingDocumentRequestItem.BillingDocumentRequestItem AS BillingDocumentRequestItem,
  BillingDocumentRequestItem.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  BillingDocumentRequestItem.SalesDocumentItemType AS SalesDocumentItemType,
  BillingDocumentRequestItem.ReturnItemProcessingType AS ReturnItemProcessingType,
  BillingDocumentRequestItem.CreatedByUser AS CreatedByUser,
  BillingDocumentRequestItem.CreationDate AS CreationDate,
  BillingDocumentRequestItem.CreationTime AS CreationTime,
  BillingDocumentRequestItem.ReferenceLogicalSystem AS ReferenceLogicalSystem,
  BillingDocumentRequestItem.OrganizationDivision AS OrganizationDivision,
  BillingDocumentRequestItem.Division AS Division,
  BillingDocumentRequestItem.SalesOffice AS SalesOffice,
  BillingDocumentRequestItem.Product AS Product,
  BillingDocumentRequestItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  BillingDocumentRequestItem.InternationalArticleNumber AS InternationalArticleNumber,
  BillingDocumentRequestItem.PricingReferenceMaterial AS PricingReferenceMaterial,
  BillingDocumentRequestItem.Batch AS Batch,
  BillingDocumentRequestItem.ProductHierarchyNode AS ProductHierarchyNode,
  BillingDocumentRequestItem.ProductGroup AS ProductGroup,
  BillingDocumentRequestItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  BillingDocumentRequestItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  BillingDocumentRequestItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  BillingDocumentRequestItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  BillingDocumentRequestItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  BillingDocumentRequestItem.MaterialCommissionGroup AS MaterialCommissionGroup,
  BillingDocumentRequestItem.Plant AS Plant,
  BillingDocumentRequestItem.StorageLocation AS StorageLocation,
  BillingDocumentRequestItem.BillingDocumentRequestItemText AS BillingDocumentRequestItemText,
  BillingDocumentRequestItem.BillingQuantity AS BillingQuantity,
  BillingDocumentRequestItem.BillingQuantityUnit AS BillingQuantityUnit,
  BillingDocumentRequestItem.BillingQuantityInBaseUnit AS BillingQuantityInBaseUnit,
  BillingDocumentRequestItem.BaseUnit AS BaseUnit,
  BillingDocumentRequestItem.MRPRequiredQuantityInBaseUnit AS MRPRequiredQuantityInBaseUnit,
  BillingDocumentRequestItem.BillingToBaseQuantityDnmntr AS BillingToBaseQuantityDnmntr,
  BillingDocumentRequestItem.BillingToBaseQuantityNmrtr AS BillingToBaseQuantityNmrtr,
  BillingDocumentRequestItem.ItemGrossWeight AS ItemGrossWeight,
  BillingDocumentRequestItem.ItemNetWeight AS ItemNetWeight,
  BillingDocumentRequestItem.ItemWeightUnit AS ItemWeightUnit,
  BillingDocumentRequestItem.ItemVolume AS ItemVolume,
  BillingDocumentRequestItem.ItemVolumeUnit AS ItemVolumeUnit,
  BillingDocumentRequestItem.NetAmount AS NetAmount,
  BillingDocumentRequestItem.TransactionCurrency AS TransactionCurrency,
  BillingDocumentRequestItem.GrossAmount AS GrossAmount,
  BillingDocumentRequestItem.PricingDate AS PricingDate,
  BillingDocumentRequestItem.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  BillingDocumentRequestItem.PricingScaleQuantityInBaseUnit AS PricingScaleQuantityInBaseUnit,
  BillingDocumentRequestItem.TaxAmount AS TaxAmount,
  BillingDocumentRequestItem.CostAmount AS CostAmount,
  BillingDocumentRequestItem.Subtotal1Amount AS Subtotal1Amount,
  BillingDocumentRequestItem.Subtotal2Amount AS Subtotal2Amount,
  BillingDocumentRequestItem.Subtotal3Amount AS Subtotal3Amount,
  BillingDocumentRequestItem.Subtotal4Amount AS Subtotal4Amount,
  BillingDocumentRequestItem.Subtotal5Amount AS Subtotal5Amount,
  BillingDocumentRequestItem.Subtotal6Amount AS Subtotal6Amount,
  BillingDocumentRequestItem.StatisticalValueControl AS StatisticalValueControl,
  BillingDocumentRequestItem.CashDiscountIsDeductible AS CashDiscountIsDeductible,
  BillingDocumentRequestItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
  BillingDocumentRequestItem.DepartureCountry AS DepartureCountry,
  BillingDocumentRequestItem.TaxJurisdiction AS TaxJurisdiction,
  BillingDocumentRequestItem.ProductTaxClassification1 AS ProductTaxClassification1,
  BillingDocumentRequestItem.ProductTaxClassification2 AS ProductTaxClassification2,
  BillingDocumentRequestItem.ProductTaxClassification3 AS ProductTaxClassification3,
  BillingDocumentRequestItem.ProductTaxClassification4 AS ProductTaxClassification4,
  BillingDocumentRequestItem.ProductTaxClassification5 AS ProductTaxClassification5,
  BillingDocumentRequestItem.ProductTaxClassification6 AS ProductTaxClassification6,
  BillingDocumentRequestItem.ProductTaxClassification7 AS ProductTaxClassification7,
  BillingDocumentRequestItem.ProductTaxClassification8 AS ProductTaxClassification8,
  BillingDocumentRequestItem.ProductTaxClassification9 AS ProductTaxClassification9,
  BillingDocumentRequestItem.ZeroVATRsn AS ZeroVATRsn,
  BillingDocumentRequestItem.BillgDocReqBillgSts AS BillgDocReqBillgSts,
  BillingDocumentRequestItem.BusinessArea AS BusinessArea,
  BillingDocumentRequestItem.ProfitCenter AS ProfitCenter,
  BillingDocumentRequestItem.OrderID AS OrderID,
  BillingDocumentRequestItem.WBSElementInternalID AS WBSElementInternalID,
  BillingDocumentRequestItem.ProviderContract AS ProviderContract,
  BillingDocumentRequestItem.ProviderContractItem AS ProviderContractItem,
  BillingDocumentRequestItem.ControllingArea AS ControllingArea,
  BillingDocumentRequestItem.CostCenter AS CostCenter,
  BillingDocumentRequestItem.OriginSDDocument AS OriginSDDocument,
  BillingDocumentRequestItem.OriginSDDocumentItem AS OriginSDDocumentItem,
  BillingDocumentRequestItem.PriceDetnExchangeRateDate AS PriceDetnExchangeRateDate,
  BillingDocumentRequestItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  BillingDocumentRequestItem.ReferenceDocument AS ReferenceDocument,
  BillingDocumentRequestItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  BillingDocumentRequestItem.ReferenceDocSDDocCategory AS ReferenceDocSDDocCategory,
  BillingDocumentRequestItem.SalesDocument AS SalesDocument,
  BillingDocumentRequestItem.SalesDocumentItem AS SalesDocumentItem,
  BillingDocumentRequestItem.SalesSDDocumentCategory AS SalesSDDocumentCategory,
  BillingDocumentRequestItem.HigherLevelItem AS HigherLevelItem,
  BillingDocumentRequestItem.BillgDocRequestItemInPartSgmt AS BillgDocRequestItemInPartSgmt,
  BillingDocumentRequestItem.SalesGroup AS SalesGroup,
  BillingDocumentRequestItem.ItemIsRelevantForCredit AS ItemIsRelevantForCredit,
  BillingDocumentRequestItem.CreditRelatedPrice AS CreditRelatedPrice,
  BillingDocumentRequestItem.ServiceDocumentType AS ServiceDocumentType,
  BillingDocumentRequestItem.ServiceDocument AS ServiceDocument,
  BillingDocumentRequestItem.ServiceDocumentItem AS ServiceDocumentItem,
  BillingDocumentRequestItem.BusinessSolutionOrder AS BusinessSolutionOrder,
  BillingDocumentRequestItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  BillingDocumentRequestItem.BillingDocumentRequestType AS BillingDocumentRequestType,
  BillingDocumentRequestItem.SalesOrganization AS SalesOrganization
FROM R_BillingDocumentRequestItemTP
;

Learn More