I_DefectTP_2
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)
| Source | Alias | Join Type |
|---|---|---|
| R_DefectTP | R_DefectTP | projection |
Annotations (11)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | DefectInternalID | _Defect | DefectInternalID | |
| Defect | _Defect | Defect | ||
| DefectCategory | _Defect | DefectCategory | ||
| CreatedByUser | _Defect | CreatedByUser | ||
| CreationDate | _Defect | CreationDate | ||
| CreationTime | _Defect | CreationTime | ||
| LastChangedByUser | _Defect | LastChangedByUser | ||
| LastChangeDate | _Defect | LastChangeDate | ||
| LastChangeTime | _Defect | LastChangeTime | ||
| DefectText | _Defect | DefectText | ||
| DefectCodeCatalog | _Defect | DefectCodeCatalog | ||
| DefectCodeGroup | _Defect | DefectCodeGroup | ||
| DefectCode | _Defect | DefectCode | ||
| DefectLocationCatalog | _Defect | DefectLocationCatalog | ||
| DefectLocationCodeGroup | _Defect | DefectLocationCodeGroup | ||
| DefectLocationCode | _Defect | DefectLocationCode | ||
| DefectiveQuantity | _Defect | DefectiveQuantity | ||
| DefectiveQuantityUnit | _Defect | DefectiveQuantityUnit | ||
| ManufacturingOrder | _Defect | ProductionOrder | ||
| OrderInternalID | _Defect | OrderInternalID | ||
| ManufacturingOrderOperation | ||||
| ManufacturingOrderSequence | _Defect | ProductionOrderSequence | ||
| DefectClass | _Defect | DefectClass | ||
| NumberOfDefects | _Defect | NumberOfDefects | ||
| InspPlanOperationInternalID | _Defect | InspPlanOperationInternalID | ||
| InspectionCharacteristic | _Defect | InspectionCharacteristic | ||
| InspectionSubsetInternalID | _Defect | InspectionSubsetInternalID | ||
| MaterialSample | _Defect | MaterialSample | ||
| WorkCenterTypeCode | _Defect | WorkCenterTypeCode | ||
| MainWorkCenterInternalID | _Defect | MainWorkCenterInternalID | ||
| MainWorkCenterPlant | _Defect | MainWorkCenterPlant | ||
| MainWorkCenter | _Defect | MainWorkCenter | ||
| IsDeleted | _Defect | IsDeleted | ||
| DefectOrigin | _Defect | DefectOrigin | ||
| Material | _Defect | Material | ||
| Batch | _Defect | Batch | ||
| Plant | _Defect | Plant | ||
| InspectionLot | _Defect | InspectionLot | ||
| ChangedDateTime | _Defect | ChangedDateTime | ||
| DefectLifecycleStatus | _Defect | DefectLifecycleStatus | ||
| ProblemAnalysisStatus | _Defect | ProblemAnalysisStatus | ||
| QualityIssueReference | _Defect | QualityIssueReference | ||
| MasterLanguage | _Defect | MasterLanguage | ||
| DefectUUID | _Defect | DefectUUID | ||
| _InspectionLot | _Defect | _InspectionLot |
@EndUserText.label: 'Defect - TP'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@VDM.usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
@ObjectModel.sapObjectNodeType: { name: 'Defect' }
@ObjectModel: {
modelingPattern: #TRANSACTIONAL_INTERFACE,
supportedCapabilities: [#TRANSACTIONAL_PROVIDER],
usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #L,
serviceQuality: #B
},
representativeKey: 'DefectInternalID',
semanticKey: ['Defect']
}
@Metadata.ignorePropagatedAnnotations: true
define root view entity I_DefectTP_2
// provider contract transactional_query // Set due to recomendation by behavior definition
provider contract transactional_interface
as projection on R_DefectTP as _Defect
{
key _Defect.DefectInternalID,
@ObjectModel.sapObjectNodeTypeReference: 'Defect'
_Defect.Defect,
_Defect.DefectCategory,
_Defect.CreatedByUser,
_Defect.CreationDate,
@Semantics.time: true
_Defect.CreationTime,
_Defect.LastChangedByUser,
_Defect.LastChangeDate,
@Semantics.time: true
_Defect.LastChangeTime,
_Defect.DefectText,
_Defect.DefectCodeCatalog,
_Defect.DefectCodeGroup,
_Defect.DefectCode,
// _Defect.DefectCodeVersion, // Do we need this field? Value is fix '0001' for each case
_Defect.DefectLocationCatalog,
_Defect.DefectLocationCodeGroup,
_Defect.DefectLocationCode,
// _Defect.DefectLocationCodeVersion, // Do we need this field? Value is fix '0001' for each case
@Semantics.quantity.unitOfMeasure: 'DefectiveQuantityUnit'
_Defect.DefectiveQuantity,
_Defect.DefectiveQuantityUnit,
_Defect.ProductionOrder as ManufacturingOrder,
_Defect.OrderInternalID,
cast( _Defect.ProductionOrderOperation as vdm_vornr preserving type ) as ManufacturingOrderOperation,
_Defect.ProductionOrderSequence as ManufacturingOrderSequence,
_Defect.DefectClass,
_Defect.NumberOfDefects,
_Defect.InspPlanOperationInternalID,
_Defect.InspectionCharacteristic,
_Defect.InspectionSubsetInternalID,
_Defect.MaterialSample,
// Work center data
_Defect.WorkCenterTypeCode,
_Defect.MainWorkCenterInternalID,
_Defect.MainWorkCenterPlant,
_Defect.MainWorkCenter,
// _Defect.Equipment,
// _Defect.FunctionalLocation,
@Semantics.booleanIndicator: true
_Defect.IsDeleted,
_Defect.DefectOrigin,
_Defect.Material,
_Defect.Batch,
_Defect.Plant,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.StorageLocation,
_Defect.InspectionLot,
// _Defect.CatalogProfile,
_Defect.ChangedDateTime,
_Defect.DefectLifecycleStatus,
_Defect.ProblemAnalysisStatus,
_Defect.QualityIssueReference,
_Defect.MasterLanguage,
_Defect.DefectUUID,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.ProductionSupplyArea,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.EWMWarehouse,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.SourceStorageType,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.SourceStorageBin,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.WarehouseLogicalSystem,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.DefectCausedBy,
// @Feature: 'QM_CE_DEFECT_WAREHOUSE_DEF' // Annotation not allwed!
// _Defect.CostCenter,
/* Association */
// _DefectAffectedObject : redirected to composition child I_DefectAffectedObjectTP_2,
_DefectLongText : redirected to composition child I_DefectLongTextTP_2,
@Consumption.hidden: true
_Defect._InspectionLot as _InspectionLot
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA