C_SEPAMandateCAVH

DDL: C_SEPAMANDATECAVH SQL: CSEPACAVH Type: view CONSUMPTION
16 Fields 1 Data Sources 2 Associations

Contract Accounting SEPA Mandate

C_SEPAMandateCAVH is a Consumption CDS View that provides data about "Contract Accounting SEPA Mandate" in SAP S/4HANA. It reads from 1 data source (I_SEPAMandate) and exposes 16 fields with key field SEPAMandateUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SEPAMandate I_SEPAMandate from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_User _CreatedByUser $projection.SEPAMandateCreatedByUser = _CreatedByUser.UserID
[1..1] I_SEPAMandateStatus _SEPAMandateStatus $projection.SEPAMandateStatus = _SEPAMandateStatus.SEPAMandateStatus

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CSEPACAVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
EndUserText.label Contract Accounting SEPA Mandate view
Search.searchable true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SEPAMandateUUID SEPAMandateUUID Mandate ID
SEPAMandate SEPAMandate SEPA Mandate
SEPAMandateApplication SEPAMandateApplication Application
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
SEPAMandateCreatedByUser User Name
CreatedByUserDescription _CreatedByUser UserDescription Full Name
SEPAMandateCreationDate SEPAMandateCreationDate Entered On
BusinessPartner ID of Sender
SEPAMandateStatus SEPAMandateStatus Workflow Status
SEPAMandateStatusName
SEPAMandateIsLocked SEPAMandateIsLocked Global Lock
SEPAMandateRecipient SEPAMandateRecipient Record ID
SEPAMandateSenderType SEPAMandateSenderType SND/RCV type
_CreatedByUser _CreatedByUser
_SEPAMandateStatus _SEPAMandateStatus

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 C_SEPAMandateCAVH.
-- 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.
-- SQL view name: CSEPACAVH

CREATE VIEW C_SEPAMandateCAVH AS
SELECT
  SEPAMandateUUID,
  SEPAMandate,
  SEPAMandateApplication,
  ValidityStartDate,
  ValidityEndDate,
  cast(SEPAMandateCreatedByUser as sepa_cds_ernam preserving type) AS SEPAMandateCreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  SEPAMandateCreationDate,
  cast( SEPAMandateSender as bu_partner) AS BusinessPartner,
  SEPAMandateStatus,
  _SEPAMandateStatus._Text[1:Language =$session.system_language].SEPAMandateStatusName AS SEPAMandateStatusName,
  SEPAMandateIsLocked,
  SEPAMandateRecipient,
  SEPAMandateSenderType
FROM I_SEPAMandate
LEFT OUTER JOIN I_User AS _CreatedByUser ON SEPAMandateCreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_SEPAMandateStatus AS _SEPAMandateStatus ON SEPAMandateStatus = _SEPAMandateStatus.SEPAMandateStatus  -- association [1..1]
;

Learn More