C_OpActyInstcePlndInspCharc

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_OpActyInstcePlndInspCharc.
-- 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 C_OpActyInstcePlndInspCharc AS
SELECT
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkInstance AS OpActyNtwkInstance,
  OpActyInstceOpActyNtwkElmnt.OpActyNtwkElement AS OpActyNtwkElement,
  OpActyBOOCharcAssgmt.BOOCharacteristic AS InspectionCharacteristic,
  BOOCharacteristicVersion.InspectionSpecificationText AS InspectionSpecificationText,
  BOOCharacteristicVersion.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  BOOCharacteristicVersion.BOOCharcHasInspSpecReference AS BOOCharcHasInspSpecReference,
  BOOCharacteristicVersion.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  BOOCharacteristicVersion.InspectionSpecification AS InspectionSpecification,
  BOOCharacteristicVersion.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  BOOCharacteristicVersion.BOOCharacteristicInspRelevance AS BOOCharacteristicInspRelevance,
  BOOCharacteristicVersion._BOOCharcInspRelevance._Text[1: Language=$session.system_language].BOOCharcInspRelevanceText AS BOOCharcInspRelevanceText,
  cast( '' as idnrk) AS Material,
  cast( '' as maktx) AS MaterialName,
  BOOCharacteristicVersion.SamplingProcedure AS SamplingProcedure,
  BOOCharacteristicVersion._InspSpecImportanceCode._Text[1: Language=$session.system_language].InspSpecImportanceCodeText AS InspSpecImportanceCodeText,
  BOOCharacteristicVersion.InspSpecImportanceCode AS InspSpecImportanceCode,
  BOOCharacteristicVersion.BOOCharcGroup AS BOOCharcGroup,
  InspCharcGrpDesc.InspCharcGrpDesc AS InspCharcGrpDesc,
  BOOCharacteristicVersion.BOOCharcGroupDivision AS BOOCharcGroupDivision,
  InspCharcGrpDivnDesc.InspCharcGrpDivnDesc AS InspCharcGrpDivnDesc,
  BOOCharacteristicVersion.InspectionMethodPlant AS InspectionMethodPlant,
  BOOCharacteristicVersion.InspectionMethod AS InspectionMethod,
  BOOCharacteristicVersion.InspectionMethodVersion AS InspectionMethodVersion,
  BOOCharacteristicVersion.InspSpecInformationField1 AS InspSpecInformationField1,
  BOOCharacteristicVersion.InspSpecInformationField2 AS InspSpecInformationField2,
  BOOCharacteristicVersion.InspSpecInformationField3 AS InspSpecInformationField3,
  BOOCharacteristicVersion.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  BOOCharacteristicVersion.InspSpecTargetValue AS InspSpecTargetValue,
  BOOCharacteristicVersion.InspSpecLowerLimit AS InspSpecLowerLimit,
  BOOCharacteristicVersion.InspSpecUpperLimit AS InspSpecUpperLimit,
  BOOCharacteristicVersion.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  BOOCharacteristicVersion.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  BOOCharacteristicVersion.SelectedCodeSet AS SelectedCodeSet,
  BOOCharacteristicVersion.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  BOOCharacteristicVersion._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  BOOCharacteristicVersion.BOOCharcSourceCharc AS BOOCharcSourceCharc,
  OpActyBOOCharcAssgmt.OpActyCharcDivnSqnc AS OpActyCharcDivnSqnc,
  OpActyBOOCharcAssgmt.OpActyCharcGrpSqnc AS OpActyCharcGrpSqnc,
  OpActyBOOCharcAssgmt.BillOfMaterial AS BillOfMaterial,
  OpActyBOOCharcAssgmt.BillOfMaterialVariant AS BillOfMaterialVariant,
  OpActyBOOCharcAssgmt.InheritedNodeNumberForBOMItem AS OriglBOMItemInheritedNodeNmbr,
  cast( '' as stvkn ) AS InheritedNodeNumberForBOMItem,
  OpActyBOOCharcAssgmt.BillOfMaterialVersion AS BillOfMaterialVersion,
  OpActyBOOCharcAssgmt.DgtlMockUpCharcsUUID AS RefDgtlMockUpCharcsUUID,
  cast(LogisticsOrderBasic.OrderID as manufacturingorder preserving type) AS ManufacturingOrder,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsType AS BillOfOperationsType,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsGroup AS BillOfOperationsGroup,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsVariant AS BillOfOperationsVariant,
  OpActyInstceOpActyNtwkElmnt.BillOfOperationsVersion AS BillOfOperationsVersion,
  cast( '' as vmp_ref_des) AS ReferenceDesignatorName,
  OpActyBOOCharcAssgmt.OriglDgtlMockUpCharcsUUID AS OriglOriglDgtlMockUpCharcsUUID,
  cast( hextobin('00000000000000000000000000000000') as cim_dmu_guid16 preserving type ) AS OriglDgtlMockUpCharcsUUID,
  cast( '' as stlan ) AS BillOfMaterialVariantUsage,
  cast( '' as werks_d ) AS BOMOrBOMAltvCrtedInPlnt,
  OpActyInstceOpActyNtwkElmnt._OperationActivityInstance AS _OperationActivityInstance,
  OpActyInstceOpActyNtwkElmnt._OpActyNtwkInstanceBasic AS _OpActyNtwkInstanceBasic
FROM I_OpActyInstceOpActyNtwkElmnt AS OpActyInstceOpActyNtwkElmnt
INNER JOIN I_LogisticsOrderBasic AS LogisticsOrderBasic ON /* join condition not captured in parsed metadata */
INNER JOIN I_OpActyBOOCharcAssgmt AS OpActyBOOCharcAssgmt ON /* join condition not captured in parsed metadata */
INNER JOIN I_BOOCharacteristicVersion AS BOOCharacteristicVersion ON /* join condition not captured in parsed metadata */
;