SHSM_M_ERDKC

DDL: SHSM_M_ERDKC SQL: SHSMMERDKC Type: view

Invoicing Document by FI/CA Document Number Search Help

SHSM_M_ERDKC is a CDS View that provides data about "Invoicing Document by FI/CA Document Number Search Help" in SAP S/4HANA. It reads from 2 data sources (erdb, erdk) and exposes 11 fields. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
erdb erdb inner
erdk erdk from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_BusinessPartner _BusinessPartner $projection.partner = _BusinessPartner.BusinessPartner

Annotations (10)

NameValueLevelField
EndUserText.label Invoicing Document by FI/CA Document Number Search Help view
AbapCatalog.sqlViewName SHSMMERDKC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
opbel erdb opbel Reopen
ficadoc erdb invopbel Print Doc. No.
partner erdk partner With Partner
vkont erdk vkont Tech. CtrAcct
budat erdk budat Posting Date
exbel erdk exbel Offic. Doc. No.
stokz erdk stokz Reversed
ergrd erdk ergrd Creation reason
doc_id erdb doc_id Reference Doc Number
begru erdk begru AuthorizGroup
_BusinessPartner _BusinessPartner

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_M_ERDKC.
-- 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: SHSMMERDKC

CREATE VIEW SHSM_M_ERDKC AS
SELECT
  erdb.opbel AS opbel,
  erdb.invopbel AS ficadoc,
  erdk.partner AS partner,
  erdk.vkont AS vkont,
  erdk.budat AS budat,
  erdk.exbel AS exbel,
  erdk.stokz AS stokz,
  erdk.ergrd AS ergrd,
  erdb.doc_id AS doc_id,
  erdk.begru AS begru
FROM erdk
INNER JOIN erdb ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON partner = _BusinessPartner.BusinessPartner  -- association [1..1]
;