SAP Table RJHCMP_LINE

IS-M/AM: Credit Management: Work Structure for Credit Check

RJHCMP_LINE (IS-M/AM: Credit Management: Work Structure for Credit Check) 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 RJHCMP_LINE to other SAP tables.

RJHCMP_LINE table fields

Field Data element Checktable Datatype Length Decimals
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
MANDT Client MANDT T000 CLNT 3 0
KKBER Credit control area KKBER T014 CHAR 4 0
CTLPC Credit management: Risk category CTLPC_CM T691A CHAR 3 0
CRMGR Document credit group CRMGR_CM T691D CHAR 2 0
CRDBI Credit check of vendor balance CRDBI_CM CHAR 1 0
X Yes
NULL No
CRPRC Credit check: Deviation of document value by x % CRPRC_CM NUMC 3 0
CRCRE Credit check: Acceptance of sales order from new customer CRCRE_CM CHAR 1 0
X Yes
NULL No
DKLIM Credit limit (default setting, unless maintained by cust.) DKLIM_CM CURR 15 2
SEAAF Seasonal factor in % SEAAF_CM NUMC 3 0
TAGEF Credit check: Number of days without check TAGEF_CM NUMC 3 0
CMPAA Credit check: Static check CMPAA_CM CHAR 1 0
X Yes
NULL No
STVAW Credit check: Taking into account the open order value STVAW_CM CHAR 1 0
X Yes
NULL No
STVLW Credit check: Take into account open delivery/bill.doc value STVLW_CM CHAR 1 0
X Yes
NULL No
STREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
STSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAB Credit check: dynamic check CMPAB_CM CHAR 1 0
X Yes
NULL No
WOVLW Credit check: Take into account open delivery/bill.doc value STVLW_CM CHAR 1 0
X Yes
NULL No
WSWIN Dynamic credit check: Distance to credit horizon WSWIN_CM NUMC 3 0
WSREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
WLSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAC Credit check against maximum document value CMPAC_CM CHAR 1 0
X Yes
NULL No
MAVAL Maximum document value MAVAL_CM CURR 15 2
MAREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
MASET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAD Credit check against critical fields (fixed value dates) CMPAD_CM CHAR 1 0
X Yes
NULL No
FSREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
FSSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAE Credit check against next customer review date CMPAE_CM CHAR 1 0
X Yes
NULL No
RVTOL Number of days that the next int.review may be overdue RVTOL_CM NUMC 3 0
RSREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
RESET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAF Credit check against overdue open items CMPAF_CM CHAR 1 0
X Yes
NULL No
PDMAX Maximum percentage of overdue open items/customer balance PDMAX_CM NUMC 3 0
PDTOL Number of days for considering open items PDTOL_CM NUMC 3 0
PDREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
PDSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAG Credit check against oldest open item CMPAG_CM CHAR 1 0
X Yes
NULL No
OITOL Number of days the oldest open item can be overdue OITOL_CM NUMC 3 0
OIREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
OISET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAH Credit check against highest dunning level allowed CMPAH_CM CHAR 1 0
X Yes
NULL No
DUNNG Highest dunning level allowed DUNNG_CM NUMC 1 0
DNREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
DNSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAI Credit check against special G/L transactions in FI CMPAI_CM CHAR 1 0
X Yes
NULL No
SPVAL Allowed value for special items of the customer SPVAL_CM CURR 15 2
SPREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
SPSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAJ Credit check of reserves CMPAJ_CM CHAR 1 0
X Yes
NULL No
PJREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
PJSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAK Credit check of reserves CMPAK_CM CHAR 1 0
X Yes
NULL No
PKREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
PKSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAL Credit check of reserves CMPAL_CM CHAR 1 0
X Yes
NULL No
PLREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
PLSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
USRPR0 Credit check for customer reserve 1 CMPA0_CM CHAR 1 0
X Yes
NULL No
USR0REA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
USR0SET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
USRPR1 Credit check for customer reserve 2 CMPA1_CM CHAR 1 0
X Yes
NULL No
USR1REA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
USR1SET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
USRPR2 Credit check for customer reserve 3 CMPA2_CM CHAR 1 0
X Yes
NULL No
USR2REA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
USR2SET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CMPAM Credit Check SAP Credit Management CMPAM_CM CHAR 1 0
X Yes
NULL No
PMREA Credit check: System reaction (warning, error) STREA_CM CHAR 1 0
NULL No message
A Warning
B Error message
C Like A + value by which the credit limit has been exceeded
D Like B + value by which the credit limit has been exceeded
PMSET Credit check: Set credit status (block) STSET_CM CHAR 1 0
X Yes
NULL No
CECKI Credit checks during header/item processing CECKI_CM CHAR 1 0
X Yes
NULL No
REGUL FI checks only against current payer REGUL_CM CHAR 1 0
X Yes
NULL No
GRPNO Number of the routine used for copying GRPNO NUMC 3 0
DVSEA Beginning of validity period for seasonal factor DVSEA DATS 8 0
DBSEA End of validity period for seasonal factor DBSEA DATS 8 0
ERLTA Permitted Ageing in Days ERLTA NUMC 2 0
ERLST Permitted Ageing in Hours ERLST NUMC 2 0
SEAAFPM Minus sign for % rate of extra credit limit-seasonal factor SEAAFPM_CM CHAR 1 0
X Yes
NULL No
WAERS Currency key of credit control area WAERS_CM TCURC CUKY 5 0
ORDER_VALUE 8(15)-character value field with 2 decimal places WERTV8 CURR 15 2
ORDER_DELTA_VALUE 8(15)-character value field with 2 decimal places WERTV8 CURR 15 2
DATE_CREDIT_EXPOSURE System Date SYDATUM DATS 8 0
SUBRC Return Code SYSUBRC INT4 10 0
RETURNCODE Return Code SYSUBRC INT4 10 0
CMPSA Status of static credit limit check CMPSA CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSB Status of dynamic credit limit check in the credit horizon CMPSB CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSC Status of credit check against maximum document value CMPSC CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSD Status of credit check against terms of payment CMPSD CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSE Status of credit check against customer review date CMPSE CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSF Status of credit check against open items due CMPSF CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSG Status of credit check against oldest open items CMPSG CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSH Status of credit check against highest dunning level CMPSH CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSI Status of credit check against financial document CMPSI CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSJ Status of credit check against export credit insurance CMPSJ CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSK Status of credit check against payment card authorization CMPSK CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSL Status of credit check of reserves 4 CMPSL CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS0 Status of credit check for customer reserve 1 CMPS0 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS1 Status of credit check for customer reserve 2 CMPS1 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS2 Status of credit check for customer reserve 3 CMPS2 CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPSM Credit check data is obsolete CMPSM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMGST Overall status of credit checks CMGST CHAR 1 0
NULL Credit check was not executed/Status not set
A Credit check was executed, document OK
B Credit check was executed, document not OK
C Credit check was executed, document not OK, partial release
D Document released by credit representative
CMPS_CM Status of Credit Check SAP Credit Management CMPS_CM CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative
CMPS_TE Status of Technical Error SAP Credit Management CMPS_TE CHAR 1 0
NULL Credit check was not executed
A Credit check was executed, document OK
B Credit check was executed, document not OK
D Document released by credit representative

