I_Currency

DDL: I_CURRENCY SQL: IFICURRENCY Type: view BASIC Package: SFIB
6 Fields 2 Data Sources 1 Associations 187 OData Services 3 Fiori Apps

Currency

I_Currency (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Public Edition with built-in and side-by-side extension capabilities.

Currency · Accounting and Financial Close

I_Currency is a Basic CDS View (Dimension) that provides data about "Currency" in SAP S/4HANA. It reads from 2 data sources (tcurc, tcurx) and exposes 6 fields with key field Currency. It has 1 association to related views. It is exposed through 187 OData services (ASQL_F0333A, ASQL_F0343, ASQL_F0354, ...). It is used in 3 Fiori applications: Billing Document, Manage Claims, Manage Claims-Customer facing process. Part of development package SFIB.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessAccounting and Financial Close
Application ComponentBC-SRV-BSF-CUR-2CL
CapabilitiesData Source for Data Extraction
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Released
PackageAccounting and Financial Close for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
tcurc tcurc from
tcurx tcurx left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CurrencyText _Text $projection.Currency = _Text.Currency

Annotations (9)

NameValueLevelField
EndUserText.label Currency view
ObjectModel.representativeKey Currency view
ObjectModel.sapObjectNodeType.name Currency view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFICURRENCY view
AccessControl.authorizationCheck #NOT_REQUIRED view
Search.searchable true view

OData Services (187)

ServiceBindingVersionContractRelease
ASQL_F0333A ASQL_F0333A C2 NOT_RELEASED
ASQL_F0343 ASQL_F0343 C2 NOT_RELEASED
ASQL_F0354 ASQL_F0354 C2 NOT_RELEASED
ASQL_F0574 ASQL_F0574 C2 NOT_RELEASED
ASQL_F0575 ASQL_F0575 C2 NOT_RELEASED
ASQL_F0731A ASQL_F0731A C2 NOT_RELEASED
ASQL_F0731B ASQL_F0731B C2 NOT_RELEASED
ASQL_F0773 ASQL_F0773 C2 NOT_RELEASED
ASQL_F0859 ASQL_F0859 C2 NOT_RELEASED
ASQL_F1345 ASQL_F1345 C2 NOT_RELEASED
ASQL_F1367 ASQL_F1367 C2 NOT_RELEASED
ASQL_F1378 ASQL_F1378 C2 NOT_RELEASED
ASQL_F1579 ASQL_F1579 C2 NOT_RELEASED
ASQL_F1597 ASQL_F1597 C2 NOT_RELEASED
ASQL_F1611A ASQL_F1611A C2 NOT_RELEASED
ASQL_F1612 ASQL_F1612 C2 NOT_RELEASED
ASQL_F1653A ASQL_F1653A C2 NOT_RELEASED
ASQL_F1660 ASQL_F1660 C2 NOT_RELEASED
ASQL_F1661 ASQL_F1661 C2 NOT_RELEASED
ASQL_F1662 ASQL_F1662 C2 NOT_RELEASED
ASQL_F1663 ASQL_F1663 C2 NOT_RELEASED
ASQL_F1688 ASQL_F1688 C2 NOT_RELEASED
ASQL_F1689 ASQL_F1689 C2 NOT_RELEASED
ASQL_F1990 ASQL_F1990 C2 NOT_RELEASED
ASQL_F2014 ASQL_F2014 C2 NOT_RELEASED
ASQL_F2017 ASQL_F2017 C2 NOT_RELEASED
ASQL_F2200 ASQL_F2200 C2 NOT_RELEASED
ASQL_F2218 ASQL_F2218 C2 NOT_RELEASED
ASQL_F2331 ASQL_F2331 C2 NOT_RELEASED
ASQL_F2358 ASQL_F2358 C2 NOT_RELEASED
ASQL_F2359 ASQL_F2359 C2 NOT_RELEASED
ASQL_F2412 ASQL_F2412 C2 NOT_RELEASED
ASQL_F2420 ASQL_F2420 C2 NOT_RELEASED
ASQL_F2422 ASQL_F2422 C2 NOT_RELEASED
ASQL_F2435 ASQL_F2435 C2 NOT_RELEASED
ASQL_F2445 ASQL_F2445 C2 NOT_RELEASED
ASQL_F2545 ASQL_F2545 C2 NOT_RELEASED
ASQL_F2550 ASQL_F2550 C2 NOT_RELEASED
ASQL_F2564 ASQL_F2564 C2 NOT_RELEASED
ASQL_F2599 ASQL_F2599 C2 NOT_RELEASED
ASQL_F2667 ASQL_F2667 C2 NOT_RELEASED
ASQL_F2668 ASQL_F2668 C2 NOT_RELEASED
ASQL_F2704 ASQL_F2704 C2 NOT_RELEASED
ASQL_F2705 ASQL_F2705 C2 NOT_RELEASED
ASQL_F2705A ASQL_F2705A C2 NOT_RELEASED
ASQL_F2740 ASQL_F2740 C2 NOT_RELEASED
ASQL_F2789 ASQL_F2789 C2 NOT_RELEASED
ASQL_F2790 ASQL_F2790 C2 NOT_RELEASED
ASQL_F2872 ASQL_F2872 C2 NOT_RELEASED
ASQL_F2873 ASQL_F2873 C2 NOT_RELEASED
ASQL_F2876 ASQL_F2876 C2 NOT_RELEASED
ASQL_F2877 ASQL_F2877 C2 NOT_RELEASED
ASQL_F2917 ASQL_F2917 C2 NOT_RELEASED
ASQL_F2930 ASQL_F2930 C2 NOT_RELEASED
ASQL_F2935 ASQL_F2935 C2 NOT_RELEASED
ASQL_F2945 ASQL_F2945 C2 NOT_RELEASED
ASQL_F2946 ASQL_F2946 C2 NOT_RELEASED
ASQL_F2964 ASQL_F2964 C2 NOT_RELEASED
ASQL_F2988 ASQL_F2988 C2 NOT_RELEASED
ASQL_F3014 ASQL_F3014 C2 NOT_RELEASED
ASQL_F3043 ASQL_F3043 C2 NOT_RELEASED
ASQL_F3044 ASQL_F3044 C2 NOT_RELEASED
ASQL_F3072 ASQL_F3072 C2 NOT_RELEASED
ASQL_F3077 ASQL_F3077 C2 NOT_RELEASED
ASQL_F3098 ASQL_F3098 C2 NOT_RELEASED
ASQL_F3130 ASQL_F3130 C2 NOT_RELEASED
ASQL_F3143 ASQL_F3143 C2 NOT_RELEASED
ASQL_F3149 ASQL_F3149 C2 NOT_RELEASED
ASQL_F3161 ASQL_F3161 C2 NOT_RELEASED
ASQL_F3162A ASQL_F3162A C2 NOT_RELEASED
ASQL_F3173 ASQL_F3173 C2 NOT_RELEASED
ASQL_F3215 ASQL_F3215 C2 NOT_RELEASED
ASQL_F3228 ASQL_F3228 C2 NOT_RELEASED
ASQL_F3232 ASQL_F3232 C2 NOT_RELEASED
ASQL_F3242 ASQL_F3242 C2 NOT_RELEASED
ASQL_F3294 ASQL_F3294 C2 NOT_RELEASED
ASQL_F3316 ASQL_F3316 C2 NOT_RELEASED
ASQL_F3366 ASQL_F3366 C2 NOT_RELEASED
ASQL_F3401 ASQL_F3401 C2 NOT_RELEASED
ASQL_F3417 ASQL_F3417 C2 NOT_RELEASED
ASQL_F3450 ASQL_F3450 C2 NOT_RELEASED
ASQL_F3486 ASQL_F3486 C2 NOT_RELEASED
ASQL_F3492 ASQL_F3492 C2 NOT_RELEASED
ASQL_F3567 ASQL_F3567 C2 NOT_RELEASED
ASQL_F3616 ASQL_F3616 C2 NOT_RELEASED
ASQL_F3676 ASQL_F3676 C2 NOT_RELEASED
ASQL_F3679 ASQL_F3679 C2 NOT_RELEASED
ASQL_F3732 ASQL_F3732 C2 NOT_RELEASED
ASQL_F3756 ASQL_F3756 C2 NOT_RELEASED
ASQL_F3760 ASQL_F3760 C2 NOT_RELEASED
ASQL_F3792 ASQL_F3792 C2 NOT_RELEASED
ASQL_F3794 ASQL_F3794 C2 NOT_RELEASED
ASQL_F3900 ASQL_F3900 C2 NOT_RELEASED
ASQL_F3932 ASQL_F3932 C2 NOT_RELEASED
ASQL_F3940 ASQL_F3940 C2 NOT_RELEASED
ASQL_F3941 ASQL_F3941 C2 NOT_RELEASED
ASQL_F3966 ASQL_F3966 C2 NOT_RELEASED
ASQL_F3976 ASQL_F3976 C2 NOT_RELEASED
ASQL_F3980 ASQL_F3980 C2 NOT_RELEASED
ASQL_F4004 ASQL_F4004 C2 NOT_RELEASED
ASQL_F4011 ASQL_F4011 C2 NOT_RELEASED
ASQL_F4051 ASQL_F4051 C2 NOT_RELEASED
ASQL_F4095 ASQL_F4095 C2 NOT_RELEASED
ASQL_F4149 ASQL_F4149 C2 NOT_RELEASED
ASQL_F4173A ASQL_F4173A C2 NOT_RELEASED
ASQL_F4345 ASQL_F4345 C2 NOT_RELEASED
ASQL_F4360 ASQL_F4360 C2 NOT_RELEASED
ASQL_F4557 ASQL_F4557 C2 NOT_RELEASED
ASQL_F4562 ASQL_F4562 C2 NOT_RELEASED
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F4760 ASQL_F4760 C2 NOT_RELEASED
ASQL_F4765 ASQL_F4765 C2 NOT_RELEASED
ASQL_F4988 ASQL_F4988 C2 NOT_RELEASED
ASQL_F4989 ASQL_F4989 C2 NOT_RELEASED
ASQL_F5061 ASQL_F5061 C2 NOT_RELEASED
ASQL_F5081 ASQL_F5081 C2 NOT_RELEASED
ASQL_F5134 ASQL_F5134 C2 NOT_RELEASED
ASQL_F5135 ASQL_F5135 C2 NOT_RELEASED
ASQL_F5150 ASQL_F5150 C2 NOT_RELEASED
ASQL_F5227 ASQL_F5227 C2 NOT_RELEASED
ASQL_F5289 ASQL_F5289 C2 NOT_RELEASED
ASQL_F5711 ASQL_F5711 C2 NOT_RELEASED
ASQL_F5716 ASQL_F5716 C2 NOT_RELEASED
ASQL_F5980 ASQL_F5980 C2 NOT_RELEASED
ASQL_F5987 ASQL_F5987 C2 NOT_RELEASED
ASQL_F6061 ASQL_F6061 C2 NOT_RELEASED
ASQL_F6096 ASQL_F6096 C2 NOT_RELEASED
ASQL_F6109 ASQL_F6109 C2 NOT_RELEASED
ASQL_F6134 ASQL_F6134 C2 NOT_RELEASED
ASQL_F6194 ASQL_F6194 C2 NOT_RELEASED
ASQL_F6204 ASQL_F6204 C2 NOT_RELEASED
ASQL_F6488 ASQL_F6488 C2 NOT_RELEASED
ASQL_F6635 ASQL_F6635 C2 NOT_RELEASED
ASQL_F6728 ASQL_F6728 C2 NOT_RELEASED
ASQL_F6742 ASQL_F6742 C2 NOT_RELEASED
ASQL_F6764 ASQL_F6764 C2 NOT_RELEASED
ASQL_F6783 ASQL_F6783 C2 NOT_RELEASED
ASQL_F6852 ASQL_F6852 C2 NOT_RELEASED
ASQL_F6869 ASQL_F6869 C2 NOT_RELEASED
ASQL_F6951 ASQL_F6951 C2 NOT_RELEASED
ASQL_F6990 ASQL_F6990 C2 NOT_RELEASED
ASQL_F7103 ASQL_F7103 C2 NOT_RELEASED
ASQL_F7107 ASQL_F7107 C2 NOT_RELEASED
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
ASQL_F7308 ASQL_F7308 C2 NOT_RELEASED
ASQL_F7321 ASQL_F7321 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED
ASQL_F7349 ASQL_F7349 C2 NOT_RELEASED
ASQL_F7441 ASQL_F7441 C2 NOT_RELEASED
ASQL_F7442 ASQL_F7442 C2 NOT_RELEASED
ASQL_F7775 ASQL_F7775 C2 NOT_RELEASED
ASQL_F7900 ASQL_F7900 C2 NOT_RELEASED
ASQL_F7933 ASQL_F7933 C2 NOT_RELEASED
ASQL_F7934 ASQL_F7934 C2 NOT_RELEASED
ASQL_F8119 ASQL_F8119 C2 NOT_RELEASED
ASQL_F8336 ASQL_F8336 C2 NOT_RELEASED
ASQL_F8417 ASQL_F8417 C2 NOT_RELEASED
ASQL_F8464 ASQL_F8464 C2 NOT_RELEASED
ASQL_F8634 ASQL_F8634 C2 NOT_RELEASED
ASQL_F8654 ASQL_F8654 C2 NOT_RELEASED
ASQL_F8712 ASQL_F8712 C2 NOT_RELEASED
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
GSFINCSIL_INCOMING_PAYMENT GSFINCSIL_INCOM_PAYMENT_V2 V2 C1 NOT_RELEASED
GSFINCSIL_INCOMING_PAYMENT GSFINCSIL_INCOM_PAYMENT_V4 V4 C1 NOT_RELEASED
ICL_INSURCLMPAYMENT ICL_UI_INSURCLMPAYMENT_O2 V2 C1 NOT_RELEASED
ICL_RESERVEMAINTAIN ICL_UI_RESERVEMAINTAIN V2 C1 NOT_RELEASED
UI_ACCRUALS_MANAGE UI_ACCRUALS_MANAGE V2 C1 NOT_RELEASED
UI_ACCRUALS_PERDCAMT_MANAGE UI_ACCRS_PERDCAMT_MANAGE V2 C1 NOT_RELEASED
UI_BILLINGDOCUMENTFS UI_BILLINGDOCUMENTFS V2 C1 NOT_RELEASED
UI_CADOCUMENT_MNG UI_CADOCUMENT_MNG V4 C1 NOT_RELEASED
UI_CMMDTYHDGSPECIFICATION UI_CMMDTYHDGSPECIFICATION V2 C1 NOT_RELEASED
UI_CREDITMEMOREQUESTMANAGE UI_CREDITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_CUSTOMER_WARRANTYCLAIM UI_CUSTOMER_WARRANTYCLAIM V2 C1 NOT_RELEASED
UI_CUSTOMERRETURNMANAGE UI_CUSTOMERRETURNMANAGE V4 C1 NOT_RELEASED
UI_CUSTPROJSALESORDERMANAGE UI_CUSTPROJSALESORDERMANAGE V4 C1 NOT_RELEASED
UI_DEBITMEMOREQUESTMANAGE UI_DEBITMEMOREQUESTMANAGE V4 C1 NOT_RELEASED
UI_MANAGE_WARRANTYCLAIM UI_MANAGE_WARRANTYCLAIM V2 C1 NOT_RELEASED
UI_PRAPRICINGFORMULA_MANAGE UI_PRAPRICINGFRML_MANAGE V2 C1 NOT_RELEASED
UI_PRELIMBILLINGDOCUMENT_F6990 UI_PRELIMBILLINGDOCUMENT_F6990 V4 C1 NOT_RELEASED
UI_PURCHASEORDERACCRS_DISPLAY UI_PURCHASEORDERACCRS_DSP V2 C1 NOT_RELEASED
UI_SALESCONTRACTMANAGE UI_SALESCONTRACTMANAGE V4 C1 NOT_RELEASED
UI_SALESDOCUMENTMANAGE UI_SALESDOCUMENTMANAGE V4 C1 NOT_RELEASED
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED
UI_SOURCINGPROJECT_MANAGE UI_SOURCINGPROJECT_MANAGE V2 C1 NOT_RELEASED
UI_SRCGPROJQUOTATION_MANAGE UI_SRCGPROJQTN_MANAGE V2 C1 NOT_RELEASED
UI_UPLOADOPENARITEMS UI_UPLOADOPENARITEMS V4 C1 NOT_TO_BE_RELEASED_STABLE

Fiori Apps (3)

App IDApp NameTypeDescription
F1901 Billing Document Fact sheet The billing document object page displays contextual information about the billing document business object, bringing together all of the object's relevant attributes to provide you with an overview of the selected billing document.
F5227 Manage Claims Transactional An application to manage warranty claims for supplier recovery processes
F6204 Manage Claims-Customer facing process Transactional An application to manage Warranty Claims for customer facing processes

Billing Document

Business Role: Billing Clerk

You can access this object page from the Enterprise Search for billing documents search results. It displays contextual information about the billing document business object, bringing together all of the object"s relevant attributes to provide you with an overview of the selected billing document. At the bottom of the page, you can choose the name of involved business partners to display their contact details.

Manage Claims

Business Role: Claims Analyst

With the Manage Supplier Claims application, you can create warranty claims that are forwarded to the suppliers for reimbursement. This includes creating supplier claims (based on repairs), validating claims for completeness and eligibility for reimbursement, and determining correct prices (for example materials, labor tasks) to claim the appropriate amount. Once the supplier responds, the application supports the transperant maintenance of values and posting of the negotiated A warranty claim is a claim for reimbursement of material and labor costs that are incurred for the purpose of rectifying faults in an object with a valid warranty.

Key Features: A claim analyst can use this application to do the following: Create a Supplier Claim Edit a Supplier Claim Validate a Supplier Claim Send a Claim to Supplier Adjust a Supplier Claim Record Supplier Response Post Supplier Claim to Finance Reverse Posted Supplier Claim Cancel a Supplier Claim Reject a Supplier Claim Reprocess a Supplier Claim Close a Supplier Claim Reopen a Supplier Claim

Manage Claims-Customer facing process

Business Role: Claims Analyst

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY Currency tcurc waers Transaction Currency
_Text _Text
Decimals Number of decimal places
CurrencyISOCode ISO Currency Code
AlternativeCurrencyKey Alternative Key
IsPrimaryCurrencyForISOCrcy tcurc xprimary Primary SAP Currency Code for ISO Code

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_Currency.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFICURRENCY

CREATE VIEW I_Currency AS
SELECT
  tcurc.waers AS Currency,
  cast(COALESCE(tcurx.currdec, 2) as currdec_cds) AS Decimals,
  cast(tcurc.isocd as isocd_cds) AS CurrencyISOCode,
  cast(tcurc.altwr as altwr_cds) AS AlternativeCurrencyKey,
  tcurc.xprimary AS IsPrimaryCurrencyForISOCrcy
FROM tcurc
LEFT OUTER JOIN tcurx ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CurrencyText AS _Text ON Currency = _Text.Currency  -- association [0..*]
;

Learn More