FIRU_RECON_REP
Reconciliation Report Header
FIRU_RECON_REP is an SAP database table in S/4HANA. Reconciliation Report Header. It contains 27 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_Z0_ReconciliationReportHdr | view_entity | from | BASIC | Reconciliation Report Header |
Fields (27)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | db_key | /BOBF/CONF_KEY | NodeID | |||
| reporting_entity | SRF_REPORTING_ENTITY | Reporting Entity | ||||
| partner | BU_PARTNER | Bus. Partner | ||||
| contract | J_3RF_INTCNTNUM | Int. Contract Number | ||||
| start_date | BEGDA | Start Date | ||||
| end_date | ENDDA | End Date | ||||
| begining_balance | FIS_OPEN_BAL | Opening Balance | ||||
| turnover_d | FIRU_DEBIT_TURNOVER | Debit turnover | ||||
| turnover_c | FIRU_CREDIT_TURNOVER | Credit turnover | ||||
| ending_balance | FIRU_END_BAL | Ending Balance | ||||
| approved_amount | FIRU_APPROVED_AMOUNT | Approved amount | ||||
| waers | WAERS | Currency | ||||
| status | FIRU_RECON_REP_STATUS | Recon Report Status | ||||
| sent_on | FIRU_SENT_ON | Sent On | ||||
| received_on | FIRU_RECEIVED_ON | Received On | ||||
| confirmed_on | FIRU_CONFIRMED_ON | Confirmed on | ||||
| log_handle | BALLOGHNDL | Handle | ||||
| created_on | FIRU_CREATED_ON | Created On | ||||
| created_by | FIRU_CREATED_BY | Created By | ||||
| contract_company | BUKRS | Company Code | ||||
| contract_str | abap.strg | |||||
| contract_type | FIRU_CONTRACTTYPE | Contract Type | ||||
| created_with_items | FLAG | Indicator | ||||
| recon_type | CHAR2 | Component of the Version Number | ||||
| act_number | COUNT10 | Count. | ||||
| fill_partner_amount | FLAG | Indicator |
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.
-- Reconciliation Report Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FIRU_RECON_REP (
MANDT, -- Client [MANDT]
DB_KEY, -- NodeID [/BOBF/CONF_KEY]
REPORTING_ENTITY, -- Reporting Entity [SRF_REPORTING_ENTITY]
PARTNER, -- Bus. Partner [BU_PARTNER]
CONTRACT, -- Int. Contract Number [J_3RF_INTCNTNUM]
START_DATE, -- Start Date [BEGDA]
END_DATE, -- End Date [ENDDA]
BEGINING_BALANCE, -- Opening Balance [FIS_OPEN_BAL]
TURNOVER_D, -- Debit turnover [FIRU_DEBIT_TURNOVER]
TURNOVER_C, -- Credit turnover [FIRU_CREDIT_TURNOVER]
ENDING_BALANCE, -- Ending Balance [FIRU_END_BAL]
APPROVED_AMOUNT, -- Approved amount [FIRU_APPROVED_AMOUNT]
WAERS, -- Currency [WAERS]
STATUS, -- Recon Report Status [FIRU_RECON_REP_STATUS]
SENT_ON, -- Sent On [FIRU_SENT_ON]
RECEIVED_ON, -- Received On [FIRU_RECEIVED_ON]
CONFIRMED_ON, -- Confirmed on [FIRU_CONFIRMED_ON]
LOG_HANDLE, -- Handle [BALLOGHNDL]
CREATED_ON, -- Created On [FIRU_CREATED_ON]
CREATED_BY, -- Created By [FIRU_CREATED_BY]
CONTRACT_COMPANY, -- Company Code [BUKRS]
CONTRACT_STR, -- abap.strg
CONTRACT_TYPE, -- Contract Type [FIRU_CONTRACTTYPE]
CREATED_WITH_ITEMS, -- Indicator [FLAG]
RECON_TYPE, -- Component of the Version Number [CHAR2]
ACT_NUMBER, -- Count. [COUNT10]
FILL_PARTNER_AMOUNT, -- Indicator [FLAG]
PRIMARY KEY (MANDT, DB_KEY)
);
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