SAP table ERCHC (Invoicing/Reversal History: ERCH)
SAP table ERCHC has 3 primary key fields being MANDT,BELNR,LFDNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | MANDT | ||||||
| BELNR | Billing Document Number | CHAR | 12 | 0 | E_BELNR | ||||||
| LFDNR | Sequence Number (Internal Use Only) | NUMC | 3 | 0 | LFDNR_KK | ||||||
| OPBEL | Number of print document | CHAR | 12 | 0 | E_PRINTDOC | ||||||
| CPUDT | Day On Which Accounting Document Was Entered | DATS | 8 | 0 | CPUDT | ||||||
| BUDAT | Posting Date in the Document | DATS | 8 | 0 | BUDAT | ||||||
| INTOPBEL | Number of Print Document Used to Reverse Document | CHAR | 12 | 0 | INTOPBEL | ||||||
| INTCPUDT | Date on which invoicing reversal was entered | DATS | 8 | 0 | INTCPUDT | ||||||
| INTBUDAT | Posting date of invoicing reversal | DATS | 8 | 0 | INTBUDAT | ||||||
| TOBRELEASD | Indicator: document not released yet | CHAR | 1 | 0 | TOBRELEASD | ||||||
| SIMULATED | Indicator: invoicing generates a simulated document | CHAR | 1 | 0 | SIMULATED | ||||||
| INVOICED | Indicator: document posted | CHAR | 1 | 0 | INVOICED | ||||||
| SPCANC | Adjustment Reversal | CHAR | 1 | 0 | SPCANC |
|
|||||
| STATUPD | Document Entered in Sales Statistics | CHAR | 1 | 0 | STATUPD | ||||||
| STATUPD_CANC | Reversal Document Entered in Sales Statistics | CHAR | 1 | 0 | STATUPD_CANC | ||||||
| COLOGRP_INST | Colocation group for Installation | CHAR | 12 | 0 | E_COLOGRP_INST |