FINS_TRR_VAL
Event Based Revenue Recognition: Valuation
FINS_TRR_VAL is an SAP database table in S/4HANA. Event Based Revenue Recognition: Valuation. It contains 11 fields. 9 CDS views read from this table.
CDS Views using this table (9)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Fins_Rev_Rec_Acc_Pri_View | view | inner | Accounting Principles for transaction based revenue recogn. | |
| Fins_Rev_Rec_Ap_Isn_Check | view | inner | check for intersections | |
| Fins_Rev_Rec_Ap_Val_Check | view | inner | Check accounting principles for Rev. Rec. valuation | |
| Fins_Rev_Rec_Check2 | view | inner | assignment rules | |
| Fins_Rev_Rec_Comp_Abgsl | view | inner | Compatible RA keys | |
| FINS_REV_REC_COMP_ABGSL_SLACK | view | inner | Slack compatible RA keys | |
| I_EBRRRevnRecgnValuationSttg | view | from | BASIC | EvntBsdRevnRecgn Key Valuation Setting |
| KKAG_DIP_RA_KEYS | view | inner | DIP RA keys | |
| P_Trrmonaccprin | view | inner | COMPOSITE |
Fields (11)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | bukrs | BUKRS | Company Code | |||
| KEY | acc_principle | FINS_TRR_ACCOUNTING_PRINCIPLE | Acc.Princ. for EBRR | |||
| KEY | abgsl | ABGR_SCHL_CUST_TBRR | Recognition key | |||
| method | FINS_TRR_METHOD | Rev. rec. method | ||||
| ass_rule | FINS_TRR_RULE_ASS | Assignment Rule | ||||
| plan_source | FINS_TRR_PLAN_SOURCE | Source plan values | ||||
| plan_versn | FINS_TRR_CATEGORY_VERSION | Category & version | ||||
| expert | FINS_TRR_EXPERT | Expert | ||||
| billable_method | FINS_TRR_BILLABLE_METHOD | Billable det. method | ||||
| time_method | FINS_TRR_TIME_METHOD | Time based methods |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Event Based Revenue Recognition: Valuation
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_TRR_VAL (
MANDT, -- Client [MANDT]
BUKRS, -- Company Code [BUKRS]
ACC_PRINCIPLE, -- Acc.Princ. for EBRR [FINS_TRR_ACCOUNTING_PRINCIPLE]
ABGSL, -- Recognition key [ABGR_SCHL_CUST_TBRR]
METHOD, -- Rev. rec. method [FINS_TRR_METHOD]
ASS_RULE, -- Assignment Rule [FINS_TRR_RULE_ASS]
PLAN_SOURCE, -- Source plan values [FINS_TRR_PLAN_SOURCE]
PLAN_VERSN, -- Category & version [FINS_TRR_CATEGORY_VERSION]
EXPERT, -- Expert [FINS_TRR_EXPERT]
BILLABLE_METHOD, -- Billable det. method [FINS_TRR_BILLABLE_METHOD]
TIME_METHOD, -- Time based methods [FINS_TRR_TIME_METHOD]
PRIMARY KEY (MANDT, BUKRS, ACC_PRINCIPLE, ABGSL)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA