SHSM_E_EABP_M

DDL: SHSM_E_EABP_M SQL: SHSMEEABPM Type: view
10 Fields 1 Data Sources 1 Associations

Budget Billing Plan Search Help

SHSM_E_EABP_M is a CDS View that provides data about "Budget Billing Plan Search Help" in SAP S/4HANA. It reads from 1 data source (eabp) and exposes 10 fields. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
eabp eabp from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_UtilitiesContract _UtilitiesContract $projection.vertrag = _UtilitiesContract.UtilitiesContract

Annotations (10)

NameValueLevelField
EndUserText.label Budget Billing Plan Search Help view
AbapCatalog.sqlViewName SHSMEEABPM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
opbel eabp opbel Reopen
vertrag eabp vertrag PoD service
gpart eabp gpart Tech. BPartner
vkonto eabp vkonto Contract Acct
begperiode eabp begperiode Start BB period
endperiode eabp endperiode End BB period
deaktiv eabp deaktiv Deactivated
sammelnr eabp sammelnr Coll. Bill Acct
kzabsver eabp kzabsver BB Procedure
_UtilitiesContract _UtilitiesContract

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_E_EABP_M.
-- 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: SHSMEEABPM

CREATE VIEW SHSM_E_EABP_M AS
SELECT
  eabp.opbel AS opbel,
  eabp.vertrag AS vertrag,
  eabp.gpart AS gpart,
  eabp.vkonto AS vkonto,
  eabp.begperiode AS begperiode,
  eabp.endperiode AS endperiode,
  eabp.deaktiv AS deaktiv,
  eabp.sammelnr AS sammelnr,
  eabp.kzabsver AS kzabsver
FROM eabp
LEFT OUTER JOIN I_UtilitiesContract AS _UtilitiesContract ON vertrag = _UtilitiesContract.UtilitiesContract  -- association [1..1]
;

Learn More