I_NominationTicketParameter

DDL: I_NOMINATIONTICKETPARAMETER SQL: INOMTKTPARAM Type: view COMPOSITE
19 Fields 2 Data Sources 1 Associations

Nomination Ticket Additional Parameter

I_NominationTicketParameter is a Composite CDS View that provides data about "Nomination Ticket Additional Parameter" in SAP S/4HANA. It reads from 2 data sources (I_NominationItemFld, I_NominationTicketList) and exposes 19 fields with key fields NominationDoc, NominationDocItem, NominationTicketKey, NominationTicketItem, NominationTicketVersion. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_NominationItemFld NominationItemFld from
I_NominationTicketList NominationTicketList left_outer

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_NominationTicketDetail _NominationTicketDetail $projection.NominationDoc = _NominationTicketDetail.NominationDoc and $projection.NominationDocItem = _NominationTicketDetail.NominationDocItem

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName INOMTKTPARAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Nomination Ticket Additional Parameter view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc I_NominationItemFld NominationDoc Nomination key
KEY NominationDocItem I_NominationItemFld NominationDocItem Nom. key item
KEY NominationTicketKey I_NominationTicketList NominationTicketKey
KEY NominationTicketItem I_NominationTicketList NominationTicketItem
KEY NominationTicketVersion I_NominationTicketList NominationTicketVersion
KEY OilPhysParamName
OilPhysParamFieldName
OilPhysParamUoMFieldName
OilPhysParamDescStyle
OilPhysParamCheckStyle
OilPhysParamValueStyle
OilPhysParamUnitStyle
OilPhysParamDesc
IsOilPhysParam
OilPhysParamValue
OilPhysParamUoM
OilPhysParamUoMDesc
OilPhysParamValueType
_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 I_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: INOMTKTPARAM

CREATE VIEW I_NominationTicketParameter AS
SELECT
  NominationItemFld.NominationDoc AS NominationDoc,
  NominationItemFld.NominationDocItem AS NominationDocItem,
  NominationTicketList.NominationTicketKey AS NominationTicketKey,
  NominationTicketList.NominationTicketItem AS NominationTicketItem,
  NominationTicketList.NominationTicketVersion AS NominationTicketVersion,
  cast( '' as abap.char(10) ) AS OilPhysParamName,
  cast( '' as abap.char(30) ) AS OilPhysParamFieldName,
  cast( '' as abap.char(30) ) AS OilPhysParamUoMFieldName,
  cast( '' as abap.char(1) ) AS OilPhysParamDescStyle,
  cast( '' as abap.char(1) ) AS OilPhysParamCheckStyle,
  cast( '' as abap.char(1) ) AS OilPhysParamValueStyle,
  cast( '' as abap.char(1) ) AS OilPhysParamUnitStyle,
  cast( '' as abap.char(30) ) AS OilPhysParamDesc,
  cast( '' as abap.char(1) ) AS IsOilPhysParam,
  cast( '' as abap.char(22) ) AS OilPhysParamValue,
  cast( '' as meinh ) AS OilPhysParamUoM,
  cast('' as abap.char(40)) AS OilPhysParamUoMDesc,
  cast('' as oib_float_char ) AS OilPhysParamValueType
FROM I_NominationItemFld AS NominationItemFld
LEFT OUTER JOIN I_NominationTicketList AS NominationTicketList ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_NominationTicketDetail AS _NominationTicketDetail ON NominationDoc = _NominationTicketDetail.NominationDoc AND NominationDocItem = _NominationTicketDetail.NominationDocItem  -- association [1..1]
;

Learn More