I_BR_NFItem_C

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_NFItem_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: IBRNFITEMC

CREATE VIEW I_BR_NFItem_C AS
SELECT
  NFBrief.BR_NotaFiscal AS BR_NotaFiscal,
  NFBrief.BR_NotaFiscalItem AS BR_NotaFiscalItem,
  case NFBrief.MaterialName when '' then NFBrief.Material else concat_with_space(concat_with_space( NFBrief.MaterialName, '-', 1), NFBrief.Material, 1) end as BR_NFItemTitle AS Material1endasBR_NFItemTitle,
  cast(concat_with_space(concat_with_space(NFBrief.BR_NFItemType, '-', 1), NFBrief.BR_NFItemTypeDesc, 1) as logbr_nfitemtype preserving type ) AS BR_NFItemTypeFrmtdDesc,
  NFBrief.Plant AS Plant,
  _BR_Plant.BR_PlantNameFrmtdDesc AS BR_PlantNameFrmtdDesc,
  NFBrief.Batch AS Batch,
  NFBrief.MaterialGroup AS MaterialGroup,
  NFBrief.QuantityInBaseUnit AS QuantityInBaseUnit,
  NFBrief.BaseUnit AS BaseUnit,
  NFBrief.BR_NFPercentReturned AS BR_NFPercentReturned,
  NFBrief.ValuationType AS ValuationType,
  NFBrief.BR_NFItemIsStatistical AS BR_NFItemIsStatistical,
  NFBrief.BR_NFIsServiceItem AS BR_NFIsServiceItem,
  NFBrief.Material AS Material,
  NFBrief.MaterialName AS MaterialName,
  cast(NFBrief.NCMCode as logbr_nfncmcode preserving type) AS NCMFrmtdCode,
  cast(concat(NFBrief.BR_MaterialOrigin, NFBrief.BR_ICMSTaxSituation) as logbr_nfcstcode) AS BR_CSTFrmtdCode,
  cast(NFBrief.BR_CFOPFrmtdCode as logbr_nfcfop ) AS BR_CFOPFrmtdCode,
  cast(NFBrief.BR_NFPriceAmountWithTaxes as logbr_nfunitprice preserving type) AS BR_NFItemUnitPriceAmount,
  cast(_ICMSValues.BR_NFItemBaseAmount as logbr_nficmsbaseamount preserving type) AS BR_ICMSBaseAmount,
  cast(_ICMSValues.BR_NFItemTaxAmount as logbr_nficmsamount preserving type) AS BR_ICMSTaxAmount,
  cast(_IPIValues.BR_NFItemTaxAmount as logbr_nfipiamount preserving type) AS BR_IPITaxAmount,
  cast(_ICMSValues.BR_NFItemTaxRate as logbr_nficmstaxrate) AS BR_ICMSTaxRate,
  cast(_IPIValues.BR_NFItemTaxRate as logbr_nfipitaxrate) AS BR_IPITaxRate,
  cast(NFBrief.NetPriceAmount as logbr_unitprice) AS NetPriceAmount,
  cast(NFBrief.NetValueAmount as logbr_totalvalue) AS NetValueAmount,
  cast(NFBrief.BR_NFNetDiscountAmount as logbr_taxdiscount) AS BR_NFNetDiscountAmount,
  cast(NFBrief.BR_ExemptedICMSAmount as logbr_nfe_vicmsdeson preserving type) AS BR_ExemptedICMSAmount2Dcmls,
  cast(NFBrief.BR_ICMSStatisticalExemptionAmt as logbr_ststcl_vicmsdeson preserving type) AS BR_ICMSStatisticalExemptionAmt,
  cast(NFBrief.BR_NFNetFreightAmount as logbr_taxfreight) AS BR_NFNetFreightAmount,
  cast(NFBrief.BR_NFNetInsuranceAmount as logbr_taxinsurance) AS BR_NFNetInsuranceAmount,
  cast(NFBrief.BR_NFNetOtherExpensesAmount as logbr_taxexpenses) AS BR_NFNetOtherExpensesAmount,
  cast(NFBrief.BR_NFTotalAmount as logbr_taxtotal) AS BR_NFTotalAmount,
  cast(NFBrief.BR_NFPriceAmountWithTaxes as logbr_unitprice preserving type) AS BR_NFPriceAmountWithTaxes,
  cast(NFBrief.BR_NFValueAmountWithTaxes as logbr_totalvalue preserving type) AS BR_NFValueAmountWithTaxes,
  cast(NFBrief.BR_NFDiscountAmountWithTaxes as logbr_taxdiscount) AS BR_NFDiscountAmountWithTaxes,
  cast(NFBrief.BR_NFExemptedICMSWithTaxes as logbr_nfe_vicmsdeson preserving type) AS BR_NFExemptedICMSWithTaxes,
  cast(NFBrief.BR_NFFreightAmountWithTaxes as logbr_taxfreight) AS BR_NFFreightAmountWithTaxes,
  cast(NFBrief.BR_NFInsuranceAmountWithTaxes as logbr_taxinsurance) AS BR_NFInsuranceAmountWithTaxes,
  cast(NFBrief.BR_NFExpensesAmountWithTaxes as logbr_taxexpenses) AS BR_NFExpensesAmountWithTaxes,
  NFBrief.BR_PISSTTaxIncludedTaxAmount AS BR_PISSTTaxIncludedTaxAmount,
  NFBrief.BR_COFINSSTTxIncludedTaxAmount AS BR_COFINSSTTxIncludedTaxAmount,
  cast(NFBrief.BR_NFTotalAmountWithTaxes as logbr_taxtotal) AS BR_NFTotalAmountWithTaxes,
  cast(concat_with_space(concat_with_space(NFBrief.BR_CFOPFrmtdCode, '-', 1), NFBrief.BR_CFOPDesc, 1) as logbr_nfcfop) AS BR_CFOPFrmtdDesc,
  NFBrief.BR_MaterialOrigin AS BR_MaterialOrigin,
  NFBrief.BR_MaterialUsage AS BR_MaterialUsage,
  NFBrief.IsProducedInhouse AS IsProducedInhouse,
  cast(concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat_with_space(concat_with_space( NFBrief.NCMCode, '-', 1), NFBrief.NCMDesc1, 1), NFBrief.NCMDesc2, 1), NFBrief.NCMDesc3, 1), NFBrief.NCMDesc4, 1), NFBrief.NCMDesc5, 1) as logbr_nfncm) as BR_NCMDesc AS NCMDesc51aslogbr_nfncmasBR_NCMDesc,
  NFBrief.BR_NFApproximateTotalTaxAmount AS BR_NFApproximateTotalTaxAmount,
  NFBrief.BR_FCINumber AS BR_FCINumber,
  NFBrief.TaxIncentiveCode AS TaxIncentiveCode,
  BR_CSTISSCode,
  BR_ISSBenefitCode,
  NFBrief.GLAccount AS GLAccount,
  NFBrief.InternationalArticleNumber AS InternationalArticleNumber,
  NFBrief.BR_RECOPINumber AS BR_RECOPINumber,
  NFBrief.BR_ISSSuspensionProcess AS BR_ISSSuspensionProcess,
  NFBrief.BR_NFeStatisticalAmount AS BR_NFeStatisticalAmount,
  NFBrief.BR_NFPartnerCNAE AS BR_NFPartnerCNAE,
  NFBrief.BR_BusinessPlaceCNAE AS BR_BusinessPlaceCNAE,
  NFBrief.BR_InternalBarcode AS BR_InternalBarcode,
  NFBrief.BR_InternalTributaryBarcode AS BR_InternalTributaryBarcode,
  NFBrief.BR_FsclBnftCodeTxBaseReduction AS BR_FsclBnftCodeTxBaseReduction,
  NFBrief.BR_NFTributaryQuantity AS BR_NFTributaryQuantity,
  NFBrief.BR_NFTributaryUnit AS BR_NFTributaryUnit,
  NFBrief.PurchaseOrder AS PurchaseOrder,
  NFBrief.PurchaseOrderItem AS PurchaseOrderItem,
  NFBrief.BR_NFExternalItemNumber AS BR_NFExternalItemNumber,
  NFBrief.BR_NFFreightNature AS BR_NFFreightNature,
  NFBrief.BR_ManufacturerCNPJ AS BR_ManufacturerCNPJ,
  NFBrief.BR_ManufacturerCNPJ_2 AS BR_ManufacturerCNPJ_2,
  _NFItemTax.BR_ICMSTaxSituation AS BR_ICMSTaxSituation,
  _NFItemTax.BR_ICMSBaseDetn AS BR_ICMSBaseDetn,
  _NFItemTax.BR_ICMSSTBaseDetermination AS BR_ICMSSTBaseDetermination,
  _NFItemTax.BR_ICMSSTMarginAddedPercent AS BR_ICMSSTMarginAddedPercent,
  _NFItemTax.BR_ICMSExemptionReason AS BR_ICMSExemptionReason,
  NFBrief.BR_ExemptedICMSSTAmount AS BR_ExemptedICMSSTAmount,
  NFBrief.BR_ICMSSTExemptionReason AS BR_ICMSSTExemptionReason,
  _NFItemTax.BR_WithholdingICMSSTBaseAmount AS BR_WithholdingICMSSTBaseAmount,
  _NFItemTax.BR_WithholdingICMSSTAmount AS BR_WithholdingICMSSTAmount,
  _NFItemTax.BR_FCPOnICMSSTWithheldBaseAmt AS BR_FCPOnICMSSTWithheldBaseAmt,
  _NFItemTax.BR_FCPonICMSSTWithheldRate AS BR_FCPonICMSSTWithheldRate,
  _NFItemTax.BR_FCPOnICMSSTWithheldAmount AS BR_FCPOnICMSSTWithheldAmount,
  _NFItemTax.BR_SubstituteICMSAmount AS BR_SubstituteICMSAmount,
  _NFItemTax.BR_ICMSSTRateIncludingFCP AS BR_ICMSSTRateIncludingFCP,
  _NFItemTax.BR_EffctvCalcBasisAmount AS BR_EffctvCalcBasisAmount,
  _NFItemTax.BR_ReducnPctEffctvCalcBasis AS BR_ReducnPctEffctvCalcBasis,
  _NFItemTax.BR_EffectiveICMSAmount AS BR_EffectiveICMSAmount,
  _NFItemTax.BR_EffectiveICMSRate AS BR_EffectiveICMSRate,
  _NFItemTax.BR_ICMSSTDestTaxBaseAmount AS BR_ICMSSTDestTaxBaseAmount,
  _NFItemTax.BR_ICMSSTDestTaxAmount AS BR_ICMSSTDestTaxAmount,
  NFBrief.BR_NFAdRemICMSReductionReason AS BR_NFAdRemICMSReductionReason,
  NFBrief.BR_NFAdRemICMSReductionRate AS BR_NFAdRemICMSReductionRate,
  _NFItemTax.BR_ICMSDefermentAmount AS BR_ICMSDefermentAmount,
  _NFItemTax.BR_ICMSDeferralTaxRate AS BR_ICMSDeferralTaxRate,
  NFBrief.BR_ICMSDefermentPercent AS BR_ICMSDefermentPercent,
  NFBrief.BR_FCPOnICMSDefermentAmount AS BR_FCPOnICMSDefermentAmount,
  NFBrief.BR_FCPOnICMSDeferralTaxRate AS BR_FCPOnICMSDeferralTaxRate,
  NFBrief.BR_FCPOnICMSDefermentPercent AS BR_FCPOnICMSDefermentPercent,
  NFBrief.BR_NFMonoICMSOperationAmount AS BR_NFMonoICMSOperationAmount,
  NFBrief.BR_NFAdRemICMSDeferralPercent AS BR_NFAdRemICMSDeferralPercent,
  NFBrief.BR_NFMonoICMSDeferredAmount AS BR_NFMonoICMSDeferredAmount,
  NFBrief.BR_NFAdRemICMSRetainedTaxRate AS BR_NFAdRemICMSRetainedTaxRate,
  NFBrief.BR_NFMonoICMSRetainedAmount AS BR_NFMonoICMSRetainedAmount,
  NFBrief.BR_NFMonoRetainedTaxedQuantity AS BR_NFMonoRetainedTaxedQuantity,
  NFBrief.BR_PISSTInNFTotal AS BR_PISSTInNFTotal,
  NFBrief.BR_PISSTTaxAmount AS BR_PISSTTaxAmount,
  NFBrief.BR_COFINSSTInNFTotal AS BR_COFINSSTInNFTotal,
  NFBrief.BR_COFINSSTTaxAmount AS BR_COFINSSTTaxAmount,
  NFBrief.BR_ExclICMSAmtFromPISAndCOFINS AS BR_ExclICMSAmtFromPISAndCOFINS,
  _NFItemTax.BR_TobaccoBeverageIPIClassfctn AS BR_TobaccoBeverageIPIClassfctn,
  _NFItemTax.BR_IPIControlSealCode AS BR_IPIControlSealCode,
  _NFItemTax.BR_IPIControlSealQuantityValue AS BR_IPIControlSealQuantityValue,
  _NFItemTax.BR_IOFTaxAmount AS BR_IOFTaxAmount,
  _NFItemTax.CustomsChargesAmount AS CustomsChargesAmount,
  _NFItemFuel.BR_ANPCode AS BR_ANPCode,
  _NFItemFuel.BR_NFRegisterCODIF AS BR_NFRegisterCODIF,
  _NFItemFuel.BR_NFeEnvrmtTemperatureFuelQty AS BR_NFeEnvrmtTemperatureFuelQty,
  _NFItemFuel.BR_NFNaturalGasPercent AS BR_NFNaturalGasPercent,
  _NFItemFuel.BR_NFPercentageNaturalGasUnit AS BR_NFPercentageNaturalGasUnit,
  _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.BR_NFBiodieselMixingIndexRate AS BR_NFBiodieselMixingIndexRate,
  _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,
  _NFItemVehicle.VehicleModel AS VehicleModel,
  _NFItemVehicle.VehicleYearOfManufacture AS VehicleYearOfManufacture,
  _NFItemVehicle.VehicleModelYear AS VehicleModelYear,
  _NFItemVehicle.VehicleFuelType AS VehicleFuelType,
  _NFItemVehicle.VehicleEnginePower AS VehicleEnginePower,
  _NFItemVehicle.VehicleCylinderCapacityValue AS VehicleCylinderCapacityValue,
  _NFItemVehicle.VehicleEngineNumber AS VehicleEngineNumber,
  _NFItemVehicle.VehicleCarMakerColor AS VehicleCarMakerColor,
  _NFItemVehicle.VehiclePaintingType AS VehiclePaintingType,
  _NFItemVehicle.VehicleColorDesc AS VehicleColorDesc,
  _NFItemVehicle.VehicleChassis AS VehicleChassis,
  _NFItemVehicle.VehicleSerialNumber AS VehicleSerialNumber,
  _NFItemVehicle.VehicleType AS NFVehicleType,
  _NFItemVehicle.VehicleNetWeight AS VehicleNetWeight,
  _NFItemVehicle.VehicleNetWeightUnit AS VehicleNetWeightUnit,
  _NFItemVehicle.VehicleGrossWeight AS VehicleGrossWeight,
  _NFItemVehicle.VehicleGrossWeightUnit AS VehicleGrossWeightUnit,
  _NFItemVehicle.VehicleMaximumCapacityValue AS VehicleMaximumCapacityValue,
  _NFItemVehicle.VehicleMaxTractionCapacity AS VehicleMaxTractionCapacity,
  _NFItemVehicle.DistanceBetweenAxlesQtyValue AS DistanceBetweenAxlesQtyValue,
  _NFItemVehicle.VehicleUsage AS VehicleUsage,
  _NFItemVehicle.VehicleCondition AS VehicleCondition,
  _NFItemVehicle.VehicleRestriction AS VehicleRestriction,
  _NFItemVehicle.VehicleOperationType AS VehicleOperationType,
  _BR_NFePharma.BR_ANVISACode AS BR_ANVISACode,
  _BR_NFePharma.BR_ANVISAExemptionReasonText AS BR_ANVISAExemptionReasonText,
  _BR_NFePharma.MedicineConsumerMaxPrice AS MedicineConsumerMaxPrice,
  _NFItemExportSqncNumber.BR_NFItemExprtSqncNumber AS BR_NFItemExprtSqncNumber,
  _NFElectronic.BR_NFeXMLVersion AS BR_NFeXMLVersion,
  _NFElectronic.BR_NFeModel AS BR_NFeModel,
  _BR_NFDocumentFlow.OriginReferenceDocument AS OriginReferenceDocument,
  _BR_NFDocumentFlow.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  _BR_NFDocumentFlow.PredecessorReferenceDocument AS PredecessorReferenceDocument,
  _BR_NFDocumentFlow.PredecessorReferenceDocItem AS PredecessorReferenceDocItem,
  _BR_NFDocumentFlow.ReferenceDocument AS ReferenceDocument,
  _BR_NFDocumentFlow.ReferenceDocumentItem AS ReferenceDocumentItem,
  NFBrief.BR_NBSCode AS BR_NBSCode,
  NFBrief.BR_EFDREINFServiceCode AS BR_EFDREINFServiceCode,
  NFBrief.BR_LC116ServiceCode AS BR_LC116ServiceCode,
  _NFItemTax.SalesDocumentCurrency AS SalesDocumentCurrency,
  _NFItemTax._BR_ICMSBaseDetn AS _BR_ICMSBaseDetn,
  _NFItemTax._BR_ICMSExemptionReason AS _BR_ICMSExemptionReason,
  _NFItemTax._BR_ICMSSTBaseDetn AS _BR_ICMSSTBaseDetn,
  _NFItemTax._BR_ICMSTaxSituation AS _BR_ICMSTaxSituation,
  _NFItemVehicle._BR_VehicleCondition AS _BR_VehicleCondition,
  _NFItemVehicle._BR_VehicleFuelType_2 AS _BR_VehicleFuelType_2,
  _NFItemVehicle._BR_VehicleOperationType AS _BR_VehicleOperationType,
  _NFItemVehicle._BR_VehicleRestriction AS _BR_VehicleRestriction,
  _NFItemVehicle._BR_VehicleUsage_2 AS _BR_VehicleUsage_2,
  _NFItemVehicle._BR_VehicleType_2 AS _BR_VehicleType_2
