SAP ABAP Table MCCONDIT (Cash external: Conditions (only LIS))
Hierarchy
☛
SAP_APPL (Software Component) Logistics and Accounting
⤷ LO-RIS (Application Component) Retail Information System (RIS)
⤷ MCW (Package) R/3 application development: Retail Information System
⤷ LO-RIS (Application Component) Retail Information System (RIS)
⤷ MCW (Package) R/3 application development: Retail Information System
Basic Data
Table Category | INTTAB | Structure |
Structure | MCCONDIT | Table Relationship Diagram |
Short Description | Cash external: Conditions (only LIS) |
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 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
3 | KSKRS | W_KSKRS | W_KSKRS | NUMC | 5 | 0 | POS controller | ||
4 | KASNR | W_KASNR | KASNR | NUMC | 10 | 0 | POS number | ||
5 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
6 | BONNR | W_BONNR | W_BONNR | NUMC | 15 | 0 | Transaction number (till receipt) | ||
7 | LFDNR | MCW_POSNR | NUMC6 | NUMC | 6 | 0 | Consecutive item number | ||
8 | EZEIT | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
9 | KSCHL | V_KSCHA | KSCHL | CHAR | 4 | 0 | Condition type, sales | T685 | |
10 | PRSNLS | W_PRSNLS | WERTV10 | CURR | 19 | 2 | Price reduction from sales as per receipts/aggregated sales | ||
11 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
12 | KZPOS | W_KZPOS | CHAR1 | CHAR | 1 | 0 | Indicator: first item | ||
13 | KKENN | W_KKENN | W_KKENN | CHAR | 1 | 0 | Condition type identification | ||
14 | ZMUMS | W_ZMUMS | WERTV10 | CURR | 19 | 2 | Means of payment sales from sales as per receipts/aggr.sales | ||
15 | AZBON | W_AZBON | BCSP6 | DEC | 11 | 0 | Number of transactions from sales as per till receipts | ||
16 | ANZPOS | W_ANZPOS | BCSP6 | DEC | 11 | 0 | Number of items from sales as per receipts/aggregated sales | ||
17 | ANZCOND | W_ANZCOND | BCSP6 | DEC | 11 | 0 | Number of conditions from sales as per receipt/aggregated | ||
18 | CCINS | CCINS | CCINS | CHAR | 4 | 0 | Payment cards: Card type | * | |
19 | CCNUM | CCNUM | CCNUM | CHAR | 25 | 0 | Payment cards: Card number | * | |
20 | KRFNR | POSKARFNR | CHAR15 | CHAR | 15 | 0 | Card Sequence Number | ||
21 | BNKLZ | BANKK | BANKK | CHAR | 15 | 0 | Bank Keys | ||
22 | KTONR | BANKN | BANKN | CHAR | 18 | 0 | Bank account number | ||
23 | CONDNR | MCW_CONDNR | NUMC6 | NUMC | 6 | 0 | Consecutive condition number | ||
24 | UMSGVP | W_UMSVPM | WERTV10 | CURR | 19 | 2 | Retail price w/tax from sales as per receipts/aggreg.sales | ||
25 | UMSGVO | W_UMSVPO | WERTV10 | CURR | 19 | 2 | Rtl price from sales as per receipts/aggreg.sales | ||
26 | UMSGVC | W_UMSVPC | WERTV10 | CURR | 19 | 2 | Retail price from sales without manufacturer's coupons | ||
27 | UMSGEO | W_UMSEP | WERTV10 | CURR | 19 | 2 | Sales transactions (till receipts) at cost | ||
28 | PRVBT | W_PRVBT | WERTV10 | CURR | 19 | 2 | Commission amount, sales | ||
29 | UMSMNG | W_UMSMNG | MENGV15_3 | QUAN | 15 | 3 | Transaction sales - quantity in base unit of measure | ||
30 | VKMNG | W_VKMNG | MENGV15_3 | QUAN | 15 | 3 | Transaction sales - quantity in sales unit | ||
31 | PDIFF | W_PDIFF | WERTV10 | CURR | 19 | 2 | Trnsctn price diff. between R/3 -> and sales price at POS | ||
32 | CONDID | W_CONDID | CHAR20 | CHAR | 20 | 0 | Condition Type Identification | ||
33 | BBYNR | BBYNR | BBYNR | CHAR | 12 | 0 | Bonus buy | * | |
34 | PAYDIR | W_PAYDIR | W_PAYDIR | CHAR | 1 | 0 | Direction of payment type (outbound/inbound) | ||
35 | ZMTTL | W_ZAHLART | KSCHL | CHAR | 4 | 0 | Payment method as condition | * | |
36 | TABIX | POS_TABIX | POS_TABIX | INT4 | 10 | 0 | Index in an internal table | ||
37 | .INCLUDE | 0 | 0 | User exit conditions, external cash data | |||||
38 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCCONDIT | KSCHL | T685 | KSCHL | C | 1 | |
2 | MCCONDIT | MANDT | T000 | MANDT | |||
3 | MCCONDIT | WERKS | T001W | WERKS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |