SHSM_PNWTYH

DDL: SHSM_PNWTYH SQL: WTYFR_CLMNO Type: view
48 Fields 1 Data Sources

CDS view for search help WTY_F4_CLMNO

SHSM_PNWTYH is a CDS View that provides data about "CDS view for search help WTY_F4_CLMNO" in SAP S/4HANA. It reads from 1 data source (pnwtyh) and exposes 48 fields with key fields mandt, pnguid, pncnt.

Data Sources (1)

SourceAliasJoin Type
pnwtyh pnwtyh from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName WTYFR_CLMNO view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label CDS view for search help WTY_F4_CLMNO view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY mandt mandt Editing Client
KEY pnguid pnguid Line Network GUID
KEY pncnt pncnt Counter
pntxcnt pntxcnt Counter
clmno clmno Claim
clmty clmty WtyClmType
refdt refdt Reference Date
refno refno Reference No.
oldcn oldcn Preceding Claim
autno autno Authorization
autna autna Authorizer
clerk clerk Person Respons.
relty relty Object type
relob_ext relob_ext Ext. Obj. No.
relob relob Int. Obj. No.
relot relot Object Group
reldt reldt Repl. Lead Time
parnr parnr Responsible
parvw parvw Task Processor
objnr objnr Val. Obj. No.
astate astate Processing Status
werks werks Receiving Plant
qmnum qmnum Notification
log_handle log_handle Migration Log Handle
log_message log_message Message After Compl.
clmgrp clmgrp Claim Group
relty2 relty2 Object type
relob_ext2 relob_ext2 Ext. Obj. No.
relob2 relob2 Int. Obj. No.
serno serno Serial Number
serno2 serno2 Serial Number
cbactiondt cbactiondt RecallValidTo
or_dummy or_dummy Dummy
close_date close_date Completion Date
archiv_flag archiv_flag Archiving
h_dummy h_dummy Dummy function in length 1
ctr_mode ctr_mode Processing Mode
new_header new_header New Status
manual manual Manually
closed closed Period closed
timstmp timstmp Time Stamp
creadat creadat Created On
creaby creaby User ID
chngdat chngdat Changed on
chngby chngby User ID
h_pntext h_pntext Info. Clm Head.
logsys logsys Source system
creatime creatime Creation Time

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 SHSM_PNWTYH.
-- 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: WTYFR_CLMNO

CREATE VIEW SHSM_PNWTYH AS
SELECT
  mandt,
  pnguid,
  pncnt,
  pntxcnt,
  clmno,
  clmty,
  refdt,
  refno,
  oldcn,
  autno,
  autna,
  clerk,
  relty,
  relob_ext,
  relob,
  relot,
  reldt,
  parnr,
  parvw,
  objnr,
  astate,
  werks,
  qmnum,
  log_handle,
  log_message,
  clmgrp,
  relty2,
  relob_ext2,
  relob2,
  serno,
  serno2,
  cbactiondt,
  or_dummy,
  close_date,
  archiv_flag,
  h_dummy,
  ctr_mode,
  new_header,
  manual,
  closed,
  timstmp,
  creadat,
  creaby,
  chngdat,
  chngby,
  h_pntext,
  logsys,
  creatime
FROM pnwtyh
;

Learn More