SAP ABAP Table CKHS_VB (CKHS extended by sales document for sales order archiving)
Hierarchy
☛
SAP_FIN (Software Component) SAP_FIN
⤷ CO-PC-PCP (Application Component) Product Cost Planning
⤷ CKJ3 (Package) Archiving and Reorganization in Product Costing
⤷ CO-PC-PCP (Application Component) Product Cost Planning
⤷ CKJ3 (Package) Archiving and Reorganization in Product Costing
Basic Data
Table Category | INTTAB | Structure |
Structure | CKHS_VB | Table Relationship Diagram |
Short Description | CKHS extended by sales document for sales order archiving |
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 | VBELN | VBELN | VBELN | CHAR | 10 | 0 | Sales and Distribution Document Number | * | |
2 | .INCLUDE | 0 | 0 | Header: Unit Costing (Control + Totals) | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | LEDNR | LEDNR | LEDNR | CHAR | 2 | 0 | Ledger for Controlling objects | ||
5 | BZOBJ | CK_OBJ | CK_OBJ | CHAR | 1 | 0 | Reference Object | * | |
6 | KALNR | CK_KALNR | CK_KALNR | NUMC | 12 | 0 | Cost Estimate Number for Cost Est. w/o Qty Structure | * | |
7 | KALKA | CK_KALKA | CK_KALKA | CHAR | 2 | 0 | Costing Type | * | |
8 | KADKY | CK_KADKY | CK_KADAT | DATS | 8 | 0 | Costing Date (Key) | ||
9 | TVERS | CK_TVERS | CK_VERSION | NUMC | 2 | 0 | Costing Version | ||
10 | BWVAR | CK_BWVAR | CK_BWVAR | CHAR | 3 | 0 | Valuation Variant in Costing | * | |
11 | KKZMA | CK_KKZMA | XFELD | CHAR | 1 | 0 | Costs Entered Manually in Additive or Automatic Cost Est. | ||
12 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
13 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
14 | FCPMG | SPRED | SPRED | CHAR | 4 | 0 | Distribution Key | T821S | |
15 | FROPER | CK_FROPER | POPER | NUMC | 3 | 0 | First Valid Period (from Period) | ||
16 | DIPER | CK_DIPER | POPER | NUMC | 3 | 0 | Interval Between Planned Periods | ||
17 | TOPER | CK_TOPER | POPER | NUMC | 3 | 0 | Last Posting Period Allowed | ||
18 | KKART | KKART | KKART | CHAR | 4 | 0 | Costing Variant (Corresponds to KLVAR) | TKKEA | |
19 | GJAHR | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
20 | ERFDT | ERFDT | DATUM | DATS | 8 | 0 | Created on | ||
21 | ERFNM | ERFNM | USNAM | CHAR | 12 | 0 | Entered by | ||
22 | AENDT | AENDT | DATUM | DATS | 8 | 0 | Date of last change | ||
23 | AENNM | AENNM | USNAM | CHAR | 12 | 0 | Last changed by | ||
24 | ABSDT | ABSDT | DATUM | DATS | 8 | 0 | Close date | ||
25 | ABSNM | ABSNM | USNAM | CHAR | 12 | 0 | User ID of the person who closed the cost estimate | ||
26 | KRSDT | KRSDT | DATUM | DATS | 8 | 0 | Exchange Rate Date | ||
27 | STATK | STATK | STATE | CHAR | 4 | 0 | Header Status | ||
28 | STRNG | STRNG | STATE | CHAR | 4 | 0 | Internal header control | ||
29 | PSDAT | PSDAT | DATUM | DATS | 8 | 0 | Pricing Date | ||
30 | MENGE | MENGE_KPF | CQUA8 | QUAN | 15 | 3 | Lot Size | ||
31 | MEEHT | CK_MEINH_BEW | MEINS | UNIT | 3 | 0 | Valuation Unit of Measure | T006 | |
32 | HWGES | HWGES | CVAL8 | CURR | 15 | 2 | Total Value of Cost Estimate in Local Currency | ||
33 | HWGFX | HWFIX | CVAL8 | CURR | 15 | 2 | Fixed Portion of Costing Value in Local Currency | ||
34 | FWGES | FWGES | CVAL8 | CURR | 15 | 2 | Total Value for Cost Estimate in Foreign Currency | ||
35 | HWAER | HWAER | WAERS | CUKY | 5 | 0 | Local Currency | TCURC | |
36 | FWAER | FWAER | WAERS | CUKY | 5 | 0 | Foreign Currency in Header | TCURC | |
37 | UKURS | UKURS_D | UKURS | DEC | 9 | 5 | Exchange Rate | ||
38 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
39 | FFACT | FFACT | DEC9 | DEC | 9 | 0 | Factor for the "From" Currency Units | ||
40 | TFACT | TFACT_D | DEC9 | DEC | 9 | 0 | Factor for the "To" Currency Units | ||
41 | GWRT1 | GWRT1 | CVAL8 | CURR | 15 | 2 | Total Value of Price Component 1 | ||
42 | GWRT2 | GWRT1 | CVAL8 | CURR | 15 | 2 | Total Value of Price Component 1 | ||
43 | GWRT3 | GWRT1 | CVAL8 | CURR | 15 | 2 | Total Value of Price Component 1 | ||
44 | GWRT4 | GWRT1 | CVAL8 | CURR | 15 | 2 | Total Value of Price Component 1 | ||
45 | GWRT5 | GWRT1 | CVAL8 | CURR | 15 | 2 | Total Value of Price Component 1 | ||
46 | STFLG | STFLG | YNFLG | CHAR | 1 | 0 | Sales Order Cost Estimate Is Marked | ||
47 | ZTFLG | DZTFLG | YNFLG | CHAR | 1 | 0 | Flag for time-based unit costing | ||
48 | FVFLG | FVFLG | FVFLG | CHAR | 1 | 0 | Fixed/Variable Indicator | ||
49 | DLFLG | DLFLG | YNFLG | CHAR | 1 | 0 | Deletion Flag for Unit Costing | ||
50 | FRFLG | FRFLG | YNFLG | CHAR | 1 | 0 | Release Flag | ||
51 | PRVFN | PRVFN | PRVFN | CHAR | 1 | 0 | Pricing procedure | ||
52 | PKANZ | PKANZ | NUM01 | NUMC | 1 | 0 | Number of Price Components | ||
53 | PSANZ | CK_PSANZ | CK_POSNR | NUMC | 5 | 0 | Number of Costing Items | * | |
54 | KNNZ1 | KK_KZEXL | CHAR1 | CHAR | 1 | 0 | Cost Estimate Created with Excel | ||
55 | KNNZ2 | KK_KZEZN | CHAR1 | CHAR | 1 | 0 | Indicator - Postprocessing of product cost estimate | ||
56 | KNNZ3 | KZCHN | CHAR1 | CHAR | 1 | 0 | Unit Costing Indicator | ||
57 | KNNZ4 | KZCHN | CHAR1 | CHAR | 1 | 0 | Unit Costing Indicator | ||
58 | KNNZ5 | KZCHN | CHAR1 | CHAR | 1 | 0 | Unit Costing Indicator | ||
59 | ME_SUMM1 | CK_MESUMM | MEINS | UNIT | 3 | 0 | Unit of Measure for Quantity Total | T006 | |
60 | SUMM1_KPF | SUMME_MNG | CQUA8 | QUAN | 15 | 3 | Quantities total for item category S | ||
61 | SUMM2_KPF | SUMME_INV | CVAL8 | CURR | 15 | 2 | Capital Spending Total for Item Category S | ||
62 | SUMM3_KPF | SUMME_POS | CVAL8 | CURR | 15 | 2 | Total of two or more items | ||
63 | EXTNR | EXTNR | EXTNR | CHAR | 18 | 0 | Base Planning Object (External Number) | CKBS | |
64 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
65 | AUFNR | AUFNR | AUFNR | CHAR | 12 | 0 | Order Number | AUFK | |
66 | KSTAR | KSTAR | KSTAR | CHAR | 10 | 0 | Cost Element | * | |
67 | HRKFT | HRKFT | HRKFT | CHAR | 4 | 0 | Origin Group as Subdivision of Cost Element | * | |
68 | KALSM | AUFKALSM | KALSM | CHAR | 6 | 0 | Costing Sheet | * | |
69 | ZSCHL | AUFZSCHL | CHAR6 | CHAR | 6 | 0 | Overhead key | ||
70 | TEMPLATE | ABC_TEMPL | ABC_TEMPL | CHAR | 10 | 0 | Template | * | |
71 | OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | ONR00 | |
72 | TWGES | TWGES | CVAL8 | CURR | 15 | 2 | Total Value in Item Foreign Currency | ||
73 | TKURST | TKURST | KURST | CHAR | 4 | 0 | Exchange Rate Type for Item Foreign Currency | TCURV | |
74 | TWAER | KKTWAER | WAERS | CUKY | 5 | 0 | Item Foreign Currency | TCURC | |
75 | KKBWVAR | KK_BWVAR | CK_BWVAR | CHAR | 3 | 0 | Valuation Variant in Costing | TCK05 | |
76 | KKSAPRL | KK_SAPRL | CHAR4 | CHAR | 4 | 0 | Release the document as it was last saved | ||
77 | TKURS | TKURS | UKURS | DEC | 9 | 5 | Exchange Rate for Item Foreign Currency | ||
78 | KZROH | CK_KZROH | XFELD | CHAR | 1 | 0 | Material Component | ||
79 | FILEPATH | KK_PATH | PC_PATH | CHAR | 66 | 0 | Description | ||
80 | FILENAME | KKXL_NAME | PC_FNAME_E | CHAR | 12 | 0 | File or Macro Name for Communication with MS Excel | ||
81 | CKCM | CK_COSTMODEL | ABC_TEMPL | CHAR | 10 | 0 | Costing Model | CKCM | |
82 | CKCMV | CKI_MODELINSTANCE | CKI_MODELINSTANCE | NUMC | 15 | 0 | Costing Model: Model Instance | CKCMV | |
83 | MAXCID | CK_MAX_COMPONENT_ID | NUMC | 7 | 0 | PCP: Highest Component ID Already Assigned | |||
84 | INTHIER | CK_INT_HIERARCHY | CHAR1 | CHAR | 1 | 0 | PCP: Cost Estimate Contains Internal Hierarchy | ||
85 | LOG_HANDLE | BALLOGHNDL | SYSUUID_22 | CHAR | 22 | 0 | Application Log: Log Handle |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CKHS_VB | AUFNR | AUFK | AUFNR | REF | 1 | CN |
2 | CKHS_VB | BUKRS | T001 | BUKRS | REF | 1 | CN |
3 | CKHS_VB | CKCM | CKCM | MODEL | |||
4 | CKHS_VB | CKCMV | CKCMV | MODEL_VAL | |||
5 | CKHS_VB | EXTNR | CKBS | EXTNR | REF | 1 | CN |
6 | CKHS_VB | FCPMG | T821S | SPRED | REF | 1 | CN |
7 | CKHS_VB | FWAER | TCURC | WAERS | REF | 1 | CN |
8 | CKHS_VB | HWAER | TCURC | WAERS | REF | 1 | CN |
9 | CKHS_VB | KKART | TKKEA | KKART | REF | 1 | CN |
10 | CKHS_VB | KKBWVAR | TCK05 | BWVAR | REF | 1 | CN |
11 | CKHS_VB | KOKRS | TKA01 | KOKRS | REF | 1 | CN |
12 | CKHS_VB | KURST | TCURV | KURST | REF | 1 | CN |
13 | CKHS_VB | MANDT | T000 | MANDT | KEY | 1 | CN |
14 | CKHS_VB | MEEHT | T006 | MSEHI | REF | 1 | CN |
15 | CKHS_VB | ME_SUMM1 | T006 | MSEHI | REF | 1 | CN |
16 | CKHS_VB | OBJNR | ONR00 | OBJNR | REF | 1 | CN |
17 | CKHS_VB | TKURST | TCURV | KURST | REF | 1 | CN |
18 | CKHS_VB | TWAER | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20050109 |
SAP Release Created in |