FNDEI__SHCM_PA3406_BLOCKINGINF

DDL: FNDEI__SHCM_PA3406_BLOCKINGINF SQL: FNDEIBSHCMPA3406 Type: view
8 Fields 1 Data Sources

Blocker View for table /SHCM/PA3406

FNDEI__SHCM_PA3406_BLOCKINGINF is a CDS View that provides data about "Blocker View for table /SHCM/PA3406" in SAP S/4HANA. It reads from 1 data source (/shcm/pa3406) and exposes 8 fields with key fields mandt, pernr, subty, objps, sprps.

Data Sources (1)

SourceAliasJoin Type
/shcm/pa3406 /shcm/pa3406 from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName FNDEIBSHCMPA3406 view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Blocker View for table /SHCM/PA3406 view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY mandt /shcm/pa3406 mandt Editing Client
KEY pernr /shcm/pa3406 pernr Personnel no.
KEY subty /shcm/pa3406 subty Subtype
KEY objps /shcm/pa3406 objps Object ID
KEY sprps /shcm/pa3406 sprps Single-Character Flag
KEY endda /shcm/pa3406 endda Valid To
KEY begda /shcm/pa3406 begda Valid From
KEY seqnr /shcm/pa3406 seqnr Tank ID

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 FNDEI__SHCM_PA3406_BLOCKINGINF.
-- 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: FNDEIBSHCMPA3406

CREATE VIEW FNDEI__SHCM_PA3406_BLOCKINGINF AS
SELECT
  /shcm/pa3406.mandt AS mandt,
  /shcm/pa3406.pernr AS pernr,
  /shcm/pa3406.subty AS subty,
  /shcm/pa3406.objps AS objps,
  /shcm/pa3406.sprps AS sprps,
  /shcm/pa3406.endda AS endda,
  /shcm/pa3406.begda AS begda,
  /shcm/pa3406.seqnr AS seqnr
FROM /shcm/pa3406
;

Learn More