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