I_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 I_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: IBRNFITEM

CREATE VIEW I_BR_NFItem AS
SELECT
  cast(NFItem.taxsi2 as logbr_taxsi2 preserving type) AS BR_IPITaxSituation,
  cast(NFItem.taxsi3 as logbr_isstaxsituation) AS BR_ISSTaxSituation,
  cast(NFItem.taxsi4 as logbr_taxsi4 preserving type) AS BR_COFINSTaxSituation,
  cast(NFItem.taxsi5 as logbr_taxsi5 preserving type) AS BR_PISTaxSituation,
  cast(NFItem.modbc as logbr_icms_base_det preserving type) AS BR_ICMSBaseDetn,
  cast(NFItem.modbcst as logbr_icst_base_det preserving type) AS BR_ICMSSTBaseDetermination,
  cast(NFItem.cest as logbr_cest preserving type) AS BR_ICMSSTLegalClassfctn,
  cast(NFItem.vicmssubstituto as logbr_vicmssubstituto preserving type) AS BR_SubstituteICMSAmount,
  cast(NFItem.motdesicms as logbr_icmsexemptionreason preserving type) AS BR_ICMSExemptionReason,
  cast(NFItem.vicmsdif as logbr_nfe_rfc_vicmsdif preserving type) AS BR_ICMSDefermentAmount,
  cast(NFItem.picmsdef as logbr_picmsdef preserving type) AS BR_ICMSDeferralTaxRate,
  cast(NFItem.vbcstret as logbr_nfe_rfc_icmsstretbase preserving type) AS BR_WithholdingICMSSTBaseAmount,
  cast(NFItem.vicmsstret as logbr_nfe_rfc_icmsstrettaxval preserving type) AS BR_WithholdingICMSSTAmount,
  cast(NFItem.cenq as logbr_ipi_legal_class_code preserving type) AS BR_IPILegalClassification,
  cast(NFItem.clenq as logbr_ipi_class_tbc_bev preserving type) AS BR_TobaccoBeverageIPIClassfctn,
  cast(NFItem.cselo as logbr_ipi_contr_seal_code preserving type) AS BR_IPIControlSealCode,
  cast(NFItem.qselo as logbr_ipi_contr_seal_quan preserving type) AS BR_IPIControlSealQuantityValue,
  cast(NFItem.netpr as j_1bnfpri preserving type) AS NetPriceAmount,
  cast(NFItem.netwr as logbr_netamount preserving type) AS NetValueAmount,
  cast(NFItem.itmtyp as logbr_itmtyp preserving type) AS BR_NFItemType,
  cast(NFItem.statit as logbr_statit preserving type) AS BR_NFItemIsStatistical,
  cast(NFItem.bwtar as logbr_bwtar_d preserving type) AS ValuationType,
  cast(NFItem.matkl as logbr_matkl preserving type) AS MaterialGroup,
  cast(NFItem.refkey as logbr_refkey preserving type) AS BR_NFSourceDocumentNumber,
  cast(NFItem.docref as logbr_docref preserving type) AS BR_ReferenceNFNumber,
  cast(NFItem.itmref as logbr_itmref preserving type) AS BR_ReferenceNFItem,
  cast(NFItem.pipidevol as logbr_nfe_pret preserving type) AS BR_NFPercentReturned,
  cast(NFItem.netdis as logbr_nfnetdiscountamount) AS BR_NFNetDiscountAmount,
  cast(NFItem.vicmsdeson as logbr_nfe_vicmsdeson preserving type) AS BR_ExemptedICMSAmount,
  cast(NFItem.ststcl_vicmsdeson as logbr_ststcl_vicmsdeson preserving type) AS BR_ICMSStatisticalExemptionAmt,
  cast(NFItem.p_mvast as logbr_pmvast preserving type) AS BR_ICMSSTMarginAddedPercent,
  cast(NFItem.cfop as logbr_cfopcode preserving type) AS BR_CFOPCode,
  cast(NFItem.matorg as logbr_matorg preserving type) AS BR_MaterialOrigin,
  cast(NFItem.matuse as logbr_matuse preserving type) AS BR_MaterialUsage,
  cast(NFItem.ownpro as logbr_ownpro preserving type) AS IsProducedInhouse,
  cast(NFItem.nbm as logbr_steuc preserving type) AS NCMCode,
  cast(NFItem.nbs as logbr_nbs preserving type) AS BR_NBSCode,
  cast(NFItem.vtottrib as logbr_nf_vtottrib) AS BR_NFApproximateTotalTaxAmount,
  cast(NFItem.nfci as logbr_nfe_nfci preserving type) AS BR_FCINumber,
  cast(NFItem.taxlw1 as logbr_taxlw1 preserving type) AS BR_ICMSTaxLaw,
  cast(NFItem.taxlw2 as logbr_taxlw2 preserving type) AS BR_IPITaxLaw,
  cast(NFItem.taxlw5 as logbr_taxlw5 preserving type) AS BR_PISTaxLaw,
  cast(NFItem.cod_cta as logbr_gl_account preserving type) AS GLAccount,
  cast(NFItem.nitemped as logbr_purch_ord_item_ext preserving type) AS PurchaseOrderItem,
  cast(NFItem.cean as logbr_article_number preserving type) AS InternationalArticleNumber,
  cast(NFItem.num_item as logbr_ext_item_num preserving type) AS BR_NFExternalItemNumber,
  cast(NFItem.nrecopi as logbr_recopi preserving type) AS BR_RECOPINumber,
  cast(NFItem.nprocesso as logbr_nfe_nprocesso preserving type) AS BR_ISSSuspensionProcess,
  cast(NFItem.menge_trib as logbr_qtdtrb preserving type) AS BR_NFTributaryQuantity,
  cast(NFItem.meins_trib as logbr_unttrb preserving type) AS BR_NFTributaryUnit,
  cast(NFItem.ind_mov as logbr_phys_move_mat preserving type) AS BR_NFIsPhysicalMvtOfMaterial,
  cast(NFItem.nfpri as j_1bnfpri preserving type) AS BR_NFPriceAmountWithTaxes,
  cast(NFItem.predbcefet as logbr_predbcefet preserving type) AS BR_ReducnPctEffctvCalcBasis,
  cast(NFItem.vbcefet as logbr_vbcefet preserving type) AS BR_EffctvCalcBasisAmount,
  cast(NFItem.vicmsefet as logbr_vicmsefet preserving type) AS BR_EffectiveICMSAmount,
  cast(NFItem.indescala as logbr_indescala preserving type) AS ProductionIsInRelevantScale,
  cast(NFItem.cnpjfab as logbr_cnpjfab preserving type) AS BR_ManufacturerCNPJ,
  cast(NFItem.cbenef as logbr_cbenef preserving type) AS TaxIncentiveCode,
  cast(NFItem.vbcstdest as logbr_vbcstdest preserving type) AS BR_ICMSSTDestTaxBaseAmount,
  cast(NFItem.vicmsstdest as logbr_vicmsstdest preserving type) AS BR_ICMSSTDestTaxAmount,
  cast(NFItem.vbcfcpstret as logbr_vbcfcpstret preserving type) AS BR_FCPOnICMSSTWithheldBaseAmt,
  cast(NFItem.pfcpstret as logbr_pfcpstret preserving type) AS BR_FCPonICMSSTWithheldRate,
  cast(NFItem.vdespadu as logbr_vdespadu preserving type) AS CustomsChargesAmount,
  cast(NFItem.vfcpstret as logbr_vfcpstret preserving type) AS BR_FCPOnICMSSTWithheldAmount,
  cast(NFItem.viof as logbr_viof preserving type) AS BR_IOFTaxAmount,
  cast(NFItem.cbarra as logbr_cbarra preserving type) AS BR_InternalBarcode,
  cast(NFItem.cbarra_trib as logbr_cbarra_trib preserving type) AS BR_InternalTributaryBarcode,
  cast(NFItem.indsomapisst as logbr_indsomapisst preserving type) AS BR_NFIsPISSTInTotalAmount,
  cast(NFItem.indsomapisst as logbr_indsomapisst preserving type) AS BR_PISSTInNFTotal,
  cast(NFItem.pisst as logbr_pisst preserving type) AS BR_PISSTTaxAmount,
  cast(NFItem.nfpisst as logbr_nfpisst preserving type) AS BR_PISSTTaxIncludedTaxAmount,
  cast(NFItem.indsomacofinsst as logbr_indsomacofinsst preserving type) AS BR_NFIsCOFINSSTInTotalAmount,
  cast(NFItem.indsomacofinsst as logbr_indsomacofinsst preserving type) AS BR_COFINSSTInNFTotal,
  cast(NFItem.cofinsst as logbr_cofinsst preserving type) AS BR_COFINSSTTaxAmount,
  cast(NFItem.nfcofinsst as logbr_nfcofinsst preserving type) AS BR_COFINSSTTxIncludedTaxAmount,
  cast(NFItem.pdif as logbr_pdif preserving type) AS BR_ICMSDefermentPercent,
  cast(NFItem.vfcpdif as logbr_vfcpdif preserving type) AS BR_FCPOnICMSDefermentAmount,
  cast(NFItem.pfcpdef as logbr_pfcpdef preserving type) AS BR_FCPOnICMSDeferralTaxRate,
  cast(NFItem.pfcpdif as logbr_pfcpdif preserving type) AS BR_FCPOnICMSDefermentPercent,
  cast(NFItem.vicmsstdeson as logbr_vicmsstdeson preserving type) AS BR_ExemptedICMSSTAmount,
  cast(NFItem.motdesicmsst as logbr_motdesicmsst preserving type) AS BR_ICMSSTExemptionReason,
  cast(NFItem.vicmsmonodif as logbr_vicmsmonodif preserving type) AS BR_NFMonoICMSDeferredAmount,
  cast(NFItem.adremicmsret as logbr_adremicmsret preserving type) AS BR_NFAdRemICMSRetainedTaxRate,
  cast(NFItem.vicmsmonoret as logbr_vicmsmonoret preserving type) AS BR_NFMonoICMSRetainedAmount,
  cast(NFItem.qbcmonoret as logbr_qbcmonoret preserving type) AS BR_NFMonoRetainedTaxedQuantity,
  cast(NFItem.motredadrem as logbr_motredadrem preserving type) AS BR_NFAdRemICMSReductionReason,
  cast(NFItem.predadrem as logbr_predadrem preserving type) AS BR_NFAdRemICMSReductionRate,
  cast(NFItem.vicmsmonoop as logbr_vicmsmonoop preserving type) AS BR_NFMonoICMSOperationAmount,
  cast(NFItem.adremicmspdif as logbr_adremicmspdif preserving type ) AS BR_NFAdRemICMSDeferralPercent,
  NFItem.docnum AS BR_NotaFiscal,
  NFItem.itmnum AS BR_NotaFiscalItem,
  NFItem.kostl AS CostCenter,
  NFItem.prctr AS ProfitCenter,
  NFItem.aufnr AS InternalOrder,
  NFItem.nplnr AS ProjectNetwork,
  NFItem.ps_psp_pnr AS WBSElementInternalID,
  NFItem.kstrg AS CostObject,
  NFItem.segment AS Segment,
  NFItem.netfre AS BR_NFNetFreightAmount,
  NFItem.netins AS BR_NFNetInsuranceAmount,
  NFItem.netoth AS BR_NFNetOtherExpensesAmount,
  NFItem.incltx AS BR_ICMSOrISSIsIncludedInPrice,
  NFItem.tmiss AS BR_NFIsServiceItem,
  NFItem.matnr AS Material,
  NFItem.maktx AS MaterialName,
  NFItem.bwkey AS ValuationArea,
  NFItem.indus3 AS BR_CFOPCategory,
  NFItem.menge AS QuantityInBaseUnit,
  NFItem.meins AS BaseUnit,
  NFItem.werks AS Plant,
  NFItem.charg AS Batch,
  NFItem.reftyp AS BR_NFSourceDocumentType,
  NFItem.refitm AS BR_NFSourceDocumentItem,
  NFItem.cprb AS BR_CPRBIsRelevant,
  NFItem.netwrt AS BR_NFTotalAmount,
  NFItem.reinf_service_code AS BR_EFDREINFServiceCode,
  NFItem.lc116_service_code AS BR_LC116ServiceCode,
  NFItem.cbenef_iss AS BR_ISSBenefitCode,
  NFItem.municipal_iss_taxsit AS BR_CSTISSCode,
  NFItem.taxlw3 AS BR_ISSTaxLaw,
  NFItem.taxlw4 AS BR_COFINSTaxLaw,
  NFItem.xped AS PurchaseOrder,
  NFItem.indincentivo AS BR_NFItemHasTaxIncentive,
  NFItem.nfnet AS BR_NFValueAmountWithTaxes,
  NFItem.nfdis AS BR_NFDiscountAmountWithTaxes,
  NFItem.nffre AS BR_NFFreightAmountWithTaxes,
  NFItem.nfins AS BR_NFInsuranceAmountWithTaxes,
  NFItem.nfoth AS BR_NFExpensesAmountWithTaxes,
  NFItem.nficmsdeson AS BR_NFExemptedICMSWithTaxes,
  NFItem.nfnett AS BR_NFTotalAmountWithTaxes,
  NFItem.mwskz AS BR_TaxCode,
  NFItem.srvnr AS ActivityNumber,
  NFItem.nat_bc_cred AS CreditCalculationBaseCode,
  NFItem.picmsefet AS BR_EffectiveICMSRate,
  NFItem.pst AS BR_ICMSSTRateIncludingFCP,
  NFItem.voutro AS BR_NFeStatisticalAmount,
  NFItem.item_cnae_partner AS BR_NFPartnerCNAE,
  NFItem.item_cnae_bupla AS BR_BusinessPlaceCNAE,
  NFItem.ind_nat_frt AS BR_NFFreightNature,
  _BR_NotaFiscal.SalesDocumentCurrency AS SalesDocumentCurrency
