I_BR_CINFPreviewImportDecln

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_CINFPreviewImportDecln.
-- 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.

CREATE VIEW I_BR_CINFPreviewImportDecln AS
SELECT
  cast( hextobin( '00000000000000000000000000000000' ) as logbr_guid_cuhd ) AS CustomsDeclarationUUID,
  cast( '' as logbr_docnum ) AS BR_NotaFiscal,
  cast( '' as logbr_import_decln_number ) AS BR_NFImportDocument,
  cast( '' as logbr_nfregistrationdate ) AS BR_NFImportDocRegistrationDate,
  cast( '' as logbr_impdoc_clearance_date ) AS BR_NFCustomsClearanceDate,
  cast( '' as logbr_customsclearance ) AS BR_NFCustomsClearanceDesc,
  cast( '' as logbr_imp_dec_clear_reg_w_desc ) AS BR_NFCstmsClearanceTaxRegDesc,
  cast( '' as logbr_nfe_exporter_code ) AS BR_NFExporter,
  cast( '' as logbr_declarationtype ) AS BR_NFImportDeclarationType,
  cast( '' as logbr_imp_decl_type_desc ) AS BR_NFImportDeclarationTypeDesc,
  cast( '' as j_1bnfe_imp_transport_mode ) AS BR_NFImpDocMeansOfTransport,
  cast( '' as logbr_imp_transport_mode_desc ) AS BR_NFImpDocMnsOfTransptDesc,
  cast( '' as waerk ) AS Currency,
  cast( 0 as j_1bnfe_imp_maritime_freight ) AS BR_NFMaritimeFreightAmount,
  cast( '' as j_1bnfe_imp_intermediate_mode ) AS BR_NFIntermediateMode,
  cast( '' as logbr_imp_interm_mode_desc ) AS BR_NFIntermediateModeDesc,
  cast( '' as logbr_formatted_cnpj ) AS NFPartnerRegistrationFrmtd,
  cast( '' as j_1bnfe_imp_region ) AS BR_NFThirdPartyRegion
FROM logbr_impnf_attr
LEFT OUTER JOIN I_BR_CINFImportDeclaration AS _ImportDeclaration ON CustomsDeclarationUUID = _ImportDeclaration.CustomsDeclarationUUID  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [1..1]
;