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
⤷ 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 |