C_CNDNCONTRWRKFLWREL

CDS View

cds-view to release workflow scenarios for CndnContr

C_CNDNCONTRWRKFLWREL is a CDS View in S/4HANA. cds-view to release workflow scenarios for CndnContr. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_CndnContrWorkItem view inner CONSUMPTION Condition Contract Work Item

Fields (39)

KeyField CDS FieldsUsed in Views
_Customer _Customer 1
_DistributionChannel _DistributionChannel 1
_Division _Division 1
_PersonWorkAgreement _PersonWorkAgreement 1
_PriorSupplier _PriorSupplier 1
_PurchasingGroup _PurchasingGroup 1
_PurchasingOrganization _PurchasingOrganization 1
_SalesOrganization _SalesOrganization 1
_Supplier _Supplier 1
CndnContrIsInactive CndnContrIsInactive 1
CndnContrIsInactiveName CndnContrIsInactiveName 1
CndnContrType CndnContrType 1
CndnContrValidFrom CndnContrValidFrom 1
CndnContrValidTo CndnContrValidTo 1
CndnContrWorkerCostCenter CndnContrWorkerCostCenter 1
CompanyCode CompanyCode 1
CompanyCodeName CompanyCodeName 1
ConditionContract ConditionContract 1
CreatedByUser CreatedByUser 1
CreationDate CreationDate 1
Customer Customer 1
CustomerName CustomerName 1
DataPoint03 CndnContrTypeDesc 1
DistributionChannel DistributionChannel 1
DistributionChannelName DistributionChannelName 1
Division Division 1
DivisionName DivisionName 1
ExternalDocumentReferenceID ExternalDocumentReferenceID 1
LastChangedByUser LastChangedByUser 1
PersonWorkAgreement PersonWorkAgreement 1
PriorSupplier PriorSupplier 1
PurchasingGroup PurchasingGroup 1
PurchasingGroupName PurchasingGroupName 1
PurchasingOrganization PurchasingOrganization 1
PurchasingOrganizationName PurchasingOrganizationName 1
SalesOrganization SalesOrganization 1
Supplier Supplier 1
SupplierName SupplierName 1
UserFullName UserFullName 1
@AbapCatalog.sqlViewName: 'CCWFREL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #MANDATORY
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

// Todo: check if VDM-annotations should be there because of GFN - DPs...

@VDM.viewType: #CONSUMPTION
@VDM.lifecycle.contract.type: #NONE

@ClientHandling.algorithm: #SESSION_VARIABLE
@ClientHandling.type: #INHERITED
@Consumption.semanticObject: 'ConditionContract'

// Todo: Needed? From example

@Metadata.ignorePropagatedAnnotations:true

@ObjectModel: {
   usageType: {
    dataClass: #MIXED,
    serviceQuality: #D,
    sizeCategory:  #L
   },
   semanticKey: [ 'ConditionContract' ],
   representativeKey: 'ConditionContract'
}

@UI: {
  textArrangement: #TEXT_FIRST,
  headerInfo: {
    title: {
        type: #WITH_INTENT_BASED_NAVIGATION,
        value: 'DocumentTitle'
    },
    description: {
      value: 'DataPoint02'
    }
  }
}

