MCPOSCAS SAP (External Cash Register: Cashier Data (SAP BW Extractor)) Structure details
Dictionary Type: Structure
Description: External Cash Register: Cashier Data (SAP BW Extractor)
Description: External Cash Register: Cashier Data (SAP BW Extractor)
Structure field list including key, data, relationships and ABAP select examples
MCPOSCAS is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "External Cash Register: Cashier Data (SAP BW Extractor)" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_MCPOSCAS TYPE MCPOSCAS.
The MCPOSCAS table consists of various fields, each holding specific information or linking keys about External Cash Register: Cashier Data (SAP BW Extractor) data available in SAP. These include POSCUR (SD Document Currency), LOCCUR (Local Currency), EXCHANG (Exchange Rate for Price Determination), POSDAT (Posting Date in the Document).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MCPOSCAS structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| POSCUR | SD Document Currency | WAERK | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
| LOCCUR | Local Currency | HWAER | CUKY | 5 | Assigned to domain | WAERS | |||
| EXCHANG | Exchange Rate for Price Determination | KURSK | DEC | 9(5) | EXCRT | KURRF | |||
| POSDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
| POSTIM | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
| WEEKDAY | Weekday | MCW_WOCHTG | NUMC | 1 | DAYS17 | ||||
| STORE | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| CMPCODE | Company Code | BUKRS | CHAR | 4 | Assigned to domain | BUKRS | BUK | C_T001 | |
| ASCAR | Assortment owner | FILIALE | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
| SALGRP | Sales Group | VKGRP | CHAR | 3 | Assigned to domain | VKGRP | VKG | ||
| POSCTR | POS controller | W_KSKRS | NUMC | 5 | W_KSKRS | ||||
| POSNO | POS number | W_KASNR | NUMC | 10 | KASNR | ||||
| CSHRNO | Cashier number | W_KBDNR | NUMC | 8 | PERNR | ||||
| CSHRNM | Cashier name | W_KASNAM | CHAR | 35 | CHAR35 | ||||
| CONDTYS | Condition type, sales | V_KSCHA | CHAR | 4 | Assigned to domain | KSCHL | VKS | ||
| TATYPE | Transact. type | POSUVORG | CHAR | 4 | Assigned to domain | POSUVORG | |||
| CONDTYI | Condition type identification | W_KKENN | CHAR | 1 | W_KKENN | ||||
| POSPAYM | Payment method at POS system | POSZAHLART | CHAR | 4 | CHAR4 | ||||
| TAXCODE | Tax on sales/purchases code | MWSKZ | CHAR | 2 | Assigned to domain | MWSKZ | |||
| SALES | Sales (Cashier) | C_UMSATZ | CURR | 19(2) | WERTV10 | ||||
| SALTAX | Amount of Sales Tax (Cashier) | C_UMSTAX | CURR | 19(2) | WERTV10 | ||||
| CONTTAX | Flag: Tax Included in Sale (Cashier) | C_CONTTAX | CHAR | 1 | W_CONTTAX | ||||
| SALPRR | Price reduction based on cashier statistics | C_PRSNLS | CURR | 19(2) | WERTV10 | ||||
| SALCPR | Cashier: price difference between R/3 -> and POS rtl price | C_PDIFF | CURR | 19(2) | WERTV10 | ||||
| VALCSHREM | Cash removed | W_UMABS | CURR | 19(2) | WERTV10 | ||||
| NOCSHREM | Number of times till has been emptied (cash removals) | W_AZABS | DEC | 7 | BCSP4 | ||||
| MOPTAM | Means of payment target amount | W_KBSOL | CURR | 19(2) | WERTV10 | ||||
| MOPAAM | Means of payment actual amount | W_KBIST | CURR | 19(2) | WERTV10 | ||||
| TDIFFP | Positive till difference | W_KDPOS | CURR | 19(2) | WERTV10 | ||||
| TDIFFM | Negative till difference | W_KDNEG | CURR | 19(2) | WERTV10 | ||||
| NOCHOL | Number of checks over limit | W_AZSUL | DEC | 7 | BCSP4 | ||||
| VALCHOL | Value of checks over the limit | W_WRSUL | CURR | 19(2) | WERTV10 | ||||
| NOICANC | Number of immediate cancellations | W_AZSST | DEC | 7 | BCSP4 | ||||
| VALICANC | Value of immediate cancellations | W_WRSST | CURR | 19(2) | WERTV10 | ||||
| NOLCANC | Number of line cancelations | W_AZZST | DEC | 7 | BCSP4 | ||||
| VALLCANC | Value of cancelled lines | W_WRZST | CURR | 19(2) | WERTV10 | ||||
| NOCTRA | Number of canceled transactions (till receipts) | W_AZBST | DEC | 7 | BCSP4 | ||||
| VALCTRA | Value of canceled transactions (till receipts) | W_WRBST | CURR | 19(2) | WERTV10 | ||||
| NOTERM | Number of terminations | W_AZABB | DEC | 7 | BCSP4 | ||||
| VALTERM | Value of terminations | W_WRABB | CURR | 19(2) | WERTV10 | ||||
| LOGTIM | Logon time | W_AMDZT | DEC | 17(5) | DEC17_5 | ||||
| REGTIM | Register time | W_REGZT | DEC | 17(5) | DEC17_5 | ||||
| NOREP | Number of reports | W_AZBRT | DEC | 7 | BCSP4 | ||||
| NOSCANA | Number of materials scanned | W_AZSCA | DEC | 7 | BCSP4 | ||||
| VALSCANA | Value of scanned material | W_WRSCA | CURR | 19(2) | WERTV10 | ||||
| NOMGRSAL | Number of material group sales | W_AZWGV | DEC | 7 | BCSP4 | ||||
| VALMGRSAL | Value of material group sales | W_WRWGV | CURR | 19(2) | WERTV10 | ||||
| BNKBVOL | Bank business volume | W_BNKUMS | CURR | 19(2) | WERTV10 | ||||
| NOTDRWOP | Number of times till drawer was opened | W_AZKSB | DEC | 7 | BCSP4 | ||||
| NOFLOGAT | Number of failed logon attempts | W_AZFAV | DEC | 7 | BCSP4 | ||||
| NOREC | Number of transactions based on cashier statistics | C_ANZBON | DEC | 11 | BCSP6 | ||||
| NOPOS | Number of items based on cashier statistics | C_ANZPOS | DEC | 11 | BCSP6 | ||||
| NOCON | Number of conditions based on cashier statistics | C_ANZCOND | DEC | 11 | BCSP6 | ||||
| DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY |
| Key field | Non-key field |
How do I retrieve data from SAP structure MCPOSCAS using ABAP code?
As MCPOSCAS is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MCPOSCAS as there is no data to select.How to access SAP table MCPOSCAS
Within an ECC or HANA version of SAP you can also view further information about MCPOSCAS and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects