I_AddressRemark

DDL: I_ADDRESSREMARK Type: view_entity Package: S_ADDRESS_VDM
6 Fields 2 Data Sources

Address Texts

I_AddressRemark is a CDS View that provides data about "Address Texts" in SAP S/4HANA. It reads from 2 data sources (adcp, adrp) and exposes 6 fields with key fields AddressID, AddressPersonID, AddressRepresentationCode, Language. Part of development package S_ADDRESS_VDM.

Data Sources (2)

SourceAliasJoin Type
adcp adcp left_outer
adrp adrp left_outer

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Address Texts view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY AddressID adrct addrnumber Address Number
KEY AddressPersonID adrp persnumber Person Number
KEY AddressRepresentationCode adrct nation Country/Region
KEY Language adrct langu Primary lang.
PersonID
AddressRemarkText adrct remark Status Description

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_AddressRemark.
-- 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 I_AddressRemark AS
SELECT
  adrct.addrnumber AS AddressID,
  adrp.persnumber AS AddressPersonID,
  adrct.nation AS AddressRepresentationCode,
  adrct.langu AS Language,
  cast(' ' as ad_persnum ) AS PersonID,
  adrct.remark AS AddressRemarkText
LEFT OUTER JOIN adcp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN adrp ON /* join condition not captured in parsed metadata */
;

Learn More