C_SrvcOrdTranTypeVislFltr

DDL: C_SRVCORDTRANTYPEVISLFLTR Type: view CONSUMPTION
18 Fields 1 Data Sources

Service Ord. Trans. Type Visual Filter

C_SrvcOrdTranTypeVislFltr is a Consumption CDS View that provides data about "Service Ord. Trans. Type Visual Filter" in SAP S/4HANA. It reads from 1 data source (I_ServiceOrderCube_2) and exposes 18 fields with key fields ServiceObjectType, ServiceOrder.

Data Sources (1)

SourceAliasJoin Type
I_ServiceOrderCube_2 I_ServiceOrderCube_2 from

Annotations (17)

NameValueLevelField
EndUserText.label Service Ord. Trans. Type Visual Filter view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CSRVORDTRNVSLFLT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceOrder view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Search.searchable true view
Metadata.allowExtensions true view
UI.selectionPresentationVariant.qualifier Default view
UI.selectionPresentationVariant.presentationVariantQualifier Default view
UI.selectionPresentationVariant.selectionVariantQualifier Default view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceOrder ServiceOrder Transaction ID
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocumentTypeName
NumberOfOverdueServiceOrders NumberOfOverdueServiceOrders Service Orders
SrvcOrdHasConfdItem SrvcOrdHasConfdItem Confirmed Items
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
_ServiceDocumentType _ServiceDocumentType
_ServiceObjType _ServiceObjType
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_DistributionChannel _DistributionChannel
_Division _Division

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_SrvcOrdTranTypeVislFltr.
-- 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_SrvcOrdTranTypeVislFltr AS
SELECT
  ServiceObjectType,
  ServiceOrder,
  ServiceDocumentType,
  _ServiceDocumentType._ServiceDocumentTypeText[1:Language = $session.system_language].ServiceDocumentTypeName AS ServiceDocumentTypeName,
  NumberOfOverdueServiceOrders,
  SrvcOrdHasConfdItem,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup
FROM I_ServiceOrderCube_2
;

Learn More