I_COUNTRY is the Basic CDS view, which provides access to the Country data in SAP S/HANA system. Core Data Services (CDS) views are semantically rich data models that provide efficient in-built functions such as aggregations, annotations, and conceptual associations.
This CDS view is found in the SAP Technology – Business Services: Address Management (SZAD) package and is part of the Address Management/Business Address (BC-SRV-ADR) module.
CDS View | I_COUNTRY |
---|---|
DDL SQL View | IFICOUNTRY |
Status | Released |
CDS View Type | Basic |
Package | SZAD |
Technical Component | BC-SRV-ADR |
You can create custom CDS views for released views and expose them as a read-only OData service that delivers data tailored to the needs of your external application.
Tables Used
The following are the SAP S/4HANA table(s) used to develop this CDS view
Table Name | Table Description |
---|---|
T005 | Countries |
CDS View Fields
The following is the list of fields available in the CDS view and key fields are highlighted in color:
CDS View Field | Text | SQL View/Table | Table Field | Data Type(Length) |
---|---|---|---|---|
MANDT | Client | T005 | MANDT | CLNT(3) |
COUNTRY | Country/Region Key | T005 | LAND1 | CHAR(3) |
COUNTRYTHREELETTERISOCODE | ISO country code 3 char | T005 | INTCA3 | CHAR(3) |
COUNTRYTHREEDIGITISOCODE | ISO Country Code Numeric 3-Characters | T005 | INTCN3 | NUMC(3) |
COUNTRYISOCODE | Country ISO code | T005 | INTCA | CHAR(2) |
COUNTRYCURRENCY | Country Currency | T005 | WAERS | CUKY(5) |
INDEXBASEDCURRENCY | Currency Key of the Index-Based Currency | T005 | CURIN | CUKY(5) |
HARDCURRENCY | Currency Key of the Hard Currency | T005 | CURHA | CUKY(5) |
TAXCALCULATIONPROCEDURE | Procedure (Pricing, Output Control, Acct. Det., Costing,…) | T005 | KALSM | CHAR(6) |
COUNTRYALTERNATIVECODE | Alternative Country Key | T005 | LANDA | CHAR(3) |
CDS View Annotaions
The following are the CDS View Annotations used in this CDS view:
CDS Annotation Name | CDS Annotation Value |
---|---|
ACCESSCONTROL.AUTHORIZATIONCHECK | #NOT_REQUIRED |
OBJECTMODEL.REPRESENTATIVEKEY | ‘Country’ |
OBJECTMODEL.USAGETYPE.SIZECATEGORY | #S |
OBJECTMODEL.USAGETYPE.DATACLASS | #MASTER |
OBJECTMODEL.USAGETYPE.SERVICEQUALITY | #A |
OBJECTMODEL.COMPOSITIONROOT | true |
SEARCH.SEARCHABLE | true |
CLIENTHANDLING.ALGORITHM | #SESSION_VARIABLE |
METADATA.IGNOREPROPAGATEDANNOTATIONS | true |
VDM.VIEWTYPE | #BASIC |
ANALYTICS.DATAEXTRACTION.ENABLED | true |
ENDUSERTEXT.LABEL | ‘Country’ |
VDM.LIFECYCLE.CONTRACT.TYPE | #PUBLIC_LOCAL_API |
ANALYTICS.DATACATEGORY | #DIMENSION |
ABAPCATALOG.SQLVIEWNAME | ‘IFICOUNTRY’ |
ABAPCATALOG.BUFFERING.NUMBEROFKEYFIELDS | 1 |
ABAPCATALOG.BUFFERING.STATUS | #ACTIVE |
ABAPCATALOG.BUFFERING.TYPE | #FULL |
Availability
The CDS view I_COUNTRY is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
SAP S/4HANA Version | Released |
---|---|
1909 | Yes |
2020 | Yes |
2021 | Yes |
2022 | Yes |
2023 | Yes |
Supported Capabilities
Supported Capabilities are NOT defined for this CDS view.
Extensibility
Coming Soon!!
Related CDS Views
Coming Soon!!