S497 is a SAP table coming under IS module and ECC-DIMP component.View details, Fields & related tables of S497 in SAP.
- Table description : DRM: DR Side Business Metrics
- Module : IS-HT-DRM
- Parent Module : IS
- Package : DRM4
- Software Component : ECC-DIMP
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP S497 Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| SPTAG | Period to analyze - current date | SPTAG | DATUM |
| PARTNER | Business Partner Number | BU_PARTNER | BU_PARTNER |
| ENDCUST | Customer to whom distributor/ reseller made resale | END_CUST | BU_PARTNER |
| SALES_ORG | Sales Organization | VKORG | VKORG |
| DIST_CHNL | Distribution Channel | VTWEG | VTWEG |
| DIVN | Division | SPART | SPART |
| MATNR | Material Number | MATNR | MATNR |
| VRSIO | Version number in the information structure | VRSIO | VRSIO |
| SPMON | Period to analyze - month | SPMON | MCPERIOD |
| SPWOC | Period to analyze - week | SPWOC | MCPERIOD |
| SPBUP | Period to analyze - posting period | SPBUP | MCPERIOD |
| SSOUR | Statistic(s) origin | SSOUR | SSOUR |
| PERIV | Fiscal Year Variant | PERIV | PERIV |
| VWDAT | Pointer to administrative data | VWDAT | VWDAT |
| BASME | Base Unit of Measure | MEINS | MEINS |
| STWAE | Statistics currency | STWAE | WAERS |
| SDQTAPP | Ship-and-debit claim quantity approved | SDQTAPP | MENGV15_3 |
| SDAMAPP | Ship-and-debit claim amount approved | SDAMAPP | WERTV8 |
| SDQTCLM | Ship-and-debit claim quantity sent by distributor/ reseller | SDQTCLM | MENGV15_3 |
| SDAMCLM | Ship-and-debit claimed amount | SDAMCLM | WERTV8 |
| PPQTCR | Price protection claim approved quantity | PPQTCR | MENGV15_3 |
| PPAMCR | Price protection approved amount | PPAMCR | WERTV8 |
| PPQTDB | Price protection claimed quantity | PPQTDB | MENGV15_3 |
| PPAMDB | Price protection claimed amount | PPAMDB | WERTV8 |
| BLQTCLM | Bill-up claim quantity | BLQTCLM | MENGV15_3 |
| BLAMCLM | Bill-up claim amount | BLAMCLM | WERTV8 |
| ERTQTNL | Quantity of material returned by resale customer | ERTQTNL | MENGV15_3 |
| ERTQTBP | Resale return quantity from special buy lot | ERTQTBP | MENGV15_3 |
| ERTAMNL | Refund amount against resale return from normal lot | ERTAMNL | WERTV8 |
| RTQTBKP | Refund amount against resale return from special buy lot | RTQTBKP | WERTV8 |
| RTNMQYGR | Return quantity issued/ received from normal lot | RTNMQYGR | MENGV15_3 |
| RTBPQYCM | Return quantity from special buy lot approved for refund | RTBPQYCM | MENGV15_3 |
| DRTAMNL | Refund amount for sales return from normal lot | DRTAMNL | WERTV8 |
| DRTAMBP | Sales return quantity from special buy lot | DRTAMBP | MENGV15_3 |
| DRTQYNAP | Normal price lot return quantity approved for refund | DRTQYNAP | MENGV15_3 |
| DRTAMBAP | Refund amount approved against return from special buy lot | DRTAMBAP | WERTV8 |
| STQYNLGI | Goods issue quantity of material resold from normal lot | STQYNLGI | MENGV15_3 |
| STQYBPIV | Invoice quantity for material resold from special buy lot | STQYBPIV | MENGV15_3 |
| STQYBPGI | Goods issue quantity of material resold from special buy lot | STQYBPGI | MENGV15_3 |
| STAMNLIV | Invoice amount for resale from normal lot | STAMNLIV | WERTV8 |
| STAMBPIV | Invoice amount for resale from special buy lot | STAMBPIV | WERTV8 |
| STQYNLIV | Invoice quantity of material resold from normal lot | STQYNLIV | MENGV15_3 |
| STDSQYNL | Drop-ship quantity from normal lot | STDSQYNL | MENGV15_3 |
| STDSAMNL | Amount for drop-ship resale from normal lot | STDSAMNL | WERTV8 |
| STDSQYBP | Drop-ship quantity from special buy lot | STDSQYBP | MENGV15_3 |
| STDSAMBP | DRM Drop Ship (Special Price) Amount Sell Through | STDSAMBP | WERTV8 |
S497 related tables
| Table | Note |
|---|---|
| S496 | DRM: MS Side Business Metrics |
| S497 | DRM: DR Side Business Metrics |
| S498 | DRM: Sellin Business Metrics |
| A435 | Sales org./Distr. chl/Customer/Material/DRM Agr No/DRM Itm |
| SSCOOKIE | Business Server Pages (BSP) DB Table Server-Side Cookies |
| ACCLEANUPCONF | Table holding the configuration for Cleanup of Metrics |
| ACE_DB_EVENT_EXP | Database table for the expiered metrics |
| AICCMSBI_METRIC | Metrics |
| CRM_CSDR_WINMS | Win Metrics |
| CRM_CSDR_WINMSH | Win Metrics |
| DBA_ALRT_MET | DBA: Alerting Metrics |
| DBA_ALRT_MET_R | DBA: Alerting Metrics Rules |
| DRP_SMTC_HIST | DEV Reporting (SE28): Metrics Data |
| E2E_DPC_DIR_INPT | Metrics to be collected |
| E2E_DPC_RECEIVE | Metrics received by DPC |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP