C_MfgWorkInstrnPlaceHolderTP

DDL: C_MFGWORKINSTRNPLACEHOLDERTP SQL: CEMBWIPHTP Type: view CONSUMPTION
39 Fields 1 Data Sources 2 Associations

Embedded WI: Placeholder/Variable

C_MfgWorkInstrnPlaceHolderTP is a Consumption CDS View that provides data about "Embedded WI: Placeholder/Variable" in SAP S/4HANA. It reads from 1 data source (I_MfgWorkInstrnPlaceHolderTP) and exposes 39 fields with key fields MfgWorkInstruction, MfgWorkInstructionVersCounter, MfgWorkInstructionPlaceHolder, Language, MfgWorkInstructionVariable. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgWorkInstrnPlaceHolderTP I_MfgWorkInstrnPlaceHolderTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_OpActyWorkInstructionTP _OpActyWorkinstructionTP $projection.MfgWorkInstruction = _OpActyWorkinstructionTP.MfgWorkInstruction and $projection.MfgWorkInstructionVersCounter = _OpActyWorkinstructionTP.MfgWorkInstructionVersCounter -- Variable Attribute Value Help
[0..*] C_MfgWrkInstrnVarblAttributeVH _MfgWrkInstrnVarblAttributeVH $projection.SelectedContextType = _MfgWrkInstrnVarblAttributeVH.MfgWrkInstrnVariableType

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CEMBWIPHTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.representativeKey MfgWorkInstructionPlaceHolder view
EndUserText.label Embedded WI: Placeholder/Variable view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY MfgWorkInstruction MfgWorkInstruction Work Instruction
KEY MfgWorkInstructionVersCounter MfgWorkInstructionVersCounter Version No.
KEY MfgWorkInstructionPlaceHolder MfgWorkInstructionPlaceHolder
KEY Language Language Report Text Language
KEY MfgWorkInstructionVariable MfgWorkInstructionVariable Variable
KEY ProdnRtgVersBOMInternalID ProdnRtgVersBOMInternalID Allocation no.
SelectedContextType SelectedContextType Var TYpe
SelectedContextName SelectedContextName
MfgWrkInstrnPlaceHolderIsRef MfgWrkInstrnPlaceHolderIsRef
MfgWrkInstrnPlaceHolderIsLink MfgWrkInstrnPlaceHolderIsLink
WorkInstrnPlaceHolderIsInptFld WorkInstrnPlaceHolderIsInptFld
MfgWrkInstrnPlchldrInptLblType MfgWrkInstrnPlchldrInptLblType
MfgWrkInstrnPlchldrCollIntID MfgWrkInstrnPlchldrCollIntID
MfgWrkInstrnPlchldrVsblColsStr MfgWrkInstrnPlchldrVsblColsStr
InspectionCharacteristicNmbr InspectionCharacteristicNmbr Characteristic
BOOCharcGroup BOOCharcGroup Characteristic Group
ProdnRsceToolCounter ProdnRsceToolCounter PRT Item Count.
BOOOpBOMItemInternalID BOOOpBOMItemInternalID Allocation no.
LogicalComponent LogicalComponent Logical Component
ProdMfgInfoCameraInternalID ProdMfgInfoCameraInternalID
OriglDgtlMockUpCharcsUUID OriglDgtlMockUpCharcsUUID DMU GUID
ProdMfgInfoItemValueUUID ProdMfgInfoItemValueUUID
BillOfMaterialItemUnit BillOfMaterialItemUnit Component UoM
Material Material Vehicle Model
DocumentType DocumentType Order Type
DocumentInfoRecord DocumentInfoRecord Document
DocumentVersion DocumentVersion Docu. Version
DocumentPart DocumentPart Document Part
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterial BillOfMaterial BOM
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion BillOfMaterialVersion BOM Version
InheritedNodeNumberForBOMItem InheritedNodeNumberForBOMItem Nodes
_WorkInstructionInternalId _WorkInstructionInternalId
_MfgWrkInstrnVarblAttribute _MfgWrkInstrnVarblAttribute
_MaterialComponent _MaterialComponent
_Material _Material
_Unit _Unit
DraftComposition_OpActyWorkinstructionTP

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 C_MfgWorkInstrnPlaceHolderTP.
-- 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: CEMBWIPHTP

CREATE VIEW C_MfgWorkInstrnPlaceHolderTP AS
SELECT
  MfgWorkInstruction,
  MfgWorkInstructionVersCounter,
  MfgWorkInstructionPlaceHolder,
  Language,
  MfgWorkInstructionVariable,
  ProdnRtgVersBOMInternalID,
  SelectedContextType,
  SelectedContextName,
  MfgWrkInstrnPlaceHolderIsRef,
  MfgWrkInstrnPlaceHolderIsLink,
  WorkInstrnPlaceHolderIsInptFld,
  MfgWrkInstrnPlchldrInptLblType,
  MfgWrkInstrnPlchldrCollIntID,
  MfgWrkInstrnPlchldrVsblColsStr,
  InspectionCharacteristicNmbr,
  BOOCharcGroup,
  ProdnRsceToolCounter,
  BOOOpBOMItemInternalID,
  LogicalComponent,
  ProdMfgInfoCameraInternalID,
  OriglDgtlMockUpCharcsUUID,
  ProdMfgInfoItemValueUUID,
  BillOfMaterialItemUnit,
  Material,
  DocumentType,
  DocumentInfoRecord,
  DocumentVersion,
  DocumentPart,
  BillOfMaterialCategory,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  InheritedNodeNumberForBOMItem
FROM I_MfgWorkInstrnPlaceHolderTP
LEFT OUTER JOIN C_OpActyWorkInstructionTP AS _OpActyWorkinstructionTP ON MfgWorkInstruction = _OpActyWorkinstructionTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _OpActyWorkinstructionTP.MfgWorkInstructionVersCounter  -- association [1..1]
LEFT OUTER JOIN C_MfgWrkInstrnVarblAttributeVH AS _MfgWrkInstrnVarblAttributeVH ON SelectedContextType = _MfgWrkInstrnVarblAttributeVH.MfgWrkInstrnVariableType  -- association [0..*]
;

Learn More