SAP ABAP Table KBS1 (CKBS + CKBT)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-CIC (Application Component) Interaction Center WinClient
⤷ KKEK (Package) Cost accounting unit costing
⤷ CRM-CIC (Application Component) Interaction Center WinClient
⤷ KKEK (Package) Cost accounting unit costing
Basic Data
Table Category | INTTAB | Structure |
Structure | KBS1 | Table Relationship Diagram |
Short Description | CKBS + CKBT |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
2 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
3 | EXTNR | EXTNR | EXTNR | CHAR | 18 | 0 | Base Planning Object (External Number) | CKBS | |
4 | OBJID | OBJID | OBJID | CHAR | 10 | 0 | Cost Estimate Number | ||
5 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | * | |
6 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
7 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
8 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | * | |
9 | ESORT | ESORT | STATE | CHAR | 4 | 0 | External Sort Field | ||
10 | ERFNM | ERFNM | USNAM | CHAR | 12 | 0 | Entered by | ||
11 | ERFDT | ERFDT | DATUM | DATS | 8 | 0 | Created on | ||
12 | AENDT | AENDT | DATUM | DATS | 8 | 0 | Date of last change | ||
13 | AENNM | AENNM | USNAM | CHAR | 12 | 0 | Last changed by | ||
14 | FRFLG | FRFLG | YNFLG | CHAR | 1 | 0 | Release Flag | ||
15 | DLFLG | DLFLG | YNFLG | CHAR | 1 | 0 | Deletion Flag for Unit Costing | ||
16 | SPRAS | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
17 | TXN08 | TXN08 | TXN08 | CHAR | 8 | 0 | Number of the standard text | ||
18 | KTEXT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
19 | LTEXT | KLTXT | TEXT40 | CHAR | 40 | 0 | Description | ||
20 | BTGRP | BTGRP | CHAR4 | CHAR | 4 | 0 | Base Planning Object Group | TCK40 | |
21 | HWGES | HWGES | CVAL8 | CURR | 15 | 2 | Total Value of Cost Estimate in Local Currency | ||
22 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
23 | LOSGR | MENGE_KPF | CQUA8 | QUAN | 15 | 3 | Lot Size | ||
24 | MEEHT | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
25 | VERSA | VERS_AKT | VERS2 | NUMC | 2 | 0 | Current Costing Version Transferred | * | |
26 | VERSM | VERS_MAX | VERS2 | NUMC | 2 | 0 | Highest Costing Version Transferred | * | |
27 | PREIS | SPREIS | CVAL8 | CURR | 15 | 2 | Price per Unit of Measure Calculated in Cost Estimate | ||
28 | ANRED | ANRED | TEXT15 | CHAR | 15 | 0 | Title | ||
29 | NAME1 | NAME1_GP | NAME | CHAR | 35 | 0 | Name 1 | ||
30 | NAME2 | NAME2_GP | NAME | CHAR | 35 | 0 | Name 2 | ||
31 | NAME3 | NAME3_GP | NAME | CHAR | 35 | 0 | Name 3 | ||
32 | NAME4 | NAME4_GP | NAME | CHAR | 35 | 0 | Name 4 | ||
33 | STRAS | STRAS_GP | TEXT35 | CHAR | 35 | 0 | House number and street | ||
34 | PFACH | PFACH | PFACH | CHAR | 10 | 0 | PO Box | ||
35 | PSTL2 | PSTL2 | PSTLZ | CHAR | 10 | 0 | P.O. Box Postal Code | ||
36 | LAND1 | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
37 | PSTLZ | PSTLZ | PSTLZ | CHAR | 10 | 0 | Postal Code | ||
38 | ORT01 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
39 | ORT02 | ORT01_GP | TEXT35 | CHAR | 35 | 0 | City | ||
40 | REGIO | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
41 | INLND | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
42 | ANZZL | KKEK_DEC3 | KKEK_DEC3 | DEC | 3 | 0 | 3-figure data element | ||
43 | WAREN | WAREN | WAREN | CHAR | 1 | 0 | Delivery address ID | ||
44 | LINE0 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
45 | LINE1 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
46 | LINE2 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
47 | LINE3 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
48 | LINE4 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
49 | LINE5 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
50 | LINE6 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
51 | LINE7 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
52 | LINE8 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
53 | LINE9 | LINES | LINES | CHAR | 80 | 0 | Address line | ||
54 | LINEK | LINES | LINES | CHAR | 80 | 0 | Address line | ||
55 | KALNR | CK_KALNR | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number for Cost Est. w/o Qty Structure | * | |
56 | KLVAR | CK_KLVAR | KLVAR | CHAR | 4 | 0 | Costing Variant | * | |
57 | HWGFX | HWFIX | CVAL8 | CURR | 15 | 2 | Fixed Portion of Costing Value in Local Currency | ||
58 | KALSM | AUFKALSM | KALSM | CHAR | 6 | 0 | Costing Sheet | * | |
59 | ZSCHL | AUFZSCHL | CHAR6 | CHAR | 6 | 0 | Overhead key |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | KBS1 | BTGRP | TCK40 | BTGRP | |||
2 | KBS1 | BUKRS | T001 | BUKRS | |||
3 | KBS1 | EXTNR | CKBS | EXTNR | |||
4 | KBS1 | HWAER | TCURC | WAERS | |||
5 | KBS1 | INLND | T005 | LAND1 | |||
6 | KBS1 | KOKRS | TKA01 | KOKRS | |||
7 | KBS1 | LAND1 | T005 | LAND1 | |||
8 | KBS1 | MEEHT | T006 | MSEHI | |||
9 | KBS1 | REGIO | T005S | BLAND | |||
10 | KBS1 | SPRAS | T002 | SPRAS | |||
11 | KBS1 | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |