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
P_CoCodeCrcyRoleCrcyTrnsltn view cross BASIC
P_CoCodeCrcyRoleCrcyTrnsltn view union_all BASIC
P_Fins_Curr_Conv_Src_Target view from BASIC
P_Fins_Curr_Conv_Src_Target view cross BASIC
P_Ldcmpcurr view left_outer BASIC

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