J_1BNFIMPORT_DI

Nota Fiscal Data for Import Documents | #transactional | Component: Logistics Brazil
Column Name Description
MANDT FK Client
DOCNUM FK Document Number
NDI Import Document (DI/DSI/DA/DUIMP) Number / XML Tag <nDI>
Column Name Description
Column Name Description
Column Name Description
DDI Registration Date of Import Document / Tag <dDI>
DDESEMB Date of Customs Clearance / XML Tag <dDesemb>
Column Name Description
COD_DOC_IMP Import Declaration Type Show values
TRANSPORT_MODE Means of Transport Show values
INTERMEDIATE_MODE Intermediate mode Show values
MFREIGHT_NFTOTAL Add Maritime Freight in the Total Amount Value of NF-e Show values
Column Name Description Domain name
XLOCDESEMB Place of Customs Clearance / XML Tag <xLocDesemb> J_1BIMPORT_CUSTOMS_CLEAR_PLACE
CEXPORTADOR Code of the Exporter / XML Tag <cExportador> J_1BIMPORT_EXPORTER_CODE
NUM_ACDRAW Number of Drawback Concession CHAR20
MARITIME_FREIGHT Maritime Freight J_1BNFE_IMP_MARITIME_FREIGHT
CNPJ CNPJ of the Buyer or Requester J_1BCGC
REGIO Region of Third Party J_1BNFE_IMP_REGION
Master Data Relations Join Conditions
Client J_1BNFIMPORT_DI.MANDT == T000.MANDT
Tax Region of the Customs Clearance Place/XML Tag <UFDesemb>
  • ?
  • Tax Region of the Customs Clearance Place/XML Tag <UFDesemb>
  • J_1BNFIMPORT_DI.MANDT == J_1BTREGX.MANDT
  • J_1BNFIMPORT_DI.[column in domain "LAND1"] == J_1BTREGX.LAND1
  • J_1BNFIMPORT_DI.UFDESEMB == J_1BTREGX.TXREG