C_InhReprItmPrChkSrvcOrdLink

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

Service Order for Perform Prechecks

C_InhReprItmPrChkSrvcOrdLink is a Consumption CDS View that provides data about "Service Order for Perform Prechecks" 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 Perform Prechecks 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_InhReprItmPrChkSrvcOrdLink.
-- 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_InhReprItmPrChkSrvcOrdLink 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