accounting document assignment table in sap

• Ask a Question
• Write a Blog Post
• Login / Sign-up

Table for Accounting Document of Invoice Document

We have accounting doc. table of material document as BKPF(HEADER) & BSEG(ITEM).

In the same way, can any one share, whats the accounting doc table for Invoice/MIRO??

• Financial Accounting FI

Report a missing table or a suggestion for improvement here... Additional tables for the following modules at Erp-Top.com: FI-GL            FI-AR            FI-AP            FI-BL            FI-AA            CO            CO-OM-CEL            CO-OM-CCA            CO-OM-OPA            CO-PC            EC-PCA            RE-FX            RE-FX-LA            SD            MM            MM-PUR            QM            PM            PP            PP-PI            PS            PA                                             AP-MD-BP           

TutorialKart

Sap accountingdocumentsegment tables, top sap tables.

• BSEG - Accounting Document Segment

SAP Table BSEG

Accounting document segment.

BSEG (Accounting Document Segment) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BSEG to other SAP tables.

BSEG stores the line items for accounting documents. Accounting documents make up the financials of your organisation. Header lines are stored in table BKPF . The link between BSEG and BKPF is made on fields MANDT, BUKRS, GJAHR, BELNR. The same document number can be used in different company codes. The same document number can also be used multiple times within the same company code in different years.

For accounting documents that have an effect on the financials (i.e. BKPF.BSTAT is blank) total debits should match total credits. Debit versus credit is indicated by field SHKZG.

BSEG table fields

Bseg foreign key relationships.

Accounting document number and invoice number Table in SAP

