SAP ABAP Table MSSQ (Project Stock Total)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0
Basic Data
Table Category TRANSP    Transparent table 
Transparent table MSSQ   Table Relationship Diagram
Short Description Project Stock Total    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
3 WERKS WERKS_D WERKS CHAR 4   0   Plant MARC
4 SOBKZ SOBKZ SOBKZ CHAR 1   0   Special Stock Indicator T148
5 PSPNR PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) PRPS
6 LFGJA LFGJA GJAHR NUMC 4   0   Fiscal Year of Current Period  
7 LFMON LFMON MONAT NUMC 2   0   Current period (posting period)  
8 SQLAB LABST MENG13V QUAN 13   3   Valuated Unrestricted-Use Stock  
9 SQINS INSME MENG13V QUAN 13   3   Stock in Quality Inspection  
10 SQSPE SPEME MENG13V QUAN 13   3   Blocked stock  
11 SQEIN EINME MENG13V QUAN 13   3   Total Stock of All Restricted Batches  
12 ERSDA ERSDA DATUM DATS 8   0   Created On  
13 KZBWS KZBWS KZBWS CHAR 1   0   Valuation of Special Stock  
14 SQTRA SQTRA MENG13V QUAN 13   3   Stock in transit  
15 SQRUE SBRUE XFELD CHAR 1   0   MxxxH rec. already exists for per. before last of Mxxx per.  
16 SQBWE SQBWE MENG13V QUAN 13   3   Valuated Goods Receipt Blocked Stock, Project  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 MSSQ MANDT T000 MANDT KEY 1 CN
2 MSSQ MATNR MARA MATNR KEY 1 CN
3 MSSQ PSPNR PRPS PSPNR KEY 1 CN
4 MSSQ SOBKZ T148 SOBKZ KEY 1 CN
5 MSSQ WERKS MARC WERKS KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in