EDOBRINCOMING

eDocument Brazil: Incoming Document | #transactional | Component: Document Compliance Brazil
Column Name Description
MANDT FK Client
EDOC_GUID FK eDocument: GUID
ACCESSKEY eDocument Brazil: Access Key
Column Name Description
💲 SD Document Currency (CURRENCY):
ICMS_VALUE eDocument for Brazil: ICMS Total Value
IPI_VALUE eDocument for Brazil: IPI Total Value
PIS_VALUE eDocument for Brazil: PIS Total Value
COFINS_VALUE eDocument for Brazil: COFINS Total Value
TOTAL_VALUE eDocument for Brazil: NF-e Total Value
Column Name Description
Column Name Description
DANFE_RECEIPT_DATE eDocument for Brazil: DANFE Receiving Date
DANFE_RECEIPT_TIME eDocument for Brazil: DANFE Receiving Time
ISSUE_DATE eDocument for Brazil: NF-e Issuing Date
ISSUE_TIME eDocument for Brazil: NF-e Issuing Time
Column Name Description
MODEL eDocument for Brazil: Document Model Show values
ISSUING_TYPE eDocument for Brazil: Issuing Type Show values
AUTH_SYSTEM_ENV eDocument for Brazil: Tax Authorities System Environment Show values
BUSINESS_MODEL eDocument Brazil: Business Model Show values
MD_FINAL_STATUS eDocument Brazil: Final Acknowledgement Status Show values
Column Name Description Domain name
MATERIALDOC_YEAR eDocument Brazil: Accounting Document Year GJAHR
INVOICE_FISCAL_YEAR eDocument for Brazil: Invoice Fiscal Year GJAHR
NFENUM Electronic Nota Fiscal Number EDOC_BR_NFENUM9
SERIES eDocument for Brazil: Series J_1BSERIES
SUPPLIER_CNPJ_CPF CNPJ/CPF Supplier EDOC_CNPJ_CPF
CARRIER_CNPJ eDocument for Brazil: Carrier CNPJ EDOC_CNPJ
AVULSA_CNPJ eDocument for Brazil: individual CNPJ EDOC_CNPJ
XML_VERSION eDocument for Brazil: XML Version J_1BNFEXMLVERSION
Master Data Relations Join Conditions
eDocument Brazil: Company Code
  • EDOBRINCOMING.MANDT == T001.MANDT
  • EDOBRINCOMING.COMPANY_CODE == T001.BUKRS
SD Document Currency
  • EDOBRINCOMING.MANDT == TCURC.MANDT
  • EDOBRINCOMING.CURRENCY == TCURC.WAERS
eDocument for Brazil: Country/Region Key
  • eDocument for Brazil: Country/Region Key
  • Client
  • EDOBRINCOMING.LAND1 == T005.LAND1
  • EDOBRINCOMING.MANDT == T005.MANDT
Client EDOBRINCOMING.MANDT == T000.MANDT
eDocument: Plant
  • EDOBRINCOMING.MANDT == T001W.MANDT
  • EDOBRINCOMING.PLANT == T001W.WERKS
eDocument Brazil: Plant Region
  • eDocument for Brazil: Country/Region Key
  • eDocument Brazil: Plant Region
  • EDOBRINCOMING.MANDT == T005S.MANDT
  • EDOBRINCOMING.LAND1 == T005S.LAND1
  • EDOBRINCOMING.PLANT_CUF == T005S.BLAND
eDocument for Brazil: Rejection
  • eDocument for Brazil: Rejection
  • ?
Account Number of Supplier
  • EDOBRINCOMING.MANDT == LFA1.MANDT
  • EDOBRINCOMING.SUPPLIER == LFA1.LIFNR
eDocument Brazil: Supplier Region
  • eDocument for Brazil: Country/Region Key
  • eDocument Brazil: Supplier Region
  • EDOBRINCOMING.MANDT == T005S.MANDT
  • EDOBRINCOMING.LAND1 == T005S.LAND1
  • EDOBRINCOMING.SUPPLIER_CUF == T005S.BLAND