T691F SAP (Control of Automatic Credit Control) Table details
Dictionary Type: Table
Description: Control of Automatic Credit Control
Description: Control of Automatic Credit Control
Table field list including key, data, relationships and ABAP select examples
T691F is a standard SAP Table which is used to store Control of Automatic Credit Control data and is available within R/3 SAP systems depending on the version and release level.
The T691F table consists of various fields, each holding specific information or linking keys about Control of Automatic Credit Control data available in SAP. These include KKBER (Credit control area), CTLPC (Credit management: Risk category), CRMGR (Document credit group), CRDBI (Credit check of vendor balance).. 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: Can be enhanced (character-type or numeric)
Text table = T691G
SAP T691F 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 | |||
KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
CTLPC | Credit management: Risk category | CTLPC_CM | CHAR | 3 | T691A | CTLPC_CM | |||
CRMGR | Document credit group | CRMGR_CM | CHAR | 2 | T691D | CRMGR_CM | |||
CRDBI | Credit check of vendor balance | CRDBI_CM | CHAR | 1 | XFELD | ||||
CRPRC | Credit check: Deviation of document value by x % | CRPRC_CM | NUMC | 3 | ABPRC | ||||
CRCRE | Credit check: Acceptance of sales order from new customer | CRCRE_CM | CHAR | 1 | XFELD | ||||
DKLIM | Credit limit (default setting, unless maintained by cust.) | DKLIM_CM | CURR | 15(2) | WERT8 | ||||
SEAAF | Seasonal factor in % | SEAAF_CM | NUMC | 3 | ABPRC | ||||
TAGEF | Credit check: Number of days without check | TAGEF_CM | NUMC | 3 | ANZTA | ||||
CMPAA | Credit check: Static check | CMPAA_CM | CHAR | 1 | XFELD | ||||
STVAW | Credit check: Taking into account the open order value | STVAW_CM | CHAR | 1 | XFELD | ||||
STVLW | Credit check: Take into account open delivery/bill.doc value | STVLW_CM | CHAR | 1 | XFELD | ||||
STREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
STSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAB | Credit check: dynamic check | CMPAB_CM | CHAR | 1 | XFELD | ||||
WOVLW | Credit check: Take into account open delivery/bill.doc value | STVLW_CM | CHAR | 1 | XFELD | ||||
WSWIN | Dynamic credit check: Distance to credit horizon | WSWIN_CM | NUMC | 3 | LAEPE | ||||
WSREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
WLSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAC | Credit check against maximum document value | CMPAC_CM | CHAR | 1 | XFELD | ||||
MAVAL | Maximum document value | MAVAL_CM | CURR | 15(2) | WERTV8 | ||||
MAREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
MASET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAD | Credit check against critical fields (fixed value dates) | CMPAD_CM | CHAR | 1 | XFELD | ||||
FSREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
FSSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAE | Credit check against next customer review date | CMPAE_CM | CHAR | 1 | XFELD | ||||
RVTOL | Number of days that the next int.review may be overdue | RVTOL_CM | NUMC | 3 | ANZTA | ||||
RSREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
RESET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAF | Credit check against overdue open items | CMPAF_CM | CHAR | 1 | XFELD | ||||
PDMAX | Maximum percentage of overdue open items/customer balance | PDMAX_CM | NUMC | 3 | ABPRC | ||||
PDTOL | Number of days for considering open items | PDTOL_CM | NUMC | 3 | ANZTA | ||||
PDREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
PDSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAG | Credit check against oldest open item | CMPAG_CM | CHAR | 1 | XFELD | ||||
OITOL | Number of days the oldest open item can be overdue | OITOL_CM | NUMC | 3 | ANZTA | ||||
OIREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
OISET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAH | Credit check against highest dunning level allowed | CMPAH_CM | CHAR | 1 | XFELD | ||||
DUNNG | Highest dunning level allowed | DUNNG_CM | NUMC | 1 | MAHNS | ||||
DNREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
DNSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAI | Credit check against special G/L transactions in FI | CMPAI_CM | CHAR | 1 | XFELD | ||||
SPVAL | Allowed value for special items of the customer | SPVAL_CM | CURR | 15(2) | WERTV8 | ||||
SPREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
SPSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAJ | Credit check of reserves | CMPAJ_CM | CHAR | 1 | XFELD | ||||
PJREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
PJSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAK | Credit check of reserves | CMPAK_CM | CHAR | 1 | XFELD | ||||
PKREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
PKSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAL | Credit check of reserves | CMPAL_CM | CHAR | 1 | XFELD | ||||
PLREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
PLSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
USRPR0 | Credit check for customer reserve 1 | CMPA0_CM | CHAR | 1 | XFELD | ||||
USR0REA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
USR0SET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
USRPR1 | Credit check for customer reserve 2 | CMPA1_CM | CHAR | 1 | XFELD | ||||
USR1REA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
USR1SET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
USRPR2 | Credit check for customer reserve 3 | CMPA2_CM | CHAR | 1 | XFELD | ||||
USR2REA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
USR2SET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CMPAM | Credit Check SAP Credit Management | CMPAM_CM | CHAR | 1 | XFELD | ||||
PMREA | Credit check: System reaction (warning, error) | STREA_CM | CHAR | 1 | FEDIAE | ||||
PMSET | Credit check: Set credit status (block) | STSET_CM | CHAR | 1 | XFELD | ||||
CECKI | Credit checks during header/item processing | CECKI_CM | CHAR | 1 | XFELD | ||||
REGUL | FI checks only against current payer | REGUL_CM | CHAR | 1 | XFELD | ||||
GRPNO | Number of the routine used for copying | GRPNO | NUMC | 3 | Assigned to domain | GRPNO | |||
DVSEA | Beginning of validity period for seasonal factor | DVSEA | DATS | 8 | DATUM | ||||
DBSEA | End of validity period for seasonal factor | DBSEA | DATS | 8 | DATUM | ||||
ERLTA | Permitted Ageing in Days | ERLTA | NUMC | 2 | NUM2 | ||||
ERLST | Permitted Ageing in Hours | ERLST | NUMC | 2 | NUM2 | ||||
SEAAFPM | Minus sign for % rate of extra credit limit-seasonal factor | SEAAFPM_CM | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table T691F using ABAP code
The following ABAP code Example will allow you to do a basic selection on T691F to SELECT all data from the tableDATA: WA_T691F TYPE T691F.
SELECT SINGLE *
FROM T691F
INTO CORRESPONDING FIELDS OF WA_T691F
WHERE...
How to access SAP table T691F
Within an ECC or HANA version of SAP you can also view further information about T691F 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