• BBPD_OR_INVHUB Table for Object Link: Invoice/Invoice Template to Reference Document Table Type : TRANSP Package : BBP_PRODOC Module : SRM-EBP
• RBKPB Table for Invoice Document Header (Batch Invoice Verification) Table Type : TRANSP Package : MRM Module : CRM
• CRMC_EDRINV_PER Table for EDR Invoice: Default values for Invoice Date search Table Type : TRANSP Package : CRM_INVOICE_UIIC Module : CRM-IC-BE
• RBVS Table for Invoice Verification: Split Invoice Amount Table Type : TRANSP Package : MRM Module : CRM
• TMRM007A Table for Tax Codes: Invoice Verification/Invoice Entry (FI) Table Type : TRANSP Package : MRM Module : CRM
• J_1IEXCREF Table for Delivery document to excise invoice refrence document link Table Type : TRANSP Package : J1I2 Module : FI-LOC
• TFK2600B Table for Document Number Assignment:Document Number Already Assigned? Table Type : TRANSP Package : FKKINV Module : FI-CA-INV
• IDGT_VATM Table for Mapping of GT Document and VAT Invoice Table Type : TRANSP Package : ID-SD-CN-GT-01 Module : FI-LOC
• ACCSYSTEM02 Table for Number Range Object for Accounting System and Company Table Type : TRANSP Package : FIN_ACC_DOCUMENT Module : FIN
• T003R Table for Number Ranges RE_BELEG (Logistics Invoice Verification) Table Type : TRANSP Package : MRM Module : CRM
• BBP_RBKP Table for Document Header: Invoice Receipt Table Type : TRANSP Package : BBP_COPIED_OBJECTS Module : SRM-EBP-PD
• CNV_20000_RBKP Table for Backup copy of RBKP (document header for incoming invoice) Table Type : TRANSP Package : CNV_20000 Module : CA-GTF-BS
• EKDF Table for Document Flow for Logistics Differential Invoice Table Type : TRANSP Package : ME Module : SRM-EBP
• FMFG_DOCT_ADJ Table for Invoice Document types for adjustment delivered Table Type : TRANSP Package : FMFG_BLEXT_E Module : PSM-FG
• IDMX_DI_DOCTYP Table for Digital invoice Mexico: Document types (payment flows) Table Type : TRANSP Package : ID-MX-DI Module : FI-LOC
• IDMX_DI_FIDCTP Table for Digital Invoice Mexico: Special FI Document Types (SAT) Table Type : TRANSP Package : ID-MX-DI Module : FI-LOC
• IFW_C_BILL_TYPE Table for Billing document type for provisional invoice Table Type : TRANSP Package : CIWB Module : LO-AB-IFW
• ITLC_DCLASGN_IN Table for Assign Document class to Billing types as per Invoice type Table Type : TRANSP Package : BEA_INDIA Module : CRM-LOC-IN
• RBCO Table for Document Item, Incoming Invoice, Account Assignment Table Type : TRANSP Package : MRM Module : CRM
• RBDRSEG Table for Batch IV: Invoice Document Items Table Type : TRANSP Package : MRM Module : CRM
• RBKP Table for Document Header: Invoice Receipt Table Type : TRANSP Package : MRM Module : CRM
• RBMA Table for Document Item: Incoming Invoice for Material Table Type : TRANSP Package : MRM Module : CRM
• RBVD Table for Invoice Document - Aggregation Data Table Type : TRANSP Package : MRM Module : CRM
• RSEG Table for Document Item: Incoming Invoice Table Type : TRANSP Package : MRM Module : CRM
• RSEG_TM Table for TM Document Items Incoming Invoice Table Type : TRANSP Package : MRM Module : CRM
• VBRL Table for Sales Document: Invoice List Table Type : TRANSP Package : VF Module : AP-PRC-PR
• FINB_TNOASS_NRO Table for Assignment of Accounting System to Number Range Object Table Type : TRANSP Package : FINB_DOC_NUMBER_ASSIGNMENT Module : FIN-BAC-AE
• T5C2I Table for WhT Accounting Number Table Type : TRANSP Package : PB02 Module : PA-PA-CH
• ACCJOURNAL0C Table for Obsolete: Former: Journals in the Accounting Document Table Type : TRANSP Package : FINB_ACCJOURNAL Module : FIN-FB
• BKPF Table for Accounting Document Header Table Type : TRANSP Package : FBAS Module : CRM
• BKPF_ADD Table for Accounting Document Header Table Type : TRANSP Package : FAGL_DB_PERSISTENCY Module : FI-GL
• BSEG Table for Accounting Document Segment Table Type : CLUSTER Package : FBAS Module : CRM
• BSEG_ADD Table for Entry View of Accounting Document for Additional Ledgers Table Type : TRANSP Package : FAGL_DB_PERSISTENCY Module : FI-GL
• CRMC_PS_ACC_ST Table for Accounting Status of Net Calculation Document /Item Table Type : TRANSP Package : CRM_PS_SSF_CUST Module : CRM-IPS-BTX-SSP
• CRMC_PS_ACC_ST_T Table for Text for Accounting Status of Net Calculation Document /Item Table Type : TRANSP Package : CRM_PS_SSF_CUST Module : CRM-IPS-BTX-SSP
• DFKKKO Table for Header Data in Open Item Accounting Document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKKO_SHORT Table for Header Data for Contract Accounting Document - Extracts Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKMKO Table for Header data for sample contract accounting document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKOPKX Table for Items for Contract Accounting Document (Enhancement) Table Type : TRANSP Package : FKKB Module : FI-CA
• FINACHD Table for Accounting Document Header Table Type : TRANSP Package : FINB_ACC_DOCUMENT Module : FIN-BAC-AE
• IDCN_DOCTYPE Table for Accounting Document Types (Golden Audit) Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
• PPDHD Table for Transfer to Accounting: Document Header Table Type : TRANSP Package : PCPO Module : PY-XX-DT
• TJL05 Table for IS-M/SD: Document Types for Transfer to Financial Accounting Table Type : TRANSP Package : JSD Module : IS-M
• TRACT_DOCUMENT Table for Treasury: Accounting Adaptor Document Table Type : TRANSP Package : FTR_ACCOUNTING_ADAPTOR Module : FIN-FSCM-TRM-TM-AC
• DPAY_CHEZAG Table for ZTF Switzerland: Assignment of POR Number to Document Number Table Type : TRANSP Package : FKKB Module : FI-CA
• ITLC_NGRP_ASG Table for Assign Number Group for Official Document Number Table Type : TRANSP Package : BEA_INTERNATIONAL Module : CRM-LOC
• OFF_NUM_LV2 Table for Assign Number Ranges to Document Class, Number Group, Date Table Type : TRANSP Package : FIN1 Module : FI
• TE003B Table for Document Number Assignment: Parallel Number Range Table Type : TRANSP Package : EE21 Module : IS-U-IN
• TE003E Table for Document Number Assignment: Number Range Objects Table Type : TRANSP Package : EE21 Module : IS-U-IN
• TE004E Table for Document Number Assignment: Number Range Objects Table Type : TRANSP Package : EE25 Module : IS-U-IN
• TFK2600A Table for Document Number Assignment: Number Range Objects Table Type : TRANSP Package : FKKINV Module : FI-CA-INV
• J_3RSIBELNR_FI Table Data element for Invoice Document Number in Financial Accounting
• BEA_ICV_FI_DOC_TYPE Table Data element for Accounting Document Type for Vendor Invoice
• FPRL_REBZZ Table Data element for Line Item within Accounting Document or Relevant Invoice
• AWREF_REB Table Data element for Invoice reference: Document number for invoice reference
• PRONU Table Data element for Invoice: Number of invoice document for import processing
• /SAPHT/DRM_INVDOCNO Table Data element for Sell-in invoice/ invoice receipt document number
• /SAPHT/DRM_INVDOCITM Table Data element for Sell-In invoice/ invoice receipt document item number
• RBWWR Table Data element for Invoice amount in document currency of vendor invoice
• PRODA Table Data element for Invoice: Date of invoice document for import processing
• J_1AFIACT Table Data element for Inflation Accounting Active for Financial Accounting (FI)
• J_1AAMACT Table Data element for Inflation Accounting Active for Asset Accounting (FI-AA)
• RERAACCSYSTYPEGL Table Data element for Accounting System for General Ledger Accounting

