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

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