SAP ABAP Table S122BIW2 (S122BIW2 * Cashier)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCS (Package) R/3 application development: Logistics Information Warehouse
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | S122BIW2 | Table Relationship Diagram |
Short Description | S122BIW2 * Cashier |
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 | SPMON | SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
3 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
4 | KBDNR | W_KBDNR | PERNR | NUMC | 8 | 0 | Cashier number | ||
5 | KASNR | W_KASNR | KASNR | NUMC | 10 | 0 | POS number | ||
6 | KSKRS | W_KSKRS | W_KSKRS | NUMC | 5 | 0 | POS controller | ||
7 | KSCHL | V_KSCHA | KSCHL | CHAR | 4 | 0 | Condition type, sales | T685 | |
8 | KVORG | POSUVORG | POSUVORG | CHAR | 4 | 0 | Transact. type | TWPPB | |
9 | VRSIO | VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
10 | SPTAG | SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
11 | SPWOC | SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
12 | SPBUP | SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
13 | SSOUR | SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
14 | PERIV | PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
15 | VWDAT | VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
16 | WAERK | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
17 | WRUMS | C_UMSVPM | WERTV10 | CURR | 19 | 2 | Retail price with tax from cashier statistics | ||
18 | UMSGVO | C_UMSVPO | WERTV10 | CURR | 19 | 2 | Retail price without tax from cashier statistics | ||
19 | PRSNLS | C_PRSNLS | WERTV10 | CURR | 19 | 2 | Price reduction based on cashier statistics | ||
20 | PDIFF | C_PDIFF | WERTV10 | CURR | 19 | 2 | Cashier: price difference between R/3 -> and POS rtl price | ||
21 | KBSOL | W_KBSOL | WERTV10 | CURR | 19 | 2 | Means of payment target amount | ||
22 | KBIST | W_KBIST | WERTV10 | CURR | 19 | 2 | Means of payment actual amount | ||
23 | KDNEG | W_KDNEG | WERTV10 | CURR | 19 | 2 | Negative till difference | ||
24 | KDPOS | W_KDPOS | WERTV10 | CURR | 19 | 2 | Positive till difference | ||
25 | AZBON | C_ANZBON | BCSP6 | DEC | 11 | 0 | Number of transactions based on cashier statistics | ||
26 | AZPOS | C_ANZPOS | BCSP6 | DEC | 11 | 0 | Number of items based on cashier statistics | ||
27 | AZBST | W_AZBST | BCSP4 | DEC | 7 | 0 | Number of canceled transactions (till receipts) | ||
28 | ANZCOND | C_ANZCOND | BCSP6 | DEC | 11 | 0 | Number of conditions based on cashier statistics | ||
29 | WRBST | W_WRBST | WERTV10 | CURR | 19 | 2 | Value of canceled transactions (till receipts) | ||
30 | AZSST | W_AZSST | BCSP4 | DEC | 7 | 0 | Number of immediate cancellations | ||
31 | WRSST | W_WRSST | WERTV10 | CURR | 19 | 2 | Value of immediate cancellations | ||
32 | AZZST | W_AZZST | BCSP4 | DEC | 7 | 0 | Number of line cancelations | ||
33 | WRZST | W_WRZST | WERTV10 | CURR | 19 | 2 | Value of cancelled lines | ||
34 | AZSCA | W_AZSCA | BCSP4 | DEC | 7 | 0 | Number of materials scanned | ||
35 | AZWGV | W_AZWGV | BCSP4 | DEC | 7 | 0 | Number of material group sales | ||
36 | AZABB | W_AZABB | BCSP4 | DEC | 7 | 0 | Number of terminations | ||
37 | WRABB | W_WRABB | WERTV10 | CURR | 19 | 2 | Value of terminations | ||
38 | AZABS | W_AZABS | BCSP4 | DEC | 7 | 0 | Number of times till has been emptied (cash removals) | ||
39 | UMABS | W_UMABS | WERTV10 | CURR | 19 | 2 | Cash removed | ||
40 | AZSUL | W_AZSUL | BCSP4 | DEC | 7 | 0 | Number of checks over limit | ||
41 | WRSUL | W_WRSUL | WERTV10 | CURR | 19 | 2 | Value of checks over the limit | ||
42 | AMDZT | W_AMDZT | DEC17_5 | DEC | 17 | 5 | Logon time | ||
43 | REGZT | W_REGZT | DEC17_5 | DEC | 17 | 5 | Register time | ||
44 | AZBRT | W_AZBRT | BCSP4 | DEC | 7 | 0 | Number of reports | ||
45 | WRSCA | W_WRSCA | WERTV10 | CURR | 19 | 2 | Value of scanned material | ||
46 | WRWGV | W_WRWGV | WERTV10 | CURR | 19 | 2 | Value of material group sales | ||
47 | AZKSB | W_AZKSB | BCSP4 | DEC | 7 | 0 | Number of times till drawer was opened | ||
48 | AZFAV | W_AZFAV | BCSP4 | DEC | 7 | 0 | Number of failed logon attempts | ||
49 | BNKUMS | W_BNKUMS | WERTV10 | CURR | 19 | 2 | Bank business volume | ||
50 | KASNAM | W_KASNAM | CHAR35 | CHAR | 35 | 0 | Cashier name | ||
51 | KKENN | W_KKENN | W_KKENN | CHAR | 1 | 0 | Condition type identification | ||
52 | BZIRK | W_BEZIRK | BZIRK | CHAR | 6 | 0 | Sales district | T171 | |
53 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
54 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
55 | UMSGVP | W_UMSVPM | WERTV10 | CURR | 19 | 2 | Retail price w/tax from sales as per receipts/aggreg.sales | ||
56 | UMSGVO_01 | W_UMSVPO | WERTV10 | CURR | 19 | 2 | Rtl price from sales as per receipts/aggreg.sales | ||
57 | PRSNLS_02 | W_PRSNLS | WERTV10 | CURR | 19 | 2 | Price reduction from sales as per receipts/aggregated sales | ||
58 | PDIFF_03 | W_PDIFF | WERTV10 | CURR | 19 | 2 | Trnsctn price diff. between R/3 -> and sales price at POS | ||
59 | ZMUMS | W_ZMUMS | WERTV10 | CURR | 19 | 2 | Means of payment sales from sales as per receipts/aggr.sales | ||
60 | ANZPOS | W_ANZPOS | BCSP6 | DEC | 11 | 0 | Number of items from sales as per receipts/aggregated sales | ||
61 | AZBON_04 | W_AZBON | BCSP6 | DEC | 11 | 0 | Number of transactions from sales as per till receipts | ||
62 | ANZCOND_05 | W_ANZCOND | BCSP6 | DEC | 11 | 0 | Number of conditions from sales as per receipt/aggregated |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | S122BIW2 | BZIRK | T171 | BZIRK | 1 | CN | |
2 | S122BIW2 | KSCHL | T685 | KSCHL | KEY | C | 1 |
3 | S122BIW2 | KVORG | TWPPB | UVORG | KEY | ||
4 | S122BIW2 | MANDT | T000 | MANDT | KEY | ||
5 | S122BIW2 | VKORG | TVKO | VKORG | |||
6 | S122BIW2 | VTWEG | TVTW | VTWEG | |||
7 | S122BIW2 | WAERK | TCURC | WAERS | |||
8 | S122BIW2 | WERKS | T001W | WERKS | KEY |
History
Last changed by/on | SAP | 20050411 |
SAP Release Created in |