SAP ABAP View V_OIISOCTSM_SILO (Silo Management Material - tank)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-BDR (Application Component) Bulk Distribution Requirements Planning
     ⤷ OII (Package) BDRP Bulk Distribution Requirement Planning

Basic Data

View Type	D	Database View
Database View	V_OIISOCTSM_SILO
Short Description	Silo Management Material - tank
Root table	OIISOCTSM	SOC: time dependent assignment SO <-> material (IS-Oil BDR

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIISOCTSM	OIISOCTSM
2	OIISOCISL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIISOCTSM	MANDT	JL	EQ				0	0
2	OIISOCISL	MANDT	JR	EQ			AND	0	0
3	OIISOCTSM	SOCNR	JL	EQ				0	0
4	OIISOCISL	SOCNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	OIISOCISL	MANDT		☐	MANDT	☐	Client
2	LGORT	OIISOCISL	LGORT		☐	LGORT_D	☐	Storage location
3	SEQNR	OIISOCISL	SEQNR		☐	OII_SSEQNR	☐	Sequence number of SO assigned to storage location
4	WERKS	OIISOCISL	WERKS		☐	WERKS_D	☐	Plant
5	FTMSTM	OIISOCTSM	FTMSTM		☐	OII_FTMSTM	☐	From/start time stamp (BDRP)
6	ASSCNT	OIISOCTSM	ASSCNT		☐	OII_ASSCNT	☐	Multiple material assignment counter (equal from timestamp)
7	TTMSTM	OIISOCTSM	TTMSTM		☐	OII_TTMSTM	☐	To/end timestamp (BDRP)
8	MATNR	OIISOCTSM	MATNR		☐	MATNR	☐	Material Number
9	CHARG	OIISOCTSM	CHARG		☐	CHARG_D	☐	Batch Number
10	BWTAR	OIISOCTSM	BWTAR		☐	BWTAR_D	☐	Valuation type
11	BSTAR	OIISOCTSM	BSTAR		☐	BSTAR	☐	Stock type
12	NS_STOCK	OIISOCTSM	NS_STOCK		☐	OII_NS_STOCK	☐	Non-special stock indicator
13	SO_STOCK	OIISOCTSM	SO_STOCK		☐	OII_SO_STOCK	☐	Sales order stock indicator
14	VC_STOCK	OIISOCTSM	VC_STOCK		☐	OII_VC_STOCK	☐	Vendor consignment stock indicator
15	PR_STOCK	OIISOCTSM	PR_STOCK		☐	OII_PR_STOCK	☐	Project stock indicator

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	20110901
SAP Release Created in