ESH_S_CNDNCONTR

DDL: ESH_S_CNDNCONTR SQL: ESH_S_CC Type: view Package: WCB_CC_PERS

Enterprise Search for Condition Contracts "Searchview"

ESH_S_CNDNCONTR is a CDS View that provides data about "Enterprise Search for Condition Contracts "Searchview"" in SAP S/4HANA. It reads from 1 data source (ESH_N_CNDNCONTR) and exposes 40 fields. Part of development package WCB_CC_PERS.

Data Sources (1)

SourceAliasJoin Type
ESH_N_CNDNCONTR root_view from

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName ESH_S_CC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.sapObjectNodeType.name ConditionContract view
UI.textArrangement #TEXT_FIRST view
UI.headerInfo.typeName Condition Contract view
UI.headerInfo.typeNamePlural Condition Contracts view
UI.headerInfo.title.value ConditionContract view
UI.headerInfo.description.value CndnContrTypeDesc view
Search.searchable true view
EnterpriseSearch.enabled true view
Consumption.semanticObject ConditionContract view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

Fields (40)

KeyFieldSource TableSource FieldDescription
ConditionContract
CreatedByUser
CreationDate
CndnContrValidFrom
CndnContrValidTo
ExternalDocumentReferenceID
CndnContrType
CndnContrTypeDesc ESH_N_CNDNCONTR CndnContrTypeDesc
Customer
CustomerBpUUID ESH_N_CNDNCONTR CustomerBpUUID
CustomerOrganizationBPName1
CustomerAuthorizationGroup ESH_N_CNDNCONTR CustomerAuthorizationGroup AuthorizGroup
Supplier
SupplierBpUUID ESH_N_CNDNCONTR SupplierBpUUID
SupplierOrganizationBPName1
SupplierAuthorizationGroup ESH_N_CNDNCONTR SupplierAuthorizationGroup AuthorizGroup
PurchasingOrganization
PurchasingGroup
SalesOrganization
DistributionChannel
Division
CndnContrIsInactive Activation Status
CndnContrIsInactiveName
CompanyCode
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg Org.key
PersonWorkAgreement ESH_N_CNDNCONTR PersonWorkAgreement Personnel No.
CndnContrWorkerCostCenter ESH_N_CNDNCONTR CndnContrWorkerCostCenter
_CndnContrIsInactive _CndnContrIsInactive
_Customer _Customer
_CustomerBusinessPartner _CustomerBusinessPartner
_Supplier _Supplier
_SupplierBusinessPartner _SupplierBusinessPartner
_CndnContrType _CndnContrType
_CompanyCode _CompanyCode
_DistributionChannel _DistributionChannel
_Division _Division
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_SalesOrganization _SalesOrganization
_PersonWorkAgreement _PersonWorkAgreement

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 ESH_S_CNDNCONTR.
-- 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: ESH_S_CC

CREATE VIEW ESH_S_CNDNCONTR AS
SELECT
  root_view.CndnContrTypeDesc AS CndnContrTypeDesc,
  root_view.CustomerBpUUID AS CustomerBpUUID,
  root_view.CustomerAuthorizationGroup AS CustomerAuthorizationGroup,
  root_view.SupplierBpUUID AS SupplierBpUUID,
  root_view.SupplierAuthorizationGroup AS SupplierAuthorizationGroup,
  PersonWorkAgrmtAuthznGrpg,
  root_view.PersonWorkAgreement AS PersonWorkAgreement,
  root_view.CndnContrWorkerCostCenter AS CndnContrWorkerCostCenter
FROM ESH_N_CNDNCONTR AS root_view
;