SAP ABAP Table /POSDW/V_DEFLT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	/POSDW/V_DEFLT	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	PROFILETYPE	☑	/POSDW/PROFILETYPE	/POSDW/PROFILETYPE	CHAR	4	0	Customizing Profile Type	/POSDW/PROF
3	DESCRIPTION	☐	/POSDW/DESCRIPTION	/POSDW/DESCRIPTION	CHAR	50	0	Description
4	DEFAULTPARTNERID	☐	/POSDW/DEFAULTPARTNERID		CHAR	13	0	Partner Number
5	ERRORPARTNERID	☐	/POSDW/ERRORPARTNERID		CHAR	13	0	Partner Number
6	DEFAULTMATNR	☐	/POSDW/DEFAULTMATERIALNUMBER	MATNR	CHAR	18	0	Standard for Material If Blank in POS Transaction
7	ERRORMATNR	☐	/POSDW/ERRORMATERIALNUMBER	MATNR	CHAR	18	0	Standard for Material, if Incorrect in POS Transaction
8	TEXTMATNR	☐	/POSDW/TEXTMATERIALNUMBER	MATNR	CHAR	18	0	Standard for Material, if Text Sent in Field ItemID
9	TRANSCURRENCY	☐	/POSDW/DEFAULTTRANSCURRENCY	WAERS	CUKY	5	0	Standard for Document Currency if Not in POS Transaction	TCURC
10	LTEXT	☐	LTEXT	TEXT40	CHAR	40	0	Long Text
11	RETAIL	☐	/POSDW/DEFAULTRETAIL	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	POS Transaction Type for Sales Movements	/POSDW/TRANTY
12	TOTALS	☐	/POSDW/DEFAULTTOTALS	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	POS Transaction Type for Totals Records	/POSDW/TRANTY
13	FIMOVEMENT	☐	/POSDW/DEFAULTFINANCIALMOVEMEN	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	POS Transaction Category for Financial Transactions	/POSDW/TRANTY
14	GOODSMOVEMENT	☐	/POSDW/DEFAULTGOODSMOVEMENT	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	POS Transaction Type for Goods Movements, if Missing	/POSDW/TRANTY
15	CONTROL	☐	/POSDW/DEFAULTCONTROL	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	POS Transaction Type for Control Transactions, if Missing	/POSDW/TRANTY
16	POSTVOID	☐	/POSDW/DEFAULTPOSTVOID	/POSDW/TRANSACTIONTYPECODE	CHAR	4	0	POS Transaction Type for Cancellation Transactions	/POSDW/TRANTY
17	RETAILTYPECODE	☐	/POSDW/DEFAULTRETAILTYPECODE	/POSDW/RETAILTYPECODE	CHAR	4	0	Sales Item Type Code, if Missing	/POSDW/RETTY

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/POSDW/V_DEFLT	CONTROL	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
2	/POSDW/V_DEFLT	FIMOVEMENT	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
3	/POSDW/V_DEFLT	GOODSMOVEMENT	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
4	/POSDW/V_DEFLT	POSTVOID	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
5	/POSDW/V_DEFLT	PROFILETYPE	/POSDW/PROF	PROFILETYPE	KEY	1	CN
6	/POSDW/V_DEFLT	RETAIL	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
7	/POSDW/V_DEFLT	RETAILTYPECODE	/POSDW/RETTY	RETAILTYPECODE	KEY	1	CN
8	/POSDW/V_DEFLT	TOTALS	/POSDW/TRANTY	TRANSTYPECODE	KEY	1	CN
9	/POSDW/V_DEFLT	TRANSCURRENCY	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20100326
SAP Release Created in