A_CommsnPerfRmnrtnAgreement

DDL: A_COMMSNPERFRMNRTNAGREEMENT Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 1 OData Services

Performance-Related Rmnrtn Agreement

A_CommsnPerfRmnrtnAgreement is a Consumption CDS View that provides data about "Performance-Related Rmnrtn Agreement" in SAP S/4HANA. It reads from 1 data source (I_CommsnPerfRmnrtnAgrmtByTime) and exposes 12 fields with key fields CommissionApplication, CommissionContract, CommsnContrEffctvFrmDateTime, CommsnContrEffctvToDateTime, CommissionContractAgreement. It is exposed through 1 OData service (API_COMMISSIONCONTRACT).

Data Sources (1)

SourceAliasJoin Type
I_CommsnPerfRmnrtnAgrmtByTime I_CommsnPerfRmnrtnAgrmtByTime from

Annotations (10)

NameValueLevelField
EndUserText.label Performance-Related Rmnrtn Agreement view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
OData.entityType.name CommsnPerfRmnrtnAgreement_Type view
ObjectModel.sapObjectNodeType.name CommsnPerfRmnrtnAgreement view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
API_COMMISSIONCONTRACT API_COMMISSIONCONTRACT V4 C2 C1

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication CommissionApplication Commission Appl
KEY CommissionContract CommissionContract
KEY CommsnContrEffctvFrmDateTime CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime CommsnContrEffctvToDateTime
KEY CommissionContractAgreement CommissionContractAgreement
CommsnAgrmtEffctvFrmDteTme CommsnAgrmtEffctvFrmDteTme
CommissionStandardAgreement CommissionStandardAgreement
CommissionContractVersion CommissionContractVersion
CommsnContractAgreementVersion CommsnContractAgreementVersion
CommsnContrChangeReason CommsnContrChangeReason
CommissionVersionIsInvalid CommissionVersionIsInvalid
_CommissionContract _CommissionContract

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 A_CommsnPerfRmnrtnAgreement.
-- 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 A_CommsnPerfRmnrtnAgreement AS
SELECT
  CommissionApplication,
  CommissionContract,
  CommsnContrEffctvFrmDateTime,
  CommsnContrEffctvToDateTime,
  CommissionContractAgreement,
  CommsnAgrmtEffctvFrmDteTme,
  CommissionStandardAgreement,
  CommissionContractVersion,
  CommsnContractAgreementVersion,
  CommsnContrChangeReason,
  CommissionVersionIsInvalid
FROM I_CommsnPerfRmnrtnAgrmtByTime
;

Learn More