I_BR_NFItemFuel_C

DDL: I_BR_NFITEMFUEL_C SQL: IBRNFITEMFUELC Type: view COMPOSITE
27 Fields 1 Data Sources 2 Associations

Brazil Nota Fiscal Fuel

I_BR_NFItemFuel_C is a Composite CDS View that provides data about "Brazil Nota Fiscal Fuel" in SAP S/4HANA. It reads from 1 data source (I_BR_NFFuel) and exposes 27 fields with key fields BR_NotaFiscal, BR_NotaFiscalItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BR_NFFuel NFItemFuel from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_RegionText _BR_Region _BR_Region.Language = $session.system_language and _BR_Region.Country = 'BR' and _BR_Region.Region = NFItemFuel.BR_NFeFuelConsumerRegion
[0..1] I_Currency _SalesDocumentCurrency $projection.SalesDocumentCurrency = _SalesDocumentCurrency.Currency

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IBRNFITEMFUELC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Brazil Nota Fiscal Fuel view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal I_BR_NFFuel BR_NotaFiscal Nota Fiscal
KEY BR_NotaFiscalItem I_BR_NFFuel BR_NotaFiscalItem NF Item Number
BR_ANPCode I_BR_NFFuel BR_ANPCode
BR_NFRegisterCODIF I_BR_NFFuel BR_NFRegisterCODIF
BR_NFeEnvrmtTemperatureFuelQty BR_NFeEnvrmtTemperatureFuelQty
BR_NFeFuelConsumerRegion I_BR_NFFuel BR_NFeFuelConsumerRegion Region
BR_NFeFuelConsumerRegionDesc _BR_Region RegionName Description
BR_NFNaturalGasPercent I_BR_NFFuel BR_NFNaturalGasPercent
BR_NFPercentageNaturalGasUnit I_BR_NFFuel BR_NFPercentageNaturalGasUnit
BR_NFFuelCIDETaxBaseQuantity I_BR_NFFuel BR_NFFuelCIDETaxBaseQuantity
BR_NFFuelCIDETaxRate I_BR_NFFuel BR_NFFuelCIDETaxRate Tax Rate
BR_NFFuelCIDETaxAmount I_BR_NFFuel BR_NFFuelCIDETaxAmount Tax Amount
BR_NFeFuelNozzle I_BR_NFFuel BR_NFeFuelNozzle
BR_NFeFuelPump I_BR_NFFuel BR_NFeFuelPump
BR_NFeFuelTank I_BR_NFFuel BR_NFeFuelTank
BR_NFeFuelGaugeStartQuantity I_BR_NFFuel BR_NFeFuelGaugeStartQuantity
BR_NFeFuelGaugeEndQuantity I_BR_NFFuel BR_NFeFuelGaugeEndQuantity
BR_GLPRatio I_BR_NFFuel BR_GLPRatio
BR_GLPRatioUnit I_BR_NFFuel BR_GLPRatioUnit
BR_GLGNNRatio I_BR_NFFuel BR_GLGNNRatio
BR_GLGNNRatioUnit I_BR_NFFuel BR_GLGNNRatioUnit
BR_GLGNIRatio I_BR_NFFuel BR_GLGNIRatio
BR_GLGNIRatioUnit I_BR_NFFuel BR_GLGNIRatioUnit
BR_GLPNetValueAmount I_BR_NFFuel BR_GLPNetValueAmount
SalesDocumentCurrency I_BR_NFFuel SalesDocumentCurrency Currency
BR_NFBiodieselMixingIndexRate I_BR_NFFuel BR_NFBiodieselMixingIndexRate
_SalesDocumentCurrency _SalesDocumentCurrency

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 I_BR_NFItemFuel_C.
-- 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.
-- SQL view name: IBRNFITEMFUELC

CREATE VIEW I_BR_NFItemFuel_C AS
SELECT
  NFItemFuel.BR_NotaFiscal AS BR_NotaFiscal,
  NFItemFuel.BR_NotaFiscalItem AS BR_NotaFiscalItem,
  NFItemFuel.BR_ANPCode AS BR_ANPCode,
  NFItemFuel.BR_NFRegisterCODIF AS BR_NFRegisterCODIF,
  BR_NFeEnvrmtTemperatureFuelQty,
  NFItemFuel.BR_NFeFuelConsumerRegion AS BR_NFeFuelConsumerRegion,
  _BR_Region.RegionName AS BR_NFeFuelConsumerRegionDesc,
  NFItemFuel.BR_NFNaturalGasPercent AS BR_NFNaturalGasPercent,
  NFItemFuel.BR_NFPercentageNaturalGasUnit AS BR_NFPercentageNaturalGasUnit,
  NFItemFuel.BR_NFFuelCIDETaxBaseQuantity AS BR_NFFuelCIDETaxBaseQuantity,
  NFItemFuel.BR_NFFuelCIDETaxRate AS BR_NFFuelCIDETaxRate,
  NFItemFuel.BR_NFFuelCIDETaxAmount AS BR_NFFuelCIDETaxAmount,
  NFItemFuel.BR_NFeFuelNozzle AS BR_NFeFuelNozzle,
  NFItemFuel.BR_NFeFuelPump AS BR_NFeFuelPump,
  NFItemFuel.BR_NFeFuelTank AS BR_NFeFuelTank,
  NFItemFuel.BR_NFeFuelGaugeStartQuantity AS BR_NFeFuelGaugeStartQuantity,
  NFItemFuel.BR_NFeFuelGaugeEndQuantity AS BR_NFeFuelGaugeEndQuantity,
  NFItemFuel.BR_GLPRatio AS BR_GLPRatio,
  NFItemFuel.BR_GLPRatioUnit AS BR_GLPRatioUnit,
  NFItemFuel.BR_GLGNNRatio AS BR_GLGNNRatio,
  NFItemFuel.BR_GLGNNRatioUnit AS BR_GLGNNRatioUnit,
  NFItemFuel.BR_GLGNIRatio AS BR_GLGNIRatio,
  NFItemFuel.BR_GLGNIRatioUnit AS BR_GLGNIRatioUnit,
  NFItemFuel.BR_GLPNetValueAmount AS BR_GLPNetValueAmount,
  NFItemFuel.SalesDocumentCurrency AS SalesDocumentCurrency,
  NFItemFuel.BR_NFBiodieselMixingIndexRate AS BR_NFBiodieselMixingIndexRate
FROM I_BR_NFFuel AS NFItemFuel
LEFT OUTER JOIN I_RegionText AS _BR_Region ON _BR_Region.Language = $session.system_language AND _BR_Region.Country = 'BR' AND _BR_Region.Region = NFItemFuel.BR_NFeFuelConsumerRegion  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _SalesDocumentCurrency ON SalesDocumentCurrency = _SalesDocumentCurrency.Currency  -- association [0..1]
;

Learn More