- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- ANSI/ISA S95 Interface (LO-S95)
- Advanced Returns Management (LO-ARM)
- Batches (LO-BM)
- Bulk Processess in Logistics (LO-BLK)
- Commodity Management in Logistics (LO-CMM)
- Configuration management (LO-CM)
- ERP Logistik Integration (LO-INT)
- Electronic Data Records (LO-ELR)
- Engineering Change Management (LO-ECH)
- Forecast (LO-PR)
- Generic Cross Application Components (LO-GEN)
- Global Trade (LO-GT)
- Handling Unit Management (LO-HU)
- Logistics Basic Data (LO-MD)
- Logistics Information System (LIS) (LO-LIS)
- Product Data Management (LO-PDM)
- Project Manufacturing Management and Optimization (LO-PMM)
- Retail & Fashion Management in S/4HANA (LO-RFM)
- SAP Agricultural Contract Management (LO-AGR)
- Service Parts Management (LO-SPM)
- Settlement Management (LO-AB)
- Supply Chain Planning Interfaces (SCPI) (LO-SCI)
- Variant Configuration (LO-VC)
- Variant configuration on HANA (LO-VCH)
- Warranty Claim Processing (LO-WTY)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
S120BIW2
S120BIW2 * Sales as Per Receipts
|
#transactional
|
Component: Data Collection
- 🔑 Keys (16)
- 💰 Amounts (8)
- ∑ Quantities (2)
- 📅 Dates (2)
- ☰ Categorical (4)
- Other (19)
- 🔗 Relations (19)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| SPTAG | Period to analyze - current date | |
| WERKS FK | Plant | |
| KSKRS | POS controller | |
| KASNR | POS number | |
| BONNR | Transaction number (till receipt) | |
| MATNR FK | Material Number | |
| EANNR | International Article Number (EAN/UPC) | |
| KSCHL FK | Condition type, sales | |
| KVORG FK | Transact. type | |
| CONDNR | Consecutive condition number | |
| VRSIO | Version number in the information structure | |
| SPMON | Period to analyze - month | |
| SPWOC | Period to analyze - week | |
| SPBUP | Period to analyze - posting period | |
| SSOUR | Statistic(s) origin |
| Column Name | Description | |
|---|---|---|
| 💲 SD Document Currency (S120.WAERK): | ||
| UMSGVP | Retail price w/tax from sales as per receipts/aggreg.sales | |
| UMSGVO | Rtl price from sales as per receipts/aggreg.sales | |
| UMSGEO_01 | Sales transactions (till receipts) at cost | |
| PRSNLS | Price reduction from sales as per receipts/aggregated sales | |
| PDIFF | Trnsctn price diff. between R/3 -> and sales price at POS | |
| ZMUMS | Means of payment sales from sales as per receipts/aggr.sales | |
| PRVBT | Commission amount, sales | |
| UMSGVC | Retail price from sales without manufacturer's coupons | |
| Column Name | Description | |
|---|---|---|
| 📏 Sales unit (S120.VRKME): | ||
| VKMNG | Transaction sales - quantity in sales unit | |
| 📏 Base Unit of Measure (S120.BASME): | ||
| UMSMNG | Transaction sales - quantity in base unit of measure | |
| Column Name | Description | |
|---|---|---|
| SPTAG | Period to analyze - current date | |
| EZEIT | Entry time |
| Column Name | Description | |
|---|---|---|
| VKSTD | Hour of sale | Show values |
| KKENN | Condition type identification | Show values |
| KUNDK | Customer ID | Show values |
| PAYDIR | Direction of payment type (outbound/inbound) | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| PERIV | Fiscal Year Variant | PERIV | |
| VWDAT | Pointer to administrative data | VWDAT | |
| AZBON | Number of transactions from sales as per till receipts | BCSP6 | |
| BONPOS | No. of material items per transaction (till receipt) | DEC9_3 | |
| KTONR | Bank account number | BANKN | |
| BNKLZ | Bank Keys | BANKK | |
| KRFNR | Card Sequence Number | CHAR15 | |
| KASNAM | Cashier name | CHAR35 | |
| SERNR | BOM Explosion Number | CHAR25 | |
| ANZCOND | Number of conditions from sales as per receipt/aggregated | BCSP6 | |
| VKFNR | Salesperson number | PERNR | |
| UMART | Sales type (sales/returns/empties) | CHAR1 | |
| DUMMY1 | Dummy element 1 POS (10 characters) | CHAR6 | |
| DUMMY2 | Dummy element 2 POS (10 characters) | CHAR4 | |
| DUMMY3 | Dummy element 3 POS (10 characters) | CHAR4 | |
| DUMMY4 | Dummy element 4 POS (10 characters) | CHAR10 | |
| DUMMY5 | Dummy element 5 POS (10 characters) | CHAR10 | |
| KBDNR | Cashier number | PERNR | |
| CONDID | Condition Type Identification | CHAR20 |
| Master Data Relations | Join Conditions |
|---|---|
Promotion
| |
| Base Unit of Measure | |
Bonus buy
| |
| Sales district | |
| Payment cards: Card type | |
Payment cards: Card number
| |
Condition type, sales
| |
| Customer number | |
| Transact. type | |
| Client | S120BIW2.MANDT == T000.MANDT |
| Material Group | |
Material Number
| |
| Sales group | |
| Sales Organization | |
| Sales unit | |
Distribution Channel
| |
| SD Document Currency | |
| Plant | |
Payment method as condition
|