C_NominationTicketAddlQuantity

DDL: C_NOMINATIONTICKETADDLQUANTITY SQL: CNOMTKTADDLQTY Type: view CONSUMPTION
12 Fields 2 Data Sources

Nomination Ticket Additional Quantity

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

Data Sources (2)

SourceAliasJoin Type
I_NominationTicketDetail _NominationTicketDetail inner
I_NominationTicketDynAddlQty NominationTicketAddlQuantity from

Annotations (9)

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

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY NominationDoc I_NominationTicketDynAddlQty NominationDoc Nomination key
KEY NominationDocItem I_NominationTicketDynAddlQty NominationDocItem Nom. key item
KEY NominationTicketKey I_NominationTicketDynAddlQty NominationTicketKey
KEY NominationTicketItem I_NominationTicketDynAddlQty NominationTicketItem
KEY NominationTicketVersion I_NominationTicketDynAddlQty NominationTicketVersion
KEY NominationTicketUoM NominationTicketUoM
NominationTicketQuantity NominationTicketQuantity
NominationTicketHighTolQty NominationTicketHighTolQty
IsQuantityManual IsQuantityManual
NominationTicketUoMDesc NominationTicketUoMDesc
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_NominationTicketAddlQuantity.
-- 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: CNOMTKTADDLQTY

CREATE VIEW C_NominationTicketAddlQuantity AS
SELECT
  NominationTicketAddlQuantity.NominationDoc AS NominationDoc,
  NominationTicketAddlQuantity.NominationDocItem AS NominationDocItem,
  NominationTicketAddlQuantity.NominationTicketKey AS NominationTicketKey,
  NominationTicketAddlQuantity.NominationTicketItem AS NominationTicketItem,
  NominationTicketAddlQuantity.NominationTicketVersion AS NominationTicketVersion,
  NominationTicketUoM,
  NominationTicketQuantity,
  NominationTicketHighTolQty,
  IsQuantityManual,
  NominationTicketUoMDesc,
  _NominationTicketDetail.NominationDocIsBlocked AS NominationDocIsBlocked
FROM I_NominationTicketDynAddlQty AS NominationTicketAddlQuantity
INNER JOIN I_NominationTicketDetail AS _NominationTicketDetail ON /* join condition not captured in parsed metadata */
;

Learn More