SHSM_I_EDISCDOCISUACCountVH

DDL: SHSM_I_EDISCDOCISUACCOUNTVH SQL: SHIEDISCDOCACVH Type: view

CDS SH for Disc. Doc. with Ref. Obj. Cont Acct VH

SHSM_I_EDISCDOCISUACCountVH is a CDS View that provides data about "CDS SH for Disc. Doc. with Ref. Obj. Cont Acct VH" in SAP S/4HANA. It reads from 3 data sources (fkkvk, fkkvkp, SHSM_I_EDISCDOCISUACCOUNT) and exposes 9 fields.

Data Sources (3)

SourceAliasJoin Type
fkkvk fkkvk left_outer
fkkvkp fkkvkp left_outer
SHSM_I_EDISCDOCISUACCOUNT SHSM_I_EDISCDOCISUACCOUNT from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHIEDISCDOCACVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #VALUE_HELP view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label CDS SH for Disc. Doc. with Ref. Obj. Cont Acct VH view

Fields (9)

KeyFieldSource TableSource FieldDescription
discno discno Disconnect.doc.
discreason discreason Discon. reason
status status Workflow Status
refobjtype refobjtype Ref. obj. type
refobjkey refobjkey Refer. obj. key
vkont fkkvk vkont Tech. CtrAcct
BusinessPartner fkkvkp gpart Tech. BPartner
CAAuthorizationGroup fkkvkp begru AuthorizGroup
ContractAccountCategory fkkvk vktyp Date type

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_I_EDISCDOCISUACCountVH.
-- 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: SHIEDISCDOCACVH

CREATE VIEW SHSM_I_EDISCDOCISUACCountVH AS
SELECT
  discno,
  discreason,
  status,
  refobjtype,
  refobjkey,
  fkkvk.vkont AS vkont,
  fkkvkp.gpart AS BusinessPartner,
  fkkvkp.begru AS CAAuthorizationGroup,
  fkkvk.vktyp AS ContractAccountCategory
FROM SHSM_I_EDISCDOCISUACCOUNT
LEFT OUTER JOIN fkkvk ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN fkkvkp ON /* join condition not captured in parsed metadata */
;