I_MfgWorkInstructionStdTextRef

DDL: I_MFGWORKINSTRUCTIONSTDTEXTREF SQL: IMFGWISTREF Type: view BASIC Package: MPE_WI
5 Fields 1 Data Sources

Standard Text Reference View

I_MfgWorkInstructionStdTextRef is a Basic CDS View that provides data about "Standard Text Reference View" in SAP S/4HANA. It reads from 1 data source (mpe_wi_st_ref) and exposes 5 fields with key fields MfgWorkInstruction, MfgWorkInstructionVersCounter, MfgStandardText, MfgStandardTextVersion, Language. Part of development package MPE_WI.

Data Sources (1)

SourceAliasJoin Type
mpe_wi_st_ref mpe_wi_st_ref from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMFGWISTREF view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Standard Text Reference View view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MfgWorkInstruction mpe_wi_st_ref wi_id WorkItem ID
KEY MfgWorkInstructionVersCounter mpe_wi_st_ref wi_version_no Version No.
KEY MfgStandardText mpe_wi_st_ref textid UUID
KEY MfgStandardTextVersion mpe_wi_st_ref versionid Version
KEY Language mpe_wi_st_ref spras Off. Language

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 I_MfgWorkInstructionStdTextRef.
-- 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: IMFGWISTREF

CREATE VIEW I_MfgWorkInstructionStdTextRef AS
SELECT
  mpe_wi_st_ref.wi_id AS MfgWorkInstruction,
  mpe_wi_st_ref.wi_version_no AS MfgWorkInstructionVersCounter,
  mpe_wi_st_ref.textid AS MfgStandardText,
  mpe_wi_st_ref.versionid AS MfgStandardTextVersion,
  mpe_wi_st_ref.spras AS Language
FROM mpe_wi_st_ref
;

Learn More