C_InhReprItmReprSrvcQtanLink

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

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.

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

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