1. Home
  2. Resources
  3. SAP Tables
  4. MC44RB0REC - Extraction Retail BW: Sales Receipt Data

SAP Table MC44RB0REC

Extraction Retail BW: Sales Receipt Data

MC44RB0REC (Extraction Retail BW: Sales Receipt Data) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MC44RB0REC to other SAP tables.

MC44RB0REC table fields

Field Data element Checktable Datatype Length Decimals
ROCANCEL Indicator: Cancel Data Record ROCANCEL CHAR 1 0
X TRUE
NULL FALSE
ARTICLE Material Number MATNR CHAR 18 0
ARTNO Number of Materials POSBW_ARTNO NUMC 6 0
ASCAR Assortment owner FILIALE CHAR 10 0
BANKAN Bank account number BANKN CHAR 18 0
BANKKEY Bank Keys BANKK CHAR 15 0
BASUNI Base Unit of Measure MEINS UNIT 3 0
CARDNO Payment cards: Card number CCNUM CHAR 25 0
CARDNXT Card Sequence Number POSKARFNR CHAR 15 0
CARDTY Payment cards: Card type CCINS CHAR 4 0
COMACC Commission amount, sales W_PRVBT CURR 19 2
CONDID Condition Type Identification W_CONDID CHAR 20 0
CONDNO Consecutive condition number MCW_CONDNR NUMC 6 0
CONDTYI Condition type identification W_KKENN CHAR 1 0
A Sales and Distribution - Condition type
B Means of payment
C Store coupon
D Manufacturer's coupon
CONDTYS Condition type, sales V_KSCHA CHAR 4 0
CONTTAX Flag: Tax Contained in Sales (Receipt) W_CONTTAX CHAR 1 0
NULL Tax Contained in Sales
X Tax not Contained in Sales
CSHRNM Cashier name W_KASNAM CHAR 35 0
CSHRNO Cashier number W_KBDNR NUMC 8 0
CUSTOM Customer number KUND1 CHAR 10 0
DSCDCL Bonus Buy Description POSBW_BBYNR CHAR 12 0
EANUPC International Article Number (EAN/UPC) EAN11 CHAR 18 0
EXCHANG Exchange Rate for Price Determination KURSK DEC 9 5
LOCCUR Local Currency HWAER CUKY 5 0
MRCHGR Material Group MATKL CHAR 9 0
NOART Number of Materials (Extractor) POSBW_NOART INT1 3 0
NOCON Number of Conditions (Extractor) POSBW_NOCON INT1 3 0
NOMGR Number of Material Groups (Extractor) POSBW_NOMGR INT1 3 0
NOPAY Number of Means of Payment (Extractor) POSBW_NOPAY INT1 3 0
NOPOS Number of Items (Extractor) POSBW_NOPOS INT1 3 0
NOREC Number of Receipts (Extractor) POSBW_NOREC INT1 3 0
NOUPC Number of EAN/UPC (Extractor) POSBW_NOUPC INT1 3 0
PAYDIR Direction of payment type (outbound/inbound) W_PAYDIR CHAR 1 0
A Expenditure on customers
B POS revenue
PAYMETH Payment method as condition W_ZAHLART CHAR 4 0
PAYSAL Means of payment sales from sales as per receipts/aggr.sales W_ZMUMS CURR 19 2
POSCTR POS controller W_KSKRS NUMC 5 0
POSCUR SD Document Currency WAERK CUKY 5 0
POSDAT Posting Date in the Document BUDAT DATS 8 0
POSNO POS number W_KASNR NUMC 10 0
POSTIM Entry time ERZET TIMS 6 0
PROMNO Promotion WAKTION CHAR 10 0
PROMOFL Action Identifier: Receipt POSBW_AFLAG NUMC 1 0
0 Standard
1 Promotion
2 Not defined
RECNO Transaction number (till receipt) W_BONNR NUMC 15 0
RECSIGN Debit/Credit Sign on Receipt POSBW_RECSIGN CHAR 1 0
+ Positive
- Negative
RECVAL Receipt Value POSBW_RECVAL NUMC 10 0
SALCPR Trnsctn price diff. between R/3 -> and sales price at POS W_PDIFF CURR 19 2
SALES Receipt Sales Volume W_UMSATZ CURR 19 2
SALGRP Sales Group VKGRP CHAR 3 0
SALNO Salesperson number W_VKFNR NUMC 8 0
SALPP Sales transactions (till receipts) at cost W_UMSEP CURR 19 2
SALPRR Price reduction from sales as per receipts/aggregated sales W_PRSNLS CURR 19 2
SALQTY Transaction sales - quantity in sales unit W_VKMNG QUAN 15 3
SALQTYB Transaction sales - quantity in base unit of measure W_UMSMNG QUAN 15 3
SALTAX Receipt for Sales Tax W_UMSTAX CURR 19 2
SALTYPE Sales type (sales/returns/empties) W_UMART CHAR 1 0
SALUNI Sales unit VRKME UNIT 3 0
SCFLAG Scan Flag POSBW_SCFLAG NUMC 1 0
0 Scanned
1 Exact
2 Estimated
SERNO BOM Explosion Number W_SERNR CHAR 25 0
STORE Plant WERKS_D CHAR 4 0
TATYPE Transact. type POSUVORG CHAR 4 0
VALWOC Retail price from sales without manufacturer's coupons POSBW_VALWOC CURR 19 2
WEEKDAY Weekday MCW_WOCHTG NUMC 1 0
4 Thursday
7 Sunday
5 Friday
6 Saturday
1 Monday
2 Tuesday
3 Wednesday