Accounting document number and invoice number related terms

Definitions.

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

Popular Table Searches

Latest table searches.

ALTERYX CONNECTORS

Knime connectors, tableau connectors, power bi connectors.

• Alteryx Connector for SAP
• Alteryx RPA Tools
• Alteryx Connector for SAP Customer Experience (CX)
• Alteryx Connector for SAP SuccessFactors
• Alteryx Connector for SAP BusinessObjects
• KNIME Connector for SAP
• KNIME Connector for SAP SuccessFactors
• Power BI Connector for SAP
• Tableau Connector for SAP
• Dataiku Connectors
• Snowflake Connectors
• Alteryx Connector Demos
• KNIME Connector Demos
• Power BI Connector Demos
• Tableau Connector Demos
• Dataiku Connector Demos
• Snowflake Connector for SAP
• Alteryx Connector Webinars
• KNIME Connector Webinars
• Power BI Connector Webinars
• Tableau Connector Webinars
• Snowflake Connector Webinars
• Alteryx Connector Pricing
• KNIME Connector Pricing
• Power BI Connector Pricing
• Tableau Connector Pricing
• Dataiku Connector Pricing
• Snowflake Connector Pricing
• Sample Workflows
• Help Centre
• BVOR - Intercompany posting procedures
• BSIP - Index for Vendor Validation of Double Documents (Note: "Double" means Duplicate)
• BSID - Accounting: Secondary Index for Customers (Open Items) 
• BSAD -  Accounting: Secondary Index for Customers (Cleared Items) 
• BSIK - Accounting: Secondary Index for Vendors (Open Items)
• BSAK - Accounting: Secondary Index for Vendors (Cleared Items)
• ​ BSIS - Accounting: Secondary Index for G/L accounts (Open Items)
• BSAS - Accounting: Secondary Index for G/L Accounts (Cleared Items) 
• BSEC - One-Time Account Data Document Segment
• ​BSET - Tax Data Document Segment

Key SAP Controlling (CO) Transaction Data Tables

Cost centre accounting.

• COBK - CO Object: Document Header
• COEP - CO Object: Line Items (by Period)
• COSP - CO Object: Cost Totals for External Postings

Profit Centre Accounting

• GLPCC - EC-PCA: Transaction Attributes
• GLPCO - EC-PCA: Object Table for Account Assignment Elements
• GLPCA - EC-PCA: Actual Line Items
• GLPCT - ​EC-PCA: Totals Table

Important SAP Finance and Controlling (FI/CO) Master Data Tables

