I_BR_NFIMPORTDOCUMENT

CDS View

Brazil Nota Fiscal Import Document

I_BR_NFIMPORTDOCUMENT is a CDS View in S/4HANA. Brazil Nota Fiscal Import Document. It contains 13 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 13 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
A_BR_NFImportDocument view from BASIC Brazil Nota Fiscal Import Document
I_BR_NFImportDocument_C view from COMPOSITE Brazil Nota Fiscal Import Document
I_BR_SINFPreviewImportDecln view_entity from COMPOSITE Imp Decln Preview from Shipment Imp NF

Fields (13)

KeyField CDS FieldsUsed in Views
KEY BR_NotaFiscal BR_NotaFiscal 1
BR_NFBuyerRequesterCNPJ BR_NFBuyerRequesterCNPJ 1
BR_NFCustomsClearanceDate BR_NFCustomsClearanceDate 1
BR_NFCustomsClearanceDesc BR_NFCustomsClearanceDesc 1
BR_NFCustomsClearanceTaxRegion BR_NFCustomsClearanceTaxRegion 1
BR_NFExporter BR_NFExporter 1
BR_NFImpDocMeansOfTransport BR_NFImpDocMeansOfTransport 1
BR_NFImportDeclarationType BR_NFImportDeclarationType 1
BR_NFImportDocRegistrationDate BR_NFImportDocRegistrationDate 1
BR_NFIntermediateMode BR_NFIntermediateMode 1
BR_NFMaritimeFreightAmount BR_NFMaritimeFreightAmount 1
BR_NFThirdPartyRegion BR_NFThirdPartyRegion 1
SalesDocumentCurrency SalesDocumentCurrency 1 
@AbapCatalog.sqlViewName: 'IBRIMPORTDOC'
@AbapCatalog.compiler.compareFilter: true
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Brazil Nota Fiscal Import Document'
@VDM.viewType: #BASIC
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.supportedCapabilities: [#SQL_DATA_SOURCE,#CDS_MODELING_DATA_SOURCE]
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view I_BR_NFImportDocument
  as select from j_1bnfimport_di as NFImportDocument

  association [1..1] to I_Currency      as _SalesDocumentCurrency on $projection.SalesDocumentCurrency = _SalesDocumentCurrency.Currency
  association [1..1] to I_BR_NFDocument as _BR_NotaFiscal         on $projection.BR_NotaFiscal = _BR_NotaFiscal.BR_NotaFiscal
{
  key NFImportDocument.docnum                                                                   as BR_NotaFiscal,
  key cast(NFImportDocument.ndi as logbr_nfimportdocument preserving type)                      as BR_NFImportDocument,
      cast(NFImportDocument.ddi as logbr_nfregistrationdate preserving type)                    as BR_NFImportDocRegistrationDate,
      cast(NFImportDocument.xlocdesemb as logbr_customsclearance preserving type)               as BR_NFCustomsClearanceDesc,
      cast(NFImportDocument.ufdesemb as logbr_impdoc_clearance_region preserving type)          as BR_NFCustomsClearanceTaxRegion,
      cast(NFImportDocument.ddesemb as logbr_impdoc_clearance_date preserving type)             as BR_NFCustomsClearanceDate,
      cast(NFImportDocument.cexportador as logbr_nfe_exporter_code preserving type)             as BR_NFExporter,
      cast(NFImportDocument.cod_doc_imp as logbr_declarationtype preserving type)               as BR_NFImportDeclarationType,
      NFImportDocument.transport_mode                                                           as BR_NFImpDocMeansOfTransport,
      
      @Aggregation.default:#SUM
      NFImportDocument.maritime_freight                                                         as BR_NFMaritimeFreightAmount,
      NFImportDocument.intermediate_mode                                                        as BR_NFIntermediateMode,
      cast(NFImportDocument.cnpj as logbr_imp_cnpj preserving type)                             as BR_NFBuyerRequesterCNPJ,
      NFImportDocument.regio                                                                    as BR_NFThirdPartyRegion,
      cast(NFImportDocument.mfreight_nftotal as logbr_nfmaritimefreightnntotal preserving type) as BR_NFIsMaritimeFrtInTotalAmt,

      @Semantics.currencyCode:true
      _BR_NotaFiscal.SalesDocumentCurrency                                                      as SalesDocumentCurrency,
      _BR_NotaFiscal,
      _SalesDocumentCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BR_NFDOCUMENT",
"J_1BNFIMPORT_DI"
],
"ASSOCIATED":
[
"I_BR_NFDOCUMENT",
"I_CURRENCY"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More