SAP ABAP Table VFKP (Shipment Costs: Item Data)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ VTRA (Package) Shipment costs

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VFKP	Table Relationship Diagram
Short Description	Shipment Costs: Item Data

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	T000
2	FKNUM	☑	FKNUM	FKNUM	CHAR	10	0	Shipment cost number	VFKK
3	FKPOS	☑	FKPOS	FKPOS	NUMC	6	0	Shipment costs item
4	FKPTY	☐	FKPTY	FKPTY	CHAR	4	0	Item category shipment costs	TVFT
5	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	NETWR	☐	NETWR_P	WERTV8	CURR	15	2	Net value in currency of shipment cost item
7	MWSBP	☐	MWSBP_P	WERTV7	CURR	13	2	Tax amount in currency of shipment cost item
8	WAERS	☐	WAERS_P	WAERS	CUKY	5	0	Currency of the Shipment Cost Item	TCURC
9	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
10	PRSDT	☐	PRSDT_P	DATUM	DATS	8	0	Pricing date
11	BUDAT	☐	BUDAT_P	DATUM	DATS	8	0	Settlement date
12	EXTI1	☐	EXTI1_P	TEXT20	CHAR	20	0	External identification 1 Item
13	EXTI2	☐	EXTI2_P	TEXT20	CHAR	20	0	External identification 2 Item
14	TPLST	☐	TPLST	TPLST	CHAR	4	0	Transportation planning point	TTDS
15	VSART	☐	VERSARTS	VERSART	CHAR	2	0	Shipping type for shipment stage	T173
16	KALSM	☐	KALSMASD	KALSM	CHAR	6	0	Sales and Distribution: Pricing Procedure in Pricing	T683
17	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
18	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
19	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
20	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
21	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
22	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
23	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	*
24	PARVW	☐	PARVW	PARVW	CHAR	2	0	Partner Role	TPAR
25	TDLNR	☐	TDLNR_P	LIFNR	CHAR	10	0	Number of service agent	LFA1
26	RECHS	☐	RECHST	LIFNR	CHAR	10	0	Invoicing party for shipment cost item	LFA1
27	KURST	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
28	KOSTY	☐	KOSTY	KOSTY	CHAR	1	0	Cost type (shipment cost item)
29	REFTY	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
30	REBEL	☐	REBEL	REBEL	CHAR	10	0	Referenced document
31	REPOS	☐	REPOS_P	REPOS_P	NUMC	6	0	Referenced document item
32	POSTX	☐	POSTX	TEXT40	CHAR	40	0	Description for reference
33	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
34	BKLAS	☐	BWKLL	BKLAS	CHAR	4	0	Valuation Class	T025
35	STBER	☐	STBER_P	STBER_P	CHAR	1	0	Status of calculation (shipment costs item data)
36	DTBER	☐	DTBER	DATUM	DATS	8	0	Date of calculation
37	UZBER	☐	UZBER	UZEIT	TIMS	6	0	Time of calculation
38	STFRE	☐	STFRE_P	STFRE_P	CHAR	1	0	Status of account determination
39	DTFRE	☐	DTFRE	DATUM	DATS	8	0	Date of account determination
40	UZFRE	☐	UZFRE	UZEIT	TIMS	6	0	Time of account assignment
41	STABR	☐	STABR_P	STABR_P	CHAR	1	0	Status of transfer (shipment costs item data)
42	DTABR	☐	DTABR_T	DATUM	DATS	8	0	Date of settlement
43	UZABR	☐	UZABR	UZEIT	TIMS	6	0	Time of settlement
44	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
45	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
46	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
47	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
48	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
49	AEZET	☐	AEZET	UZEIT	TIMS	6	0	Time last change was made
50	LOGSYS	☐	LOGSYS	LOGSYS	CHAR	10	0	Logical system	TBDLS
51	KSTAU	☐	KSTAU	KSTAU	CHAR	1	0	Cost distribution CO
52	TRFZNA	☐	TRFZNA	TRFZN	CHAR	10	0	Tariff zone of point of departure	TVFTZ
53	TRFZNZ	☐	TRFZNZ	TRFZN	CHAR	10	0	Tariff zone of point of destination	TVFTZ
54	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
55	BASWR	☐	BASWR_P	WERTV8	CURR	15	2	Tax base amount
56	SLAND1_A	☐	SLAND1_A	LAND1	CHAR	3	0	Tax country departure	T005
57	SLAND1_Z	☐	SLAND1_Z	LAND1	CHAR	3	0	Tax country destination	T005
58	FKSTO	☐	FKSTO_P	XFELD	CHAR	1	0	Shipment cost item already cancelled
59	.INCLUDE	☐				0	0	Subtotals
60	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
61	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
62	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
63	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
64	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
65	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VFKP	BKLAS	T025	BKLAS
2	VFKP	BUKRS	T001	BUKRS	REF	1	CN
3	VFKP	EKGRP	T024	EKGRP	REF	1	CN
4	VFKP	EKORG	T024E	EKORG	REF	1	N
5	VFKP	FKNUM	VFKK	FKNUM	KEY	1	CN
6	VFKP	FKPTY	TVFT	FKPTY	REF	1	CN
7	VFKP	KALSM	T683	KALSM	REF	C	CN
8	VFKP	KNTTP	T163K	KNTTP
9	VFKP	KURST	TCURV	KURST	REF	C	CN
10	VFKP	LOGSYS	TBDLS	LOGSYS
11	VFKP	MANDT	T000	MANDT	KEY	1	CN
12	VFKP	MWSKZ	T007A	MWSKZ
13	VFKP	PARVW	TPAR	PARVW	REF	1	CN
14	VFKP	RECHS	LFA1	LIFNR	REF	1	CN
15	VFKP	SLAND1_A	T005	LAND1
16	VFKP	SLAND1_Z	T005	LAND1
17	VFKP	TDLNR	LFA1	LIFNR	REF	1	CN
18	VFKP	TPLST	TTDS	TPLST	REF	C	CN
19	VFKP	TRFZNA	TVFTZ	TRFZN
20	VFKP	TRFZNZ	TVFTZ	TRFZN
21	VFKP	VSART	T173	VSART	REF	C	CN
22	VFKP	WAERS	TCURC	WAERS	REF	1	CN
23	VFKP	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in