A_BR_NFFuel

DDL: A_BR_NFFUEL SQL: ABRNFFUEL Type: view BASIC

Brazil Nota Fiscal Fuel Data

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

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_BR_NFFuel I_BR_NFFuel from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_BR_NFDocument _BR_NFDoc $projection.BR_NotaFiscal = _BR_NFDoc.BR_NotaFiscal

Annotations (18)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ABRNFFUEL view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Brazil Nota Fiscal Fuel Data view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
OData.entitySet.name A_BR_NFFuel view
ObjectModel.representativeKey BR_NotaFiscalItem view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal BR_NotaFiscal
KEY BR_NotaFiscalItem BR_NotaFiscalItem
BR_ANPCode BR_ANPCode
BR_NFRegisterCODIF BR_NFRegisterCODIF
BR_NFeEnvrmtTemperatureFuelQty BR_NFeEnvrmtTemperatureFuelQty
BR_NFeFuelConsumerRegion BR_NFeFuelConsumerRegion
BR_NFPercentageNaturalGasUnit BR_NFPercentageNaturalGasUnit
BR_NFNaturalGasPercent BR_NFNaturalGasPercent
BR_NFFuelCIDETaxBaseQuantity BR_NFFuelCIDETaxBaseQuantity
BR_NFFuelCIDETaxRate BR_NFFuelCIDETaxRate
BR_NFFuelCIDETaxAmount BR_NFFuelCIDETaxAmount
BR_NFeFuelNozzle BR_NFeFuelNozzle
BR_NFeFuelPump BR_NFeFuelPump
BR_NFeFuelTank BR_NFeFuelTank
BR_NFeFuelGaugeStartQuantity BR_NFeFuelGaugeStartQuantity
BR_NFeFuelGaugeEndQuantity BR_NFeFuelGaugeEndQuantity
BR_GLPRatioUnit BR_GLPRatioUnit
BR_GLPRatio BR_GLPRatio
BR_GLGNNRatioUnit BR_GLGNNRatioUnit
BR_GLGNNRatio BR_GLGNNRatio
BR_GLGNIRatioUnit BR_GLGNIRatioUnit
BR_GLGNIRatio BR_GLGNIRatio
BR_GLPNetValueAmount BR_GLPNetValueAmount
BR_NFBiodieselMixingIndexRate BR_NFBiodieselMixingIndexRate
SalesDocumentCurrency SalesDocumentCurrency
BaseUnit BaseUnit
_BR_NFDoc _BR_NFDoc
_BR_NFItem _BR_NFItem 
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ABRNFFUEL'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@EndUserText.label: 'Brazil Nota Fiscal Fuel Data'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_BR_NFFuel'
@ObjectModel: {
  representativeKey: 'BR_NotaFiscalItem',
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: false
}
define view A_BR_NFFuel
  as select from I_BR_NFFuel
  association        to parent A_BR_NFItem as _BR_NFItem on  $projection.BR_NotaFiscal     = _BR_NFItem.BR_NotaFiscal
                                                         and $projection.BR_NotaFiscalItem = _BR_NFItem.BR_NotaFiscalItem
  association [1..1] to A_BR_NFDocument    as _BR_NFDoc  on  $projection.BR_NotaFiscal = _BR_NFDoc.BR_NotaFiscal
{
      //I_BR_NFFuel

      @ObjectModel.foreignKey.association: '_BR_NFDoc'
  key BR_NotaFiscal,
      @ObjectModel.foreignKey.association: '_BR_NFItem'
  key BR_NotaFiscalItem,
      BR_ANPCode,
      BR_NFRegisterCODIF,
      @Semantics.quantity.unitOfMeasure: 'BR_NFPercentageNaturalGasUnit'
      BR_NFeEnvrmtTemperatureFuelQty,
      BR_NFeFuelConsumerRegion,
      @Semantics.unitOfMeasure: true
      BR_NFPercentageNaturalGasUnit,
      BR_NFNaturalGasPercent,
      @Semantics.quantity.unitOfMeasure: 'BR_NFPercentageNaturalGasUnit'
      BR_NFFuelCIDETaxBaseQuantity,
      BR_NFFuelCIDETaxRate,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFFuelCIDETaxAmount,
      BR_NFeFuelNozzle,
      BR_NFeFuelPump,
      BR_NFeFuelTank,
      @Semantics.quantity.unitOfMeasure: 'BR_NFPercentageNaturalGasUnit'
      BR_NFeFuelGaugeStartQuantity,
      @Semantics.quantity.unitOfMeasure: 'BR_NFPercentageNaturalGasUnit'
      BR_NFeFuelGaugeEndQuantity,
      BR_GLPRatioUnit,
      BR_GLPRatio,
      BR_GLGNNRatioUnit,
      BR_GLGNNRatio,
      BR_GLGNIRatioUnit,
      BR_GLGNIRatio,
      BR_GLPNetValueAmount,
      BR_NFBiodieselMixingIndexRate,
      SalesDocumentCurrency,
      BaseUnit,
      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
      _BR_NFDoc,
      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
      _BR_NFItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BR_NFFUEL"
],
"ASSOCIATED":
[
"A_BR_NFDOCUMENT",
"A_BR_NFITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More