I_ServiceQuotationType

DDL: I_SERVICEQUOTATIONTYPE SQL: QUOTETRANSTYPE Type: view BASIC
6 Fields 5 Data Sources

Transaction Types relevant to quotation

I_ServiceQuotationType is a Basic CDS View that provides data about "Transaction Types relevant to quotation" in SAP S/4HANA. It reads from 5 data sources (crmc_it_assign, crmc_item_type, crmc_sales_head, crmc_sales_item, I_ServiceDocumentTypeStdVH) and exposes 6 fields with key fields ServiceDocumentType, ServiceDocItemCategory, ItemCategoryGroup.

Data Sources (5)

SourceAliasJoin Type
crmc_it_assign _it_assign inner
crmc_item_type _item_type inner
crmc_sales_head _sales_head inner
crmc_sales_item _sales_item inner
I_ServiceDocumentTypeStdVH I_ServiceDocumentTypeStdVH from

Annotations (13)

NameValueLevelField
EndUserText.label Transaction Types relevant to quotation view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName QUOTETRANSTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceDocumentType view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ServiceDocumentType ServiceDocumentType Transaction Type
KEY ServiceDocItemCategory crmc_item_type itm_type Item Category
KEY ItemCategoryGroup crmc_it_assign item_cat_group Item Cat. Group
ServiceObjectType ServiceObjectType Object Type
PrcgProcedureDocumentClfn doc_pric_proc Doc. Pric.Proc.
_ServiceDocumentTypeText _ServiceDocumentTypeText

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 I_ServiceQuotationType.
-- 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.
-- SQL view name: QUOTETRANSTYPE

CREATE VIEW I_ServiceQuotationType AS
SELECT
  ServiceDocumentType,
  _item_type.itm_type AS ServiceDocItemCategory,
  _it_assign.item_cat_group AS ItemCategoryGroup,
  ServiceObjectType,
  doc_pric_proc AS PrcgProcedureDocumentClfn
FROM I_ServiceDocumentTypeStdVH
INNER JOIN crmc_sales_head AS _sales_head ON /* join condition not captured in parsed metadata */
INNER JOIN crmc_it_assign AS _it_assign ON /* join condition not captured in parsed metadata */
INNER JOIN crmc_item_type AS _item_type ON /* join condition not captured in parsed metadata */
INNER JOIN crmc_sales_item AS _sales_item ON /* join condition not captured in parsed metadata */
;

Learn More