C_InhReprItmQtanSrvcOrdLink

DDL: C_INHREPRITMQTANSRVCORDLINK Type: view_entity CONSUMPTION
18 Fields 1 Data Sources

Service Order for Process Repair Qtan

C_InhReprItmQtanSrvcOrdLink is a Consumption CDS View that provides data about "Service Order for Process Repair Qtan" in SAP S/4HANA. It reads from 1 data source (R_InhRepairItmSrvcOrdTP) and exposes 18 fields with key fields InHouseRepair, InHouseRepairItem, ServiceOrder.

Data Sources (1)

SourceAliasJoin Type
R_InhRepairItmSrvcOrdTP R_InhRepairItmSrvcOrdTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Service Order for Process Repair Qtan 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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY InHouseRepair itemord InHouseRepair
KEY InHouseRepairItem itemord InHouseRepairItem
KEY ServiceOrder itemord ServiceOrder Transaction ID
InHouseRepairItemUUID itemord InHouseRepairItemUUID
InhRepairType itemord InhRepairType
_InHouseRepair itemord _InHouseRepair
ServiceOrderIsNotNew itemord ServiceOrderIsNotNew
ServiceOrderIsOpen itemord ServiceOrderIsOpen
ServiceOrderIsReleased itemord ServiceOrderIsReleased
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_InhReprItmQtanSrvcOrdLink.
-- 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_InhReprItmQtanSrvcOrdLink AS
SELECT
  itemord.InHouseRepair AS InHouseRepair,
  itemord.InHouseRepairItem AS InHouseRepairItem,
  itemord.ServiceOrder AS ServiceOrder,
  itemord.InHouseRepairItemUUID AS InHouseRepairItemUUID,
  itemord.InhRepairType AS InhRepairType,
  itemord._InHouseRepair AS _InHouseRepair,
  itemord.ServiceOrderIsNotNew AS ServiceOrderIsNotNew,
  itemord.ServiceOrderIsOpen AS ServiceOrderIsOpen,
  itemord.ServiceOrderIsReleased AS ServiceOrderIsReleased,
  RespEmployeeBusinessPartnerId,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID
FROM R_InhRepairItmSrvcOrdTP
;

Learn More