I_TrdCmplncLicCommodityCodeTP

DDL: I_TRDCMPLNCLICCOMMODITYCODETP SQL: ITRDCMPLCMTCDTP Type: view_entity TRANSACTIONAL
17 Fields 1 Data Sources

License Commodity Codes

I_TrdCmplncLicCommodityCodeTP is a Transactional CDS View that provides data about "License Commodity Codes" in SAP S/4HANA. It reads from 1 data source (I_TrdCmplncLicCommodityCode) and exposes 17 fields with key field TrdCmplncLicCmmdtyCodeUUID.

Data Sources (1)

SourceAliasJoin Type
I_TrdCmplncLicCommodityCode I_TrdCmplncLicCommodityCode from

Annotations (8)

NameValueLevelField
EndUserText.label License Commodity Codes view
VDM.viewType #TRANSACTIONAL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.modelCategory #BUSINESS_OBJECT 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 TrdCmplncLicCmmdtyCodeUUID TrdCmplncLicCmmdtyCodeUUID UUID
TrdCmplncLicenseUUID TrdCmplncLicenseUUID UUID
CommodityCode CommodityCode Commodity Code
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_TrdCmplncLicCommodityCodeTP.
-- 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: ITRDCMPLCMTCDTP

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

Learn More