TDESRVDINVIH SAP (CML Corr.: Invoice Header) Table details
Dictionary Type: Table
Description: CML Corr.: Invoice Header
Description: CML Corr.: Invoice Header
Table field list including key, data, relationships and ABAP select examples
TDESRVDINVIH is a standard SAP Table which is used to store CML Corr.: Invoice Header data and is available within R/3 SAP systems depending on the version and release level.
The TDESRVDINVIH table consists of various fields, each holding specific information or linking keys about CML Corr.: Invoice Header data available in SAP. These include SRECHNGNR (CML Corr.: Loan Invoice, Invoice Number), SRECHNGJAHR (Calendar Year of the Invoice Number), BUKRS (Company Code), RPARTNR (Business Partner Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP TDESRVDINVIH table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
SRECHNGNR | CML Corr.: Loan Invoice, Invoice Number | TB_ESRINVOICENR | NUMC | 10 | T_ESRINVOICENR | ||||
SRECHNGJAHR | Calendar Year of the Invoice Number | VVRECHNGJAHR | NUMC | 4 | GJAHR | GJAHR | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
RPARTNR | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RPARTNR_ADR_REF | Address ID | BP_ADR_REF_NEW | CHAR | 10 | Assigned to domain | BU_ADRKIND | |||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | KUN | C_KUNNR |
RDARNEHM | Business Partner Number | BP_PARTNR_NEW | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RDARNEHM_ADR_REF | Address ID | BP_ADR_REF_NEW | CHAR | 10 | Assigned to domain | BU_ADRKIND | |||
HDN_KUNNR | Main Borrower Customer Number | HDN_KUNNR | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
SBWHR | Position Currency (Currency of Position Amount) | SBWHR | CUKY | 5 | Assigned to domain | WAERS | |||
DZLSCH | Payment Method | DZLSCH | CHAR | 1 | Assigned to domain | ZLSCH | |||
DINVFROM | Start Date for Due Period of Open Items | VVDINVFROM | DATS | 8 | DDAT | ||||
DINVTO | End Date for Due Period of Open Items | VVDINVTO | DATS | 8 | DDAT | ||||
INVALLOPENITEMS | CML Corr.: Print OI With Invoice Number | TB_ESRINVALLOPENITEMS | CHAR | 1 | XFELD | ||||
INVCOLLECT | CML Corr.: Grouping Option: Group Invoices | TB_ESRINVCOLLECT | CHAR | 1 | T_ESRINVCOLLECT | ||||
INVPERIOD | Grouping option: divide up invoices for each ... | RECPINVPERIOD | CHAR | 1 | RECPINVPERIOD | ||||
PLANACTUAL | CML Corr.:Sel. of Cash Flow Docs.: Plan Record, Act. Records | TB_ESRINVPLANACTUAL | CHAR | 1 | T_ESRINVPLANACTUAL | ||||
INVRESTFI | CML Corr.: Clear Residual Items FI Documents | TB_ESRINVRESTFI | CHAR | 1 | XFELD | ||||
PRINTDATE | Print Date | PRIDT | DATS | 8 | DATUM | ||||
BBWHR | Amount in position currency | BBWHR | CURR | 13(2) | WERTV7 | ||||
SSOLHAB | Debit/credit indicator | VVSSOLHAB | CHAR | 1 | VVSSOLHAB | ||||
DBERVON | Start of Calculation Period | DBERVON | DATS | 8 | DATUM | ||||
DBERBIS | End of Calculation Period | DBERBIS | DATS | 8 | DATUM | ||||
DFAELL | Due date | DFAELL | DATS | 8 | DATUM | ||||
COUNT_RANL | CML Corr.: Number of Loan Contracts for Invoice | TB_ESRCOUNT_RANL | INT4 | 10 | |||||
COUNT_RKLAMMER | CML Corr.: Number of Fin. Projects on Invoice | TB_ESRCOUNT_RKLAMMER | INT4 | 10 | |||||
ALTPAYER | Does business partner act as alternative payer? | RECPALTPAYER | CHAR | 1 | XFELD | ||||
RERF | Entered by | RERF | CHAR | 12 | SYCHAR12 | ||||
DERF | First Entered on | DERF | DATS | 8 | DATUM | ||||
TERF | Time of Initial Entry | TERF | TIMS | 6 | TIMES | ||||
REHER | Source of initial entry | REHER | CHAR | 10 | CHAR10 | ||||
RBEAR | Employee ID | RBEAR | CHAR | 12 | SYCHAR12 | ||||
DBEAR | Last Edited on | DBEAR | DATS | 8 | DATUM | ||||
TBEAR | Last Edited at | TBEAR | TIMS | 6 | TIMES | ||||
RBHER | Editing Source | RBHER | CHAR | 10 | CHAR10 | ||||
RQIDENT | Spool number | RQIDENT | CHAR | 10 | CHAR10 |
Key field | Non-key field |
How do I retrieve data from SAP table TDESRVDINVIH using ABAP code
The following ABAP code Example will allow you to do a basic selection on TDESRVDINVIH to SELECT all data from the tableDATA: WA_TDESRVDINVIH TYPE TDESRVDINVIH.
SELECT SINGLE *
FROM TDESRVDINVIH
INTO CORRESPONDING FIELDS OF WA_TDESRVDINVIH
WHERE...
How to access SAP table TDESRVDINVIH
Within an ECC or HANA version of SAP you can also view further information about TDESRVDINVIH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects