A_CommsnSchedulingAgreement

DDL: A_COMMSNSCHEDULINGAGREEMENT Type: view_entity CONSUMPTION Package: CACSVDM_CONTRACT
16 Fields 1 Data Sources 1 OData Services

Settlement scheduling agreement

A_CommsnSchedulingAgreement is a Consumption CDS View that provides data about "Settlement scheduling agreement" in SAP S/4HANA. It reads from 1 data source (I_CommsnSchedgAgreementByTime) and exposes 16 fields with key fields CommissionApplication, CommissionContract, CommsnContrEffctvFrmDateTime, CommsnContrEffctvToDateTime, CommissionContractAgreement. It is exposed through 1 OData service (API_COMMISSIONCONTRACT). Part of development package CACSVDM_CONTRACT.

Data Sources (1)

SourceAliasJoin Type
I_CommsnSchedgAgreementByTime Agreement from

Annotations (10)

NameValueLevelField
EndUserText.label Settlement scheduling agreement view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.sapObjectNodeType.name CommissionSchedulingAgreement view
OData.entityType.name CommissionSchedulingAgreement_Type view
VDM.viewType #CONSUMPTION 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 (16)

KeyFieldSource TableSource FieldDescription
KEY CommissionApplication I_CommsnSchedgAgreementByTime CommissionApplication Commission Appl
KEY CommissionContract I_CommsnSchedgAgreementByTime CommissionContract
KEY CommsnContrEffctvFrmDateTime I_CommsnSchedgAgreementByTime CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime I_CommsnSchedgAgreementByTime CommsnContrEffctvToDateTime
KEY CommissionContractAgreement I_CommsnSchedgAgreementByTime CommissionContractAgreement
CommsnAgrmtEffctvFrmDteTme I_CommsnSchedgAgreementByTime CommsnAgrmtEffctvFrmDteTme
CommsnAgrmtEffctvToDteTme I_CommsnSchedgAgreementByTime CommsnAgrmtEffctvToDteTme
CommsnContrAgreementRule I_CommsnSchedgAgreementByTime CommsnContrAgreementRule
CommsnContrAgrmtPriorityValue I_CommsnSchedgAgreementByTime CommsnContrAgrmtPriorityValue
CommsnAgrmtRmnrtnStrtDteTme I_CommsnSchedgAgreementByTime CommsnAgrmtRmnrtnStrtDteTme
CommsnAgrmtRmnrtnEndDteTime I_CommsnSchedgAgreementByTime CommsnAgrmtRmnrtnEndDteTime
CommissionContractVersion I_CommsnSchedgAgreementByTime CommissionContractVersion
CommsnContractAgreementVersion I_CommsnSchedgAgreementByTime CommsnContractAgreementVersion
CommissionVersionIsInvalid I_CommsnSchedgAgreementByTime CommissionVersionIsInvalid
CommsnContrChangeReason I_CommsnSchedgAgreementByTime 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_CommsnSchedulingAgreement.
-- 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_CommsnSchedulingAgreement AS
SELECT
  Agreement.CommissionApplication AS CommissionApplication,
  Agreement.CommissionContract AS CommissionContract,
  Agreement.CommsnContrEffctvFrmDateTime AS CommsnContrEffctvFrmDateTime,
  Agreement.CommsnContrEffctvToDateTime AS CommsnContrEffctvToDateTime,
  Agreement.CommissionContractAgreement AS CommissionContractAgreement,
  Agreement.CommsnAgrmtEffctvFrmDteTme AS CommsnAgrmtEffctvFrmDteTme,
  Agreement.CommsnAgrmtEffctvToDteTme AS CommsnAgrmtEffctvToDteTme,
  Agreement.CommsnContrAgreementRule AS CommsnContrAgreementRule,
  Agreement.CommsnContrAgrmtPriorityValue AS CommsnContrAgrmtPriorityValue,
  Agreement.CommsnAgrmtRmnrtnStrtDteTme AS CommsnAgrmtRmnrtnStrtDteTme,
  Agreement.CommsnAgrmtRmnrtnEndDteTime AS CommsnAgrmtRmnrtnEndDteTime,
  Agreement.CommissionContractVersion AS CommissionContractVersion,
  Agreement.CommsnContractAgreementVersion AS CommsnContractAgreementVersion,
  Agreement.CommissionVersionIsInvalid AS CommissionVersionIsInvalid,
  Agreement.CommsnContrChangeReason AS CommsnContrChangeReason
FROM I_CommsnSchedgAgreementByTime AS Agreement
;

Learn More