I_DefectTP_2

DDL: I_DEFECTTP_2 Type: view_entity TRANSACTIONAL Package: VDM_QM_NOTIFICATION
45 Fields 1 Data Sources

Defect - TP

I_DefectTP_2 is a Transactional CDS View that provides data about "Defect - TP" in SAP S/4HANA. It reads from 1 data source (R_DefectTP) and exposes 45 fields with key field DefectInternalID. Part of development package VDM_QM_NOTIFICATION.

Data Sources (1)

SourceAliasJoin Type
R_DefectTP R_DefectTP projection

Annotations (11)

NameValueLevelField
EndUserText.label Defect - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ObjectModel.sapObjectNodeType.name Defect view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.representativeKey DefectInternalID view
Metadata.ignorePropagatedAnnotations true view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID _Defect DefectInternalID Internal Defect ID
Defect _Defect Defect
DefectCategory _Defect DefectCategory
CreatedByUser _Defect CreatedByUser User Name
CreationDate _Defect CreationDate Time Stamp
CreationTime _Defect CreationTime Time of Change
LastChangedByUser _Defect LastChangedByUser User Name
LastChangeDate _Defect LastChangeDate Time Stamp
LastChangeTime _Defect LastChangeTime Time changed
DefectText _Defect DefectText
DefectCodeCatalog _Defect DefectCodeCatalog
DefectCodeGroup _Defect DefectCodeGroup Code Group
DefectCode _Defect DefectCode Damage Code
DefectLocationCatalog _Defect DefectLocationCatalog
DefectLocationCodeGroup _Defect DefectLocationCodeGroup
DefectLocationCode _Defect DefectLocationCode
DefectiveQuantity _Defect DefectiveQuantity
DefectiveQuantityUnit _Defect DefectiveQuantityUnit
ManufacturingOrder _Defect ProductionOrder Order
OrderInternalID _Defect OrderInternalID Plan No.f.Oper.
ManufacturingOrderOperation
ManufacturingOrderSequence _Defect ProductionOrderSequence Visit Sequence
DefectClass _Defect DefectClass Defect Class
NumberOfDefects _Defect NumberOfDefects
InspPlanOperationInternalID _Defect InspPlanOperationInternalID
InspectionCharacteristic _Defect InspectionCharacteristic
InspectionSubsetInternalID _Defect InspectionSubsetInternalID
MaterialSample _Defect MaterialSample
WorkCenterTypeCode _Defect WorkCenterTypeCode Object Type
MainWorkCenterInternalID _Defect MainWorkCenterInternalID Work Center
MainWorkCenterPlant _Defect MainWorkCenterPlant Plnt WorkCenter
MainWorkCenter _Defect MainWorkCenter Work Center
IsDeleted _Defect IsDeleted TRUE
DefectOrigin _Defect DefectOrigin
Material _Defect Material Vehicle Model
Batch _Defect Batch Lot No.
Plant _Defect Plant Valuation Area
InspectionLot _Defect InspectionLot Inspection Lot
ChangedDateTime _Defect ChangedDateTime Time Stamp
DefectLifecycleStatus _Defect DefectLifecycleStatus
ProblemAnalysisStatus _Defect ProblemAnalysisStatus
QualityIssueReference _Defect QualityIssueReference Reference Number
MasterLanguage _Defect MasterLanguage Primary lang.
DefectUUID _Defect DefectUUID Defect UUID
_InspectionLot _Defect _InspectionLot

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_DefectTP_2.
-- 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_DefectTP_2 AS
SELECT
  _Defect.DefectInternalID AS DefectInternalID,
  _Defect.Defect AS Defect,
  _Defect.DefectCategory AS DefectCategory,
  _Defect.CreatedByUser AS CreatedByUser,
  _Defect.CreationDate AS CreationDate,
  _Defect.CreationTime AS CreationTime,
  _Defect.LastChangedByUser AS LastChangedByUser,
  _Defect.LastChangeDate AS LastChangeDate,
  _Defect.LastChangeTime AS LastChangeTime,
  _Defect.DefectText AS DefectText,
  _Defect.DefectCodeCatalog AS DefectCodeCatalog,
  _Defect.DefectCodeGroup AS DefectCodeGroup,
  _Defect.DefectCode AS DefectCode,
  _Defect.DefectLocationCatalog AS DefectLocationCatalog,
  _Defect.DefectLocationCodeGroup AS DefectLocationCodeGroup,
  _Defect.DefectLocationCode AS DefectLocationCode,
  _Defect.DefectiveQuantity AS DefectiveQuantity,
  _Defect.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  _Defect.ProductionOrder AS ManufacturingOrder,
  _Defect.OrderInternalID AS OrderInternalID,
  cast( _Defect.ProductionOrderOperation as vdm_vornr preserving type ) AS ManufacturingOrderOperation,
  _Defect.ProductionOrderSequence AS ManufacturingOrderSequence,
  _Defect.DefectClass AS DefectClass,
  _Defect.NumberOfDefects AS NumberOfDefects,
  _Defect.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _Defect.InspectionCharacteristic AS InspectionCharacteristic,
  _Defect.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _Defect.MaterialSample AS MaterialSample,
  _Defect.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Defect.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  _Defect.MainWorkCenterPlant AS MainWorkCenterPlant,
  _Defect.MainWorkCenter AS MainWorkCenter,
  _Defect.IsDeleted AS IsDeleted,
  _Defect.DefectOrigin AS DefectOrigin,
  _Defect.Material AS Material,
  _Defect.Batch AS Batch,
  _Defect.Plant AS Plant,
  _Defect.InspectionLot AS InspectionLot,
  _Defect.ChangedDateTime AS ChangedDateTime,
  _Defect.DefectLifecycleStatus AS DefectLifecycleStatus,
  _Defect.ProblemAnalysisStatus AS ProblemAnalysisStatus,
  _Defect.QualityIssueReference AS QualityIssueReference,
  _Defect.MasterLanguage AS MasterLanguage,
  _Defect.DefectUUID AS DefectUUID,
  _Defect._InspectionLot AS _InspectionLot
FROM R_DefectTP
;

Learn More