I_MfgStandardTextTP_1

DDL: I_MFGSTANDARDTEXTTP_1 Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources

Manufacturing Standard header - TP

I_MfgStandardTextTP_1 is a Transactional CDS View that provides data about "Manufacturing Standard header - TP" in SAP S/4HANA. It reads from 1 data source (R_MfgStandardTextTP) and exposes 11 fields with key field MfgStandardText.

Data Sources (1)

SourceAliasJoin Type
R_MfgStandardTextTP R_MfgStandardTextTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Manufacturing Standard header - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey MfgStandardText view
Metadata.ignorePropagatedAnnotations true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY MfgStandardText MfgStandardText
MfgStandardTextCategoryUUID MfgStandardTextCategoryUUID
MfgStandardTextCategory MfgStandardTextCategory
MfgStandardTextUsageType MfgStandardTextUsageType
MfgStandardTextReferenceType MfgStandardTextReferenceType
Plant Plant Valuation Area
MfgStandardTextStatus MfgStandardTextStatus
CreationDateDecimalValue CreationDateDecimalValue Created At
CreationUserName CreationUserName User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name

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_MfgStandardTextTP_1.
-- 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 I_MfgStandardTextTP_1 AS
SELECT
  MfgStandardText,
  MfgStandardTextCategoryUUID,
  MfgStandardTextCategory,
  MfgStandardTextUsageType,
  MfgStandardTextReferenceType,
  Plant,
  MfgStandardTextStatus,
  CreationDateDecimalValue,
  CreationUserName,
  LastChangeDateTime,
  LastChangedByUser
FROM R_MfgStandardTextTP
;

Learn More