FINSC_IC_PROJ

Transparent Table Customizing Table

IC: Customizing

FINSC_IC_PROJ is an SAP database table in S/4HANA. IC: Customizing. It contains 8 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
fins_ic_acd_0 view inner IC: Selection of UJ line items
fins_ic_acd_1 view inner IC: Selection of UJ line items
fins_ic_spl_0 view inner IC: Selection of split line items
IC_ReconciliationLedger view inner IC: Determine Reconciliation Ledger
IC_SelectSplitLineItems view inner IC: Selection of split line items

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY project_id FINS_MPROJ_ID Project ID
KEY curtype FINS_CURTYPE Curr./Val. Type
KEY rldnr FINS_LEDGER Ledger
KEY bukrs BUKRS Company Code
source_curtype FINS_SOURCE_CURTYPE Source Currency Type
kurst KURST Exch. Rate Type
curdt CURDT Trans.Date Type

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.

-- IC: Customizing
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_IC_PROJ (
    MANDT,           -- Client [MANDT]
    PROJECT_ID,      -- Project ID [FINS_MPROJ_ID]
    CURTYPE,         -- Curr./Val. Type [FINS_CURTYPE]
    RLDNR,           -- Ledger [FINS_LEDGER]
    BUKRS,           -- Company Code [BUKRS]
    SOURCE_CURTYPE,  -- Source Currency Type [FINS_SOURCE_CURTYPE]
    KURST,           -- Exch. Rate Type [KURST]
    CURDT,           -- Trans.Date Type [CURDT]
    PRIMARY KEY (MANDT, PROJECT_ID, CURTYPE, RLDNR, BUKRS)
);