S496 SAP (DRM: MS Side Business Metrics) Table details

Dictionary Type: Table
Description: DRM: MS Side Business Metrics




ABAP Code to SELECT data from S496
Related tables to S496
Access table S496




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
MANDTClient MANDTCLNT3T000MANDT
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
TRK_PRNRTracking partner TRK_PRNRCHAR10BUT000ALPHABU_PARTNER
ENDCUSTCustomer to whom distributor/ reseller made resale END_CUSTCHAR10BUT000ALPHABU_PARTNER
SALES_ORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
DIST_CHNLDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
DIVNDivision SPARTCHAR2TSPASPARTSPAC_SPART
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
SSOURStatistic(s) origin SSOURCHAR4SSOUR
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
BASMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
STWAEStatistics currency STWAECUKY5TCURCWAERS
SDQTAPPShip-and-debit claim quantity approved SDQTAPPQUAN15(3) MENGV15_3
SDAMAPPShip-and-debit claim amount approved SDAMAPPCURR15(2) WERTV8
SDQTCLMShip-and-debit claim quantity sent by distributor/ reseller SDQTCLMQUAN15(3) MENGV15_3
SDAMCLMShip-and-debit claimed amount SDAMCLMCURR15(2) WERTV8
PPQTCRPrice protection claim approved quantity PPQTCRQUAN15(3) MENGV15_3
PPAMCRPrice protection approved amount PPAMCRCURR15(2) WERTV8
PPQTDBPrice protection claimed quantity PPQTDBQUAN15(3) MENGV15_3
PPAMDBPrice protection claimed amount PPAMDBCURR15(2) WERTV8
BLQTCLMBill-up claim quantity BLQTCLMQUAN15(3) MENGV15_3
BLAMCLMBill-up claim amount BLAMCLMCURR15(2) WERTV8
STQTNLQuantity of material resold from normal lot STQTNLQUAN15(3) MENGV15_3
STQTBPQuantity of material resold from special buy lot STQTBPQUAN15(3) MENGV15_3
STAMNLValue of resale from normal lot STAMNLCURR15(2) WERTV8
STAMBPValue of resale of material from special buy lot STAMBPCURR15(2) WERTV8
ERTQTNLQuantity of material returned by resale customer ERTQTNLQUAN15(3) MENGV15_3
ERTQTBPResale return quantity from special buy lot ERTQTBPQUAN15(3) MENGV15_3
ERTAMNLRefund amount against resale return from normal lot ERTAMNLCURR15(2) WERTV8
RTQTBKPRefund amount against resale return from special buy lot RTQTBKPCURR15(2) WERTV8
RTNMQYGRReturn quantity issued/ received from normal lot RTNMQYGRQUAN15(3) MENGV15_3
RTBPQYCMReturn quantity from special buy lot approved for refund RTBPQYCMQUAN15(3) MENGV15_3
DRTAMNLRefund amount for sales return from normal lot DRTAMNLCURR15(2) WERTV8
DRTAMBPSales return quantity from special buy lot DRTAMBPQUAN15(3) MENGV15_3
DRTQYNAPNormal price lot return quantity approved for refund DRTQYNAPQUAN15(3) MENGV15_3
DRTAMBAPRefund amount approved against return from special buy lot DRTAMBAPCURR15(2) WERTV8
SIQYNLGIGoods Issue quantity for normal lot sale to distributor SIQYNLGIQUAN15(3) MENGV15_3
SIQYNLIVInvoiced quantity for normal lot sale to distributor SIQYNLIVQUAN15(3) MENGV15_3
SIAMNLNormal lot invoice amount SIAMNLCURR15(2) WERTV8
SIQYBPGISpecial buy lot quantity sold to distributor/ reseller SIQYBPGIQUAN15(3) MENGV15_3
SIQYBPIVSpecial buy invoiced quantity SIQYBPIVQUAN15(3) MENGV15_3
SIAMBPSpecial buy invoice amount SIAMBPCURR15(2) WERTV8
PCRQYNLIncrement applied on normal lot quantity for reconciliation PCRQYNLQUAN15(3) MENGV15_3
PCRQYBPIncrement applied to special buy quantity for reconciliation PCRQYBPQUAN15(3) MENGV15_3
NCRQYNLReduction applied for reconciliation of normal lot quantity NCRQYNLQUAN15(3) MENGV15_3
NCRQYBPReduction applied to special buy quantity for reconciliation NCRQYBPQUAN15(3) MENGV15_3
DSAMNLDrop ship amount for normal lot DSAMNLCURR15(2) WERTV8
DSQYNLDrop ship quantity from normal lot DSQYNLQUAN15(3) MENGV15_3
DSQYBPDrop ship quantity from special buy lot DSQYBPQUAN15(3) MENGV15_3
DSAMBPDrop ship amount for special buy lot DSAMBPCURR15(2) WERTV8
STDSQYNLDrop-ship quantity from normal lot STDSQYNLQUAN15(3) MENGV15_3
STDSAMNLAmount for drop-ship resale from normal lot STDSAMNLCURR15(2) WERTV8
STDSQYBPDrop-ship quantity from special buy lot STDSQYBPQUAN15(3) MENGV15_3
STDSAMBPDRM Drop Ship (Special Price) Amount Sell Through STDSAMBPCURR15(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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!