SAP ABAP View SLDV_QUERY (SLD: Transactions, Flow, Events)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM (Application Component) Transaction Manager
     ⤷ FTR_SUBLEDGER_DISTRIBUTOR (Package) Subledger Distributor

Basic Data

View Type	D	Database View
Database View	SLDV_QUERY
Short Description	SLD: Transactions, Flow, Events
Root table	SLDT_TRANSACTION	Subledger Distributor Business Transactions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SLDT_TRANSACTION	SLDT_TRANSACTION
2	SLDT_EVENT
3	SLDT_FLOW

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SLDT_TRANSACTION	MANDT	JL	EQ				0	0
2	SLDT_EVENT	MANDT	JR	EQ			AND	0	0
3	SLDT_TRANSACTION	OS_GUID	JL	EQ				0	0
4	SLDT_EVENT	OS_GUID	JR	EQ			AND	0	0
5	SLDT_TRANSACTION	MANDT	JL	EQ				0	0
6	SLDT_FLOW	MANDT	JR	EQ			AND	0	0
7	SLDT_TRANSACTION	OS_GUID	JL	EQ				0	0
8	SLDT_FLOW	OS_GUID	JR	EQ				0	0

View Fields

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

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