General ledger .

• SKA1 - G/L Account Master (Chart of Accounts)
• SKAT - G/L Account Master Record (Chart of Accounts: Description)
• SKB1 - G/L account master (Company Code)

Cost Centre

• CSKS - Cost Center Master Record
• CSKT - Cost Center Texts

Cost Element

• CSKA - ​Cost Elements (Data Dependent on Chart of Accounts)
• CSKU - Cost Element Texts
• CSKB - Cost Elements (Data Dependent on Controlling Area)

Profit Centre

• CEPC - Profit Center Master Data Table
• CEPCT - Profit Center Master Data​

Accounts Payable - Vendor Master Data

Vendor master - general data.

• LFA1 - Vendor / Supplier Master (General Section)
• ​LFBK - Vendor / Supplier Master (Bank Details)

Vendor Master - Purchasing Data

• LFM1 - Vendor Master Record purchasing organization data
• ​LFM2 - Vendor Master Record: Purchasing Data

Vendor Master - Company Code Data

• LFB1 - Vendor Master (Company Code)
• LFB5 - Vendor master (dunning data)

Accounts Receivable - Customer Master Data

Customer master - general data.

• KNA1 - ​General Data in Customer Master

Customer Master - Sales Area Data

• KNVP - Customer Master Partner Functions
• KNVV - Customer Master Sales Data

Customer Master - Company Code Data

• KNB1 - Customer Master (Company Code)
• ​KNB5 - Customer master (dunning data)

Useful  SAP Finance and Controlling (FI/CO)  Configuration Data Tables

• M_KOSTS - Generated View for Matchcode ID KOST-S (Cost Centre Texts)
• T001 - Company Codes
• T001K - Valuation area
• T077S - G/L account groups
• TBSL and TBSLT - Posting Key and Posting Key Names

SAP S/4HANA Finance Tables

• ACDOCA - Universal Journal Entry Line Items
• BSEG - Accounting Document Segment
• COEP - CO Object: Line Items (by Period)

Other Sources of SAP Table Information

All ACS ACS BOP ACS CX ACS Metadata ACS SF Alteryx Alteryx Connector For BusinessObjects Alteryx Connector For SAP Alteryx Connector For SuccessFactors Alteryx Gallery Alteryx Inspire Alteryx RPA Tools Alteryx Server APA Audit Augmented Analytics BusinessObjects Data Migration DVW Integration Platform Finance KCS KNIME KNIME Connector For SAP Microsoft Azure Office Of Finance On Demand Webinar Power BI Power BI Connector For SAP Predictive Analytics Process Automation Professional Services Qlik Read Tools RPA Salesforce Salesforce Wave Analytics Sample Workflow SAP Business Suite SAP BW SAP C4C SAP ECC SAP ERP SAP HANA SAP S/4HANA SAP Tables SAP T Codes SAP T-Codes SAP Transaction Codes Snowflake Snowflake Connector For SAP SuccessFactors Tableau Tableau Connector For SAP Tableau Desktop Tableau Online Tableau Prep Tableau Server Tax TCS ThoughtSpot Tool: BOP Universe Tool: BOP Webi Tool: HTML RPA Tool: SAP BAPI Read Tool: SAP BAPI Write Tool: SAP BW Write Tool: SAP Document Read Tool: SAP IDoc Tool: SAP Query Tool: SAP Report Tool: SAP RPA Tool: SAP Spool Read Tool: SAP Table Data Tool: SuccessFactors Read Tool: SuccessFactors Write Top 10 Blog Webinar Write Tools

October 2023 June 2023 May 2023 April 2023 March 2023 February 2023 January 2023 October 2022 June 2022 May 2022 April 2022 March 2022 February 2022 December 2021 November 2021 October 2021 May 2021 April 2021 December 2020 October 2020 July 2020 June 2020 May 2020 February 2020 November 2019 October 2019 September 2019 August 2019 July 2019 June 2019 May 2019 September 2018 August 2018 June 2018 April 2018 February 2018 July 2017 April 2017 March 2017 February 2017 January 2017 December 2016 October 2016 September 2016 August 2016 July 2016 June 2016 May 2016 November 2015