A_CommsnAddlCaseAgreement

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

Additional Commission Case Agreement

A_CommsnAddlCaseAgreement is a Consumption CDS View that provides data about "Additional Commission Case Agreement" in SAP S/4HANA. It reads from 1 data source (I_CommsnAddlCaseAgrmtByTime) 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_CommsnAddlCaseAgrmtByTime CommsnAdditionalCaseAgreement from

Annotations (10)

NameValueLevelField
EndUserText.label Additional Commission Case 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
ObjectModel.sapObjectNodeType.name CommsnAdditionalCaseAgreement view
OData.entityType.name CommsnAdditionalCaseAgreement_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_CommsnAddlCaseAgrmtByTime CommissionApplication Commission Appl
KEY CommissionContract I_CommsnAddlCaseAgrmtByTime CommissionContract
KEY CommsnContrEffctvFrmDateTime I_CommsnAddlCaseAgrmtByTime CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime I_CommsnAddlCaseAgrmtByTime CommsnContrEffctvToDateTime
KEY CommissionContractAgreement I_CommsnAddlCaseAgrmtByTime CommissionContractAgreement
KEY CommsnContrAgreementRule I_CommsnAddlCaseAgrmtByTime CommsnContrAgreementRule
CommsnAgrmtEffctvFrmDteTme I_CommsnAddlCaseAgrmtByTime CommsnAgrmtEffctvFrmDteTme
CommsnAgrmtEffctvToDteTme I_CommsnAddlCaseAgrmtByTime CommsnAgrmtEffctvToDteTme
CommissionContractCurrency I_CommsnAddlCaseAgrmtByTime CommissionContractCurrency
CommsnAgrmtRmnrtnStrtDteTme I_CommsnAddlCaseAgrmtByTime CommsnAgrmtRmnrtnStrtDteTme
CommsnAgrmtRmnrtnEndDteTime I_CommsnAddlCaseAgrmtByTime CommsnAgrmtRmnrtnEndDteTime
CommissionTriggerCaseReason I_CommsnAddlCaseAgrmtByTime CommissionTriggerCaseReason
CommissionProcessingTarget I_CommsnAddlCaseAgrmtByTime CommissionProcessingTarget
CommissionContractVersion I_CommsnAddlCaseAgrmtByTime CommissionContractVersion
CommsnContractAgreementVersion I_CommsnAddlCaseAgrmtByTime CommsnContractAgreementVersion
CommsnContrChangeReason I_CommsnAddlCaseAgrmtByTime CommsnContrChangeReason
CommissionVersionIsInvalid I_CommsnAddlCaseAgrmtByTime 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_CommsnAddlCaseAgreement.
-- 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_CommsnAddlCaseAgreement AS
SELECT
  CommsnAdditionalCaseAgreement.CommissionApplication AS CommissionApplication,
  CommsnAdditionalCaseAgreement.CommissionContract AS CommissionContract,
  CommsnAdditionalCaseAgreement.CommsnContrEffctvFrmDateTime AS CommsnContrEffctvFrmDateTime,
  CommsnAdditionalCaseAgreement.CommsnContrEffctvToDateTime AS CommsnContrEffctvToDateTime,
  CommsnAdditionalCaseAgreement.CommissionContractAgreement AS CommissionContractAgreement,
  CommsnAdditionalCaseAgreement.CommsnContrAgreementRule AS CommsnContrAgreementRule,
  CommsnAdditionalCaseAgreement.CommsnAgrmtEffctvFrmDteTme AS CommsnAgrmtEffctvFrmDteTme,
  CommsnAdditionalCaseAgreement.CommsnAgrmtEffctvToDteTme AS CommsnAgrmtEffctvToDteTme,
  CommsnAdditionalCaseAgreement.CommissionContractCurrency AS CommissionContractCurrency,
  CommsnAdditionalCaseAgreement.CommsnAgrmtRmnrtnStrtDteTme AS CommsnAgrmtRmnrtnStrtDteTme,
  CommsnAdditionalCaseAgreement.CommsnAgrmtRmnrtnEndDteTime AS CommsnAgrmtRmnrtnEndDteTime,
  CommsnAdditionalCaseAgreement.CommissionTriggerCaseReason AS CommissionTriggerCaseReason,
  CommsnAdditionalCaseAgreement.CommissionProcessingTarget AS CommissionProcessingTarget,
  CommsnAdditionalCaseAgreement.CommissionContractVersion AS CommissionContractVersion,
  CommsnAdditionalCaseAgreement.CommsnContractAgreementVersion AS CommsnContractAgreementVersion,
  CommsnAdditionalCaseAgreement.CommsnContrChangeReason AS CommsnContrChangeReason,
  CommsnAdditionalCaseAgreement.CommissionVersionIsInvalid AS CommissionVersionIsInvalid
FROM I_CommsnAddlCaseAgrmtByTime AS CommsnAdditionalCaseAgreement
;

Learn More