SAP ABAP View V_JSTO_JEST (SD-Specific Database View for Tables JSTO and JEST)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_LORD (Package) ERP Sales Lean Order

Basic Data

View Type	D	Database View
Database View	V_JSTO_JEST
Short Description	SD-Specific Database View for Tables JSTO and JEST
Root table	JSTO	Status object information

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	JSTO	JSTO
2	JEST

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	JSTO	MANDT	JL	EQ				0	0
2	JEST	MANDT	JR	EQ			AND	0	0
3	JSTO	OBJNR	JL	EQ				0	0
4	JEST	OBJNR	JR	EQ			AND	0	0
5	JSTO	STSMA		NE	' '		AND	0	0
6	JSTO	OBJNR		LK	'VB%'		AND	0	0
7	JSTO	OBTYP		EQ	'VBK'		OR	0	0
8	JSTO	OBTYP		EQ	'VBP'		AND	0	0
9	JEST	STAT		LK	'E%'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	JSTO	MANDT		☐	MANDT	☐	Client
2	OBJNR	JSTO	OBJNR		☐	J_OBJNR	☐	Object number
3	OBTYP	JSTO	OBTYP		☐	J_OBTYP	☐	Object Category
4	STSMA	JSTO	STSMA		☐	J_STSMA	☐	Status Profile
5	STAT	JEST	STAT		☐	J_STATUS	☐	Object status
6	INACT	JEST	INACT		☐	J_INACT	☐	Indicator: Status Is Inactive

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20100310
SAP Release Created in	605