A_BR_NFItem

DDL: A_BR_NFITEM SQL: ABRNFITEM Type: view BASIC

Brazil Nota Fiscal Item

A_BR_NFItem is a Basic CDS View that provides data about "Brazil Nota Fiscal Item" in SAP S/4HANA. It reads from 1 data source (I_BR_NFItem) and exposes 154 fields with key fields BR_NotaFiscal, BR_NotaFiscalItem. It has 11 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_BR_NFItem I_BR_NFItem from

Associations (11)

CardinalityTargetAliasCondition
[1..*] A_BR_NFTax _BR_NFTax
[0..*] A_BR_NFAdditionImportDoc _BR_NFAdditionImportDoc
[0..*] A_BR_NFExportDocument _BR_NFExportDocument
[0..*] A_BR_NFItemNVE _BR_NFItemNVE
[0..*] A_BR_NFeProductTraceability _BR_NFeProductTraceability
[0..1] A_BR_NFVehicle _BR_NFVehicle
[0..1] A_BR_NFePharmaceutical _BR_NFePharmaceutical
[0..1] A_BR_NFFuel _BR_NFFuel
[0..*] A_BR_NFItemText _BR_NFItemText
[0..*] A_BR_NFItemAdditionalInfo _BR_NFItemAdditionalInfo
[0..*] A_BR_NFFuelOriginIndicator _BR_NFFuelOriginIndicator

Annotations (18)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName ABRNFITEM view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Brazil Nota Fiscal Item 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_NFItem view
ObjectModel.representativeKey BR_NotaFiscalItem view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled false view

Fields (154)

