SAP ABAP Table MSOA (Total Sales Orders on Hand with Vendor)

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	MSOA	Table Relationship Diagram
Short Description	Total Sales Orders on Hand with Vendor

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	T001W
4	LIFNR	☑	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
5	SOBKZ	☑	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
6	VBELN	☑	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	VBUK
7	POSNR	☑	POSNR	POSNR	NUMC	6	0	Item number of the SD document	VBUP
8	LFGJA	☐	LFGJA	GJAHR	NUMC	4	0	Fiscal Year of Current Period
9	LFMON	☐	LFMON	MONAT	NUMC	2	0	Current period (posting period)
10	OALAB	☐	LABST	MENG13V	QUAN	13	3	Valuated Unrestricted-Use Stock
11	OAINS	☐	INSME	MENG13V	QUAN	13	3	Stock in Quality Inspection
12	OASPE	☐	SPEME	MENG13V	QUAN	13	3	Blocked stock

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MSOA	LIFNR	LFA1	LIFNR	KEY	1	CN
2	MSOA	MANDT	T000	MANDT	KEY	1	CN
3	MSOA	MATNR	MARA	MATNR	KEY	1	CN
4	MSOA	POSNR	VBUP	POSNR	KEY	1	CN
5	MSOA	SOBKZ	T148	SOBKZ	KEY	1	CN
6	MSOA	VBELN	VBUK	VBELN	KEY	1	CN
7	MSOA	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in