C_SVTExcludedCoOrPlntTP

DDL: C_SVTEXCLUDEDCOORPLNTTP Type: view_entity CONSUMPTION Package: EHPMA_SVT_CNS_EXCL_CMPNS_PLNTS
14 Fields 1 Data Sources 2 OData Services

Excluded Companies and Plants

C_SVTExcludedCoOrPlntTP is a Consumption CDS View that provides data about "Excluded Companies and Plants" in SAP S/4HANA. It reads from 1 data source (R_SVTExcludedCoOrPlntTP) and exposes 14 fields with key field ProdCmplncExclCoPlntUUID. It is exposed through 2 OData services (ASQL_F6590, UI_CMPNSPLNTS_EXCLUDE). Part of development package EHPMA_SVT_CNS_EXCL_CMPNS_PLNTS.

Data Sources (1)

SourceAliasJoin Type
R_SVTExcludedCoOrPlntTP R_SVTExcludedCoOrPlntTP projection

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Excluded Companies and Plants view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey ProdCmplncExclCoPlntUUID view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F6590 ASQL_F6590 C2 NOT_RELEASED
UI_CMPNSPLNTS_EXCLUDE UI_CMPNSPLNTS_EXCLUDE V4 C1 NOT_RELEASED

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncExclCoPlntUUID ProdCmplncExclCoPlntUUID Excl Cmpn Plnt UUID
SVTBusinessProcess SVTBusinessProcess Business Process
SVTBusinessProcessText
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Plant Plant Valuation Area
PlantName _PlantName PlantName Plant Name
SVTRemarkText SVTRemarkText Text Remark
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
CreationUTCDateTime CreationUTCDateTime Time Stamp
CreatedByUserName _CreatedByUser UserDescription Full Name
LastChangeUTCDateTime LastChangeUTCDateTime Time Stamp
LastChangedByUserName _LastChangedByUser UserDescription Full Name

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_SVTExcludedCoOrPlntTP.
-- 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_SVTExcludedCoOrPlntTP AS
SELECT
  ProdCmplncExclCoPlntUUID,
  SVTBusinessProcess,
  _BusinessProcess._Text[1: Language = $session.system_language].SVTBusinessProcessText AS SVTBusinessProcessText,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Plant,
  _PlantName.PlantName AS PlantName,
  SVTRemarkText,
  ValidityStartDate,
  ValidityEndDate,
  CreationUTCDateTime,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  LastChangeUTCDateTime,
  _LastChangedByUser.UserDescription AS LastChangedByUserName
FROM R_SVTExcludedCoOrPlntTP
;

Learn More