SAP ABAP Table EXPE (Trading Contract: Structure for Expenses)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ LO (Application Component) Logistics - General
     ⤷ WB2B_DDIC (Package) Trading Contract: DDIC Objects Retained in AL0

Basic Data

Table Category	INTTAB	Structure
Structure	EXPE	Table Relationship Diagram
Short Description	Trading Contract: Structure for Expenses

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	FLAG	☐	FLAG	FLAG	CHAR	1	0	General Flag
2	VTEXT	☐	VTEXT	TEXT20	CHAR	20	0	Description
3	.INCLUDE	☐				0	0	Conditions (Item)
4	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	KNUMH	☐	KNUMH	KNUMB	CHAR	10	0	Condition record number
6	KOPOS	☐	KOPOS	NUM02	NUMC	2	0	Sequential number of the condition
7	KAPPL	☐	KAPPL	KAPPL	CHAR	2	0	Application	T681A
8	KSCHL	☐	KSCHA	KSCHL	CHAR	4	0	Condition Type	T685
9	KNUMT	☐	KNUMT	KNUMB	CHAR	10	0	Number of texts
10	STFKZ	☐	STFKZ	STFKZ	CHAR	1	0	Scale type
11	KZBZG	☐	KZBZG	KZBZG	CHAR	1	0	Indicator: Scale Base Type
12	KSTBM	☐	KSTBM	MENG15	QUAN	15	3	Condition scale quantity
13	KONMS	☐	KONMS	MEINS	UNIT	3	0	Condition scale unit of measure	T006
14	KSTBW	☐	KSTBW	WERT8	CURR	15	2	Scale value
15	KONWS	☐	KONWS	WAERS	CUKY	5	0	Currency Key: Condition Scale	TCURC
16	KRECH	☐	KRECH	KRECH	CHAR	1	0	Calculation type for condition
17	KBETR	☐	KBETR_KOND	WERTV6	CURR	11	2	Rate (condition amount or percentage) where no scale exists
18	KONWA	☐	KONWA	WAERS	CUKY	5	0	Rate unit (currency or percentage)	TCURC
19	KPEIN	☐	KPEIN	KPEIN	DEC	5	0	Condition pricing unit
20	KMEIN	☐	KMEIN	MEINS	UNIT	3	0	Condition Unit	T006
21	PRSCH	☐	SCLGR	CHAR4	CHAR	4	0	Scale Group
22	KUMZA	☐	KUMZA	UMBSZ	DEC	5	0	Numerator for converting condition units to base units
23	KUMNE	☐	KUMNE	UMBSN	DEC	5	0	Denominator for converting condition units to base units
24	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
25	MXWRT	☐	MXWRT	WERTV6	CURR	11	2	Lower limit of the condition rate/amount
26	GKWRT	☐	GKWRT	WERTV6	CURR	11	2	Upper limit for the condition rate
27	PKWRT	☐	PKWRT	WERTV8	CURR	15	2	Planned condition value
28	FKWRT	☐	FKWRT	WERTV8	CURR	15	2	Cumulative guaranteed discount (not used)
29	RSWRT	☐	RSWRT	WERTV8	CURR	15	2	Accumulated accruals values (not used)
30	KWAEH	☐	KWAEH	WAERS	CUKY	5	0	Condition currency (for cumulation fields)	TCURC
31	UKBAS	☐	UKBAS	WERTV8	CURR	15	2	Planned condition basis
32	KZNEP	☐	KZNEP	KZNEP	CHAR	1	0	Condition exclusion indicator	T686A
33	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
34	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
35	MWSK1	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
36	LOEVM_KO	☐	LOEVM_KO	XFELD	CHAR	1	0	Deletion indicator for condition item
37	ZAEHK_IND	☐	DZAEHK_IND	ZAEHK	NUMC	2	0	Condition item index
38	BOMAT	☐	BOMAT	MATNR	CHAR	18	0	Material for rebate settlement	MARA
39	KBRUE	☐	KBRUE	WERTV6	CURR	11	2	Accrual Amount
40	KSPAE	☐	KSPAE	XFELD	CHAR	1	0	Rebate was set up retroactively
41	BOSTA	☐	BOSTA_CR	BOSTA_CR	CHAR	1	0	Condition Record Status (Rebate)
42	KNUMA_PI	☐	KNUMA_PI	KNUMA	CHAR	10	0	Promotion	KONA
43	KNUMA_AG	☐	KNUMA_AG	KNUMA	CHAR	10	0	Sales deal	KONA
44	KNUMA_SQ	☐	KNUMA_SQ	KNUMA	CHAR	10	0	Sales quote	KONA
45	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
46	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
47	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
48	ANZAUF	☐	ANZAUF	ANZAUF	NUMC	2	0	Maximum number of sales orders per condition record
49	MIKBAS	☐	MIKBAS	MENG15	QUAN	15	3	Minimum condition base value
50	MXKBAS	☐	MXKBAS	MENG15	QUAN	15	3	Maximum condition base value
51	KOMXWRT	☐	KOMXWRT	WERTV7	CURR	13	2	Maximum condition value
52	KLF_STG	☐	KLF_STG	KLFNR	NUMC	4	0	Number of incremental scale
53	KLF_KAL	☐	KLF_KAL	KLFNR	NUMC	4	0	Scale number for pricing
54	VKKAL	☐	VKKAL	XFELD	CHAR	1	0	Sales Price Calculation: Relevant to pricing
55	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
56	KNUMA_BO	☐	KNUMA_BO	KNUMA	CHAR	10	0	Agreement (subsequent settlement)	KONA
57	MWSK2	☐	WT_WITHCD	WT_WITHCD	CHAR	2	0	Withholding tax code	*
58	VERTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
59	VERTN	☐	RANL	RANL	CHAR	13	0	Contract Number
60	VBEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	TZB0A
61	MDFLG	☐	MDFLG	MDFLG	CHAR	1	0	Indicator: Matrix maintenance
62	KFRST	☐	KFRST	KFRST	CHAR	1	0	Release Status
63	UASTA	☐	UASTA	UASTA	CHAR	1	0	Status of business volume comparison for a condition
64	.INCLU--AP	☐				0	0	Customer Fields for KONP
65	/BEV1/ECRTT	☐	RANTYP	RANTYP	CHAR	1	0	Contract Type
66	/BEV1/ECRTN	☐	RANL	RANL	CHAR	13	0	Contract Number
67	/BEV1/ECEWA	☐	SBEWART	SBEWART	CHAR	4	0	Flow Type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EXPE	BOMAT	MARA	MATNR	KEY	1	CN
2	EXPE	KAPPL	T681A	KAPPL	REF	C	CN
3	EXPE	KMEIN	T006	MSEHI	REF	C	CN
4	EXPE	KNUMA_AG	KONA	KNUMA	REF	C	CN
5	EXPE	KNUMA_BO	KONA	KNUMA
6	EXPE	KNUMA_PI	KONA	KNUMA	REF	C	CN
7	EXPE	KNUMA_SQ	KONA	KNUMA	REF	C	CN
8	EXPE	KONMS	T006	MSEHI	REF	C	CN
9	EXPE	KONWA	TCURC	WAERS	REF	C	CN
10	EXPE	KONWS	TCURC	WAERS	REF	C	CN
11	EXPE	KSCHL	T685	KSCHL
12	EXPE	KUNNR	KNA1	KUNNR	REF	C	CN
13	EXPE	KWAEH	TCURC	WAERS	REF	C	CN
14	EXPE	KZNEP	T686A	KZNEP	REF	C	CN
15	EXPE	LIFNR	LFA1	LIFNR	REF	C	CN
16	EXPE	MANDT	T000	MANDT	KEY	1	CN
17	EXPE	MEINS	T006	MSEHI	REF	C	CN
18	EXPE	VBEWA	TZB0A	SBEWART		C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in