C_DefectMngDefectsForTransfer

DDL: C_DEFECTMNGDEFECTSFORTRANSFER SQL: CDEFECTMNGDFT Type: view CONSUMPTION
13 Fields 1 Data Sources

Defects for Transfer

C_DefectMngDefectsForTransfer is a Consumption CDS View that provides data about "Defects for Transfer" in SAP S/4HANA. It reads from 1 data source (I_Defect_TP) and exposes 13 fields with key field DefectInternalID.

Data Sources (1)

SourceAliasJoin Type
I_Defect_TP I_Defect_TP from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CDEFECTMNGDFT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Defects for Transfer view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey DefectInternalID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #B view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY DefectInternalID DefectInternalID Internal Defect ID
Defect Defect
DefectText DefectText
DefectCodeGroup DefectCodeGroup Code Group
DefectCode DefectCode Damage Code
InspectionLot InspectionLot Inspection Lot
DefectCategory DefectCategory
Plant Plant Valuation Area
MainWorkCenter MainWorkCenter Work Center
MainWorkCenterPlant MainWorkCenterPlant Plnt WorkCenter
_InspectionLot _InspectionLot
_DefectCodeGroup _DefectCodeGroup
_DefectCode _DefectCode

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_DefectMngDefectsForTransfer.
-- 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: CDEFECTMNGDFT

CREATE VIEW C_DefectMngDefectsForTransfer AS
SELECT
  DefectInternalID,
  Defect,
  DefectText,
  DefectCodeGroup,
  DefectCode,
  InspectionLot,
  DefectCategory,
  Plant,
  MainWorkCenter,
  MainWorkCenterPlant
FROM I_Defect_TP
;

Learn More