C_CndnContrWrkflwRelReWrk

DDL: C_CNDNCONTRWRKFLWRELREWRK SQL: CCWFRELRW Type: view CONSUMPTION Package: WZRE_PC
44 Fields 1 Data Sources 1 Associations

cds-view to rework workflow scenarios for CndnContr

C_CndnContrWrkflwRelReWrk is a Consumption CDS View that provides data about "cds-view to rework workflow scenarios for CndnContr" in SAP S/4HANA. It reads from 1 data source (I_ConditionContract) and exposes 44 fields with key field ConditionContract. It has 1 association to related views. Part of development package WZRE_PC.

Data Sources (1)

SourceAliasJoin Type
I_ConditionContract Contract from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_CndnContrWrkflwSettlmtCal _SettlmtCal _SettlmtCal.ConditionContract = $projection.ConditionContract

Annotations (20)

NameValueLevelField
AbapCatalog.sqlViewName CCWFRELRW view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #NONE view
ClientHandling.algorithm #SESSION_VARIABLE view
ClientHandling.type #INHERITED view
Consumption.semanticObject ConditionContract view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.representativeKey ConditionContract view
UI.textArrangement #TEXT_FIRST view
UI.headerInfo.title.type #WITH_INTENT_BASED_NAVIGATION view
UI.headerInfo.title.value DocumentTitle view
UI.headerInfo.description.value DataPoint02 view
EndUserText.label cds-view to rework workflow scenarios for CndnContr view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY ConditionContract I_ConditionContract ConditionContract Condition Contract
DocumentTitle
DataPoint02 CndnContrType Contract Type
CndnContrType CndnContrType Contract Type
DataPoint03 Contract Type Desc.
Customer I_ConditionContract Customer Sold-to Party
CustomerName _Customer CustomerName Name of Customer
Supplier I_ConditionContract Supplier Supplier
SupplierName _Supplier SupplierName Supplier Name
CndnContrValidFrom I_ConditionContract CndnContrValidFrom Valid From
CndnContrValidTo I_ConditionContract CndnContrValidTo Valid To
ExternalDocumentReferenceID ExternalDocumentReferenceID Ext. Identifier
CndnContrIsInactive I_ConditionContract CndnContrIsInactive
CndnContrIsInactiveName
CreatedByUser CreatedByUser User Name
UserFullName _CreatedByUser UserDescription Full Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationName
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName
Division Division Internal Division ID
DivisionName
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganization PurchasingOrganizationName Purch. Org. Name
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
PriorSupplier I_ConditionContract PriorSupplier Prior Supplier
PersonWorkAgreement I_ConditionContract PersonWorkAgreement Personnel No.
CndnContrWorkerCostCenter I_ConditionContract CndnContrWorkerCostCenter
_Division _Division
_CndnContrType _CndnContrType
_DistributionChannel _DistributionChannel
_SalesOrganization _SalesOrganization
_PurchasingGroup _PurchasingGroup
_PurchasingOrganization _PurchasingOrganization
_SettlmtCal _SettlmtCal
_Customer _Customer
_Supplier _Supplier
_PriorSupplier _PriorSupplier
_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 C_CndnContrWrkflwRelReWrk.
-- 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: CCWFRELRW

CREATE VIEW C_CndnContrWrkflwRelReWrk AS
SELECT
  Contract.ConditionContract AS ConditionContract,
  concat_with_space(' ' , ' ' , 68) AS DocumentTitle,
  CndnContrType AS DataPoint02,
  CndnContrType,
  _CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc AS DataPoint03,
  Contract.Customer AS Customer,
  _Customer.CustomerName AS CustomerName,
  Contract.Supplier AS Supplier,
  _Supplier.SupplierName AS SupplierName,
  Contract.CndnContrValidFrom AS CndnContrValidFrom,
  Contract.CndnContrValidTo AS CndnContrValidTo,
  ExternalDocumentReferenceID,
  Contract.CndnContrIsInactive AS CndnContrIsInactive,
  Contract._CndnContrIsInactive._Text[1: Language = $session.system_language ].CndnContrIsInactiveName AS CndnContrIsInactiveName,
  CreatedByUser,
  _CreatedByUser.UserDescription AS UserFullName,
  CreationDate,
  LastChangedByUser,
  SalesOrganization,
  _SalesOrganization._Text[1: Language=$session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  DistributionChannel,
  _DistributionChannel._Text[1: Language=$session.system_language ].DistributionChannelName AS DistributionChannelName,
  Division,
  _Division._Text[1: Language=$session.system_language ].DivisionName AS DivisionName,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Contract.PriorSupplier AS PriorSupplier,
  Contract.PersonWorkAgreement AS PersonWorkAgreement,
  Contract.CndnContrWorkerCostCenter AS CndnContrWorkerCostCenter
FROM I_ConditionContract AS Contract
LEFT OUTER JOIN C_CndnContrWrkflwSettlmtCal AS _SettlmtCal ON _SettlmtCal.ConditionContract = ConditionContract  -- association [1..*]
;

Learn More