FINS_TRR_PECRSLT

Transparent Table Application Table
46 Fields 1 CDS Views

Result list values of Periodic Closing Run

FINS_TRR_PECRSLT is an SAP database table in S/4HANA. Result list values of Periodic Closing Run. It contains 46 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EvtBsdRevnRecgnClsgRunRslt view from BASIC EBRR Periodic Closing Run Results

Fields (46)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY guid GUID16 GUID
KEY rsltln FINS_TRR_RSLTLN6 Line Item
lognumber BALOGNR Log Number
acc_principle TBRR_EVAL_AREA Evaluation area EBRR
pspid PS_PSPID Project def.
pspnr PS_POSNR WBS Element
aufnr AUFNR Order
vbeln VBELN_VA Sales Document
posnr POSNR_VA Item
auart AUART Sales Doc. Type
service_doc_type FCO_SRVDOC_TYPE Service Doc. Type
service_doc_id FCO_SRVDOC_ID Service Document
service_doc_item_id FCO_SRVDOC_ITEM_ID Service Doc. Item
vtkey VTKEY_KK Contract
vtpos VTPOS_KK Contract Item
contract_id FARR_CONTRACT_ID Contract
pob_id FARR_POB_ID POB
bukrs BUKRS Company Code
objnr J_OBJNR Object number
objnr_long FINS_TRR_OBJNR_LONG Long object number
gjahr GJAHR Fiscal Year
perio POPER Posting Period
ledger FINS_LEDGER Ledger
abgsl ABGR_SCHL RA Key
periv PERIV FY Variant
prctr PRCTR Profit Center
log_handle BALLOGHNDL Handle
msg_cnt_al BALDBCNTAL Total Messages
msg_cnt_e BALDBCNTE Error Messages
timestamp TIMESTAMP Time Stamp
rhcur FINS_CURRH CompanyCode Currency
accruedcogsamount FINS_TRR_ACCCOGS Accrued COS
accruedrevenueamount FINS_TRR_ACCREVN Accrued Revenue
actualcostamount FINS_TRR_ACTCOST Actual Cost
actualrevenueamount FINS_TRR_ACTREVN Billed Revenue
cogsadjustmentamount FINS_TRR_COGSADJ COS Adjustment
deferredcogsamount FINS_TRR_DEFCOGS Deferred COS
deferredrevenueamount FINS_TRR_DEFREVN Deferred Revenue
recognizedcogsamount FINS_TRR_RECCOGS Recognized COS
recognizedmarginamt FINS_TRR_AMOUNT_DISPLAY_CRCY Rec Mar in Dspl Crcy
recognizedrevenueamount FINS_TRR_RECREVN Recognized Revenue
revenueadjustmentamount FINS_TRR_REVNADJUST Revenue Adjustment
unbilledrevenueamount FINS_TRR_UNBILLEDREVENUE Unbilled Revenue
accruedrevenuecapamount FINS_TRR_ACCREVN_CAP Revenue Cap
downpaymentamount FINS_TRR_DOWNPAYMENT Downpayment

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.

-- Result list values of Periodic Closing Run
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINS_TRR_PECRSLT (
    MANDT,                    -- Client [MANDT]
    GUID,                     -- GUID [GUID16]
    RSLTLN,                   -- Line Item [FINS_TRR_RSLTLN6]
    LOGNUMBER,                -- Log Number [BALOGNR]
    ACC_PRINCIPLE,            -- Evaluation area EBRR [TBRR_EVAL_AREA]
    PSPID,                    -- Project def. [PS_PSPID]
    PSPNR,                    -- WBS Element [PS_POSNR]
    AUFNR,                    -- Order [AUFNR]
    VBELN,                    -- Sales Document [VBELN_VA]
    POSNR,                    -- Item [POSNR_VA]
    AUART,                    -- Sales Doc. Type [AUART]
    SERVICE_DOC_TYPE,         -- Service Doc. Type [FCO_SRVDOC_TYPE]
    SERVICE_DOC_ID,           -- Service Document [FCO_SRVDOC_ID]
    SERVICE_DOC_ITEM_ID,      -- Service Doc. Item [FCO_SRVDOC_ITEM_ID]
    VTKEY,                    -- Contract [VTKEY_KK]
    VTPOS,                    -- Contract Item [VTPOS_KK]
    CONTRACT_ID,              -- Contract [FARR_CONTRACT_ID]
    POB_ID,                   -- POB [FARR_POB_ID]
    BUKRS,                    -- Company Code [BUKRS]
    OBJNR,                    -- Object number [J_OBJNR]
    OBJNR_LONG,               -- Long object number [FINS_TRR_OBJNR_LONG]
    GJAHR,                    -- Fiscal Year [GJAHR]
    PERIO,                    -- Posting Period [POPER]
    LEDGER,                   -- Ledger [FINS_LEDGER]
    ABGSL,                    -- RA Key [ABGR_SCHL]
    PERIV,                    -- FY Variant [PERIV]
    PRCTR,                    -- Profit Center [PRCTR]
    LOG_HANDLE,               -- Handle [BALLOGHNDL]
    MSG_CNT_AL,               -- Total Messages [BALDBCNTAL]
    MSG_CNT_E,                -- Error Messages [BALDBCNTE]
    TIMESTAMP,                -- Time Stamp [TIMESTAMP]
    RHCUR,                    -- CompanyCode Currency [FINS_CURRH]
    ACCRUEDCOGSAMOUNT,        -- Accrued COS [FINS_TRR_ACCCOGS]
    ACCRUEDREVENUEAMOUNT,     -- Accrued Revenue [FINS_TRR_ACCREVN]
    ACTUALCOSTAMOUNT,         -- Actual Cost [FINS_TRR_ACTCOST]
    ACTUALREVENUEAMOUNT,      -- Billed Revenue [FINS_TRR_ACTREVN]
    COGSADJUSTMENTAMOUNT,     -- COS Adjustment [FINS_TRR_COGSADJ]
    DEFERREDCOGSAMOUNT,       -- Deferred COS [FINS_TRR_DEFCOGS]
    DEFERREDREVENUEAMOUNT,    -- Deferred Revenue [FINS_TRR_DEFREVN]
    RECOGNIZEDCOGSAMOUNT,     -- Recognized COS [FINS_TRR_RECCOGS]
    RECOGNIZEDMARGINAMT,      -- Rec Mar in Dspl Crcy [FINS_TRR_AMOUNT_DISPLAY_CRCY]
    RECOGNIZEDREVENUEAMOUNT,  -- Recognized Revenue [FINS_TRR_RECREVN]
    REVENUEADJUSTMENTAMOUNT,  -- Revenue Adjustment [FINS_TRR_REVNADJUST]
    UNBILLEDREVENUEAMOUNT,    -- Unbilled Revenue [FINS_TRR_UNBILLEDREVENUE]
    ACCRUEDREVENUECAPAMOUNT,  -- Revenue Cap [FINS_TRR_ACCREVN_CAP]
    DOWNPAYMENTAMOUNT,        -- Downpayment [FINS_TRR_DOWNPAYMENT]
    PRIMARY KEY (MANDT, GUID, RSLTLN)
);

Learn More