SAP ABAP Table SLDV_QUERY (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	SLDV_QUERY	Table Relationship Diagram
Short Description	Generated Table for View

Delivery and Maintenance

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

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	MANDT	MANDT	CLNT	3	0	Client	T000
2	OS_GUID	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
3	USER_DATA_CLS	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format
4	USER_DATA_OID	TPM_DB_OS_GUID	TPM_DB_OS_GUID	CHAR	32	0	Object Identity in Database Format	TRGT_USER_DATA
5	VERSION	TPM_TRDVERSION	TPM_TRDVERSION	CHAR	6	0	Distributor Version in Generation of Data
6	OWNER	TPM_BUSTRANS_OWNER	TPM_BUSTRANS_OWNER	INT1	3	0	Origin of a Distributor Business Transaction
7	COMPANY_CODE	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
8	VALUATION_AREA	TPM_VAL_AREA	TPM_VAL_AREA	CHAR	3	0	Valuation Area	TRGC_VAL_AREA
9	BUSTRANSID	TPM_BUSTRANSID	SYSUUID	RAW	16	0	Identifier of the Distributor Business Transaction
10	BUSTRANSCAT	TPM_BUSTRANSCAT	TPM_BUSTRANSCAT	NUMC	4	0	Business Transaction Category	TRDTS_BT_CAT
11	PRODUCT_GROUP	TPM_PRODUCT_GROUP	TPM_PRODUCT_GROUP	NUMC	3	0	Product Group
12	PRODUCT_CATEGORY	SANLF	VVSANLF	NUMC	3	0	Product Category	TZAF
13	BUSTRANS_STATE	TPM_BUSTRANS_STATE	TPM_BUSTRANS_STATE	CHAR	1	0	Status of Distributor Business Transaction
14	PLANNED_ACTION	TPM_PLANNED_ACTION	TPM_PLANNED_ACTION	INT1	3	0	Planned Action in a Business Transaction
15	POSITION_DATE	TPM_POSTING_DATE	DATUM	DATS	8	0	Posting Date for the Subledger
16	CREATE_DATE	TPM_BT_CREATE_DATE	DATUM	DATS	8	0	Creation Date of the Operative Business Transaction
17	CREATE_TIME	TPM_BT_CREATE_TIME	UZEIT	TIMS	6	0	Creation Time of the Operative Business Transaction
18	REF_BUSTRANSID	TPM_REFBUSTRANSID	SYSUUID	RAW	16	0	Business Transaction ID of Reference Business Transaction
19	TR_REV_REASON	SSTOGRD	SSTOGRD	CHAR	2	0	Reason for Reversal	TZST
20	DOCUMENT_DATE	BLDAT	DATUM	DATS	8	0	Document Date in Document
21	FI_POST_DATE	TPM_FI_POSTING_DATE	DATUM	DATS	8	0	Different FI Posting Date
22	FI_POST_PERIOD	TPM_FI_POSTING_PERIOD	MONAT	NUMC	2	0	Different FI Posting Period
23	FI_REV_DATE	TPM_FI_REVERSAL_DATE	DATUM	DATS	8	0	Different FI Reversal Date
24	FI_REV_PERIOD	TPM_FI_REVERSAL_PERIOD	MONAT	NUMC	2	0	Alternative FI Reversal Period
25	DEAL_NUMBER	TB_RFHA	T_RFHA	CHAR	13	0	Financial Transaction
26	PARTITION_CAT	TPM_PARTITION_CATEGORY	TPM_PARTITION_CATEGORY	INT1	3	0	Category of Group of Distributor Flow Partitions
27	FLOW_NUMBER	TPM_TRDFLOWNR	TPM_TRDFLOWNR	INT4	10	0	Number of a Distributor Flow
28	DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	TPM_DIS_FLOWTYPE	CHAR	8	0	Update Type	TRDC_DFLOWTYPE
29	ALLOC_NMBR	DZUONR	ZUONR	CHAR	18	0	Assignment number
30	PRODUCT_TYPE	VVSART	VVSART	CHAR	3	0	Product Type	TZPA
31	TRANSACTION_TYPE	TB_SFHAART	T_SFHAART	CHAR	3	0	Financial Transaction Type	AT10
32	COM_VAL_CLASS	TPM_COM_VAL_CLASS	TPM_COM_VAL_CLASS	NUMC	4	0	General Valuation Class	TRGC_COM_VALCL
33	VALUATION_CLASS	TPM_VAL_CLASS	TPM_VAL_CLASS	NUMC	4	0	Valuation Class
34	SECURITY_ID	VVRANLW	WP_RANL	CHAR	13	0	Security ID Number	VWPANLA
35	SECURITY_ACCOUNT	RLDEPO	RLDEPO	CHAR	10	0	Securities Account
36	ACCOUNT_GROUP	TPM_SEC_ACCT_GRP	TPM_SEC_ACCT_GRP	CHAR	10	0	Securities Account Group
37	PORTFOLIO	RPORTB	RPORTB	CHAR	10	0	Portfolio
38	TRADER	RDEALER	RDEALER	CHAR	12	0	Trader
39	LOANS_CONTRACT	RANL	RANL	CHAR	13	0	Contract Number
40	POSITION_ACCOUNT	TPM_POS_ACCOUNT_FUT	TPM_POS_ACCOUNT_FUT	CHAR	10	0	Futures Account for Listed Options and Futures
41	LOT_ID	TPM_LOT_ID	SYSUUID	RAW	16	0	Identifier of the Lot
42	FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	TPM_FLAG_LONG_SHORT	CHAR	1	0	Indicator: Long or Short Position
43	UNITS	TPM_UNITS	TPM_UNITS	DEC	22	6	Units
44	NOMINAL_CURR	TPM_NOMINAL_CURR	WAERS	CUKY	5	0	Nominal Currency
45	NOMINAL_AMT	TPM_NOMINAL_AMT	TPM_AMOUNT	CURR	21	2	Nominal Amount
46	POSITION_CURR	TPM_POSITION_CURR	WAERS	CUKY	5	0	Position Currency
47	POSITION_AMT	TPM_POSITION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Position Currency
48	POSAMT_IDX_CLEAN	TPM_POSITION_AMT_IDX_CLEAN	TPM_AMOUNT	CURR	21	2	Amount in Position Currency Index-Clean
49	QUANT_CAT	TPM_QTY_PM_CAT	TPM_QTY_PM_CAT	CHAR	4	0	Position Change Category: Quantity
50	LOCAL_CURR	TPM_LOCAL_CURR	WAERS	CUKY	5	0	Local Currency
51	LOCAL_AMT	TPM_LOCAL_AMT	TPM_AMOUNT	CURR	21	2	Amount in Local Currency
52	VALUATION_CURR	TPM_VALUATION_CURR	WAERS	CUKY	5	0	Valuation Currency
53	VALUATION_AMT	TPM_VALUATION_AMT	TPM_AMOUNT	CURR	21	2	Amount in Valuation Currency
54	TRL_POS_MAN_CAT	TPM_AMT_PM_CAT	TPM_PM_CAT	CHAR	4	0	Position Change Category
55	FIXED_AA_REF	TPM_AA_REF	TPM_AA_REF	CHAR	12	0	Account Assignment Reference of Position Management	TRACC_AA_REF
56	SOURCETARGET_FLG	TPM_SOURCE_TARGET_FLG	TPM_SOURCE_TARGET_FLG	CHAR	1	0	Indicator: Source or Target of a Flow
57	TRANSFER_GROUP	TPM_TRANSFER_GROUP	TPM_SYSTEM_KEY	NUMC	4	0	Group of Flows from a Source or Target
58	LOT_CREATION	TPM_LOT_CREATION	TPM_LOT_CREATION	NUMC	1	0	Lot Creation Category
59	AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	TPM_AMOUNT_FACTOR	FLTP	16	16	Value Coefficient
60	PAYMENT_CURR	TPM_PAYMENT_CURR	WAERS	CUKY	5	0	Payment Currency
61	PAYMENT_AMT	TPM_PAYMENT_AMT	TPM_AMOUNT	CURR	21	2	Amount in Payment Currency
62	SIGN	TB_SSIGN	T_SSIGN	CHAR	1	0	Direction of flow
63	HOUSE_BANK	TB_RHABKI	HBKID	CHAR	5	0	Short key for own house bank
64	HOUSE_BANK_ACC	TB_RHKTID	HKTID	CHAR	5	0	Short key for house bank account
65	PAYMENT_DATE	TPM_PAYMENT_DATE	TPM_POSITION_DATE	DATS	8	0	Payment Date
66	DUE_DATE	TPM_DUE_DATE	DATUM	DATS	8	0	Due Date
67	RPBANK	TB_RPBANK	BVTYP	CHAR	4	0	Partner bank details
68	RPZAHL	TB_RPZAHL_NEW	BU_PARTNER	CHAR	10	0	Payer/payee	BUT000
69	SZART	TB_SZART	XFELD	CHAR	1	0	Payment transaction
70	ZLSCH	DZLSCH	ZLSCH	CHAR	1	0	Payment method
71	UZAWE	UZAWE	UZAWE	CHAR	2	0	Payment method supplement	T042F
72	SPAYRQ	TB_SPAYRQ	T_SPAYRQ	CHAR	1	0	Payment request allowed
73	SPRSNG	TB_SPRSNG	T_SPAYRQ	CHAR	1	0	Individual payment required
74	SPRGRD	TB_SPRGRD	T_SPRGRD	CHAR	1	0	Determine grouping definition
75	SCSPAY	TB_SCSPAY	XFELD	CHAR	1	0	Same direction necessary for joint payment?
76	ZWELS	DZWELS	ZWELS	CHAR	10	0	List of the Payment Methods to be Considered
77	PAYGR	PAYGR	CHAR20	CHAR	20	0	Grouping Field for Automatic Payments
78	CALCULATION_DATE	DVALUT	DATUM	DATS	8	0	Calculation Date
79	CALC_DATE_INCL	VVSINCL	VVSINCL	NUMC	1	0	Inclusive indicator for beginning and end of a period
80	COUPON_DATE	TPM_COUPON_DATE	DATUM	DATS	8	0	Date of the Next Coupon
81	COUPON_SIGN	TPM_COUPON_SIGN	VVSCOUPON	CHAR	1	0	Coupon ID for Interest and Accrued Interest Calculation
82	CALC_BEGIN	DBERVON	DATUM	DATS	8	0	Start of Calculation Period
83	CALC_END	DBERBIS	DATUM	DATS	8	0	End of Calculation Period
84	EVENT_CATEGORY	TPM_TRD_EVENT_CATEGORY	TPM_TRD_EVENT_CATEGORY	INT1	3	0	Category of Event in Distributor Business Transaction
85	CHANGED_PARTITIO	TPM_PARTITION_CATEGORY	TPM_PARTITION_CATEGORY	INT1	3	0	Category of Group of Distributor Flow Partitions
86	NOMINAL_ORG_AMT	TPM_NOMINAL_ORG_AMT	TPM_AMOUNT	CURR	21	2	Original Nominal Amount in Position Currency
87	EFF_INT_RATE_U	TPM_TRL_EFF_INT_RATE_USED	DEC3_7	DEC	10	7	For Calculation of Amortization Amts (SAC) for Used EffInR
88	EFF_INT_RATE_N	TPM_TRL_EFF_INT_RATE_NEW	DEC3_7	DEC	10	7	Valid Effective Interest Rate for the Next Amortization
89	LANDL	LANDL	LAND1	CHAR	3	0	Supplying Country
90	LZBKZ	LZBKZ	LZBKZ	CHAR	3	0	State central bank indicator
91	RPCODE	RPCODE	RPCODE	CHAR	20	0	Repetitive Code
92	RP_TEXT	RPCODE_TEXT	XTEXT50	CHAR	50	0	Reference Text for Repetitive Code
93	RFHAZU	TB_RFHAZU	T_RFHAZU	NUMC	5	0	Transaction activity
94	NORDEXT	TB_NORDEXT	FTI_CHAR16LOW	CHAR	16	0	External Reference
95	SFGZUSTT	TB_SFGZUTY	T_SFGZUTY	NUMC	2	0	Transaction Activity Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right

1	SLDV_QUERY	BUSTRANSCAT	TRDTS_BT_CAT	BUSTRANSCAT	KEY	1	CN
2	SLDV_QUERY	COMPANY_CODE	T001	BUKRS	KEY	1	CN
3	SLDV_QUERY	COM_VAL_CLASS	TRGC_COM_VALCL	COM_VAL_CLASS	KEY	1	CN
4	SLDV_QUERY	DIS_FLOWTYPE	TRDC_DFLOWTYPE	DIS_FLOWTYPE	KEY	1	CN
5	SLDV_QUERY	FIXED_AA_REF	TRACC_AA_REF	AA_REF	KEY	1	CN
6	SLDV_QUERY	MANDT	T000	MANDT	KEY	1	CN
7	SLDV_QUERY	PRODUCT_CATEGORY	TZAF	SANLF	KEY	1	CN
8	SLDV_QUERY	PRODUCT_TYPE	TZPA	GSART	KEY	1	CN
9	SLDV_QUERY	RPZAHL	BUT000	PARTNER	KEY	1	CN
10	SLDV_QUERY	SECURITY_ID	VWPANLA	RANL	KEY	C	CN
11	SLDV_QUERY	TRANSACTION_TYPE	AT10	SFHAART	KEY	1	CN
12	SLDV_QUERY	TR_REV_REASON	TZST	SSTOGRD	KEY	1	CN
13	SLDV_QUERY	USER_DATA_OID	TRGT_USER_DATA	OS_GUID	KEY	1	CN
14	SLDV_QUERY	UZAWE	T042F	UZAWE	KEY	1	CN
15	SLDV_QUERY	VALUATION_AREA	TRGC_VAL_AREA	VALUATION_AREA	KEY	1	CN