I_ACMSettlementReasonCode

DDL: I_ACMSETTLEMENTREASONCODE SQL: IACMSTLRCNTR Type: view BASIC
6 Fields 1 Data Sources

ACM Settlement Reason Code

I_ACMSettlementReasonCode is a Basic CDS View that provides data about "ACM Settlement Reason Code" in SAP S/4HANA. It reads from 1 data source (/accgo/t_stlrctr) and exposes 6 fields with key fields SettlementDocHeaderUUID, ACMSettlementSequenceNmbr, ACMSettlementReasonType, ACMSettlementReasonCode.

Data Sources (1)

SourceAliasJoin Type
/accgo/t_stlrctr /accgo/t_stlrctr from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IACMSTLRCNTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label ACM Settlement Reason Code view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY SettlementDocHeaderUUID stl_header_guid STL Hdr GUID
KEY ACMSettlementSequenceNmbr sequence Visit Sequence
KEY ACMSettlementReasonType reason_type Reason Type
KEY ACMSettlementReasonCode reason_code Return/Change Reason
ACMSettlementCreatedBy created_by Version Created By
clientNULLasSettlementCreatedOn

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 I_ACMSettlementReasonCode.
-- 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: IACMSTLRCNTR

CREATE VIEW I_ACMSettlementReasonCode AS
SELECT
  stl_header_guid AS SettlementDocHeaderUUID,
  sequence AS ACMSettlementSequenceNmbr,
  reason_type AS ACMSettlementReasonType,
  reason_code AS ACMSettlementReasonCode,
  created_by AS ACMSettlementCreatedBy,
  tstmp_to_dats( created_on, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as SettlementCreatedOn AS clientNULLasSettlementCreatedOn
FROM /accgo/t_stlrctr
;

Learn More