- 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)
S001BIW2
S001BIW2 * SIS: Customer statistics
|
#transactional
|
Component: Data Collection
- 🔑 Keys (12)
- 💰 Amounts (33)
- ∑ Quantities (5)
- 📅 Dates (1)
- ☰ Categorical
- Other (3)
- 🔗 Relations (7)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| SPBUP | Period to analyze - posting period | |
| KUNNR FK | Sold-to Party | |
| VKORG FK | Sales Organization | |
| VTWEG FK | Distribution Channel | |
| SPART FK | Division | |
| MATNR FK | Material Number | |
| VRSIO | Version number in the information structure | |
| SPMON | Period to analyze - month | |
| SPTAG | Period to analyze - current date | |
| SPWOC | Period to analyze - week | |
| SSOUR | Statistic(s) origin |
| Column Name | Description | |
|---|---|---|
| 💲 Statistics currency (STWAE): | ||
| AENETWR | Net Value of Incoming Orders | |
| UMNETWR | Net Value of Invoiced Sales | |
| OAUWE | Net Value of Open Orders | |
| RENETWR | Net Value of Incoming Returns | |
| GUNETWR | Net Value of Credit Memos | |
| AEWAVWR | Cost of incoming orders | |
| UMWAVWR | Cost of invoiced sales | |
| REWAVWR | Incoming returns: cost | |
| GUWAVWR | Credit memos: cost | |
| AEKZWI1 | Incoming orders: gross | |
| UMKZWI1 | Invoiced sales: gross | |
| REKZWI1 | Incoming returns: gross | |
| GUKZWI1 | Credit memos: gross | |
| AEKZWI2 | Incoming orders: net 1 | |
| UMKZWI2 | Invoiced sales: net 1 | |
| REKZWI2 | Incoming returns: net 1 | |
| GUKZWI2 | Credit memos: net 1 | |
| AEKZWI3 | Incoming orders: net 2 | |
| UMKZWI3 | Invoiced sales: net 2 | |
| REKZWI3 | Incoming returns: net 2 | |
| GUKZWI3 | Credit memos: net 2 | |
| AEKZWI4 | Incoming orders: freight | |
| UMKZWI4 | Invoice freight charges | |
| REKZWI4 | Incoming returns: freight | |
| GUKZWI4 | Credit memos: freight | |
| AEKZWI5 | Incoming orders: pricing subtotal 5 | |
| UMKZWI5 | Billing document: pricing subtotal 5 | |
| REKZWI5 | Incoming returns: pricing subtotal 5 | |
| GUKZWI5 | Credit memos: pricing subtotal 5 | |
| AEKZWI6 | Incoming orders: pricing subtotal 6 | |
| UMKZWI6 | Billing document: pricing subtotal 6 | |
| REKZWI6 | Incoming returns: pricing subtotal 6 | |
| GUKZWI6 | Credit memos: pricing subtotal 6 | |
| Column Name | Description | |
|---|---|---|
| 📏 Base Unit of Measure (BASME): | ||
| AEMENGE | Incoming Orders Quantity | |
| UMMENGE | Sales Volume Quantity | |
| OAUME | Open orders quantity in base unit of measure | |
| REMENGE | Quantity of Returns | |
| GUMENGE | Quantity of Credit Memos | |
| Column Name | Description | |
|---|---|---|
| SPTAG | Period to analyze - current date |
| Column Name | Description |
|---|
| Column Name | Description | Domain name | |
|---|---|---|---|
| VWDAT | Pointer to administrative data | VWDAT | |
| ANZAUPOS | Number of Order Items | MCZAEHLER | |
| ANZREPOS | No.of returns items | MCZAEHLER |
| Master Data Relations | Join Conditions |
|---|---|
| Sold-to Party | |
| Client | S001BIW2.MANDT == T000.MANDT |
Material Number
| |
Fiscal Year Variant
| |
| Division | |
| Sales Organization | |
Distribution Channel
|