R_MfgStandardTextVersionLangTP

DDL: R_MFGSTANDARDTEXTVERSIONLANGTP Type: view_entity TRANSACTIONAL
13 Fields 1 Data Sources 1 Associations

Manufacturing Standard Text Version Lang

R_MfgStandardTextVersionLangTP is a Transactional CDS View that provides data about "Manufacturing Standard Text Version Lang" in SAP S/4HANA. It reads from 1 data source (I_MfgStandardTextVersion) and exposes 13 fields with key fields MfgStandardText, MfgStandardTextVersion, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgStandardTextVersion I_MfgStandardTextVersion from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_MfgStandardTextTP _StandardText $projection.MfgStandardText = _StandardText.MfgStandardText

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Manufacturing Standard Text Version Lang view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey Language view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MfgStandardText MfgStandardText UUID
KEY MfgStandardTextVersion MfgStandardTextVersion Version
KEY Language Language Report Text Language
MfgStandardTextContentUUID MfgStandardTextContentUUID Content UUID
MfgStandardTextContent MfgStandardTextContent Trusted Site Content
Plant Plant Valuation Area
MfgStandardTextCategory MfgStandardTextCategory Category
CreationDateDecimalValue CreationTime Time of Change
CreationUserName CreationUserName User Name
LocalLastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_Version _Version
_StandardText _StandardText

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 R_MfgStandardTextVersionLangTP.
-- 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.

CREATE VIEW R_MfgStandardTextVersionLangTP AS
SELECT
  MfgStandardText,
  MfgStandardTextVersion,
  Language,
  MfgStandardTextContentUUID,
  MfgStandardTextContent,
  Plant,
  MfgStandardTextCategory,
  CreationTime AS CreationDateDecimalValue,
  CreationUserName,
  LastChangeDateTime AS LocalLastChangeDateTime,
  LastChangedByUser
FROM I_MfgStandardTextVersion
LEFT OUTER JOIN R_MfgStandardTextTP AS _StandardText ON MfgStandardText = _StandardText.MfgStandardText  -- association [1..1]
;

Learn More