C_InhReprItmReprSrvcQtanLink

DDL: C_INHREPRITMREPRSRVCQTANLINK Type: view_entity CONSUMPTION
18 Fields 1 Data Sources 1 OData Services 1 Fiori Apps

Service Quotation for Perform Repairs

C_InhReprItmReprSrvcQtanLink is a Consumption CDS View that provides data about "Service Quotation for Perform Repairs" in SAP S/4HANA. It reads from 1 data source (R_InhRepairItmSrvcQtanTP) and exposes 18 fields with key fields InHouseRepair, InHouseRepairItem, ServiceQuotation. It is exposed through 1 OData service (UI_PERFORMREPAIRS). It is used in 1 Fiori application: Perform Repairs.

Data Sources (1)

SourceAliasJoin Type
R_InhRepairItmSrvcQtanTP R_InhRepairItmSrvcQtanTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Service Quotation for Perform Repairs view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PERFORMREPAIRS UI_PERFORMREPAIRS V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F4241 Perform Repairs Transactional You can use this app to access the repair order that contains the details about the repair. You confirm the required service products, service parts, and expenses in this order.

Perform Repairs

Business Role: Service Technician - In-House Repair

You can use this app to access the repair order that contains the details about the diagnosis and the repair. You confirm the required service items, service parts, and expense items in the repair order.

Key Features: Call up a worklist of all repair objects that are currently in diagnosis and in repair (statuses Perform: Diagnosis or Perform: Repair). You can filter, sort, and group a list of repair objects that are currently in diagnosis and in repair. Display the details of the repair objects that are currently in diagnosis or repair. You can access the related product and equipment data to check their details. Access the repair order to see the details of the diagnosis or the repair. Access the repair order to confirm the required service items, service parts, and expense items.

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InHouseRepair itemqtan InHouseRepair
KEY InHouseRepairItem itemqtan InHouseRepairItem
KEY ServiceQuotation itemqtan ServiceQuotation Transaction ID
InHouseRepairItemUUID itemqtan InHouseRepairItemUUID
InhRepairType itemqtan InhRepairType
_InHouseRepair itemqtan _InHouseRepair
ServiceQuotationIsNotNew itemqtan ServiceQuotationIsNotNew
ServiceQuotationIsOpen itemqtan ServiceQuotationIsOpen
ServiceQuotationIsReleased itemqtan ServiceQuotationIsReleased
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID

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_InhReprItmReprSrvcQtanLink.
-- 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_InhReprItmReprSrvcQtanLink AS
SELECT
  itemqtan.InHouseRepair AS InHouseRepair,
  itemqtan.InHouseRepairItem AS InHouseRepairItem,
  itemqtan.ServiceQuotation AS ServiceQuotation,
  itemqtan.InHouseRepairItemUUID AS InHouseRepairItemUUID,
  itemqtan.InhRepairType AS InhRepairType,
  itemqtan._InHouseRepair AS _InHouseRepair,
  itemqtan.ServiceQuotationIsNotNew AS ServiceQuotationIsNotNew,
  itemqtan.ServiceQuotationIsOpen AS ServiceQuotationIsOpen,
  itemqtan.ServiceQuotationIsReleased AS ServiceQuotationIsReleased,
  RespEmployeeBusinessPartnerId,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID
FROM R_InhRepairItmSrvcQtanTP
;

Learn More