LEFT OUTER JOIN I_BR_NFItemNVE AS _NFItemNVE ON _NFItemNVE.BR_NotaFiscal = BR_NotaFiscal AND _NFItemNVE.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_BR_NFItemTaxByItem_C AS _NFTaxByItem ON _NFTaxByItem.BR_NotaFiscal = BR_NotaFiscal AND _NFTaxByItem.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_BR_NFItemMessage_C AS _NFItemMessages ON _NFItemMessages.BR_NotaFiscal = BR_NotaFiscal AND _NFItemMessages.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_BR_NFItemPharmaceutical_C AS _NFItemPharma ON _NFItemPharma.BR_NotaFiscal = BR_NotaFiscal AND _NFItemPharma.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_BR_NFePharmaceutical AS _BR_NFePharma ON _BR_NFePharma.BR_NotaFiscal = BR_NotaFiscal AND _BR_NFePharma.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..1]
LEFT OUTER JOIN I_BR_NFItemExportDocument_C AS _NFItemExport ON _NFItemExport.BR_NotaFiscal = BR_NotaFiscal AND _NFItemExport.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_BR_NFItemExportDocument_C AS _NFItemExportSqncNumber ON _NFItemExportSqncNumber.BR_NotaFiscal = BR_NotaFiscal AND _NFItemExportSqncNumber.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..1]
LEFT OUTER JOIN I_BR_NFItemTax_C AS _NFItemTax ON _NFItemTax.BR_NotaFiscal = BR_NotaFiscal AND _NFItemTax.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItemFuel_C AS _NFItemFuel ON _NFItemFuel.BR_NotaFiscal = BR_NotaFiscal AND _NFItemFuel.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItemVehicle_C AS _NFItemVehicle ON _NFItemVehicle.BR_NotaFiscal = BR_NotaFiscal AND _NFItemVehicle.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItemCostInformation_C AS _NFItemCostInfo ON _NFItemCostInfo.BR_NotaFiscal = BR_NotaFiscal AND _NFItemCostInfo.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItemTaxByItem_C AS _ICMSValues ON _ICMSValues.BR_NotaFiscal = BR_NotaFiscal AND _ICMSValues.BR_NotaFiscalItem = BR_NotaFiscalItem AND _ICMSValues.TaxGroup = 'ICMS' AND _ICMSValues.BR_ICMSPartilhaSubdivisionCode = ''  -- association [0..1]
LEFT OUTER JOIN I_BR_NFItemTaxByItem_C AS _IPIValues ON _IPIValues.BR_NotaFiscal = BR_NotaFiscal AND _IPIValues.BR_NotaFiscalItem = BR_NotaFiscalItem AND _IPIValues.TaxGroup = 'IPI'  -- association [0..1]
LEFT OUTER JOIN I_BR_OrderText AS _NetworkText ON _NetworkText.InternalOrder = NFBrief.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_BR_Plant_C AS _BR_Plant ON _BR_Plant.Plant = NFBrief.Plant  -- association [1..1]
LEFT OUTER JOIN I_BR_NFElectronic_C AS _NFElectronic ON _NFElectronic.BR_NotaFiscal = BR_NotaFiscal  -- association [0..1]
LEFT OUTER JOIN I_BR_NFeProductTraceability AS _BR_NFTrace ON _BR_NFTrace.BR_NotaFiscal = BR_NotaFiscal AND _BR_NFTrace.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_DataElementLabelText AS _BR_NotaFiscal ON _BR_NotaFiscal.ABAPDataElement = 'LOGBR_DOCNUM' AND _BR_NotaFiscal.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DataElementLabelText AS _BR_NotaFiscalItem ON _BR_NotaFiscalItem.ABAPDataElement = 'LOGBR_ITEM' AND _BR_NotaFiscalItem.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BR_NFDocumentFlow_C AS _BR_NFDocumentFlow ON _BR_NFDocumentFlow.BR_NotaFiscal = BR_NotaFiscal AND _BR_NFDocumentFlow.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..1]
LEFT OUTER JOIN I_BR_NBSCode AS _BR_NBSCode ON _BR_NBSCode.BR_NBSCode = NFBrief.BR_NBSCode  -- association [0..1]
LEFT OUTER JOIN I_BR_REINFServiceCode AS _BR_REINFServiceCode ON _BR_REINFServiceCode.BR_EFDREINFServiceCode = NFBrief.BR_EFDREINFServiceCode  -- association [0..1]
LEFT OUTER JOIN I_BR_LC116ServiceCode AS _BR_LC116ServiceCode ON _BR_LC116ServiceCode.BR_LC116ServiceCode = NFBrief.BR_LC116ServiceCode  -- association [0..1]
LEFT OUTER JOIN I_BR_ISSBenefitCode AS _BR_ISSBenefitCode ON _BR_ISSBenefitCode.BR_ISSBenefitCode = NFBrief.BR_ISSBenefitCode  -- association [0..1]
LEFT OUTER JOIN I_BR_CSTMunicipalISSCode AS _BR_CSTMunicipalISSCode ON _BR_CSTMunicipalISSCode.BR_CSTISSCode = NFBrief.BR_CSTISSCode  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SalesDocumentCurrency ON SalesDocumentCurrency = _SalesDocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_BR_NFItemAdditionalInfoCube AS _BR_NFItemAdditionalInfoCube ON BR_NotaFiscal = _BR_NFItemAdditionalInfoCube.BR_NotaFiscal AND BR_NotaFiscalItem = _BR_NFItemAdditionalInfoCube.BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_BR_NFFuelOriginIndicatorCube AS _BR_NFFuelOriginIndicatorCube ON BR_NotaFiscal = _BR_NFFuelOriginIndicatorCube.BR_NotaFiscal AND BR_NotaFiscalItem = _BR_NFFuelOriginIndicatorCube.BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN I_BR_NFPresumedCreditCube AS _BR_NFPresumedCreditCube ON _BR_NFPresumedCreditCube.BR_NotaFiscal = BR_NotaFiscal AND _BR_NFPresumedCreditCube.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..*]
LEFT OUTER JOIN E_BR_NotaFiscalItem AS _ExtensionItem ON BR_NotaFiscal = _ExtensionItem.BR_NotaFiscal AND _ExtensionItem.BR_NotaFiscalItem = BR_NotaFiscalItem  -- association [0..1]
;