A_CommsnContrPaytRelAgreement

DDL: A_COMMSNCONTRPAYTRELAGREEMENT Type: view_entity CONSUMPTION Package: CACSVDM_CONTRACT
17 Fields 1 Data Sources 1 OData Services

Payment release agreement

A_CommsnContrPaytRelAgreement is a Consumption CDS View that provides data about "Payment release agreement" in SAP S/4HANA. It reads from 1 data source (I_CommsnContrPaytRelAgrmtByTme) and exposes 17 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_CommsnContrPaytRelAgrmtByTme PaymentReleaseAgreement from

Annotations (10)

NameValueLevelField
EndUserText.label Payment release 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 CommsnContrPaytRelAgreement view
OData.entityType.name CommsnContrPaytRelAgreement_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 (17)

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

Learn More