I_CndnContrIntcoRoyaltyStdVH

DDL: I_CNDNCONTRINTCOROYALTYSTDVH Type: view_entity COMPOSITE
21 Fields 1 Data Sources

Intercompany Royalty Condition Contracts

I_CndnContrIntcoRoyaltyStdVH is a Composite CDS View that provides data about "Intercompany Royalty Condition Contracts" in SAP S/4HANA. It reads from 1 data source (R_ConditionContract) and exposes 21 fields with key field ConditionContract.

Data Sources (1)

SourceAliasJoin Type
R_ConditionContract Contract from

Annotations (14)

NameValueLevelField
EndUserText.label Intercompany Royalty Condition Contracts view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ConditionContract view
ObjectModel.modelingPattern #VALUE_HELP_PROVIDER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Search.searchable true view
Consumption.ranked true view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract R_ConditionContract ConditionContract Condition Contract
CndnContrType R_ConditionContract CndnContrType Contract Type
CndnContrTypeDesc
ExternalDocumentReferenceID R_ConditionContract ExternalDocumentReferenceID Ext. Identifier
CndnContrValidFrom R_ConditionContract CndnContrValidFrom Valid From
CndnContrValidTo R_ConditionContract CndnContrValidTo Valid To
PurchasingOrganization R_ConditionContract PurchasingOrganization Purchasing Organization
PurchasingGroup R_ConditionContract PurchasingGroup Purchasing Group
SalesOrganization R_ConditionContract SalesOrganization Sales Organization
DistributionChannel R_ConditionContract DistributionChannel RefDistCh-Cust/Mat.
Division R_ConditionContract Division Internal Division ID
CompanyCode R_ConditionContract CompanyCode Receiver Company Code
CndnContrWorkerCostCenter R_ConditionContract CndnContrWorkerCostCenter
Customer R_ConditionContract Customer Sold-to Party
_Customer R_ConditionContract _Customer
PriorSupplier R_ConditionContract PriorSupplier Prior Supplier
_PriorSupplier R_ConditionContract _PriorSupplier
Supplier R_ConditionContract Supplier Supplier
_Supplier R_ConditionContract _Supplier
PersonWorkAgreement R_ConditionContract PersonWorkAgreement Personnel No.
_PersonWorkAgreement R_ConditionContract _PersonWorkAgreement

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_CndnContrIntcoRoyaltyStdVH.
-- 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.

CREATE VIEW I_CndnContrIntcoRoyaltyStdVH AS
SELECT
  Contract.ConditionContract AS ConditionContract,
  Contract.CndnContrType AS CndnContrType,
  Contract._CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc AS CndnContrTypeDesc,
  Contract.ExternalDocumentReferenceID AS ExternalDocumentReferenceID,
  Contract.CndnContrValidFrom AS CndnContrValidFrom,
  Contract.CndnContrValidTo AS CndnContrValidTo,
  Contract.PurchasingOrganization AS PurchasingOrganization,
  Contract.PurchasingGroup AS PurchasingGroup,
  Contract.SalesOrganization AS SalesOrganization,
  Contract.DistributionChannel AS DistributionChannel,
  Contract.Division AS Division,
  Contract.CompanyCode AS CompanyCode,
  Contract.CndnContrWorkerCostCenter AS CndnContrWorkerCostCenter,
  Contract.Customer AS Customer,
  Contract._Customer AS _Customer,
  Contract.PriorSupplier AS PriorSupplier,
  Contract._PriorSupplier AS _PriorSupplier,
  Contract.Supplier AS Supplier,
  Contract._Supplier AS _Supplier,
  Contract.PersonWorkAgreement AS PersonWorkAgreement,
  Contract._PersonWorkAgreement AS _PersonWorkAgreement
FROM R_ConditionContract AS Contract
;

Learn More