I_TrdCmplncLicControlClassTP

DDL: I_TRDCMPLNCLICCONTROLCLASSTP SQL: ITRDCMPLCTLCLSTP Type: view_entity TRANSACTIONAL Package: VDM_SLL_LMG
17 Fields 1 Data Sources

License Control Classes

I_TrdCmplncLicControlClassTP is a Transactional CDS View that provides data about "License Control Classes" in SAP S/4HANA. It reads from 1 data source (I_TrdCmplncLicControlClass) and exposes 17 fields with key field TrdCmplncLicCtrlClUUID. Part of development package VDM_SLL_LMG.

Data Sources (1)

SourceAliasJoin Type
I_TrdCmplncLicControlClass I_TrdCmplncLicControlClass from

Annotations (7)

NameValueLevelField
EndUserText.label License Control Classes view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TrdCmplncLicCtrlClUUID TrdCmplncLicCtrlClUUID UUID
TrdCmplncLicenseUUID TrdCmplncLicenseUUID UUID
ControlClass ControlClass Control Class
TrdCmplncLicenseMaxAmount TrdCmplncLicenseMaxAmount Maximum Amount
TrdCmplncLicenseUsdAmount TrdCmplncLicenseUsdAmount
TrdCmplncLicenseAvailAmount TrdCmplncLicenseAvailAmount
TrdCmplncLicenseDeprCurrency TrdCmplncLicenseDeprCurrency Currency
TrdCmplncLicenseAmtExcdPct TrdCmplncLicenseAmtExcdPct Exceeded Value (%)
TrdCmplncLicenseMaxQuantity TrdCmplncLicenseMaxQuantity Maximum Quantity
TrdCmplncLicenseUsdQuantity TrdCmplncLicenseUsdQuantity
TrdCmplncLicenseAvailQuantity
TrdCmplncLicenseDeprUnit TrdCmplncLicenseDeprUnit Int. Unit Meas.
TrdCmplncLicenseQtyExcdPct TrdCmplncLicenseQtyExcdPct Exceeded Quant. (%)
_TrdCmplncLicHeader _TrdCmplncLicHeader
_Currency _Currency
_UnitOfMeasure _UnitOfMeasure
_TrdCmplncLicenseTP _TrdCmplncLicenseTP

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_TrdCmplncLicControlClassTP.
-- 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: ITRDCMPLCTLCLSTP

CREATE VIEW I_TrdCmplncLicControlClassTP AS
SELECT
  TrdCmplncLicCtrlClUUID,
  TrdCmplncLicenseUUID,
  ControlClass,
  TrdCmplncLicenseMaxAmount,
  TrdCmplncLicenseUsdAmount,
  TrdCmplncLicenseAvailAmount,
  TrdCmplncLicenseDeprCurrency,
  TrdCmplncLicenseAmtExcdPct,
  TrdCmplncLicenseMaxQuantity,
  TrdCmplncLicenseUsdQuantity,
  cast (( TrdCmplncLicenseMaxQuantity * (1 + division(TrdCmplncLicenseQtyExcdPct,100,4)) - TrdCmplncLicenseUsdQuantity) as /sapsll/avqua ) AS TrdCmplncLicenseAvailQuantity,
  TrdCmplncLicenseDeprUnit,
  TrdCmplncLicenseQtyExcdPct
FROM I_TrdCmplncLicControlClass
;

Learn More