@EndUserText.label: 'cds-view to release workflow scenarios for CndnContr'
define view C_CndnContrWrkflwRel
  as select from I_ConditionContract as Contract
  //  Todo: Needed? Try to add Pop-Up

  //  association [0..1] to I_UserContactCard           as _UserContactCard on $projection.CreatedByUser = _UserContactCard.ContactCardID

  association [1..*] to C_CndnContrWrkflwSettlmtCal as _SettlmtCal on _SettlmtCal.ConditionContract = $projection.ConditionContract
{

      /******************
      * Facet-Definition
      *******************/

      @UI.facet: [
        // Information Area

        {
          id:'InformationArea',
          purpose: #STANDARD,
          type: #COLLECTION,
          isSummary,
          position: 10
        },
            {
              label: 'General Information',
              id: 'BasicData',
              parentId: 'InformationArea',
              type: #FIELDGROUP_REFERENCE,
              targetQualifier: 'BasicDataRefGeneralInfos1',
              position: 10
            },
            {
              label: 'Administrational Data',
              id: 'BasicUserData',
              parentId: 'InformationArea',
              type: #FIELDGROUP_REFERENCE,
              targetQualifier: 'BasicUserData',
              position: 20
            },
            {
              label: 'Sales',
              id: 'SuplrOrgData',
              parentId: 'InformationArea',
              type: #FIELDGROUP_REFERENCE,
              targetQualifier: 'SupOrgData',
              position: 30
            },
            {
              label: 'Purchasing',
              id: 'CustOrgData',
              parentId: 'InformationArea',
              type: #FIELDGROUP_REFERENCE,
              targetQualifier: 'CustOrgData',
              position: 40
            },
          // Detail Area (Table)

          {
            id:'SettlmtCalTable',
            type: #LINEITEM_REFERENCE,
            targetQualifier: 'SettlmtCal',
            targetElement: '_SettlmtCal',
            label: 'Settlement Calender',
            position: 10,
            purpose: #STANDARD
          }
        ]


         // Key attribute

      @UI.fieldGroup: [{qualifier: 'BasicDataRefGeneralInfos1', position: 10, importance: #HIGH}]
      @Consumption.semanticObject: 'ConditionContract'
  key Contract.ConditionContract,


      /*****************************
      * Header-Section
      ******************************/

      // DocumentTitle (headerInfo -> Title)

      @Consumption.semanticObject: 'ConditionContract'
      //Deleted - concat_with_space('Release Condition Contract' , ltrim(Contract.ConditionContract, '0'), 1) as DocumentTitle,

      //Reserve 70 chars for the document title. Because of translatability, the title text is set in the backend via service extension class

      concat_with_space(' ' , ' ' , 68)                                                                    as DocumentTitle,

      // Condition Contract Type + Description (headerInfo -> Description)

      @UI.dataPoint: {
        targetValue: 'DataPoint02'
      }
      CndnContrType                                                                                        as DataPoint02,

      // Needed because of inheritance of dcl

      @UI.hidden: true
      CndnContrType,

      @Semantics.text: true
      @UI.dataPoint: {
        targetValue: 'DataPoint03'
      }
      @EndUserText.label: 'Contract Type Desc.'
      _CndnContrType._Text[1: Language = $session.system_language ].CndnContrTypeDesc                      as DataPoint03,

      // Customer / Supplier

      @ObjectModel: {
        foreignKey.association: '_Customer',
        text.element: [ 'CustomerName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'SupOrgData', position: 5, importance: #HIGH}],
        textArrangement: #TEXT_FIRST
      }
      Contract.Customer,

      @Semantics.text: true
      @UI.hidden: true
      _Customer.CustomerName,

      @ObjectModel: {
        foreignKey.association: '_Supplier',
        text.element: [ 'SupplierName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'CustOrgData', position: 5, importance: #HIGH}],
        textArrangement: #TEXT_FIRST
      }
      Contract.Supplier,

      @Semantics.text: true
      @UI.hidden: true
      _Supplier.SupplierName,



      /*****************************
      * Detail-Section
      ******************************/



      /* General Information */


      // Validity

      @UI: {
        fieldGroup: [{ qualifier:'BasicDataRefGeneralInfos1', importance: #HIGH, position: 40 }]
      }
      Contract.CndnContrValidFrom                                                                          as CndnContrValidFrom,
      @UI: {
          fieldGroup: [{ qualifier: 'BasicDataRefGeneralInfos1', position: 50, importance: #HIGH}]
      }
      Contract.CndnContrValidTo                                                                            as CndnContrValidTo,


      // External Reference

      @UI: {
        fieldGroup: [{qualifier: 'BasicDataRefGeneralInfos1', position: 30, importance: #HIGH}]
      }
      ExternalDocumentReferenceID,


      // Activation Status

      @ObjectModel: {
        text.element: ['CndnContrIsInactiveName']
      }
      @UI: {
        fieldGroup: [{qualifier: 'BasicDataRefGeneralInfos1', position: 60, importance: #HIGH}]
      }
      @Semantics: {
          booleanIndicator: true
      }
      Contract.CndnContrIsInactive,

      @Semantics.text: true
      @Consumption.filter.hidden: true
      @UI.hidden: true
      Contract._CndnContrIsInactive._Text[1: Language = $session.system_language ].CndnContrIsInactiveName as CndnContrIsInactiveName,



      /* Administrational Data */


      // Created By

      @ObjectModel: {
        text.element:  [ 'UserFullName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'BasicUserData', position: 10, importance: #HIGH, type: #WITH_INTENT_BASED_NAVIGATION }],
        textArrangement: #TEXT_ONLY
      }
      CreatedByUser,

      @Semantics.text: true
      @UI.hidden: true
      _CreatedByUser.UserDescription                                                                       as UserFullName,


      // Created On

      @UI: {
        fieldGroup: [{qualifier: 'BasicUserData', position: 20, importance: #HIGH}]
      }
      CreationDate,


      // Last Changed By

      @ObjectModel: {
        text.element:  [ 'UserFullName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'BasicUserData', position: 30, importance: #HIGH}]
      }
      LastChangedByUser,



      /* Sales */


      // Sales Organization

      @ObjectModel: {
        foreignKey.association: '_SalesOrganization',
        text.element: [ 'SalesOrganizationName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'SupOrgData', position: 10, importance: #HIGH}] //SupCustOrgData

      }
      SalesOrganization,

      @UI.hidden:true
      @Semantics.text: true
      _SalesOrganization._Text[1: Language=$session.system_language ].SalesOrganizationName                as SalesOrganizationName,


      // Distribution Channel

      @ObjectModel: {
        foreignKey.association: '_DistributionChannel',
        text.element: [ 'DistributionChannelName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'SupOrgData', position: 20, importance: #MEDIUM }] //SupCustOrgData

      }
      DistributionChannel,

      @UI.hidden:true
      @Semantics.text: true
      _DistributionChannel._Text[1: Language=$session.system_language ].DistributionChannelName            as DistributionChannelName,


      // Division

      @ObjectModel: {
        foreignKey.association: '_Division',
        text.element: [ 'DivisionName' ]
      }
      @UI: {
        fieldGroup: [{ qualifier: 'SupOrgData', position: 30, importance: #MEDIUM }] //SupOrgData

      }
      Division,

      @UI.hidden:true
      @Semantics.text: true
      _Division._Text[1: Language=$session.system_language ].DivisionName,



      /* Purchasing */

      // Purchasing Group

      @ObjectModel: {
        foreignKey.association: '_PurchasingGroup',
        text.element: [ 'PurchasingGroupName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'CustOrgData', position: 40, importance: #HIGH}] //SupCustOrgData

      }
      PurchasingGroup,

      @UI.hidden:true
      @Semantics.text: true
      _PurchasingGroup.PurchasingGroupName,


      // Purchasing Organisation

      @ObjectModel: {
        foreignKey.association: '_PurchasingOrganization',
        text.element: [ 'PurchasingOrganizationName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'CustOrgData', position: 50, importance: #HIGH}] //CustOrgData

      }
      PurchasingOrganization,

      @UI.hidden:true
      @Semantics.text: true
      _PurchasingOrganization.PurchasingOrganizationName,


      // Company Code

      @ObjectModel: {
        text.element: [ 'CompanyCodeName' ]
      }
      @UI: {
        fieldGroup: [{qualifier: 'CustOrgData', position: 60, importance: #HIGH}] //CustOrgData

      }
      CompanyCode,

      @UI.hidden:true
      @Semantics.text: true
      _CompanyCode.CompanyCodeName,


      // PriorSupplier

      @UI.hidden: true
      Contract.PriorSupplier,

      /* Worker related fields */
      @Consumption.hidden: true
      Contract.PersonWorkAgreement,
      @Consumption.hidden: true
      Contract.CndnContrWorkerCostCenter,


      /*****************************
      * Associations
      ******************************/

      //      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

      //      _UserContactCard,

      _Division,
      _CndnContrType,
      _DistributionChannel,
      _SalesOrganization,
      _PurchasingGroup,
      _PurchasingOrganization,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _SettlmtCal,
      _Customer,
      _Supplier,
      _PriorSupplier,
      @Consumption.hidden: true
      _PersonWorkAgreement

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNDNCONTRISINACTIVE",
"I_CNDNCONTRISINACTIVETEXT",
"I_CNDNCONTRTYPE",
"I_CNDNCONTRTYPETEXT",
"I_COMPANYCODE",
"I_CONDITIONCONTRACT",
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_DISTRIBUTIONCHANNELTEXT",
"I_DIVISION",
"I_DIVISIONTEXT",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SALESORGANIZATION",
"I_SALESORGANIZATIONTEXT",
"I_SUPPLIER",
"I_USER"
],
"ASSOCIATED":
[
"C_CNDNCONTRWRKFLWSETTLMTCAL",
"I_CNDNCONTRTYPE",
"I_CUSTOMER",
"I_DISTRIBUTIONCHANNEL",
"I_DIVISION",
"I_PERSONWORKAGREEMENT_1",
"I_PURCHASINGGROUP",
"I_PURCHASINGORGANIZATION",
"I_SALESORGANIZATION",
"I_SUPPLIER"
],
"BASE":
[
"I_CONDITIONCONTRACT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/