S122BIW1

S122BIW1 * Cashier | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SPMON Period to analyze - month
WERKS FK Plant
KBDNR Cashier number
KASNR POS number
KSKRS POS controller
KSCHL FK Condition type, sales
KVORG FK Transact. type
VRSIO Version number in the information structure
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
💲 SD Document Currency (S122.WAERK):
WRUMS Retail price with tax from cashier statistics
UMSGVO Retail price without tax from cashier statistics
PRSNLS Price reduction based on cashier statistics
PDIFF Cashier: price difference between R/3 -> and POS rtl price
KBSOL Means of payment target amount
KBIST Means of payment actual amount
KDNEG Negative till difference
KDPOS Positive till difference
WRBST Value of canceled transactions (till receipts)
WRSST Value of immediate cancellations
WRZST Value of cancelled lines
WRABB Value of terminations
UMABS Cash removed
WRSUL Value of checks over the limit
WRSCA Value of scanned material
WRWGV Value of material group sales
BNKUMS Bank business volume
UMSGVP Retail price w/tax from sales as per receipts/aggreg.sales
UMSGVO_01 Rtl price from sales as per receipts/aggreg.sales
PRSNLS_02 Price reduction from sales as per receipts/aggregated sales
PDIFF_03 Trnsctn price diff. between R/3 -> and sales price at POS
ZMUMS Means of payment sales from sales as per receipts/aggr.sales
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
KKENN Condition type identification Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
AZBON Number of transactions based on cashier statistics BCSP6
AZPOS Number of items based on cashier statistics BCSP6
AZBST Number of canceled transactions (till receipts) BCSP4
ANZCOND Number of conditions based on cashier statistics BCSP6
AZSST Number of immediate cancellations BCSP4
AZZST Number of line cancelations BCSP4
AZSCA Number of materials scanned BCSP4
AZWGV Number of material group sales BCSP4
AZABB Number of terminations BCSP4
AZABS Number of times till has been emptied (cash removals) BCSP4
AZSUL Number of checks over limit BCSP4
AMDZT Logon time DEC17_5
REGZT Register time DEC17_5
AZBRT Number of reports BCSP4
AZKSB Number of times till drawer was opened BCSP4
AZFAV Number of failed logon attempts BCSP4
KASNAM Cashier name CHAR35
ANZPOS Number of items from sales as per receipts/aggregated sales BCSP6
AZBON_04 Number of transactions from sales as per till receipts BCSP6
ANZCOND_05 Number of conditions from sales as per receipt/aggregated BCSP6
Master Data Relations Join Conditions
Sales district
  • S122BIW1.MANDT == T171.MANDT
  • S122BIW1.BZIRK == T171.BZIRK
Condition type, sales
  • Condition type, sales
  • Client
  • ?
  • ?
  • S122BIW1.KSCHL == T685.KSCHL
  • S122BIW1.MANDT == T685.MANDT
  • S122BIW1.[column in domain "KVEWE"] == T685.KVEWE
  • S122BIW1.[column in domain "KAPPL"] == T685.KAPPL
Transact. type
  • S122BIW1.MANDT == TWPPB.MANDT
  • S122BIW1.KVORG == TWPPB.UVORG
Client S122BIW1.MANDT == T000.MANDT
Sales Organization
  • S122BIW1.MANDT == TVKO.MANDT
  • S122BIW1.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S122BIW1.VTWEG == TVTW.VTWEG
  • S122BIW1.MANDT == TVTW.MANDT
SD Document Currency
  • S122BIW1.MANDT == TCURC.MANDT
  • S122BIW1.WAERK == TCURC.WAERS
Plant
  • S122BIW1.MANDT == T001W.MANDT
  • S122BIW1.WERKS == T001W.WERKS