S116 - Customer Analysis
Customer Analysis information is stored in SAP table S116.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".
Fields for table S116
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| SSOUR | Statistic(s) origin | X | SSOUR | CHAR | 8 | |
| VRSIO | Version number in the information structure | X | VRSIO | CHAR | 6 | * |
| SPMON | Period to analyze - month | X | SPMON | NUMC | 12 | |
| SPTAG | Period to analyze - current date | X | SPTAG | DATS | 16 | |
| SPWOC | Period to analyze - week | X | SPWOC | NUMC | 12 | |
| SPBUP | Period to analyze - posting period | X | SPBUP | NUMC | 12 | |
| VKORG | Sales Organization | X | VKORG | CHAR | 8 | TVKO |
| VTWEG | Distribution Channel | X | VTWEG | CHAR | 4 | TVTW |
| SPART | Division | X | SPART | CHAR | 4 | TSPA |
| IWERK | Maintenance Planning Plant | X | IWERK | CHAR | 8 | T399I |
| QMART | Notification Type | X | QMART | CHAR | 4 | TQ80 |
| KUNUM | Customer Number | X | KUNUM | CHAR | 20 | KNA1 |
| TPLNR | Functional Location | X | TPLNR | CHAR | 60 | IFLOT |
| EQUNR | Equipment Number | X | EQUNR | CHAR | 36 | EQUI |
| BAUTL | Assembly | X | BAUTL | CHAR | 80 | MARA |
| PERIV | Fiscal Year Variant | PERIV | CHAR | 4 | * | |
| VWDAT | Pointer to administrative data | VWDAT | NUMC | 20 | ||
| SUNIT | Unit for Breakdown Duration | MAUEH | UNIT | 6 | T006 | |
| SMOFN | No.of recorded notifications | SMOFN | DEC | 5 | ||
| SMMAB | No. of completed notifications | SMMAB | DEC | 5 | ||
| SABTG | No. processing days creation to completion | SABTG | DEC | 5 | ||
| SGMSAUS | Number of machine breakdowns reported | SGMSAUS | DEC | 5 | ||
| SGAUSZT | Downtime entered | SGAUSZT | QUAN | 7 | ||
| SSCODE | PMIS: No.of damages | SSCODE | DEC | 5 | ||
| SACODE | PMIS: number of activity codes | SACODE | DEC | 5 | ||
| SUCODE | PMIS: No. of cause of damage codes | SUCODE | DEC | 5 |