S077 SAP (STRPS: Movements) Table details

Dictionary Type: Table
Description: STRPS: Movements




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




Table field list including key, data, relationships and ABAP select examples

S077 is a standard SAP Table which is used to store STRPS: Movements data and is available within R/3 SAP systems depending on the version and release level.

The S077 table consists of various fields, each holding specific information or linking keys about STRPS: Movements data available in SAP. These include SSOUR (Statistic(s) origin), VRSIO (Version number in the information structure), SPMON (Period to analyze - month), SPTAG (Period to analyze - current date).. 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 S077 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
SSOURStatistic(s) origin SSOURCHAR4SSOUR
VRSIOVersion number in the information structure VRSIOCHAR3Assigned to domainVRSIOMCV
SPMONPeriod to analyze - month SPMONNUMC6PERIMCPERIOD
SPTAGPeriod to analyze - current date SPTAGDATS8DATUM
SPWOCPeriod to analyze - week SPWOCNUMC6PERIMCPERIOD
SPBUPPeriod to analyze - posting period SPBUPNUMC6PERIMCPERIOD
EKORGPurchasing Organization EKORGCHAR4T024EEKORGEKO
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
BZIRKSales district BZIRKCHAR6T171BZIRKBZI
BTRKZPlant category VLFKZCHAR1VLFKZ
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
WGRU2Material group hierarchy 2 MCW_WGRU2CHAR18KLASSEWGRU2
WGRU1Material group hierarchy 1 MCW_WGRU1CHAR18KLASSEWGRU1
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
PERIVFiscal Year Variant PERIVCHAR2Assigned to domainPERIV
VWDATPointer to administrative data VWDATNUMC10VWDAT
BASMEBase Unit of Measure MEINSUNIT3T006CUNITMEINS
HWAERLocal Currency HWAERCUKY5TCURCWAERS
UMSMNGSales quantity in base unit of measure MCW_UMSMNGQUAN15(3) MENGV15_3
UMSGEOSales at cost MCW_UMSGEOCURR19(2) WERTV10
UMSGVOSales at retail MCW_UMSGVOCURR19(2) WERTV10
UMSGVPSales at retail with tax MCW_UMSGVPCURR19(2) WERTV10
PRSNLSSales deviation during sales MCW_PRSNLSCURR19(2) WERTV10
AUMMNGPromotion sales quantity in BUn MCW_AUMMNGQUAN15(3) MENGV15_3
AUMGEOPromotion sales at cost MCW_AUMGEOCURR19(2) WERTV10
AUMGVOPromotion sales at retail MCW_AUMGVOCURR19(2) WERTV10
AUMGVPPromotion sales at retail with tax MCW_AUMGVPCURR19(2) WERTV10
WESMNGGoods receipt (vendor) quantity in BUn MCW_WESMNGQUAN15(3) MENGV15_3
WESGEOGoods receipt (vendor) at cost MCW_WESGEOCURR19(2) WERTV10
WESGVOGoods receipt (vendor) at retail MCW_WESGVOCURR19(2) WERTV10
WESGVPGoods receipt (vendor) at retail with tax MCW_WESGVPCURR19(2) WERTV10
WESANZGoods receipt (vendor) number of transactions MCW_WESANZINT410MCZAEHLINT
RTEMNGReturns to vendor quantity in base unit of measure MCW_RTEMNGQUAN15(3) MENGV15_3
RTEGEOReturns to vendor at cost MCW_RTEGEOCURR19(2) WERTV10
RTEGVOReturns to vendor at retail MCW_RTEGVOCURR19(2) WERTV10
RTEGVPReturns to vendor at retail with tax MCW_RTEGVPCURR19(2) WERTV10
RTEANZReturns to vendor, no. of transactions MCW_RTEANZINT410MCZAEHLINT
KMEMNGGoods receipt (distribution center) quantity in BUn MCW_KMEMNGQUAN15(3) MENGV15_3
KMEGEOGoods receipt (DC) at cost MCW_KMEGEOCURR19(2) WERTV10
KMEGVOGoods receipt (DC) at retail MCW_KMEGVOCURR19(2) WERTV10
KMEGVPGoods receipt (dist. center) at retail with tax MCW_KMEGVPCURR19(2) WERTV10
KMEANZGoods receipt (distribution center), no. of transactions MCW_KMEANZINT410MCZAEHLINT
KMAMNGGoods issue (distribution center) quantity in BUn MCW_KMAMNGQUAN15(3) MENGV15_3
KMAGEOGoods issue (DC) at cost MCW_KMAGEOCURR19(2) WERTV10
KMAGVOGoods issue (DC) at retail MCW_KMAGVOCURR19(2) WERTV10
KMAGVPGoods issue (dist. center) at retail with tax MCW_KMAGVPCURR19(2) WERTV10
KMAANZGoods issue (distribution center), no. of transactions MCW_KMAANZINT410MCZAEHLINT
ULEMNGGoods clearing: receipts quantity in BUn MCW_ULEMNGQUAN15(3) MENGV15_3
ULEGEOGoods clearing: receipts at cost MCW_ULEGEOCURR19(2) WERTV10
ULEGVOGoods clearing: receipts at retail MCW_ULEGVOCURR19(2) WERTV10
ULEGVPGoods clearing: receipts at retail with tax MCW_ULEGVPCURR19(2) WERTV10
ULEANZGoods clearing: receipts, no. of transactions MCW_ULEANZINT410MCZAEHLINT
ULAMNGGoods clearing: issues quantity in BUn MCW_ULAMNGQUAN15(3) MENGV15_3
ULAGEOGoods clearing: issues at cost MCW_ULAGEOCURR19(2) WERTV10
ULAGVOGoods clearing: issues at retail MCW_ULAGVOCURR19(2) WERTV10
ULAGVPGoods clearing: issues at retail with tax MCW_ULAGVPCURR19(2) WERTV10
ULAANZGoods clearing: issues, no. of transactions MCW_ULAANZINT410MCZAEHLINT
AUEMNGMaterial transfer: receipts quantity BUn MCW_AUEMNGQUAN15(3) MENGV15_3
AUEGEOMaterial transfer: receipts at cost MCW_AUEGEOCURR19(2) WERTV10
AUEGVOMaterial transfer: receipts at retail MCW_AUEGVOCURR19(2) WERTV10
AUEGVPMaterial transfer: receipts at retail with tax MCW_AUEGVPCURR19(2) WERTV10
AUEANZMaterial transfer: receipts, no. transactions MCW_AUEANZINT410MCZAEHLINT
AUAMNGMaterial transfer: issues quantity BUn MCW_AUAMNGQUAN15(3) MENGV15_3
AUAGEOMaterial transfer: issues at cost MCW_AUAGEOCURR19(2) WERTV10
AUAGVOMaterial transfer: issues at retail MCW_AUAGVOCURR19(2) WERTV10
AUAGVPMaterial transfer: issues at retail with tax MCW_AUAGVPCURR19(2) WERTV10
AUAANZMaterial transfer: issues, no. of transactions MCW_AUAANZINT410MCZAEHLINT
BKIPMGStock adjustment inventory difference plus (quantity) MCW_BKIPMGQUAN15(3) MENGV15_3
BKIPEOStock adjustment inventory difference plus (cost) MCW_BKIPEOCURR19(2) WERTV10
BKIPVOStock adjustment inventory difference plus (retail) MCW_BKIPVOCURR19(2) WERTV10
BKIPVPStock adjustment inventory difference plus (at retail w/tax) MCW_BKIPVPCURR19(2) WERTV10
BKIPAZStock adjustment inv. difference plus (no. of transactions) MCW_BKIPAZINT410MCZAEHLINT
BKIMMGStock adjustment inventory difference minus (quantity) MCW_BKIMMGQUAN15(3) MENGV15_3
BKIMEOStock adjustment inventory difference minus (cost) MCW_BKIMEOCURR19(2) WERTV10
BKIMVOStock adjustment inventory difference minus (retail) MCW_BKIMVOCURR19(2) WERTV10
BKIMVPStock adjustment inventory difference minus (retail w/tax) MCW_BKIMVPCURR19(2) WERTV10
BKIMAZStock adjustment inv. difference minus (no. of transactions) MCW_BKIMAZINT410MCZAEHLINT
BKSPMGStock adjustment miscellaneous plus (quantity) MCW_BKSPMGQUAN15(3) MENGV15_3
BKSPEOStock adjustment miscellaneous plus (cost) MCW_BKSPEOCURR19(2) WERTV10
BKSPVOStock adjustment miscellaneous plus (retail) MCW_BKSPVOCURR19(2) WERTV10
BKSPVPStock adjustment miscellaneous plus (retail with tax) MCW_BKSPVPCURR19(2) WERTV10
BKSPAZStock adjustment miscellaneous plus (no. of transactions) MCW_BKSPAZINT410MCZAEHLINT
BKSMMGStock adjustment miscellaneous minus (quantity) MCW_BKSMMGQUAN15(3) MENGV15_3
BKSMEOStock adjustment miscellaneous minus (cost) MCW_BKSMEOCURR19(2) WERTV10
BKSMVOStock adjustment miscellaneous minus (retail) MCW_BKSMVOCURR19(2) WERTV10
BKSMVPStock adjustment miscellaneous minus (retail with tax) MCW_BKSMVPCURR19(2) WERTV10
BKSMAZStock adjustment miscellaneous minus (no. of transactions) MCW_BKSMAZINT410MCZAEHLINT
BVLMNGOrder volume quantity Retail MCW_BVLMNGQUAN15(3) MENGV15_3
BVLGEOOrder volume at cost MCW_BVLGEOCURR19(2) WERTV10
BVLGVOOrder volume at retail MCW_BVLGVOCURR19(2) WERTV10
BVLGVPOrder volume at retail with tax MCW_BVLGVPCURR19(2) WERTV10
BVLANZOrder volume, number of transactions MCW_BVLANZINT410MCZAEHLINT
UBPEPMRevaluation at cost, plus, quantity MCW_UBPEPMQUAN15(3) MENGV15_3
UBPGEORevaluation at cost, plus MCW_UBPGEOCURR19(2) WERTV10
UBPEAZRevaluation at cost plus, no. of transactions MCW_UBPEAZINT410MCZAEHLINT
UBMEPMRevaluation at cost minus, quantity MCW_UBMEPMQUAN15(3) MENGV15_3
UBMGEORevaluation at cost, minus MCW_UBMGEOCURR19(2) WERTV10
UBMEAZRevaluation at cost minus, no. of transactions MCW_UBMEAZINT410MCZAEHLINT
UBPVPMRevaluation at retail, plus, quantity MCW_UBPVPMQUAN15(3) MENGV15_3
UBPGVORevaluation at retail, plus MCW_UBPGVOCURR19(2) WERTV10
UBPGVPRevaluation at retail, plus, at retail with tax MCW_UBPGVPCURR19(2) WERTV10
UBPVAZRevaluation at retail, plus, no. of transactions MCW_UBPVAZINT410MCZAEHLINT
UBMVPMRevaluation at retail, minus, quantity MCW_UBMVPMQUAN15(3) MENGV15_3
UBMGVORevaluation at retail, minus MCW_UBMGVOCURR19(2) WERTV10
UBMGVPRevaluation at retail, minus, at retail with tax MCW_UBMGVPCURR19(2) WERTV10
UBMVAZRevaluation at retail, minus, no. of transactions MCW_UBMVAZINT410MCZAEHLINT
ZUGMNGReceipts quantity in BUn MCW_ZUGMNGQUAN15(3) MENGV15_3
ZUGGEOReceipts at cost MCW_ZUGGEOCURR19(2) WERTV10
ZUGGVOReceipts at retail MCW_ZUGGVOCURR19(2) WERTV10
ZUGGVPReceipts at retail with tax MCW_ZUGGVPCURR19(2) WERTV10
ABGMNGIssues quantity in BUn MCW_ABGMNGQUAN15(3) MENGV15_3
ABGGEOIssues at cost MCW_ABGGEOCURR19(2) WERTV10
ABGGVOIssues at retail MCW_ABGGVOCURR19(2) WERTV10
ABGGVPIssues at retail with tax MCW_ABGGVPCURR19(2) WERTV10

Key field Non-key field



How do I retrieve data from SAP table S077 using ABAP code

The following ABAP code Example will allow you to do a basic selection on S077 to SELECT all data from the table
DATA: WA_S077 TYPE S077.

SELECT SINGLE *
FROM S077
INTO CORRESPONDING FIELDS OF WA_S077
WHERE...

How to access SAP table S077

Within an ECC or HANA version of SAP you can also view further information about S077 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!