KeyFieldSource TableSource FieldDescription
KEY BR_NotaFiscal BR_NotaFiscal
KEY BR_NotaFiscalItem BR_NotaFiscalItem
BR_ICMSTaxSituation BR_ICMSTaxSituation
BR_IPITaxSituation BR_IPITaxSituation
BR_ISSTaxSituation BR_ISSTaxSituation
BR_COFINSTaxSituation BR_COFINSTaxSituation
BR_PISTaxSituation BR_PISTaxSituation
BR_ICMSBaseDetn BR_ICMSBaseDetn
BR_ICMSSTBaseDetermination BR_ICMSSTBaseDetermination
BR_ICMSSTLegalClassfctn BR_ICMSSTLegalClassfctn
BR_SubstituteICMSAmount BR_SubstituteICMSAmount
BR_ICMSExemptionReason BR_ICMSExemptionReason
BR_ICMSDefermentAmount BR_ICMSDefermentAmount
BR_ICMSDeferralTaxRate BR_ICMSDeferralTaxRate
BR_WithholdingICMSSTBaseAmount BR_WithholdingICMSSTBaseAmount
BR_WithholdingICMSSTAmount BR_WithholdingICMSSTAmount
BR_IPILegalClassification BR_IPILegalClassification
BR_TobaccoBeverageIPIClassfctn BR_TobaccoBeverageIPIClassfctn
BR_IPIControlSealCode BR_IPIControlSealCode
BR_IPIControlSealQuantityValue BR_IPIControlSealQuantityValue
CostCenter CostCenter
ProfitCenter ProfitCenter
InternalOrder InternalOrder
ProjectNetwork ProjectNetwork
WBSElementInternalID WBSElementInternalID
CostObject CostObject
Segment Segment
BR_NFNetFreightAmount BR_NFNetFreightAmount
BR_NFNetInsuranceAmount BR_NFNetInsuranceAmount
BR_NFNetOtherExpensesAmount BR_NFNetOtherExpensesAmount
NetPriceAmount NetPriceAmount
NetValueAmount NetValueAmount
BR_NFItemType BR_NFItemType
BR_ICMSOrISSIsIncludedInPrice BR_ICMSOrISSIsIncludedInPrice
BR_NFItemIsStatistical BR_NFItemIsStatistical
BR_NFIsServiceItem BR_NFIsServiceItem
Material Material
MaterialName MaterialName
ValuationArea ValuationArea
ValuationType ValuationType
MaterialGroup MaterialGroup
BR_CFOPCategory BR_CFOPCategory
QuantityInBaseUnit QuantityInBaseUnit
BaseUnit BaseUnit
Plant Plant
Batch Batch
BR_NFSourceDocumentType BR_NFSourceDocumentType
BR_NFSourceDocumentNumber BR_NFSourceDocumentNumber
BR_NFSourceDocumentItem BR_NFSourceDocumentItem
BR_ReferenceNFNumber BR_ReferenceNFNumber
BR_ReferenceNFItem BR_ReferenceNFItem
BR_NFPercentReturned BR_NFPercentReturned
BR_NFNetDiscountAmount BR_NFNetDiscountAmount
BR_ExemptedICMSAmount BR_ExemptedICMSAmount
BR_ICMSStatisticalExemptionAmt BR_ICMSStatisticalExemptionAmt
BR_ICMSSTMarginAddedPercent BR_ICMSSTMarginAddedPercent
BR_CPRBIsRelevant BR_CPRBIsRelevant
BR_NFTotalAmount BR_NFTotalAmount
BR_CFOPCode BR_CFOPCode
BR_MaterialOrigin BR_MaterialOrigin
BR_MaterialUsage BR_MaterialUsage
IsProducedInhouse IsProducedInhouse
NCMCode NCMCode
BR_NBSCode BR_NBSCode
BR_EFDREINFServiceCode BR_EFDREINFServiceCode
BR_LC116ServiceCode BR_LC116ServiceCode
BR_ISSBenefitCode BR_ISSBenefitCode
BR_CSTISSCode BR_CSTISSCode
BR_NFApproximateTotalTaxAmount BR_NFApproximateTotalTaxAmount
BR_FCINumber BR_FCINumber
BR_ICMSTaxLaw BR_ICMSTaxLaw
BR_IPITaxLaw BR_IPITaxLaw
BR_ISSTaxLaw BR_ISSTaxLaw
BR_COFINSTaxLaw BR_COFINSTaxLaw
BR_PISTaxLaw BR_PISTaxLaw
GLAccount GLAccount
PurchaseOrder PurchaseOrder
PurchaseOrderItem PurchaseOrderItem
InternationalArticleNumber InternationalArticleNumber
BR_NFExternalItemNumber BR_NFExternalItemNumber
BR_RECOPINumber BR_RECOPINumber
BR_ISSSuspensionProcess BR_ISSSuspensionProcess
BR_NFTributaryQuantity BR_NFTributaryQuantity
BR_NFTributaryUnit BR_NFTributaryUnit
BR_NFIsPhysicalMvtOfMaterial BR_NFIsPhysicalMvtOfMaterial
BR_NFItemHasTaxIncentive BR_NFItemHasTaxIncentive
BR_NFPriceAmountWithTaxes BR_NFPriceAmountWithTaxes
BR_NFValueAmountWithTaxes BR_NFValueAmountWithTaxes
BR_NFDiscountAmountWithTaxes BR_NFDiscountAmountWithTaxes
BR_NFFreightAmountWithTaxes BR_NFFreightAmountWithTaxes
BR_NFInsuranceAmountWithTaxes BR_NFInsuranceAmountWithTaxes
BR_NFExpensesAmountWithTaxes BR_NFExpensesAmountWithTaxes
BR_NFExemptedICMSWithTaxes BR_NFExemptedICMSWithTaxes
BR_NFTotalAmountWithTaxes BR_NFTotalAmountWithTaxes
BR_TaxCode BR_TaxCode
ActivityNumber ActivityNumber
CreditCalculationBaseCode CreditCalculationBaseCode
BR_ReducnPctEffctvCalcBasis BR_ReducnPctEffctvCalcBasis
BR_EffctvCalcBasisAmount BR_EffctvCalcBasisAmount
BR_EffectiveICMSRate BR_EffectiveICMSRate
BR_EffectiveICMSAmount BR_EffectiveICMSAmount
ProductionIsInRelevantScale ProductionIsInRelevantScale
BR_ManufacturerCNPJ BR_ManufacturerCNPJ
TaxIncentiveCode TaxIncentiveCode
BR_ICMSSTDestTaxBaseAmount BR_ICMSSTDestTaxBaseAmount
BR_ICMSSTDestTaxAmount BR_ICMSSTDestTaxAmount
BR_FCPOnICMSSTWithheldBaseAmt BR_FCPOnICMSSTWithheldBaseAmt
BR_FCPonICMSSTWithheldRate BR_FCPonICMSSTWithheldRate
CustomsChargesAmount CustomsChargesAmount
BR_FCPOnICMSSTWithheldAmount BR_FCPOnICMSSTWithheldAmount
BR_IOFTaxAmount BR_IOFTaxAmount
BR_ICMSSTRateIncludingFCP BR_ICMSSTRateIncludingFCP
BR_NFeStatisticalAmount BR_NFeStatisticalAmount
SalesDocumentCurrency SalesDocumentCurrency
BR_NFPartnerCNAE BR_NFPartnerCNAE
BR_BusinessPlaceCNAE BR_BusinessPlaceCNAE
BR_NFFreightNature BR_NFFreightNature
BR_InternalBarcode BR_InternalBarcode
BR_InternalTributaryBarcode BR_InternalTributaryBarcode
BR_NFIsPISSTInTotalAmount BR_PISSTInNFTotal
BR_PISSTInNFTotal BR_PISSTInNFTotal
BR_PISSTTaxAmount BR_PISSTTaxAmount
BR_NFIsCOFINSSTInTotalAmount BR_COFINSSTInNFTotal
BR_COFINSSTInNFTotal BR_COFINSSTInNFTotal
BR_COFINSSTTaxAmount BR_COFINSSTTaxAmount
BR_ICMSDefermentPercent BR_ICMSDefermentPercent
BR_FCPOnICMSDefermentAmount BR_FCPOnICMSDefermentAmount
BR_FCPOnICMSDeferralTaxRate BR_FCPOnICMSDeferralTaxRate
BR_FCPOnICMSDefermentPercent BR_FCPOnICMSDefermentPercent
BR_ExemptedICMSSTAmount BR_ExemptedICMSSTAmount
BR_ICMSSTExemptionReason BR_ICMSSTExemptionReason
BR_ExclICMSAmtFromPISAndCOFINS BR_ExclICMSAmtFromPISAndCOFINS
BR_NFMonoICMSDeferredAmount BR_NFMonoICMSDeferredAmount
BR_NFAdRemICMSRetainedTaxRate BR_NFAdRemICMSRetainedTaxRate
BR_NFMonoICMSRetainedAmount BR_NFMonoICMSRetainedAmount
BR_NFMonoRetainedTaxedQuantity BR_NFMonoRetainedTaxedQuantity
BR_NFAdRemICMSReductionReason BR_NFAdRemICMSReductionReason
BR_NFAdRemICMSReductionRate BR_NFAdRemICMSReductionRate
BR_NFMonoICMSOperationAmount BR_NFMonoICMSOperationAmount
BR_NFAdRemICMSDeferralPercent BR_NFAdRemICMSDeferralPercent
BR_NFMessageText
BR_NFAdditionalProductInfoText
_BR_NFDoc _BR_NFDoc
_BR_NFTax _BR_NFTax
_BR_NFAdditionImportDoc _BR_NFAdditionImportDoc
_BR_NFExportDocument _BR_NFExportDocument
_BR_NFItemNVE _BR_NFItemNVE
_BR_NFeProductTraceability _BR_NFeProductTraceability
_BR_NFVehicle _BR_NFVehicle
_BR_NFePharmaceutical _BR_NFePharmaceutical
_BR_NFFuel _BR_NFFuel
_BR_NFItemText _BR_NFItemText
_BR_NFItemAdditionalInfo _BR_NFItemAdditionalInfo
_BR_NFFuelOriginIndicator _BR_NFFuelOriginIndicator
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'ABRNFITEM'
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Brazil Nota Fiscal Item'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@OData.entitySet.name : 'A_BR_NFItem'
@ObjectModel: {
  representativeKey: 'BR_NotaFiscalItem',
  createEnabled: true,
  updateEnabled: true,
  deleteEnabled: false
}
define view A_BR_NFItem
  as select from I_BR_NFItem
  association to parent A_BR_NFDocument             as _BR_NFDoc on $projection.BR_NotaFiscal = _BR_NFDoc.BR_NotaFiscal
  composition [1..*] of A_BR_NFTax                  as _BR_NFTax
  composition [0..*] of A_BR_NFAdditionImportDoc    as _BR_NFAdditionImportDoc
  composition [0..*] of A_BR_NFExportDocument       as _BR_NFExportDocument
  composition [0..*] of A_BR_NFItemNVE              as _BR_NFItemNVE
  composition [0..*] of A_BR_NFeProductTraceability as _BR_NFeProductTraceability
  composition [0..1] of A_BR_NFVehicle              as _BR_NFVehicle
  composition [0..1] of A_BR_NFePharmaceutical      as _BR_NFePharmaceutical
  composition [0..1] of A_BR_NFFuel                 as _BR_NFFuel
  composition [0..*] of A_BR_NFItemText             as _BR_NFItemText
  composition [0..*] of A_BR_NFItemAdditionalInfo   as _BR_NFItemAdditionalInfo
  composition [0..*] of A_BR_NFFuelOriginIndicator  as _BR_NFFuelOriginIndicator
{
      //I_BR_NFItem

      @ObjectModel.foreignKey.association: '_BR_NFDoc'
  key BR_NotaFiscal,
  key BR_NotaFiscalItem,
      BR_ICMSTaxSituation,
      BR_IPITaxSituation,
      BR_ISSTaxSituation,
      BR_COFINSTaxSituation,
      BR_PISTaxSituation,
      BR_ICMSBaseDetn,
      BR_ICMSSTBaseDetermination,
      BR_ICMSSTLegalClassfctn,
      BR_SubstituteICMSAmount,
      BR_ICMSExemptionReason,
      BR_ICMSDefermentAmount,
      BR_ICMSDeferralTaxRate,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_WithholdingICMSSTBaseAmount,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_WithholdingICMSSTAmount,
      BR_IPILegalClassification,
      BR_TobaccoBeverageIPIClassfctn,
      BR_IPIControlSealCode,
      BR_IPIControlSealQuantityValue,
      CostCenter,
      ProfitCenter,
      InternalOrder,
      ProjectNetwork,
      WBSElementInternalID,
      CostObject,
      Segment,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFNetFreightAmount,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFNetInsuranceAmount,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFNetOtherExpensesAmount,
      NetPriceAmount,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      NetValueAmount,
      BR_NFItemType,
      BR_ICMSOrISSIsIncludedInPrice,
      BR_NFItemIsStatistical,
      BR_NFIsServiceItem,
      Material,
      MaterialName,
      ValuationArea,
      ValuationType,
      MaterialGroup,
      BR_CFOPCategory,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      QuantityInBaseUnit,
      BaseUnit,
      Plant,
      Batch,
      BR_NFSourceDocumentType,
      BR_NFSourceDocumentNumber,
      BR_NFSourceDocumentItem,
      BR_ReferenceNFNumber,
      BR_ReferenceNFItem,
      BR_NFPercentReturned,
      BR_NFNetDiscountAmount,
      BR_ExemptedICMSAmount,
      BR_ICMSStatisticalExemptionAmt,
      BR_ICMSSTMarginAddedPercent,
      BR_CPRBIsRelevant,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFTotalAmount,
      BR_CFOPCode,
      BR_MaterialOrigin,
      BR_MaterialUsage,
      IsProducedInhouse,
      NCMCode,
      BR_NBSCode,
      BR_EFDREINFServiceCode,
      BR_LC116ServiceCode,
      BR_ISSBenefitCode,
      BR_CSTISSCode,
      BR_NFApproximateTotalTaxAmount,
      BR_FCINumber,
      BR_ICMSTaxLaw,
      BR_IPITaxLaw,
      BR_ISSTaxLaw,
      BR_COFINSTaxLaw,
      BR_PISTaxLaw,
      GLAccount,
      PurchaseOrder,
      PurchaseOrderItem,
      InternationalArticleNumber,
      BR_NFExternalItemNumber,
      BR_RECOPINumber,
      BR_ISSSuspensionProcess,
      @Semantics.quantity.unitOfMeasure:'BR_NFTributaryUnit'
      BR_NFTributaryQuantity,
      BR_NFTributaryUnit,
      BR_NFIsPhysicalMvtOfMaterial,
      BR_NFItemHasTaxIncentive,
      BR_NFPriceAmountWithTaxes,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFValueAmountWithTaxes,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFDiscountAmountWithTaxes,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFFreightAmountWithTaxes,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFInsuranceAmountWithTaxes,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFExpensesAmountWithTaxes,
      BR_NFExemptedICMSWithTaxes,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_NFTotalAmountWithTaxes,
      BR_TaxCode,
      ActivityNumber,
      CreditCalculationBaseCode,
      BR_ReducnPctEffctvCalcBasis,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_EffctvCalcBasisAmount,
      BR_EffectiveICMSRate,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_EffectiveICMSAmount,
      ProductionIsInRelevantScale,
      BR_ManufacturerCNPJ,
      TaxIncentiveCode,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_ICMSSTDestTaxBaseAmount,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_ICMSSTDestTaxAmount,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_FCPOnICMSSTWithheldBaseAmt,
      BR_FCPonICMSSTWithheldRate,
      CustomsChargesAmount,
      BR_FCPOnICMSSTWithheldAmount,
      BR_IOFTaxAmount,
      BR_ICMSSTRateIncludingFCP,
      BR_NFeStatisticalAmount,
      SalesDocumentCurrency,
      BR_NFPartnerCNAE,
      BR_BusinessPlaceCNAE,
      BR_NFFreightNature,
      BR_InternalBarcode,         
      BR_InternalTributaryBarcode,
      BR_PISSTInNFTotal as BR_NFIsPISSTInTotalAmount,
      BR_PISSTInNFTotal,  
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_PISSTTaxAmount,    
      BR_COFINSSTInNFTotal as BR_NFIsCOFINSSTInTotalAmount,
      BR_COFINSSTInNFTotal,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      BR_COFINSSTTaxAmount,
      BR_ICMSDefermentPercent,     
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'                             
      @OData.v2.amount.noDecimalShift:true
      BR_FCPOnICMSDefermentAmount, 
      BR_FCPOnICMSDeferralTaxRate, 
      BR_FCPOnICMSDefermentPercent,
      BR_ExemptedICMSSTAmount, 
      BR_ICMSSTExemptionReason,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      @OData.v2.amount.noDecimalShift:true
      BR_ExclICMSAmtFromPISAndCOFINS,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      @OData.v2.amount.noDecimalShift:true
      BR_NFMonoICMSDeferredAmount,
      BR_NFAdRemICMSRetainedTaxRate,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      @OData.v2.amount.noDecimalShift:true
      BR_NFMonoICMSRetainedAmount,
      @Semantics.quantity.unitOfMeasure:'BaseUnit'
      BR_NFMonoRetainedTaxedQuantity,
      BR_NFAdRemICMSReductionReason,
      BR_NFAdRemICMSReductionRate,
      @Semantics.amount.currencyCode:'SalesDocumentCurrency'
      @OData.v2.amount.noDecimalShift:true
      BR_NFMonoICMSOperationAmount,
      BR_NFAdRemICMSDeferralPercent,
      //Texts

      cast('' as abap.sstring(999)) as BR_NFMessageText,
      cast('' as abap.sstring(132)) as BR_NFAdditionalProductInfoText,
      /* Associations */
      @ObjectModel.association.type: [#TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT]
      _BR_NFDoc,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFTax,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFAdditionImportDoc,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFExportDocument,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFItemNVE,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFeProductTraceability,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFVehicle,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFePharmaceutical,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFFuel,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFItemText,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _BR_NFItemAdditionalInfo,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]      
      _BR_NFFuelOriginIndicator
}