RJHCMP_LINE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RJHCMP_LINE CRMGR RJHCMP_LINE MANDT T691D Credit groups for document types MANDT
RJHCMP_LINE CRMGR RJHCMP_LINE CRMGR T691D Credit groups for document types CRMGR_CM
RJHCMP_LINE CTLPC RJHCMP_LINE CTLPC T691A Credit management risk categories CTLPC
RJHCMP_LINE CTLPC RJHCMP_LINE KKBER T691A Credit management risk categories KKBER
RJHCMP_LINE CTLPC RJHCMP_LINE MANDT T691A Credit management risk categories MANDT
RJHCMP_LINE KKBER RJHCMP_LINE MANDT T014 Credit control areas MANDT
RJHCMP_LINE KKBER RJHCMP_LINE KKBER T014 Credit control areas KKBER
RJHCMP_LINE KUNNR RJHCMP_LINE MANDT KNA1 General Data in Customer Master MANDT
RJHCMP_LINE KUNNR RJHCMP_LINE KUNNR KNA1 General Data in Customer Master KUNNR
RJHCMP_LINE MANDT RJHCMP_LINE MANDT T000 Clients MANDT
RJHCMP_LINE WAERS RJHCMP_LINE WAERS TCURC Currency Codes WAERS
RJHCMP_LINE WAERS RJHCMP_LINE MANDT TCURC Currency Codes MANDT