C_NominationTicketParameter

DDL: C_NOMINATIONTICKETPARAMETER SQL: CNOMTKTPARAM Type: view CONSUMPTION
20 Fields 2 Data Sources

Nomination Ticket Additional Parameter

C_NominationTicketParameter is a Consumption CDS View that provides data about "Nomination Ticket Additional Parameter" in SAP S/4HANA. It reads from 2 data sources (I_NominationTicketDetail, I_NominationTicketParameter) and exposes 20 fields with key fields NominationDoc, NominationDocItem, NominationTicketKey, NominationTicketItem, NominationTicketVersion.

Data Sources (2)

SourceAliasJoin Type
I_NominationTicketDetail _NominationTicketDetail inner
I_NominationTicketParameter NominationTicketParameter from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CNOMTKTPARAM view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Nomination Ticket Additional Parameter view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc I_NominationTicketParameter NominationDoc Nomination key
KEY NominationDocItem I_NominationTicketParameter NominationDocItem Nom. key item
KEY NominationTicketKey I_NominationTicketParameter NominationTicketKey
KEY NominationTicketItem I_NominationTicketParameter NominationTicketItem
KEY NominationTicketVersion I_NominationTicketParameter NominationTicketVersion
KEY OilPhysParamName OilPhysParamName
OilPhysParamFieldName OilPhysParamFieldName
OilPhysParamUoMFieldName OilPhysParamUoMFieldName
OilPhysParamDescStyle OilPhysParamDescStyle
OilPhysParamCheckStyle OilPhysParamCheckStyle
OilPhysParamValueStyle OilPhysParamValueStyle
OilPhysParamUnitStyle OilPhysParamUnitStyle
OilPhysParamDesc OilPhysParamDesc
IsOilPhysParam IsOilPhysParam CHAR flag
OilPhysParamValue OilPhysParamValue Par. character
OilPhysParamUoM OilPhysParamUoM
OilPhysParamUoMDesc OilPhysParamUoMDesc
OilPhysParamValueType OilPhysParamValueType
NominationDocIsBlocked I_NominationTicketDetail NominationDocIsBlocked
_NominationTicketDetail _NominationTicketDetail

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 C_NominationTicketParameter.
-- 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: CNOMTKTPARAM

CREATE VIEW C_NominationTicketParameter AS
SELECT
  NominationTicketParameter.NominationDoc AS NominationDoc,
  NominationTicketParameter.NominationDocItem AS NominationDocItem,
  NominationTicketParameter.NominationTicketKey AS NominationTicketKey,
  NominationTicketParameter.NominationTicketItem AS NominationTicketItem,
  NominationTicketParameter.NominationTicketVersion AS NominationTicketVersion,
  OilPhysParamName,
  OilPhysParamFieldName,
  OilPhysParamUoMFieldName,
  OilPhysParamDescStyle,
  OilPhysParamCheckStyle,
  OilPhysParamValueStyle,
  OilPhysParamUnitStyle,
  OilPhysParamDesc,
  IsOilPhysParam,
  OilPhysParamValue,
  OilPhysParamUoM,
  OilPhysParamUoMDesc,
  OilPhysParamValueType,
  _NominationTicketDetail.NominationDocIsBlocked AS NominationDocIsBlocked
FROM I_NominationTicketParameter AS NominationTicketParameter
INNER JOIN I_NominationTicketDetail AS _NominationTicketDetail ON /* join condition not captured in parsed metadata */
;

Learn More