C_MfgWorkInstrnBOMAssgmtTP

DDL: C_MFGWORKINSTRNBOMASSGMTTP SQL: CMBWIBOMASSTP Type: view CONSUMPTION
20 Fields 1 Data Sources 1 Associations

Embedded WI: Assigned MBOMs

C_MfgWorkInstrnBOMAssgmtTP is a Consumption CDS View that provides data about "Embedded WI: Assigned MBOMs" in SAP S/4HANA. It reads from 1 data source (I_MfgWorkInstrnBOMAssgmtTP) and exposes 20 fields with key fields MfgWorkInstruction, MfgWorkInstructionVersCounter, BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgWorkInstrnBOMAssgmtTP I_MfgWorkInstrnBOMAssgmtTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_OpActyWorkInstructionTP _OpActyWorkinstructionTP $projection.MfgWorkInstruction = _OpActyWorkinstructionTP.MfgWorkInstruction and $projection.MfgWorkInstructionVersCounter = _OpActyWorkinstructionTP.MfgWorkInstructionVersCounter

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CMBWIBOMASSTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.personalData.blocking #REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled false view
ObjectModel.updateEnabled true view
ObjectModel.representativeKey ProdnRtgVersBOMInternalID view
EndUserText.label Embedded WI: Assigned MBOMs view
AccessControl.authorizationCheck #CHECK view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MfgWorkInstruction MfgWorkInstruction Work Instruction
KEY MfgWorkInstructionVersCounter MfgWorkInstructionVersCounter Version No.
KEY BillOfOperationsType BillOfOperationsType Task List Type
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
KEY BillOfOperationsVersion BillOfOperationsVersion Routing Version
KEY ProdnRtgVersBOMInternalID ProdnRtgVersBOMInternalID Allocation no.
BillOfOperations BillOfOperationsGroup Group
BillOfMaterial BillOfMaterial BOM
BillOfMaterialVariant BillOfMaterialVariant AlternativeBOM
BillOfMaterialVersion BillOfMaterialVersion BOM Version
BillOfMaterialCategory BillOfMaterialCategory BOM category
BillOfMaterialVariantUsage BillOfMaterialVariantUsage Usage
BillOfMaterialHeaderUUID BillOfMaterialHeaderUUID Guid
PhysicalDocument PhysicalDocument Phys. Document
_OpActyWorkinstructionTP _OpActyWorkinstructionTP
_BillOfOperationsType _BillOfOperationsType
_BillOfOperationsVersion _BillOfOperationsVersion
_BOMVersion _BOMVersion
_BillOfOperations _BillOfOperations

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_MfgWorkInstrnBOMAssgmtTP.
-- 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: CMBWIBOMASSTP

CREATE VIEW C_MfgWorkInstrnBOMAssgmtTP AS
SELECT
  MfgWorkInstruction,
  MfgWorkInstructionVersCounter,
  BillOfOperationsType,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsVersion,
  ProdnRtgVersBOMInternalID,
  BillOfOperationsGroup AS BillOfOperations,
  BillOfMaterial,
  BillOfMaterialVariant,
  BillOfMaterialVersion,
  BillOfMaterialCategory,
  BillOfMaterialVariantUsage,
  BillOfMaterialHeaderUUID,
  PhysicalDocument
FROM I_MfgWorkInstrnBOMAssgmtTP
LEFT OUTER JOIN C_OpActyWorkInstructionTP AS _OpActyWorkinstructionTP ON MfgWorkInstruction = _OpActyWorkinstructionTP.MfgWorkInstruction AND MfgWorkInstructionVersCounter = _OpActyWorkinstructionTP.MfgWorkInstructionVersCounter  -- association [1..1]
;

Learn More