SAP-tabelreferentie
CKBS
Base Planning Object - Unit CostingBekijk een andere tabel
Vul een tabelcode of zoekwoord in om verder te zoeken.
Bekijk de structuur, velden en relaties van SAP-tabel CKBS.
SAP-tabel CKBS heeft 3 primaire sleutelvelden: MANDT,KOKRS,EXTNR.
Bij analyse van data uit één SAP-instance is MANDT normaal overal gelijk en kun je dit veld weglaten uit relaties. Combineer je meerdere instances, neem MANDT dan wel op.
/ Velden
CKBS velden.
| Veld | Omschrijving | Datatype | Lengte | Decimalen | Checktabel | Data-element | |
|---|---|---|---|---|---|---|---|
| Sleutel MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Sleutel KOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |
| Sleutel EXTNR | Base Planning Object (External Number) | CHAR | 18 | 0 | EXTNR | ||
| OBJID | Cost Estimate Number | CHAR | 10 | 0 | OBJID | ||
| KSTAR | Cost Element | CHAR | 10 | 0 | * | KSTAR | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| PRCTR | Profit Center | CHAR | 10 | 0 | * | PRCTR | |
| ESORT | External Sort Field | CHAR | 4 | 0 | ESORT | ||
| BTGRP | Base Planning Object Group | CHAR | 4 | 0 | TCK40 | BTGRP | |
| ERFNM | Entered By | CHAR | 12 | 0 | ERFNM | ||
| ERFDT | Entered On | DATS | 8 | 0 | ERFDT | ||
| AENDT | Date of last change | DATS | 8 | 0 | AENDT | ||
| AENNM | Last Changed By | CHAR | 12 | 0 | AENNM | ||
| DLFLG | Deletion Flag for Unit Costing | CHAR | 1 | 0 | DLFLG | ||
| FRFLG | Release Flag | CHAR | 1 | 0 | FRFLG | ||
| VERSA | Current Costing Version Transferred | NUMC | 2 | 0 | * | VERS_AKT | |
| VERSM | Highest Costing Version Transferred | NUMC | 2 | 0 | * | VERS_MAX | |
| HWGES | Total Value of Cost Estimate in Local Currency | CURR | 15 | 2 | HWGES | ||
| HWAER | Local Currency | CUKY | 5 | 0 | TCURC | HWAER | |
| LOSGR | Lot Size | QUAN | 15 | 3 | MENGE_KPF | ||
| MEEHT | Base Unit of Measure | UNIT | 3 | 0 | T006 | MEINS | |
| PREIS | Price per Unit of Measure Calculated in Cost Estimate | CURR | 15 | 2 | SPREIS | ||
| ANRED | Title | CHAR | 15 | 0 | ANRED | ||
| NAME1 | Name 1 | CHAR | 35 | 0 | NAME1_GP | ||
| NAME2 | Name 2 | CHAR | 35 | 0 | NAME2_GP | ||
| NAME3 | Name 3 | CHAR | 35 | 0 | NAME3_GP | ||
| NAME4 | Name 4 | CHAR | 35 | 0 | NAME4_GP | ||
| STRAS | Street and House Number | CHAR | 35 | 0 | STRAS_GP | ||
| PFACH | PO Box | CHAR | 10 | 0 | PFACH | ||
| PSTL2 | P.O. Box Postal Code | CHAR | 10 | 0 | PSTL2 | ||
| LAND1 | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| PSTLZ | Postal Code | CHAR | 10 | 0 | PSTLZ | ||
| ORT01 | City | CHAR | 35 | 0 | ORT01_GP | ||
| ORT02 | City | CHAR | 35 | 0 | ORT01_GP | ||
| REGIO | Region (State, Province, County) | CHAR | 3 | 0 | T005S | REGIO | |
| INLND | Country/Region Key | CHAR | 3 | 0 | T005 | LAND1 | |
| ANZZL | 3-figure data element | DEC | 3 | 0 | KKEK_DEC3 | ||
| WAREN | Delivery address ID | CHAR | 1 | 0 | WAREN | ||
| LINE0 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE1 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE2 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE3 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE4 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE5 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE6 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE7 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE8 | Address line | CHAR | 80 | 0 | LINES | ||
| LINE9 | Address line | CHAR | 80 | 0 | LINES | ||
| LINEK | Address line | CHAR | 80 | 0 | LINES | ||
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | NUMC | 12 | 0 | * | CK_KALNR | |
| KLVAR | Costing Variant | CHAR | 4 | 0 | TCK03 | CK_KLVAR | |
| KALSM | Costing Sheet | CHAR | 6 | 0 | * | AUFKALSM | |
| ZSCHL | Overhead key | CHAR | 6 | 0 | AUFZSCHL | ||
| HWGFX | Fixed Portion of Costing Value in Local Currency | CURR | 15 | 2 | HWFIX |
/ Relaties
CKBS relaties.
| Tabel | Veld | Checktabel | Omschrijving | Checkveld |
|---|---|---|---|---|
| CKBS | BTGRP | TCK40 | Base Planning Object Group | MANDT |
| CKBS | BTGRP | TCK40 | Base Planning Object Group | KOKRS |
| CKBS | BTGRP | TCK40 | Base Planning Object Group | BTGRP |
| CKBS | BUKRS | T001 | Company Codes | BUKRS |
| CKBS | HWAER | TCURC | Currency Codes | MANDT |
| CKBS | HWAER | TCURC | Currency Codes | WAERS |
| CKBS | INLND | T005 | Countries | MANDT |
| CKBS | INLND | T005 | Countries | LAND1 |
| CKBS | KLVAR | TCK03 | Costing Variants | MANDT |
| CKBS | KOKRS | TKA01 | Controlling Areas | MANDT |
| CKBS | LAND1 | T005 | Countries | MANDT |
| CKBS | LAND1 | T005 | Countries | LAND1 |
| CKBS | MANDT | T000 | Clients | MANDT |
| CKBS | MEEHT | T006 | Units of Measurement | MANDT |
| CKBS | REGIO | T005S | Taxes: Region (Province) Key | LAND1 |
| CKBS | WERKS | T001W | Plants/Branches | WERKS |