FROM j_1bnflin AS NFItem
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _NFTributaryUnit ON BR_NFTributaryUnit = _NFTributaryUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _SalesDocumentCurrency ON SalesDocumentCurrency = _SalesDocumentCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_BR_NFDocument AS _BR_NotaFiscal ON BR_NotaFiscal = _BR_NotaFiscal.BR_NotaFiscal  -- association [1..1]
LEFT OUTER JOIN I_BR_ICMSBaseDetn AS _BR_ICMSBaseDetn ON _BR_ICMSBaseDetn.BR_ICMSBaseDetn = BR_ICMSBaseDetn  -- association [0..1]
LEFT OUTER JOIN I_BR_ICMSExemptionReason AS _BR_ICMSExemptionReason ON _BR_ICMSExemptionReason.BR_ICMSExemptionReason = BR_ICMSExemptionReason  -- association [0..1]
LEFT OUTER JOIN I_BR_ICMSSTBaseDetn AS _BR_ICMSSTBaseDetn ON _BR_ICMSSTBaseDetn.BR_ICMSSTBaseDetermination = BR_ICMSSTBaseDetermination  -- association [0..1]
LEFT OUTER JOIN I_BR_ICMSTaxSituation AS _BR_ICMSTaxSituation ON _BR_ICMSTaxSituation.BR_ICMSTaxSituation = BR_ICMSTaxSituation  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialOrigin AS _MaterialOrigin ON _MaterialOrigin.BR_MaterialOrigin = BR_MaterialOrigin  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialUsage AS _MaterialUsage ON _MaterialUsage.BR_MaterialUsage = BR_MaterialUsage  -- association [0..1]
LEFT OUTER JOIN I_BR_CNAE AS _BR_CNAEPartner ON _BR_CNAEPartner.BR_CNAE = BR_NFPartnerCNAE  -- association [0..1]
LEFT OUTER JOIN I_BR_CNAE AS _BR_CNAEBusinessPlace ON _BR_CNAEBusinessPlace.BR_CNAE = BR_BusinessPlaceCNAE  -- association [0..1]
LEFT OUTER JOIN I_BR_NFFreightNature AS _BR_NFFreightNature ON _BR_NFFreightNature.BR_NFFreightNature = BR_NFFreightNature  -- association [0..1]
LEFT OUTER JOIN I_BR_ICMSSTExemptionReason AS _BR_ICMSSTExemptionReason ON _BR_ICMSSTExemptionReason.BR_ICMSSTExemptionReason = BR_ICMSSTExemptionReason  -- association [0..1]
LEFT OUTER JOIN I_BR_NFAdRemICMSReducnReason AS _BR_NFAdRemICMSReducnReason ON _BR_NFAdRemICMSReducnReason.BR_NFAdRemICMSReductionReason = BR_NFAdRemICMSReductionReason  -- association [0..1]
;