I_FactoryCalendarText

DDL: I_FACTORYCALENDARTEXT SQL: IPPFACTORYCALTXT Type: view BASIC Package: VDM_FND
4 Fields 1 Data Sources 1 Associations 22 OData Services

Factory Calendar - Text

I_FactoryCalendarText (Basic)

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

Cross Applications

I_FactoryCalendarText is a Basic CDS View that provides data about "Factory Calendar - Text" in SAP S/4HANA. It reads from 1 data source (tfact) and exposes 4 fields with key fields FactoryCalendar, Language. It has 1 association to related views. It is exposed through 22 OData services (ASQL_F1754, ASQL_F3034, ASQL_F3040, ...). Part of development package VDM_FND.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentCA-GTF-VDM
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>What are the names of factory calendars in different languages?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
tfact txt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IPPFACTORYCALTXT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey FactoryCalendar view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
Search.searchable true view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #BASIC view
EndUserText.label Factory Calendar - Text view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.type #INHERITED view
AbapCatalog.buffering.type #FULL view
Analytics.dataExtraction.enabled true view

OData Services (22)

ServiceBindingVersionContractRelease
ASQL_F1754 ASQL_F1754 C2 NOT_RELEASED
ASQL_F3034 ASQL_F3034 C2 NOT_RELEASED
ASQL_F3040 ASQL_F3040 C2 NOT_RELEASED
ASQL_F3215 ASQL_F3215 C2 NOT_RELEASED
ASQL_F3480 ASQL_F3480 C2 NOT_RELEASED
ASQL_F3799 ASQL_F3799 C2 NOT_RELEASED
ASQL_F3822 ASQL_F3822 C2 NOT_RELEASED
ASQL_F4173A ASQL_F4173A C2 NOT_RELEASED
ASQL_F4657 ASQL_F4657 C2 NOT_RELEASED
ASQL_F4684 ASQL_F4684 C2 NOT_RELEASED
ASQL_F5176 ASQL_F5176 C2 NOT_RELEASED
ASQL_F5380 ASQL_F5380 C2 NOT_RELEASED
ASQL_F5941 ASQL_F5941 C2 NOT_RELEASED
ASQL_F6883 ASQL_F6883 C2 NOT_RELEASED
ASQL_F6884 ASQL_F6884 C2 NOT_RELEASED
ASQL_F6951 ASQL_F6951 C2 NOT_RELEASED
ASQL_F7204A ASQL_F7204A C2 NOT_RELEASED
ASQL_F7205A ASQL_F7205A C2 NOT_RELEASED
ASQL_F7264 ASQL_F7264 C2 NOT_RELEASED
ASQL_F7308 ASQL_F7308 C2 NOT_RELEASED
ASQL_F7321 ASQL_F7321 C2 NOT_RELEASED
ASQL_F7334 ASQL_F7334 C2 NOT_RELEASED

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY FactoryCalendar Factory Calendar ID
KEY Language Language Key
FactoryCalendarName Factory Calendar Text
_Language _Language

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_FactoryCalendarText.
-- 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: IPPFACTORYCALTXT

CREATE VIEW I_FactoryCalendarText AS
SELECT
  cast(txt.ident as cr_wfcid preserving type) AS FactoryCalendar,
  cast(txt.spras as spras preserving type) AS Language,
  cast(txt.ltext as pph_fktext preserving type) AS FactoryCalendarName
FROM tfact AS txt
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
;

Learn More