FINSC_001A

Transparent Table Customizing Table
8 Fields 10 CDS Views

Currency conversion settings for company code

FINSC_001A is an SAP database table in S/4HANA. Currency conversion settings for company code. It contains 8 fields. 10 CDS views read from this table.

CDS Views using this table (10)

ViewTypeJoinVDMDescription
FINS_T001A view left_outer Compatibility view for table T001A
FINSV_CompanyCode_CurrencyType view_entity inner Currency Type per Company Code
fiscds_ldcmpcurr view left_outer Currencies of Company Code and Ledger
I_CoCodeCrcyTranslationBasic view_entity from BASIC Currency Translation
P_CoCodeCrcyRoleCrcyTrnsltn view from BASIC Company Code Currency Translation Config
P_CoCodeCrcyRoleCrcyTrnsltn view cross BASIC Company Code Currency Translation Config
P_CoCodeCrcyRoleCrcyTrnsltn view union_all BASIC Company Code Currency Translation Config
P_Fins_Curr_Conv_Src_Target view from BASIC Currency Conversion ACDOC Source and Target
P_Fins_Curr_Conv_Src_Target view cross BASIC Currency Conversion ACDOC Source and Target
P_Ldcmpcurr view_entity left_outer BASIC Currencies for ledger an Company Code

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY curtype fins_curtype Curr./Val. Type
waers waers Currency
source_curtype fins_source_curtype Source Currency Type
kurst kurst Exch. Rate Type
curdt curdt Trans.Date Type
norealtimeconv fins_norealtimeconv No realtime conv.

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.

-- Currency conversion settings for company code
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_001A (
    MANDT,           -- Client [mandt]
    BUKRS,           -- Company Code [bukrs]
    CURTYPE,         -- Curr./Val. Type [fins_curtype]
    WAERS,           -- Currency [waers]
    SOURCE_CURTYPE,  -- Source Currency Type [fins_source_curtype]
    KURST,           -- Exch. Rate Type [kurst]
    CURDT,           -- Trans.Date Type [curdt]
    NOREALTIMECONV,  -- No realtime conv. [fins_norealtimeconv]
    PRIMARY KEY (MANDT, BUKRS, CURTYPE)
);

Learn More