SAP ABAP View TLVV_VAL_ALL (Treasury: Valuation Business Transactions + Steps + Flows)

Hierarchy

☛ EA-FINSERV (Software Component) SAP Enterprise Extension Financial Services
   ⤷ FIN-FSCM-TRM-TM-AC (Application Component) Transfer to Financial Accounting
     ⤷ FTR_TRL_VALUATION (Package) CFM TM: Valuation

Basic Data

View Type	D	Database View
Database View	TLVV_VAL_ALL
Short Description	Treasury: Valuation Business Transactions + Steps + Flows
Root table	TLVT_VAL_TRANS	Treasury: Valuation Business Transactions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	TLVT_VAL_TRANS	TLVT_VAL_TRANS
2	TLVT_VAL_STEP
3	TLVT_VAL_FLOW

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	TLVT_VAL_TRANS	MANDT	JL	EQ				0	0
2	TLVT_VAL_STEP	MANDT	JR	EQ			AND	0	0
3	TLVT_VAL_TRANS	OS_GUID	JL	EQ				0	0
4	TLVT_VAL_STEP	VALUATION_TRANS	JR	EQ			AND	0	0
5	TLVT_VAL_STEP	MANDT	JL	EQ				0	0
6	TLVT_VAL_FLOW	MANDT	JR	EQ			AND	0	0
7	TLVT_VAL_STEP	VALUATION_TRANS	JL	EQ				0	0
8	TLVT_VAL_FLOW	VALUATION_TRANS	JR	EQ			AND	0	0
9	TLVT_VAL_STEP	STEP_NUMBER	JL	EQ				0	0
10	TLVT_VAL_FLOW	STEP_NUMBER	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	TLVT_VAL_TRANS	MANDT		☐	MANDT	☐	Client
2	OS_GUID	TLVT_VAL_TRANS	OS_GUID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
3	VALUATION_AREA	TLVT_VAL_TRANS	VALUATION_AREA		☐	TPM_VAL_AREA	☐	Valuation Area
4	TR_ACC_CODE	TLVT_VAL_TRANS	TR_ACC_CODE		☐	TPM_ACC_CODE	☐	Accounting Code
5	KEYDATE	TLVT_VAL_TRANS	KEYDATE		☐	TPM_VAL_KEYDATE	☐	Key Date for Valuation
6	RESET_KEYDATE	TLVT_VAL_TRANS	RESET_KEYDATE		☐	TPM_VAL_RESET_KEYDATE	☐	Key Date for Valuation Reset
7	VALUATION_STATE	TLVT_VAL_TRANS	VALUATION_STATE		☐	TPM_VAL_STATE	☐	Status of Valuation
8	VALUATION_CAT	TLVT_VAL_TRANS	VALUATION_CAT		☐	TPM_VAL_CAT	☐	Valuation Category
9	VAL_BUSTRANSID	TLVT_VAL_TRANS	VAL_BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
10	VAL_DOCUMENTID	TLVT_VAL_TRANS	VAL_DOCUMENTID		☐	TPM_TRDDOCID	☐	Distributor Document ID
11	RESET_BUSTRANSID	TLVT_VAL_TRANS	RESET_BUSTRANSID		☐	TPM_BUSTRANSID	☐	Identifier of the Distributor Business Transaction
12	RESET_DOCUMENTID	TLVT_VAL_TRANS	RESET_DOCUMENTID		☐	TPM_TRDDOCID	☐	Distributor Document ID
13	POSITION_OID	TLVT_VAL_TRANS	POSITION_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
14	POSITION_CLS	TLVT_VAL_TRANS	POSITION_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
15	USER_DATA_OID	TLVT_VAL_TRANS	USER_DATA_OID		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
16	USER_DATA_CLS	TLVT_VAL_TRANS	USER_DATA_CLS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
17	VALUATION_TRANS	TLVT_VAL_STEP	VALUATION_TRANS		☐	TPM_DB_OS_GUID	☐	Object Identity in Database Format
18	STEP_NUMBER	TLVT_VAL_STEP	STEP_NUMBER		☐	TPM_VAL_STEP_NR	☐	Number of Valuation Step within a Business Transaction
19	STEP_CAT	TLVT_VAL_STEP	STEP_CAT		☐	TPM_VAL_STEP_CAT	☐	Type of Step
20	SECURITY_PRICE	TLVT_VAL_STEP	SECURITY_PRICE		☐	VVPKTKUR	☐	Price of Unit- or Percentage-Quoted Security
21	EXCHANGE_RATE	TLVT_VAL_STEP	EXCHANGE_RATE		☐	UKURS_CURR	☐	Exchange Rate
22	FLOW_NUMBER	TLVT_VAL_FLOW	FLOW_NUMBER		☐	TPM_VAL_FLOW_NR	☐	Valuation Flow Number
23	DIS_FLOWTYPE	TLVT_VAL_FLOW	DIS_FLOWTYPE		☐	TPM_DIS_FLOWTYPE	☐	Update Type
24	VAL_FLOW_CAT	TLVT_VAL_FLOW	VAL_FLOW_CAT		☐	TPM_VAL_FLOW_CAT	☐	Valuation Flow Category
25	POSITION_CURR	TLVT_VAL_FLOW	POSITION_CURR		☐	TPM_POSITION_CURR	☐	Position Currency
26	VAL_FLOW_RESET	TLVT_VAL_FLOW	VAL_FLOW_RESET		☐	TPM_VAL_FLOW_RESET	☐	Indicator: Flow for Valuation Reset
27	POSITION_AMT	TLVT_VAL_FLOW	POSITION_AMT		☐	TPM_POSITION_AMT	☐	Amount in Position Currency
28	VALUATION_CURR	TLVT_VAL_FLOW	VALUATION_CURR		☐	TPM_VALUATION_CURR	☐	Valuation Currency
29	VALUATION_AMT	TLVT_VAL_FLOW	VALUATION_AMT		☐	TPM_VALUATION_AMT	☐	Amount in Valuation Currency

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