R_PurchasingDocumentItem

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 R_PurchasingDocumentItem.
-- 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: RMMPURGDOCITEM

CREATE VIEW R_PurchasingDocumentItem AS
SELECT
  cast (ekpo.matnr as productnumber preserving type ) AS Product,
  cast (ekpo.lgort as vdm_storage_location preserving type) AS StorageLocation,
  cast (ekpo.matkl as productgroup preserving type ) AS ProductGroup,
  cast (ekpo.peinh as vdm_price_unit preserving type) AS NetPriceQuantity,
  cast (ekpo.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  fipos AS CommitmentItem,
  cast( ekpo.fipos as fmis_ci_internalname) AS CommitmentItemShortID,
  cast (ekpo.iprkz as vdm_dattp preserving type) AS ShelfLifeExpirationDatePeriod,
  cast(ekpo.j_1bnbm as j_1ig_hsn_sac preserving type) AS ConsumptionTaxCtrlCode,
  cast( ekpo.j_1bnbm as j_1ig_hsn_sac preserving type) AS IN_GSTControlCode,
  cast ( ekpo.inco2_key as /scmtms/inc_loc_1_key_nc preserving type ) AS IncotermsSupChnLoc1AddlUUID,
  cast ( ekpo.inco3_key as /scmtms/inc_loc_2_key_nc preserving type ) AS IncotermsSupChnLoc2AddlUUID,
  cast ( ekpo.inco4_key as /scmtms/inc_dv_plce_dst_key_nc preserving type ) AS IncotermsSupChnDvtgLocAddlUUID,
  uptyp AS SubItemCategory,
  uptyp AS PurgDocSubitemCategory,
  fsh_season_year AS ProductSeasonYear,
  fsh_season AS ProductSeason,
  fsh_collection AS ProductCollection,
  fsh_theme AS ProductTheme,
  rfm_scc_indicator AS SeasonCompletenessStatus,
  cnfm_qty AS CommittedQuantity,
  rfm_psst_rule AS ShippingGroupRule,
  rfm_psst_group AS ShippingGroupNumber,
  wrf_charstc1 AS ProductCharacteristic1,
  wrf_charstc2 AS ProductCharacteristic2,
  wrf_charstc3 AS ProductCharacteristic3,
  rfm_diversion AS DiversionStatus,
  rfm_ref_doc AS ReferenceDocumentNumber,
  rfm_ref_doc AS RefDocNmbrForTrcblyInPO,
  rfm_ref_item AS ReferenceDocumentItem,
  rfm_ref_item AS RefDocItmNmbrForTrcblyInPO,
  rfm_ref_action AS PurchaseOrderReferenceType,
  rfm_ref_action AS RefActnForTrcblyInPO,
  rfm_ref_slitem AS ReferenceDocumentScheduleLine,
  rfm_ref_slitem AS RefDocSchdLnNmbrForTrcblyInPO,
  fsh_vas_rel AS ItemHasValueAddedService,
  fsh_vas_prnt_id AS ValAddedSrvcParentItmNumber,
  assignment_priority AS ARunPriorityValue,
  arun_group_prio AS ARunDemandGroupPriority,
  PFMTransDataFootprintUUID,
  sgt_scat AS StockSegment,
  ekpo.ebeln AS PurchasingDocument,
  ekpo.ebelp AS PurchasingDocumentItem,
  ekpo.uniqueid AS PurchasingDocumentItemUniqueID,
  ekpo.bstyp AS PurchasingDocumentCategory,
  ekpo.loekz AS PurchasingDocumentDeletionCode,
  ekpo.statu AS PurchasingDocumentItemOrigin,
  ekpo.creationdate AS PurchasingDocumentCreationDate,
  ekpo.creationtime AS PurchasingDocumentCreationTime,
  ekpo.matnr AS Material,
  ekpo.idnlf AS SupplierMaterialNumber,
  ekpo.ematn AS ManufacturerMaterial,
  ekpo.mfrpn AS ManufacturerPartNmbr,
  ekpo.mfrnr AS Manufacturer,
  ekpo.txz01 AS PurchasingDocumentItemText,
  ekpo.bukrs AS CompanyCode,
  ekpo.werks AS Plant,
  ekpo.adrnr AS ManualDeliveryAddressID,
  ekpo.adrn2 AS ReferenceDeliveryAddressID,
  ekpo.kunnr AS Customer,
  ekpo.emlif AS Subcontractor,
  ekpo.lblkz AS SupplierIsSubcontractor,
  ekpo.satnr AS CrossPlantConfigurableProduct,
  ekpo.attyp AS ArticleCategory,
  ekpo.kanba AS PlndOrderReplnmtElmntType,
  ekpo.punei AS ProductPurchasePointsQtyUnit,
  ekpo.anzpu AS ProductPurchasePointsQty,
  ekpo.matkl AS MaterialGroup,
  ekpo.meins AS OrderQuantityUnit,
  ekpo.umrez AS OrderItemQtyToBaseQtyNmrtr,
  ekpo.umren AS OrderItemQtyToBaseQtyDnmntr,
  ekpo.elikz AS IsCompletelyDelivered,
  ekpo.erekz AS IsFinallyInvoiced,
  ekpo.wepos AS GoodsReceiptIsExpected,
  ekpo.repos AS InvoiceIsExpected,
  ekpo.eglkz AS OutwardDeliveryIsComplete,
  ekpo.webre AS InvoiceIsGoodsReceiptBased,
  ekpo.weunb AS GoodsReceiptIsNonValuated,
  ekpo.weora AS IsToBeAcceptedAtOrigin,
  ekpo.price_change_in_ses_allowed AS PriceChangeInSESIsAllowed,
  ekpo.banfn AS PurchaseRequisition,
  ekpo.bnfpo AS PurchaseRequisitionItem,
  ekpo.packno AS ServicePackage,
  ekpo.serviceperformer AS ServicePerformer,
  ekpo.producttype AS ProductType,
  ekpo.producttype AS ProductTypeCode,
  ekpo.mtart AS MaterialType,
  ekpo.ktpnr AS PurchaseContractItem,
  ekpo.konnr AS PurchaseContract,
  ekpo.requestforquotation AS RequestForQuotation,
  ekpo.requestforquotationitem AS RequestForQuotationItem,
  ekpo.xersy AS EvaldRcptSettlmtIsAllowed,
  ekpo.uebtk AS UnlimitedOverdeliveryIsAllowed,
  ekpo.uebto AS OverdelivTolrtdLmtRatioInPct,
  ekpo.untto AS UnderdelivTolrtdLmtRatioInPct,
  ekpo.afnam AS RequisitionerName,
  ekpo.berid AS MRPArea,
  ekpo.inco1 AS IncotermsClassification,
  ekpo.inco2 AS IncotermsTransferLocation,
  ekpo.inco2_l AS IncotermsLocation1,
  ekpo.inco3_l AS IncotermsLocation2,
  ekpo.kolif AS PriorSupplier,
  ekpo.fplnr AS InvoicingPlan,
  ekpo.ean11 AS InternationalArticleNumber,
  ekpo.bstae AS SupplierConfirmationControlKey,
  ekpo.prsdr AS PriceIsToBePrinted,
  ekpo.lmein AS BaseUnit,
  ekpo.pstyp AS PurchasingDocumentItemCategory,
  ekpo.ko_prctr AS ProfitCenter,
  ekpo.bprme AS OrderPriceUnit,
  ekpo.voleh AS VolumeUnit,
  ekpo.gewei AS WeightUnit,
  ekpo.vrtkz AS MultipleAcctAssgmtDistribution,
  ekpo.twrkz AS PartialInvoiceDistribution,
  ekpo.meprf AS PricingDateControl,
  ekpo.stapo AS IsStatisticalItem,
  ekpo.uebpo AS PurchasingParentItem,
  ekpo.lewed AS GoodsReceiptLatestCreationDate,
  ekpo.retpo AS IsReturnsItem,
  ekpo.bsgru AS PurchasingOrderReason,
  ekpo.knttp AS AccountAssignmentCategory,
  ekpo.infnr AS PurchasingInfoRecord,
  ekpo.netwr AS NetAmount,
  ekpo.brtwr AS GrossAmount,
  ekpo.effwr AS EffectiveAmount,
  ekpo.kzwi1 AS Subtotal1Amount,
  ekpo.kzwi2 AS Subtotal2Amount,
  ekpo.kzwi3 AS Subtotal3Amount,
  ekpo.kzwi4 AS Subtotal4Amount,
  ekpo.kzwi5 AS Subtotal5Amount,
  ekpo.kzwi6 AS Subtotal6Amount,
  ekpo.ktmng AS TargetQuantity,
  ekpo.menge AS OrderQuantity,
  ekpo.netpr AS NetPriceAmount,
  ekpo.zwert AS TargetAmount,
  ekpo.volum AS ItemVolume,
  ekpo.brgew AS ItemGrossWeight,
  ekpo.ntgew AS ItemNetWeight,
  ekpo.bpumz AS OrderPriceUnitToOrderUnitNmrtr,
  ekpo.bpumn AS OrdPriceUnitToOrderUnitDnmntr,
  ekpo.abdat AS SchedAgrmtCumQtyReconcileDate,
  ekpo.abftz AS SchedAgrmtAgreedCumQty,
  ekpo.drdat AS ItemLastTransmissionDate,
  ekpo.etfz1 AS ScheduleLineFirmOrderInDays,
  ekpo.etfz2 AS SchedLineSemiFirmOrderInDays,
  ekpo.mahn1 AS NoDaysReminder1,
  ekpo.mahn2 AS NoDaysReminder2,
  ekpo.mahn3 AS NoDaysReminder3,
  ekpo.bednr AS RequirementTracking,
  ekpo.kzabs AS IsOrderAcknRqd,
  ekpo.insmk AS StockType,
  ekpo.mwskz AS TaxCode,
  ekpo.txjcd AS TaxJurisdiction,
  ekpo.evers AS ShippingInstruction,
  ekpo.vsart AS ShippingType,
  ekpo.navnw AS NonDeductibleInputTaxAmount,
  ekpo.bwtar AS ValuationType,
  ekpo.bwtty AS ValuationCategory,
  ekpo.abskz AS ItemIsRejectedBySupplier,
  ekpo.prdat AS PurgDocPriceDate,
  ekpo.spinf AS PurchasingInfoRecordUpdateCode,
  ekpo.abmng AS PurgDocReleaseOrderQuantity,
  ekpo.labnr AS PurgDocOrderAcknNumber,
  ekpo.schpr AS PurchasingPriceIsEstimated,
  ekpo.borgr_miss AS IsInfoAtRegistration,
  ekpo.ltsnr AS SupplierSubrange,
  ekpo.kostl AS CostCenter,
  ekpo.sakto AS GLAccount,
  ekpo.geber AS Fund,
  ekpo.budget_pd AS BudgetPeriod,
  ekpo.fistl AS FundsCenter,
  ekpo.fkber AS FunctionalArea,
  ekpo.grant_nbr AS GrantID,
  ekpo.kblnr AS EarmarkedFundsDocument,
  ekpo.kblpos AS EarmarkedFundsDocumentItem,
  ekpo.ko_gsber AS PartnerReportedBusinessArea,
  ekpo.plifz AS PlannedDeliveryDurationInDays,
  ekpo.webaz AS GoodsReceiptDurationInDays,
  ekpo.kztlf AS PartialDeliveryIsAllowed,
  ekpo.kzvbr AS ConsumptionPosting,
  ekpo.abueb AS SchedgAgrmtRelCreationProfile,
  ekpo.spe_cq_ctrltype AS SchedAgrmtCumulativeQtyControl,
  ekpo.spe_cq_nocq AS CumulativeQuantityIsNotSent,
  ekpo.mhdrz AS MinRemainingShelfLife,
  ekpo.ssqss AS QualityMgmtCtrlKey,
  ekpo.sobkz AS InventorySpecialStockType,
  ekpo.fabkz AS IsRelevantForJITDelivSchedule,
  ekpo.nfabd AS NextJITDelivSchedSendingDate,
  ekpo.nlabd AS NextFcstDelivSchedSendingDate,
  ekpo.kzstu AS FirmTradeOffZoneBindMRP,
  ekpo.zgtyp AS QualityCertificateType,
  ekpo.anfnr AS SupplierQuotation,
  ekpo.anfps AS SupplierQuotationItem,
  ekpo.isvco AS IntrastatServiceCode,
  ekpo.stawn AS CommodityCode,
  ekpo.lfret AS DeliveryDocumentType,
  ekpo.mfrgr AS MaterialFreightGroup,
  ekpo.nrfhg AS DiscountInKindEligibility,
  ekpo.novet AS PurgItemIsBlockedForDelivery,
  ekpo.reslo AS IssuingStorageLocation,
  ekpo.abeln AS AllocationTable,
  ekpo.abelp AS AllocationTableItem,
  ekpo.aktnr AS RetailPromotion,
  ekpo.exlin AS PurgConfigurableItemNumber,
  ekpo.upvor AS PurgDocAggrgdSubitemCategory,
  ekpo.exsnr AS PurgExternalSortNumber,
  ekpo.dptyp AS DownPaymentType,
  ekpo.dppct AS DownPaymentPercentageOfTotAmt,
  ekpo.dpamt AS DownPaymentAmount,
  ekpo.dpdat AS DownPaymentDueDate,
  ekpo.loadingpoint AS LoadingPointForDelivery,
  ekpo.expected_value AS ExpectedOverallLimitAmount,
  ekpo.limit_amount AS OverallLimitAmount,
  ekpo.contract_for_limit AS PurContractForOverallLimit,
  ekpo.contract_item_for_limit AS PurContractItemForOverallLimit,
  ekpo.sgt_rcat AS RequirementSegment,
  ekpo.itcons AS SubcontrgCompIsRealTmeCnsmd,
  ekpo.status_dg AS PurgProdCmplncDngrsGoodsStatus,
  ekpo.status_pcs AS PurgProdCmplncSupplierStatus,
  ekpo.status_pma AS PurgProductMarketabilityStatus,
  ekpo.status_sds AS PurgSafetyDataSheetStatus,
  ekpo.blk_reason_id AS PurgDocItmBlkRsnCode,
  ekpo.renegotiation_status AS PurgDocItemRenegotiationStatus,
  ekpo.j_1bmatorg AS BR_MaterialOrigin,
  ekpo.j_1bmatuse AS BR_MaterialUsage,
  ekpo.j_1bindust AS BR_CFOPCategory,
  ekpo.j_1bnbm AS BR_NCM,
  ekpo.j_1bownpro AS BR_IsProducedInHouse,
  ekpo.extmaterialforpurg AS PurchasingCentralMaterial,
  ekpo.extmaterialforpurg AS ProcmtHubExtReferencedMaterial,
  ekpo.procmt_hub_source_system AS ProcmtHubRefcdConnectedSystem,
  ekpo.target_value AS PurgDocItmTargetAmount,
  ekpo.txdat_from AS TaxCodeValidFromDate,
  ekpo.tax_country AS TaxCountry,
  ekpo.txdat AS TaxDeterminationDate,
  ekpo.spe_crm_ref_so AS ThirdPtyOrdProcgExtReference,
  ekpo.spe_crm_ref_item AS ThirdPtyOrdProcgExtRefItem,
  ekpo.goods_count_correction AS IsGoodsCountCorrectionItem,
  ekpo.lifex AS GdsCtCrrtnDelivDocBySuplr,
  ekpo.lifexpos AS GdsCtCrrtnDelivDocItemBySuplr,
  ekpo.is_catalog_relevant AS PurchasingIsCatalogRelevant,
  _PurchasingDocument.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _PurchasingDocument.DocumentCurrency AS DocumentCurrency,
  _PurchasingDocument.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingDocument.PurchasingGroup AS PurchasingGroup,
  _PurchasingDocument.PurchasingDocumentType AS PurchasingDocumentType,
  _PurchasingDocument._DocumentCurrency AS _DocumentCurrency
FROM ekpo
LEFT OUTER JOIN R_PurchasingDocument AS _PurchasingDocument ON PurchasingDocument = _PurchasingDocument.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN I_PurgDocScheduleLine AS _ScheduleLine ON PurchasingDocument = _ScheduleLine.PurchasingDocument AND PurchasingDocumentItem = _ScheduleLine.PurchasingDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_Purchaserequisition AS _PurchaseRequisition ON PurchaseRequisition = _PurchaseRequisition.PurchaseRequisition  -- association [0..1]
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContract AS _PurchaseContract ON PurchaseContract = _PurchaseContract.PurchaseContract  -- association [0..1]
LEFT OUTER JOIN I_PurchaseContractItem AS _PurchaseContractItem ON PurchaseContract = _PurchaseContractItem.PurchaseContract AND PurchaseContractItem = _PurchaseContractItem.PurchaseContractItem  -- association [0..1]
LEFT OUTER JOIN I_PurchasingInfoRecordApi01 AS _PurchasingInfoRecord ON PurchasingInfoRecord = _PurchasingInfoRecord.PurchasingInfoRecord  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_Material AS _ManufacturerMaterial ON ManufacturerMaterial = _ManufacturerMaterial.Material  -- association [0..1]
LEFT OUTER JOIN I_Material AS _ConfigurableProduct ON CrossPlantConfigurableProduct = _ConfigurableProduct.Material  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderQuantityUnit ON OrderQuantityUnit = _OrderQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON VolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _WeightUnit ON WeightUnit = _WeightUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OrderPriceUnit ON OrderPriceUnit = _OrderPriceUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Address AS _ManualDeliveryAddress ON ManualDeliveryAddressID = _ManualDeliveryAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_OrganizationAddress AS _ManualDeliveryAddress_2 ON ManualDeliveryAddressID = _ManualDeliveryAddress_2.AddressID AND _ManualDeliveryAddress_2.AddressPersonID = ' ' AND _ManualDeliveryAddress_2.AddressRepresentationCode = ' '  -- association [0..1]
LEFT OUTER JOIN I_Address AS _ReferenceDeliveryAddress ON ReferenceDeliveryAddressID = _ReferenceDeliveryAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_Address_2 AS _ReferenceDeliveryAddress_2 ON ReferenceDeliveryAddressID = _ReferenceDeliveryAddress_2.AddressID AND _ReferenceDeliveryAddress_2.AddressPersonID = ' ' AND _ReferenceDeliveryAddress_2.AddressRepresentationCode = ' '  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurgDocumentCategory ON PurchasingDocumentCategory = _PurgDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchasingDocumentItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Manufacturer ON Manufacturer = _Manufacturer.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Subcontractor ON Subcontractor = _Subcontractor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _PriorSupplier ON PriorSupplier = _PriorSupplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _ServicePerformer ON ServicePerformer = _ServicePerformer.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductType ON ProductType = _ProductType.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_ProductCategory AS _ProductCategory ON ArticleCategory = _ProductCategory.ProductCategory  -- association [0..1]
LEFT OUTER JOIN I_AccountAssignmentCategory AS _AccountAssignmentCategory ON AccountAssignmentCategory = _AccountAssignmentCategory.AccountAssignmentCategory  -- association [0..1]
LEFT OUTER JOIN I_ConsumptionPosting AS _ConsumptionPosting ON ConsumptionPosting = _ConsumptionPosting.ConsumptionPosting  -- association [0..1]
LEFT OUTER JOIN I_AllocationTable AS _AllocationTable ON AllocationTable = _AllocationTable.AllocationTable  -- association [0..1]
LEFT OUTER JOIN I_AllocationTableItem AS _AllocationTableItem ON AllocationTableItem = _AllocationTableItem.AllocationTableItem AND AllocationTable = _AllocationTableItem.AllocationTable  -- association [0..1]
LEFT OUTER JOIN I_RetailPromotion AS _RetailPromotion ON RetailPromotion = _RetailPromotion.RetailPromotion  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _ItemExtension ON PurchasingDocument = _ItemExtension.PurchasingDocument AND PurchasingDocumentItem = _ItemExtension.PurchasingDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialOrigin AS _BR_MaterialOrigin ON _BR_MaterialOrigin.BR_MaterialOrigin = BR_MaterialOrigin  -- association [0..1]
LEFT OUTER JOIN I_BR_MaterialUsage AS _BR_MaterialUsage ON _BR_MaterialUsage.BR_MaterialUsage = BR_MaterialUsage  -- association [0..1]
LEFT OUTER JOIN I_BR_CFOPCategory AS _BR_CFOPCategory ON _BR_CFOPCategory.BR_CFOPCategory = BR_CFOPCategory  -- association [0..1]
LEFT OUTER JOIN I_BR_NCM AS _BR_NCM ON _BR_NCM.CountryCode = 'BR' AND _BR_NCM.BR_NCM = BR_NCM  -- association [0..1]
;