A_BR_NFDocument

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_NFDocument.
-- 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: ABRNFDOCUMENT

CREATE VIEW A_BR_NFDocument AS
SELECT
  BR_NotaFiscal,
  BR_NFPartnerFunction,
  BR_NFPartner,
  BR_NFPartnerName1,
  BR_NFPartnerName2,
  BR_NFPartnerName3,
  BR_NFPartnerName4,
  PartnerIsOneTimeAccount,
  BR_NFPartnerType,
  BR_NFPartnerStreetName,
  BusinessPartnerHouseNumber,
  BPHsNmbrSuplmntTxt,
  BR_NFPartnerCityName,
  BR_NFPartnerRegionCode,
  BR_NFPartnerDistrictName,
  BR_NFPartnerCountryCode,
  BR_NFPartnerPostalCode,
  BR_NFPartnerIsNaturalPerson,
  BR_NFPartnerCNPJ,
  BR_NFPartnerCPF,
  PhoneNumber,
  BR_NFPartnerStateTaxNumber,
  BR_NFPartnerMunicipalTaxNumber,
  BR_NFPartnerStateTaxNumberST,
  BR_NFPartnerCNAE,
  BR_NFPartnerTaxRegimenCode,
  BR_PartnerCFOPCategory,
  BR_SUFRAMACode,
  BR_SPEDTaxCategory,
  ReportingIncgOrOutgDate,
  BR_NFPartnerTaxJurisdiction,
  BR_NFObservationText,
  MeansOfTransportType,
  MeansOfTransport,
  IncotermsClassification,
  IncotermsTransferLocation,
  ShippingPoint,
  BR_NFShippingUnitBrand,
  BR_NFShippingUnitNumber,
  BR_NFNumberOfPackages,
  BR_NFShippingUnit,
  BR_NFArrivalOrDepartureDate,
  HeaderWeightUnit,
  HeaderNetWeight,
  HeaderGrossWeight,
  BR_NFArrivalOrDepartureTime,
  BR_WhldgICMSForTranspCFOP,
  BR_WhldgICMSForTranspCity,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LogicalSystem,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  PaymentTerms,
  BR_NFIsPrinted,
  BR_NFIsCreatedManually,
  BR_NFIsIncomingIssdByCust,
  BR_NFIsCanceled,
  BR_NFIsChargingInvoice,
  BR_NFDirection,
  BR_NFType,
  BR_NFDocumentType,
  BR_NFModel,
  BR_NFNumber,
  BR_NFSeries,
  BR_NFSubSeries,
  BR_NFSituationCode,
  BR_NFIssuedBy,
  BR_NFIsContingency,
  BR_NFAuthznProtocolNumber,
  BR_NFAuthenticationDate,
  BR_NFAuthenticationTime,
  BR_NFeXMLVersion,
  SupplierInvoice,
  BR_NFOriginalAmount,
  BR_NFDiscountAmount,
  BR_NFNetAmount,
  BR_NFCommitmentNote,
  SugarcaneHarvest,
  SugarcaneRefMonthYear,
  SugarcaneCurMnthQtyUnit,
  SugarcaneCurrentMonthQty,
  SugarcaneLastMnthQtyUnit,
  SugarcaneLastMnthQuantity,
  SugarcaneSumBothMnthsQtyUnit,
  SugarcaneSumBothMonthsQty,
  SugarcaneSuppliesAmount,
  SugarcaneTotalDeductionAmount,
  SugarcaneSuppliesNetAmt,
  BR_NFeDocumentStatus,
  BR_NFIsFinalConsumer,
  BR_NFeCustomerPresence,
  BR_NFeDestination,
  CompanyCode,
  BR_NFPostingDate,
  BusinessPlace,
  BR_BusinessPlaceCNPJ,
  BusinessPlaceStateTaxNumber,
  BR_BusPlaceStateTaxNumberST,
  BusPlaceMunicipalTaxNumber,
  BR_BusinessPlaceCNAE,
  BusinessPlaceTaxRegimenCode,
  BR_NFTotalAmount,
  SalesDocumentCurrency,
  AccountingDocument,
  BR_NFFiscalYear,
  BR_NFWithholdingAmount,
  BR_PaymentForm,
  FreightPayer,
  BR_ANTTCarrierRegistration,
  BR_NFeNumber,
  WagonID,
  FerryBoatID,
  BR_NFExportShipmentPlace,
  BR_NFExportShipmentRegion,
  BR_NFExportDispatchLocation,
  BR_NFIssueDate,
  BR_NFIsMunicipal,
  BR_NFOperationTypeDesc,
  BR_IsNFe,
  BR_NFCancellationDate,
  BR_NFHasFollowOnDocument,
  BR_NFReferenceDocument,
  LicensePlate,
  VehicleRegion,
  BR_UtilsNFNumber,
  BR_NFPartnerPlaceType,
  BR_NFIsCalculatedByTaxService,
  ChangeAmount,
  BR_NFFiscalCouponDocModel,
  BR_NFOperationOrderNumber,
  BR_NFPartnerForeignIdn,
  BR_CTeDocumentType,
  BR_CTeMainProductTransported,
  BR_CTeTotalGoodsAmount,
  BR_CTePartnerServiceTaker,
  BR_CTeFiscalDocumentPartner,
  BR_CTeServiceType,
  BR_CTeTransportationMode,
  BR_CTeEstimatedDeliveryDate,
  BR_CTeIsTruckFullyLoaded,
  BR_CTeJurisdictionCodeOrigin,
  BR_CTeJurisdictionCodeDest,
  BR_NFSVerificationCode,
  BR_NFSNumber,
  BR_NFHasServiceItem,
  IsBusinessPurposeCompleted,
  CompanyCodeName,
  BR_NFeIntermediatorTransaction,
  BR_NFeIntermediatorRegistry,
  BR_NFeIntermediatorCNPJ,
  BR_CreditNFType,
  BR_GovernmentEntityType,
  BR_GovPurRateReducnPercent,
  BR_GvmntEntityOperationType,
  cast('' as abap.sstring(999)) AS BR_NFMessageText,
  cast('' as abap.sstring(132)) AS BR_NFAdditionalFiscalInfoText,
  cast('' as abap.sstring(132)) AS BR_NFAdditionalCompanyInfoText
FROM I_BR_NFDocument AS Root
LEFT OUTER JOIN A_BR_NFItem AS _BR_NFItem ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFPartner AS _BR_NFPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_OneTimePartner AS _BR_OneTimePartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFImportDocument AS _BR_NFImportDocument ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFTransportedVolume AS _BR_NFTransportedVolume ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFTrailer AS _BR_NFTrailer ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFTradeNote AS _BR_NFTradeNote ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFAdditionalInformation AS _BR_NFAdditionalInformation ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFReferencedProcess AS _BR_NFReferencedProcess ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFSugarCaneSupply AS _BR_NFSugarCaneSupply ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFSugarCaneDeductible AS _BR_NFSugarCaneDeductible ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFePayment AS _BR_NFePayment ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_TechnicalResponsible AS _BR_TechnicalResponsible ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN A_BR_NFHeaderText AS _BR_NFHeaderText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN A_BR_NFExportDeclaration AS _BR_NFExportDeclaration ON /* condition not available in parsed metadata */  -- association [0..1]
LEFT OUTER JOIN A_BR_NFDocumentReference AS _BR_NFDocumentReference ON /* condition not available in parsed metadata */  -- association [0..*]
;