| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | KKBER | Credit control area | nvarchar | 4 | 0 | CHAR | (N' ') | No | T014 | KKBER | Allow NULL? |
| 3 | CTLPC | Credit management: Risk category | nvarchar | 3 | 0 | CHAR | (N' ') | No | T691A | CTLPC_CM | Allow NULL? |
| 4 | CRMGR | Document credit group | nvarchar | 2 | 0 | CHAR | (N' ') | No | T691D | CRMGR_CM | Allow NULL? |
| 5 | CRDBI | Credit check of vendor balance | char | 1 | 0 | CHAR | (N' ') | Yes | | CRDBI_CM | Allow NULL? |
| 6 | CRPRC | Credit check: Deviation of document value by x % | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | CRPRC_CM | Allow NULL? |
| 7 | CRCRE | Credit check: Acceptance of sales order from new customer | char | 1 | 0 | CHAR | (N' ') | Yes | | CRCRE_CM | Allow NULL? |
| 8 | DKLIM | Credit limit (default setting, unless maintained by cust.) | decimal | 15 | 2 | CURR | ((0)) | Yes | | DKLIM_CM | |
| 9 | SEAAF | Seasonal factor in % | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SEAAF_CM | Allow NULL? |
| 10 | TAGEF | Credit check: Number of days without check | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | TAGEF_CM | Allow NULL? |
| 11 | CMPAA | Credit check: Static check | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAA_CM | Allow NULL? |
| 12 | STVAW | Credit check: Taking into account the open order value | char | 1 | 0 | CHAR | (N' ') | Yes | | STVAW_CM | Allow NULL? |
| 13 | STVLW | Credit check: Take into account open delivery/bill.doc value | char | 1 | 0 | CHAR | (N' ') | Yes | | STVLW_CM | Allow NULL? |
| 14 | STREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 15 | STSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 16 | CMPAB | Credit check: dynamic check | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAB_CM | Allow NULL? |
| 17 | WOVLW | Credit check: Take into account open delivery/bill.doc value | char | 1 | 0 | CHAR | (N' ') | Yes | | STVLW_CM | Allow NULL? |
| 18 | WSWIN | Dynamic credit check: Distance to credit horizon | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | WSWIN_CM | Allow NULL? |
| 19 | WSREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 20 | WLSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 21 | CMPAC | Credit check against maximum document value | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAC_CM | Allow NULL? |
| 22 | MAVAL | Maximum document value | decimal | 15 | 2 | CURR | ((0)) | Yes | | MAVAL_CM | |
| 23 | MAREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 24 | MASET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 25 | CMPAD | Credit check against critical fields (fixed value dates) | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAD_CM | Allow NULL? |
| 26 | FSREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 27 | FSSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 28 | CMPAE | Credit check against next customer review date | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAE_CM | Allow NULL? |
| 29 | RVTOL | Number of days that the next int.review may be overdue | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | RVTOL_CM | Allow NULL? |
| 30 | RSREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 31 | RESET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 32 | CMPAF | Credit check against overdue open items | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAF_CM | Allow NULL? |
| 33 | PDMAX | Maximum percentage of overdue open items/customer balance | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PDMAX_CM | Allow NULL? |
| 34 | PDTOL | Number of days for considering open items | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PDTOL_CM | Allow NULL? |
| 35 | PDREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 36 | PDSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 37 | CMPAG | Credit check against oldest open item | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAG_CM | Allow NULL? |
| 38 | OITOL | Number of days the oldest open item can be overdue | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | OITOL_CM | Allow NULL? |
| 39 | OIREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 40 | OISET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 41 | CMPAH | Credit check against highest dunning level allowed | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAH_CM | Allow NULL? |
| 42 | DUNNG | Highest dunning level allowed | char | 1 | 0 | NUMC | (N'0') | Yes | | DUNNG_CM | Allow NULL? |
| 43 | DNREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 44 | DNSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 45 | CMPAI | Credit check against special G/L transactions in FI | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAI_CM | Allow NULL? |
| 46 | SPVAL | Allowed value for special items of the customer | decimal | 15 | 2 | CURR | ((0)) | Yes | | SPVAL_CM | |
| 47 | SPREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 48 | SPSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 49 | CMPAJ | Credit check of reserves | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAJ_CM | Allow NULL? |
| 50 | PJREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 51 | PJSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 52 | CMPAK | Credit check of reserves | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAK_CM | Allow NULL? |
| 53 | PKREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 54 | PKSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 55 | CMPAL | Credit check of reserves | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAL_CM | Allow NULL? |
| 56 | PLREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 57 | PLSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 58 | USRPR0 | Credit check for customer reserve 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPA0_CM | Allow NULL? |
| 59 | USR0REA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 60 | USR0SET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 61 | USRPR1 | Credit check for customer reserve 2 | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPA1_CM | Allow NULL? |
| 62 | USR1REA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 63 | USR1SET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 64 | USRPR2 | Credit check for customer reserve 3 | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPA2_CM | Allow NULL? |
| 65 | USR2REA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 66 | USR2SET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 67 | CMPAM | Credit Check SAP Credit Management | char | 1 | 0 | CHAR | (N' ') | Yes | | CMPAM_CM | Allow NULL? |
| 68 | PMREA | Credit check: System reaction (warning, error) | char | 1 | 0 | CHAR | (N' ') | Yes | | STREA_CM | Allow NULL? |
| 69 | PMSET | Credit check: Set credit status (block) | char | 1 | 0 | CHAR | (N' ') | Yes | | STSET_CM | Allow NULL? |
| 70 | CECKI | Credit checks during header/item processing | char | 1 | 0 | CHAR | (N' ') | Yes | | CECKI_CM | Allow NULL? |
| 71 | REGUL | FI checks only against current payer | char | 1 | 0 | CHAR | (N' ') | Yes | | REGUL_CM | Allow NULL? |
| 72 | GRPNO | Number of the routine used for copying | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | * | GRPNO | Allow NULL? |
| 73 | DVSEA | Beginning of validity period for seasonal factor | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DVSEA | Allow NULL? |
| 74 | DBSEA | End of validity period for seasonal factor | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | DBSEA | Allow NULL? |
| 75 | ERLTA | Permitted Ageing in Days | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ERLTA | Allow NULL? |
| 76 | ERLST | Permitted Ageing in Hours | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | ERLST | Allow NULL? |
| 77 | SEAAFPM | Minus sign for % rate of extra credit limit-seasonal factor | char | 1 | 0 | CHAR | (N' ') | Yes | | SEAAFPM_CM | Allow NULL? |