I_MfgWorkInstructionVersionTP

DDL: I_MFGWORKINSTRUCTIONVERSIONTP SQL: IMFGWIVERSIONTP Type: view TRANSACTIONAL
13 Fields 1 Data Sources 1 Associations

Work Instruction Version Transactional View

I_MfgWorkInstructionVersionTP is a Transactional CDS View that provides data about "Work Instruction Version Transactional View" in SAP S/4HANA. It reads from 1 data source (I_MfgWorkInstructionVersion) and exposes 13 fields with key fields MfgWorkInstruction, MfgWorkInstructionVersCounter, Language. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgWorkInstructionVersion Draft from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_MfgWorkInstructionTP _WorkInstruction $projection.MfgWorkInstruction = _WorkInstruction.MfgWorkInstruction and $projection.MfgWorkInstructionVersCounter = _WorkInstruction.MfgWorkInstructionVersCounter

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IMFGWIVERSIONTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Work Instruction Version Transactional View view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.writeDraftPersistence MPE_WI_VERSION_D view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MfgWorkInstruction I_MfgWorkInstructionVersion MfgWorkInstruction Work Instruction
KEY MfgWorkInstructionVersCounter I_MfgWorkInstructionVersion MfgWorkInstructionVersCounter Version No.
KEY Language I_MfgWorkInstructionVersion Language Report Text Language
MfgWorkInstructionContentUUID I_MfgWorkInstructionVersion MfgWorkInstructionContentUUID Content UUID
MfgWorkInstructionForEdit I_MfgWorkInstructionVersion MfgWorkInstructionForEdit WorkItem ID
IsDeleted
CreationTime I_MfgWorkInstructionVersion CreationTime Time of Change
CreationUserName I_MfgWorkInstructionVersion CreationUserName User Name
LastChangeDateTime I_MfgWorkInstructionVersion LastChangeDateTime Timestamp
LastChangedByUser I_MfgWorkInstructionVersion LastChangedByUser User Name
MfgWorkInstructionContent I_MfgWorkInstructionVersion MfgWorkInstructionContent Content
MfgWorkInstructionVersStatus I_MfgWorkInstructionVersion MfgWorkInstructionVersStatus WI Status
_WorkInstruction _WorkInstruction

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_MfgWorkInstructionVersionTP.
-- 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: IMFGWIVERSIONTP

CREATE VIEW I_MfgWorkInstructionVersionTP AS
SELECT
  Draft.MfgWorkInstruction AS MfgWorkInstruction,
  Draft.MfgWorkInstructionVersCounter AS MfgWorkInstructionVersCounter,
  Draft.Language AS Language,
  Draft.MfgWorkInstructionContentUUID AS MfgWorkInstructionContentUUID,
  Draft.MfgWorkInstructionForEdit AS MfgWorkInstructionForEdit,
  cast(' ' as lkenz preserving type) AS IsDeleted,
  Draft.CreationTime AS CreationTime,
  Draft.CreationUserName AS CreationUserName,
  Draft.LastChangeDateTime AS LastChangeDateTime,
  Draft.LastChangedByUser AS LastChangedByUser,
  Draft.MfgWorkInstructionContent AS MfgWorkInstructionContent,
  Draft.MfgWorkInstructionVersStatus AS MfgWorkInstructionVersStatus
FROM I_MfgWorkInstructionVersion AS Draft
LEFT OUTER JOIN I_MfgWorkInstructionTP AS _WorkInstruction ON MfgWorkInstruction = _WorkInstruction.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _WorkInstruction.MfgWorkInstructionVersCounter  -- association [1..1]
;

Learn More