SAP table T014 (Credit control areas)
SAP table T014 has 2 primary key fields being MANDT,KKBER.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
MANDT
Client
CLNT
3
0
T000
MANDT
KKBER
Credit control area
CHAR
4
0
KKBER
WAERS
Currency Key
CUKY
5
0
TCURC
WAERS
STAFO
Credit update for open order/delivery/billing document value
CHAR
6
0
STAFO_CM
Possible values
No update from SD documents
000012
Open order value on time axis, delivery and bill.doct value
000015
Open delivery and billing document value
000018
Open delivery value for sales order, open billing doct value
PERIV
Fiscal Year Variant of Credit Control Area
CHAR
2
0
T009
PERIV_CM
CTLPC
Credit Management: Risk Category New Customer
CHAR
3
0
T691A
CTLPD_CM
KLIMK
Credit limit (default setting, unless maintained by cust.)
CURR
15
2
DKLIM_CM
SBGRP
Credit management representatives group for new customers
CHAR
3
0
T024B
DSBGR_CM
ALLCC
Indicator: Is Posting Possible for All Company Codes?
CHAR
1
0
ALLCC_CM
T014 foreign key relationships
Table
Field
Check Table
Check Field
0 T014
CTLPC
T691A
Credit management risk categories
CTLPC
0 T014
CTLPC
T691A
Credit management risk categories
KKBER
1 T014
MANDT
T000
Clients
MANDT
0 T014
PERIV
T009
Fiscal Year Variants
MANDT
0 T014
PERIV
T009
Fiscal Year Variants
PERIV
1 T014
SBGRP
T024B
Credit management: Credit representative groups
MANDT
1 T014
SBGRP
T024B
Credit management: Credit representative groups
KKBER
0 T014
WAERS
TCURC
Currency Codes
MANDT
0 T014
WAERS
TCURC
Currency Codes
WAERS