A_CommsnContrCorrespncAgrmt

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

Correspondence agreement

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

Data Sources (1)

SourceAliasJoin Type
I_CmsnConCorrespncAgrmtByTime CorrespncAgreement from

Annotations (10)

NameValueLevelField
EndUserText.label Correspondence 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 CommsnContrCorrespncAgreement_Type view
ObjectModel.sapObjectNodeType.name CommsnContrCorrespncAgreement 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_CmsnConCorrespncAgrmtByTime CommissionApplication Commission Appl
KEY CommissionContract I_CmsnConCorrespncAgrmtByTime CommissionContract
KEY CommsnContrEffctvFrmDateTime I_CmsnConCorrespncAgrmtByTime CommsnContrEffctvFrmDateTime
KEY CommsnContrEffctvToDateTime I_CmsnConCorrespncAgrmtByTime CommsnContrEffctvToDateTime
KEY CommsnContractCorrespondence I_CmsnConCorrespncAgrmtByTime CommsnContractCorrespondence
CommsnAgrmtEffctvFrmDteTme I_CmsnConCorrespncAgrmtByTime CommsnAgrmtEffctvFrmDteTme
CommsnAgrmtEffctvToDteTme I_CmsnConCorrespncAgrmtByTime CommsnAgrmtEffctvToDteTme
CommissionContractVersion I_CmsnConCorrespncAgrmtByTime CommissionContractVersion
CommsnContractAgreementVersion I_CmsnConCorrespncAgrmtByTime CommsnContractAgreementVersion
CommsnContrCorrespondenceType I_CmsnConCorrespncAgrmtByTime CommsnContrCorrespondenceType
CommsnContrCorrespncRcpntRole I_CmsnConCorrespncAgrmtByTime CommsnContrCorrespncRcpntRole
CommsnContrCorrespncRcpnt I_CmsnConCorrespncAgrmtByTime CommsnContrCorrespncRcpnt
CAOriglPartIsNotRcvgCorrespnc I_CmsnConCorrespncAgrmtByTime CAOriglPartIsNotRcvgCorrespnc Alt./Add.Recip.
CommsnContrCorrespncActyKey I_CmsnConCorrespncAgrmtByTime CommsnContrCorrespncActyKey
CommissionVersionIsInvalid I_CmsnConCorrespncAgrmtByTime CommissionVersionIsInvalid
CommsnContrChangeReason I_CmsnConCorrespncAgrmtByTime 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_CommsnContrCorrespncAgrmt.
-- 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_CommsnContrCorrespncAgrmt AS
SELECT
  CorrespncAgreement.CommissionApplication AS CommissionApplication,
  CorrespncAgreement.CommissionContract AS CommissionContract,
  CorrespncAgreement.CommsnContrEffctvFrmDateTime AS CommsnContrEffctvFrmDateTime,
  CorrespncAgreement.CommsnContrEffctvToDateTime AS CommsnContrEffctvToDateTime,
  CorrespncAgreement.CommsnContractCorrespondence AS CommsnContractCorrespondence,
  CorrespncAgreement.CommsnAgrmtEffctvFrmDteTme AS CommsnAgrmtEffctvFrmDteTme,
  CorrespncAgreement.CommsnAgrmtEffctvToDteTme AS CommsnAgrmtEffctvToDteTme,
  CorrespncAgreement.CommissionContractVersion AS CommissionContractVersion,
  CorrespncAgreement.CommsnContractAgreementVersion AS CommsnContractAgreementVersion,
  CorrespncAgreement.CommsnContrCorrespondenceType AS CommsnContrCorrespondenceType,
  CorrespncAgreement.CommsnContrCorrespncRcpntRole AS CommsnContrCorrespncRcpntRole,
  CorrespncAgreement.CommsnContrCorrespncRcpnt AS CommsnContrCorrespncRcpnt,
  CorrespncAgreement.CAOriglPartIsNotRcvgCorrespnc AS CAOriglPartIsNotRcvgCorrespnc,
  CorrespncAgreement.CommsnContrCorrespncActyKey AS CommsnContrCorrespncActyKey,
  CorrespncAgreement.CommissionVersionIsInvalid AS CommissionVersionIsInvalid,
  CorrespncAgreement.CommsnContrChangeReason AS CommsnContrChangeReason
FROM I_CmsnConCorrespncAgrmtByTime AS CorrespncAgreement
;

Learn More