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
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