A_CommsnContrGuarRmnrtnAgrmt

DDL: A_COMMSNCONTRGUARRMNRTNAGRMT Type: view_entity CONSUMPTION
18 Fields 1 Data Sources 1 OData Services

Guarantee Remuneration

A_CommsnContrGuarRmnrtnAgrmt is a Consumption CDS View that provides data about "Guarantee Remuneration" in SAP S/4HANA. It reads from 1 data source (I_CmsnConGuarRmnrtnAgrmtByTme) and exposes 18 fields with key fields CommissionApplication, CommissionContract, CommsnContrEffctvFrmDateTime, CommsnContrEffctvToDateTime, CommissionContractAgreement. It is exposed through 1 OData service (API_COMMISSIONCONTRACT).

Data Sources (1)

SourceAliasJoin Type
I_CmsnConGuarRmnrtnAgrmtByTme GuarRmnrtnAgreement from

Annotations (10)

NameValueLevelField
EndUserText.label Guarantee Remuneration view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
ObjectModel.sapObjectNodeType.name CommsnContrGuarRmnrtnAgreement view
OData.entityType.name CommsnContrGuarRmnrtnAgreement_Type 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 (18)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication I_CmsnConGuarRmnrtnAgrmtByTme CommissionApplication Commission Appl
KEY CommissionContract I_CmsnConGuarRmnrtnAgrmtByTme CommissionContract
KEY CommsnContrEffctvFrmDateTime I_CmsnConGuarRmnrtnAgrmtByTme CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime I_CmsnConGuarRmnrtnAgrmtByTme CommsnContrEffctvToDateTime
KEY CommissionContractAgreement I_CmsnConGuarRmnrtnAgrmtByTme CommissionContractAgreement
KEY CommsnContrAgreementRule I_CmsnConGuarRmnrtnAgrmtByTme CommsnContrAgreementRule
CommsnAgrmtEffctvFrmDteTme I_CmsnConGuarRmnrtnAgrmtByTme CommsnAgrmtEffctvFrmDteTme
CommsnAgrmtEffctvToDteTme I_CmsnConGuarRmnrtnAgrmtByTme CommsnAgrmtEffctvToDteTme
CommissionContractVersion I_CmsnConGuarRmnrtnAgrmtByTme CommissionContractVersion
CommsnContractAgreementVersion I_CmsnConGuarRmnrtnAgrmtByTme CommsnContractAgreementVersion
CommissionContractCurrency I_CmsnConGuarRmnrtnAgrmtByTme CommissionContractCurrency
CommsnAgrmtRemunerationAmount I_CmsnConGuarRmnrtnAgrmtByTme CommsnAgrmtRemunerationAmount
CommsnAgrmtRmnrtnStrtDteTme I_CmsnConGuarRmnrtnAgrmtByTme CommsnAgrmtRmnrtnStrtDteTme
CommsnAgrmtRmnrtnEndDteTime I_CmsnConGuarRmnrtnAgrmtByTme CommsnAgrmtRmnrtnEndDteTime
CommsnRemunerationType I_CmsnConGuarRmnrtnAgrmtByTme CommsnRemunerationType
CommissionVersionIsInvalid I_CmsnConGuarRmnrtnAgrmtByTme CommissionVersionIsInvalid
CommsnContrChangeReason I_CmsnConGuarRmnrtnAgrmtByTme CommsnContrChangeReason
_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_CommsnContrGuarRmnrtnAgrmt.
-- 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_CommsnContrGuarRmnrtnAgrmt AS
SELECT
  GuarRmnrtnAgreement.CommissionApplication AS CommissionApplication,
  GuarRmnrtnAgreement.CommissionContract AS CommissionContract,
  GuarRmnrtnAgreement.CommsnContrEffctvFrmDateTime AS CommsnContrEffctvFrmDateTime,
  GuarRmnrtnAgreement.CommsnContrEffctvToDateTime AS CommsnContrEffctvToDateTime,
  GuarRmnrtnAgreement.CommissionContractAgreement AS CommissionContractAgreement,
  GuarRmnrtnAgreement.CommsnContrAgreementRule AS CommsnContrAgreementRule,
  GuarRmnrtnAgreement.CommsnAgrmtEffctvFrmDteTme AS CommsnAgrmtEffctvFrmDteTme,
  GuarRmnrtnAgreement.CommsnAgrmtEffctvToDteTme AS CommsnAgrmtEffctvToDteTme,
  GuarRmnrtnAgreement.CommissionContractVersion AS CommissionContractVersion,
  GuarRmnrtnAgreement.CommsnContractAgreementVersion AS CommsnContractAgreementVersion,
  GuarRmnrtnAgreement.CommissionContractCurrency AS CommissionContractCurrency,
  GuarRmnrtnAgreement.CommsnAgrmtRemunerationAmount AS CommsnAgrmtRemunerationAmount,
  GuarRmnrtnAgreement.CommsnAgrmtRmnrtnStrtDteTme AS CommsnAgrmtRmnrtnStrtDteTme,
  GuarRmnrtnAgreement.CommsnAgrmtRmnrtnEndDteTime AS CommsnAgrmtRmnrtnEndDteTime,
  GuarRmnrtnAgreement.CommsnRemunerationType AS CommsnRemunerationType,
  GuarRmnrtnAgreement.CommissionVersionIsInvalid AS CommissionVersionIsInvalid,
  GuarRmnrtnAgreement.CommsnContrChangeReason AS CommsnContrChangeReason
FROM I_CmsnConGuarRmnrtnAgrmtByTme AS GuarRmnrtnAgreement
;

Learn More