A_BR_NFItem

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_BR_NFItem.
-- 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: ABRNFITEM

CREATE VIEW A_BR_NFItem AS
SELECT
  BR_NotaFiscal,
  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,
  BR_WithholdingICMSSTBaseAmount,
  BR_WithholdingICMSSTAmount,
  BR_IPILegalClassification,
  BR_TobaccoBeverageIPIClassfctn,
  BR_IPIControlSealCode,
  BR_IPIControlSealQuantityValue,
  CostCenter,
  ProfitCenter,
  InternalOrder,
  ProjectNetwork,
  WBSElementInternalID,
  CostObject,
  Segment,
  BR_NFNetFreightAmount,
  BR_NFNetInsuranceAmount,
  BR_NFNetOtherExpensesAmount,
  NetPriceAmount,
  NetValueAmount,
  BR_NFItemType,
  BR_ICMSOrISSIsIncludedInPrice,
  BR_NFItemIsStatistical,
  BR_NFIsServiceItem,
  Material,
  MaterialName,
  ValuationArea,
  ValuationType,
  MaterialGroup,
  BR_CFOPCategory,
  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,
  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,
  BR_NFTributaryQuantity,
  BR_NFTributaryUnit,
  BR_NFIsPhysicalMvtOfMaterial,
  BR_NFItemHasTaxIncentive,
  BR_NFPriceAmountWithTaxes,
  BR_NFValueAmountWithTaxes,
  BR_NFDiscountAmountWithTaxes,
  BR_NFFreightAmountWithTaxes,
  BR_NFInsuranceAmountWithTaxes,
  BR_NFExpensesAmountWithTaxes,
  BR_NFExemptedICMSWithTaxes,
  BR_NFTotalAmountWithTaxes,
  BR_TaxCode,
  ActivityNumber,
  CreditCalculationBaseCode,
  BR_ReducnPctEffctvCalcBasis,
  BR_EffctvCalcBasisAmount,
  BR_EffectiveICMSRate,
  BR_EffectiveICMSAmount,
  ProductionIsInRelevantScale,
  BR_ManufacturerCNPJ,
  TaxIncentiveCode,
  BR_ICMSSTDestTaxBaseAmount,
  BR_ICMSSTDestTaxAmount,
  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,
  BR_PISSTTaxAmount,
  BR_COFINSSTInNFTotal AS BR_NFIsCOFINSSTInTotalAmount,
  BR_COFINSSTInNFTotal,
  BR_COFINSSTTaxAmount,
  BR_ICMSDefermentPercent,
  BR_FCPOnICMSDefermentAmount,
  BR_FCPOnICMSDeferralTaxRate,
  BR_FCPOnICMSDefermentPercent,
  BR_ExemptedICMSSTAmount,
  BR_ICMSSTExemptionReason,
  BR_ExclICMSAmtFromPISAndCOFINS,
  BR_NFMonoICMSDeferredAmount,
  BR_NFAdRemICMSRetainedTaxRate,
  BR_NFMonoICMSRetainedAmount,
  BR_NFMonoRetainedTaxedQuantity,
  BR_NFAdRemICMSReductionReason,
  BR_NFAdRemICMSReductionRate,
  BR_NFMonoICMSOperationAmount,
  BR_NFAdRemICMSDeferralPercent,
  BR_IBSAndCBSTaxSituationCode,
  BR_IBSAndCBSTaxClfnCode,
  BR_StateIBSRate,
  BR_StateIBSDeferralPercent,
  BR_StateIBSDeferralAmount,
  BR_StateIBSTaxRefundAmount,
  BR_StateIBSRateReducnPercent,
  BR_MunicipalIBSRate,
  BR_MncplIBSDeferralPercent,
  BR_MncplIBSDeferralAmount,
  BR_MncplIBSTaxRefundAmount,
  BR_MncplIBSRateReducnPercent,
  BR_CBSRate,
  BR_CBSDeferralPercent,
  BR_CBSDeferralAmount,
  BR_CBSTaxRefundAmount,
  BR_CBSRateReducnPercent,
  BR_IBSAndCBSRegularIntSitnCode,
  BR_IBSAndCBSRegularTaxSitnCode,
  BR_IBSAndCBSRegularTaxClfnCode,
  BR_StateIBSEffectiveRate,
  BR_StateIBSAmount,
  BR_MunicipalIBSEffectiveRate,
  BR_MunicipalIBSAmount,
  BR_CBSEffectiveRate,
  BR_CBSAmount,
  BR_IBSPresumedCreditClfnCode,
  BR_IBSPresumedCreditPercent,
  BR_IBSPresumedCreditAmount,
  BR_IBSPrsmdCrdtSuspCndnAmount,
  BR_CBSPresumedCrdtClfnCode,
  BR_CBSPresumedCreditPercent,
  BR_CBSPresumedCreditAmount,
  BR_CBSPrsmdCrdtSuspCndnAmount,
  BR_ReferencedDFeAccessKey,
  BR_ReferencedDFeItemNumber,
  BR_UsedMovableAsset,
  BR_GvmntProcmtStateIBSRate,
  BR_GvmntProcmtStateIBSFullAmt,
  BR_GvmntProcmtMncplIBSRate,
  BR_GvmntProcmtMncplIBSFullAmt,
  BR_GvmntProcmtCBSRate,
  BR_GvmntProcmtCBSFullAmount,
  BR_CreditTransferIBSAmount,
  BR_CreditTransferCBSAmount,
  BR_FreeTxZoneIBSPrsmdCrdtClfn,
  BR_FreeTxZoneIBSPrsmdCrdtAmt,
  cast('' as abap.sstring(999)) AS BR_NFMessageText,
  cast('' as abap.sstring(132)) AS BR_NFAdditionalProductInfoText
FROM I_BR_NFItem
LEFT OUTER JOIN A_BR_NFTax AS _BR_NFTax ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN A_BR_NFAdditionImportDoc AS _BR_NFAdditionImportDoc ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFExportDocument AS _BR_NFExportDocument ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFItemNVE AS _BR_NFItemNVE ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFeProductTraceability AS _BR_NFeProductTraceability ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFVehicle AS _BR_NFVehicle ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN A_BR_NFePharmaceutical AS _BR_NFePharmaceutical ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN A_BR_NFFuel AS _BR_NFFuel ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN A_BR_NFItemText AS _BR_NFItemText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFItemAdditionalInfo AS _BR_NFItemAdditionalInfo ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFFuelOriginIndicator AS _BR_NFFuelOriginIndicator ON /* condition not available in parsed metadata */  -- association [0..*]
;