I_TrdCmplncLicenseVH

DDL: I_TRDCMPLNCLICENSEVH SQL: ITRDCMPLVH Type: view COMPOSITE
14 Fields 2 Data Sources

License

I_TrdCmplncLicenseVH is a Composite CDS View that provides data about "License" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_TrdCmplncLicHeader) and exposes 14 fields with key field TrdCmplncLicenseUUID.

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode _CompanyCode left_outer
I_TrdCmplncLicHeader I_TrdCmplncLicHeader from

Annotations (12)

NameValueLevelField
EndUserText.label License view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
AbapCatalog.sqlViewName ITRDCMPLVH view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view
ObjectModel.usageType.sizeCategory M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
Search.searchable true view
Consumption.ranked true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY TrdCmplncLicenseUUID TrdCmplncLicenseUUID UUID
LegalRegulation LegalRegulation Legal Regulation
TrdCmplncLicenseType TrdCmplncLicenseType License Type
ExtTrdCmplncLicense ExtTrdCmplncLicense Official License No.
TrdCmplncLicenseOwner TrdCmplncLicenseOwner License Owner
TrdCmplncLicenseOwnerName I_CompanyCode CompanyCodeName Company Name
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
TrdCmplncLicenseRemark TrdCmplncLicenseRemark Remark
TrdCmplncLicenseIsOutbound _TrdCmplncLicType TrdCmplncLicenseIsOutbound
TrdCmplncLicenseIsInbound _TrdCmplncLicType TrdCmplncLicenseIsInbound
_LegalRegulation _LegalRegulation
_TrdCmplncLicType _TrdCmplncLicType
_TrdCmplncLicTypeText _TrdCmplncLicTypeText

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_TrdCmplncLicenseVH.
-- 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: ITRDCMPLVH

CREATE VIEW I_TrdCmplncLicenseVH AS
SELECT
  TrdCmplncLicenseUUID,
  LegalRegulation,
  TrdCmplncLicenseType,
  ExtTrdCmplncLicense,
  TrdCmplncLicenseOwner,
  _CompanyCode.CompanyCodeName AS TrdCmplncLicenseOwnerName,
  ValidityStartDate,
  ValidityEndDate,
  TrdCmplncLicenseRemark,
  _TrdCmplncLicType.TrdCmplncLicenseIsOutbound AS TrdCmplncLicenseIsOutbound,
  _TrdCmplncLicType.TrdCmplncLicenseIsInbound AS TrdCmplncLicenseIsInbound
FROM I_TrdCmplncLicHeader
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON /* join condition not captured in parsed metadata */
;

Learn More