TVZ03 SAP (Flow control of advance payments and overpayments) Pooled Table details
Description: Flow control of advance payments and overpayments
Pooled Table field list including key, data, relationships and ABAP select examples
TVZ03 is a standard SAP Pooled Table which is used to store Flow control of advance payments and overpayments data and is available within R/3 SAP systems depending on the version and release level.
The TVZ03 table consists of various fields, each holding specific information or linking keys about Flow control of advance payments and overpayments data available in SAP. These include BUKRS (Company Code), RANTYP (Contract Type), SPRIO (Processing level / priority level flow control), SKRIT (Criterion for flow logic in planned record processing/IPD).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TVZ03 pooled 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 | T000 | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
RANTYP | Contract Type | RANTYP | CHAR | 1 | RANTYP | ||||
SPRIO | Processing level / priority level flow control | VVSPRIO | NUMC | 2 | NUM2 | ||||
SKRIT | Criterion for flow logic in planned record processing/IPD | VVSKRIT2 | CHAR | 4 | TVZ06 | VVSKRIT2 | |||
SEFFKAP | Effective Capital Available | VVSEFFKAP | CHAR | 1 | CHAR1 | ||||
SFAELLIG | Next Due Date | VVSFAELLIG | CHAR | 1 | CHAR1 | ||||
SANTEILIG | Proportional Planned Value Calculation | VVANTEIL | CHAR | 1 | CHAR1 | ||||
SBTAGE | Upto days from system date | VVSBTAGE | INT4 | 10 | INT4 | ||||
SBEWART | Flow Type | SBEWART | CHAR | 4 | TZB0A | SBEWART | |||
SMANU | Manual debit position / manually created planned records | VVSMANU | CHAR | 1 | CHAR1 | ||||
SMASU | Automatic debit position / memo records | VVSMASU | CHAR | 1 | CHAR1 | ||||
SGRENZE | Trivial Amount Limit | VVBAGATELL | CURR | 13(2) | WERTV7 |
Key field | Non-key field |
How do I retrieve data from SAP table TVZ03 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TVZ03 to SELECT all data from the tableDATA: WA_TVZ03 TYPE TVZ03.
SELECT SINGLE *
FROM TVZ03
INTO CORRESPONDING FIELDS OF WA_TVZ03
WHERE...
How to access SAP table TVZ03
Within an ECC or HANA version of SAP you can also view further information about TVZ03 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