A_SrvcQtanItmInHouseRepairItem

DDL: A_SRVCQTANITMINHOUSEREPAIRITEM Type: view_entity CONSUMPTION
17 Fields 2 Data Sources

In-House Service Object of Srvc Qtan Itm

A_SrvcQtanItmInHouseRepairItem is a Consumption CDS View that provides data about "In-House Service Object of Srvc Qtan Itm" in SAP S/4HANA. It reads from 2 data sources (I_ServiceDocumentItemEnhcd, I_ServiceDocumentItemPrdcssr_2) and exposes 17 fields with key fields ServiceQuotation, ServiceQuotationItem, InHouseRepair, InHouseRepairItem.

Data Sources (2)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd ServiceDocItem from
I_ServiceDocumentItemPrdcssr_2 ServiceDocItmPre inner

Annotations (11)

NameValueLevelField
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label In-House Service Object of Srvc Qtan Itm view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ServiceQuotation I_ServiceDocumentItemEnhcd ServiceDocument Transaction ID
KEY ServiceQuotationItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document
KEY InHouseRepair _IHRItem InHouseRepair
KEY InHouseRepairItem _IHRItem InHouseRepairItem
SalesGroup I_ServiceDocumentItemEnhcd SalesGroup Sales Group
SalesOffice I_ServiceDocumentItemEnhcd SalesOffice Sales Office
Division I_ServiceDocumentItemEnhcd Division Internal Division ID
DistributionChannel I_ServiceDocumentItemEnhcd DistributionChannel RefDistCh-Cust/Mat.
ServiceOrganization I_ServiceDocumentItemEnhcd ServiceOrganization
SalesGroupOrgUnitID I_ServiceDocumentItemEnhcd SalesGroupOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItemEnhcd SalesOfficeOrgUnitID
SalesOrganizationOrgUnitID I_ServiceDocumentItemEnhcd SalesOrganizationOrgUnitID
SalesOrganization I_ServiceDocumentItemEnhcd SalesOrganization Sales Organization
ServiceDocumentType I_ServiceDocumentItemEnhcd ServiceDocumentType Transaction Type
ServiceObjectType I_ServiceDocumentItemEnhcd ServiceObjectType Object Type
RespEmployeeBusinessPartnerId I_ServiceDocumentItemEnhcd ResponsibleEmployee Employee Resp.
_ServiceQuotationItem _ServiceQuotationItem

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 A_SrvcQtanItmInHouseRepairItem.
-- 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 A_SrvcQtanItmInHouseRepairItem AS
SELECT
  ServiceDocItem.ServiceDocument AS ServiceQuotation,
  ServiceDocItem.ServiceDocumentItem AS ServiceQuotationItem,
  _IHRItem.InHouseRepair AS InHouseRepair,
  _IHRItem.InHouseRepairItem AS InHouseRepairItem,
  ServiceDocItem.SalesGroup AS SalesGroup,
  ServiceDocItem.SalesOffice AS SalesOffice,
  ServiceDocItem.Division AS Division,
  ServiceDocItem.DistributionChannel AS DistributionChannel,
  ServiceDocItem.ServiceOrganization AS ServiceOrganization,
  ServiceDocItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  ServiceDocItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  ServiceDocItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  ServiceDocItem.SalesOrganization AS SalesOrganization,
  ServiceDocItem.ServiceDocumentType AS ServiceDocumentType,
  ServiceDocItem.ServiceObjectType AS ServiceObjectType,
  ServiceDocItem.ResponsibleEmployee AS RespEmployeeBusinessPartnerId
FROM I_ServiceDocumentItemEnhcd AS ServiceDocItem
INNER JOIN I_ServiceDocumentItemPrdcssr_2 AS ServiceDocItmPre ON /* join condition not captured in parsed metadata */
;

Learn More