S496 SAP (DRM: MS Side Business Metrics) Table details
Dictionary Type: Table
Description: DRM: MS Side Business Metrics
Description: DRM: MS Side Business Metrics
Table field list including key, data, relationships and ABAP select examples
S496 is a standard SAP Table which is used to store DRM: MS Side Business Metrics data and is available within R/3 SAP systems depending on the version and release level.
The S496 table consists of various fields, each holding specific information or linking keys about DRM: MS Side Business Metrics data available in SAP. These include SPTAG (Period to analyze - current date), TRK_PRNR (Tracking partner), ENDCUST (Customer to whom distributor/ reseller made resale), SALES_ORG (Sales Organization).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP S496 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
SPTAG | Period to analyze - current date | SPTAG | DATS | 8 | DATUM | ||||
TRK_PRNR | Tracking partner | TRK_PRNR | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
ENDCUST | Customer to whom distributor/ reseller made resale | END_CUST | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
SALES_ORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
DIST_CHNL | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
DIVN | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
VRSIO | Version number in the information structure | VRSIO | CHAR | 3 | Assigned to domain | VRSIO | MCV | ||
SPMON | Period to analyze - month | SPMON | NUMC | 6 | PERI | MCPERIOD | |||
SPWOC | Period to analyze - week | SPWOC | NUMC | 6 | PERI | MCPERIOD | |||
SPBUP | Period to analyze - posting period | SPBUP | NUMC | 6 | PERI | MCPERIOD | |||
SSOUR | Statistic(s) origin | SSOUR | CHAR | 4 | SSOUR | ||||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | Assigned to domain | PERIV | |||
VWDAT | Pointer to administrative data | VWDAT | NUMC | 10 | VWDAT | ||||
BASME | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
STWAE | Statistics currency | STWAE | CUKY | 5 | TCURC | WAERS | |||
SDQTAPP | Ship-and-debit claim quantity approved | SDQTAPP | QUAN | 15(3) | MENGV15_3 | ||||
SDAMAPP | Ship-and-debit claim amount approved | SDAMAPP | CURR | 15(2) | WERTV8 | ||||
SDQTCLM | Ship-and-debit claim quantity sent by distributor/ reseller | SDQTCLM | QUAN | 15(3) | MENGV15_3 | ||||
SDAMCLM | Ship-and-debit claimed amount | SDAMCLM | CURR | 15(2) | WERTV8 | ||||
PPQTCR | Price protection claim approved quantity | PPQTCR | QUAN | 15(3) | MENGV15_3 | ||||
PPAMCR | Price protection approved amount | PPAMCR | CURR | 15(2) | WERTV8 | ||||
PPQTDB | Price protection claimed quantity | PPQTDB | QUAN | 15(3) | MENGV15_3 | ||||
PPAMDB | Price protection claimed amount | PPAMDB | CURR | 15(2) | WERTV8 | ||||
BLQTCLM | Bill-up claim quantity | BLQTCLM | QUAN | 15(3) | MENGV15_3 | ||||
BLAMCLM | Bill-up claim amount | BLAMCLM | CURR | 15(2) | WERTV8 | ||||
STQTNL | Quantity of material resold from normal lot | STQTNL | QUAN | 15(3) | MENGV15_3 | ||||
STQTBP | Quantity of material resold from special buy lot | STQTBP | QUAN | 15(3) | MENGV15_3 | ||||
STAMNL | Value of resale from normal lot | STAMNL | CURR | 15(2) | WERTV8 | ||||
STAMBP | Value of resale of material from special buy lot | STAMBP | CURR | 15(2) | WERTV8 | ||||
ERTQTNL | Quantity of material returned by resale customer | ERTQTNL | QUAN | 15(3) | MENGV15_3 | ||||
ERTQTBP | Resale return quantity from special buy lot | ERTQTBP | QUAN | 15(3) | MENGV15_3 | ||||
ERTAMNL | Refund amount against resale return from normal lot | ERTAMNL | CURR | 15(2) | WERTV8 | ||||
RTQTBKP | Refund amount against resale return from special buy lot | RTQTBKP | CURR | 15(2) | WERTV8 | ||||
RTNMQYGR | Return quantity issued/ received from normal lot | RTNMQYGR | QUAN | 15(3) | MENGV15_3 | ||||
RTBPQYCM | Return quantity from special buy lot approved for refund | RTBPQYCM | QUAN | 15(3) | MENGV15_3 | ||||
DRTAMNL | Refund amount for sales return from normal lot | DRTAMNL | CURR | 15(2) | WERTV8 | ||||
DRTAMBP | Sales return quantity from special buy lot | DRTAMBP | QUAN | 15(3) | MENGV15_3 | ||||
DRTQYNAP | Normal price lot return quantity approved for refund | DRTQYNAP | QUAN | 15(3) | MENGV15_3 | ||||
DRTAMBAP | Refund amount approved against return from special buy lot | DRTAMBAP | CURR | 15(2) | WERTV8 | ||||
SIQYNLGI | Goods Issue quantity for normal lot sale to distributor | SIQYNLGI | QUAN | 15(3) | MENGV15_3 | ||||
SIQYNLIV | Invoiced quantity for normal lot sale to distributor | SIQYNLIV | QUAN | 15(3) | MENGV15_3 | ||||
SIAMNL | Normal lot invoice amount | SIAMNL | CURR | 15(2) | WERTV8 | ||||
SIQYBPGI | Special buy lot quantity sold to distributor/ reseller | SIQYBPGI | QUAN | 15(3) | MENGV15_3 | ||||
SIQYBPIV | Special buy invoiced quantity | SIQYBPIV | QUAN | 15(3) | MENGV15_3 | ||||
SIAMBP | Special buy invoice amount | SIAMBP | CURR | 15(2) | WERTV8 | ||||
PCRQYNL | Increment applied on normal lot quantity for reconciliation | PCRQYNL | QUAN | 15(3) | MENGV15_3 | ||||
PCRQYBP | Increment applied to special buy quantity for reconciliation | PCRQYBP | QUAN | 15(3) | MENGV15_3 | ||||
NCRQYNL | Reduction applied for reconciliation of normal lot quantity | NCRQYNL | QUAN | 15(3) | MENGV15_3 | ||||
NCRQYBP | Reduction applied to special buy quantity for reconciliation | NCRQYBP | QUAN | 15(3) | MENGV15_3 | ||||
DSAMNL | Drop ship amount for normal lot | DSAMNL | CURR | 15(2) | WERTV8 | ||||
DSQYNL | Drop ship quantity from normal lot | DSQYNL | QUAN | 15(3) | MENGV15_3 | ||||
DSQYBP | Drop ship quantity from special buy lot | DSQYBP | QUAN | 15(3) | MENGV15_3 | ||||
DSAMBP | Drop ship amount for special buy lot | DSAMBP | CURR | 15(2) | WERTV8 | ||||
STDSQYNL | Drop-ship quantity from normal lot | STDSQYNL | QUAN | 15(3) | MENGV15_3 | ||||
STDSAMNL | Amount for drop-ship resale from normal lot | STDSAMNL | CURR | 15(2) | WERTV8 | ||||
STDSQYBP | Drop-ship quantity from special buy lot | STDSQYBP | QUAN | 15(3) | MENGV15_3 | ||||
STDSAMBP | DRM Drop Ship (Special Price) Amount Sell Through | STDSAMBP | CURR | 15(2) | WERTV8 |
Key field | Non-key field |
How do I retrieve data from SAP table S496 using ABAP code
The following ABAP code Example will allow you to do a basic selection on S496 to SELECT all data from the tableDATA: WA_S496 TYPE S496.
SELECT SINGLE *
FROM S496
INTO CORRESPONDING FIELDS OF WA_S496
WHERE...
How to access SAP table S496
Within an ECC or HANA version of SAP you can also view further information about S496 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects