I_OCFormTemplate

DDL: I_OCFORMTEMPLATE SQL: IOCFORMTEMPLATE Type: view BASIC Package: APOC_OUTPUT_CONTROL_IMPL

Form Template

I_OCFormTemplate is a Basic CDS View that provides data about "Form Template" in SAP S/4HANA. It reads from 1 data source (apoc_c_form) and exposes 7 fields with key fields OutputControlApplObjectType, OutputDocumentType, FormType, FormTemplate. It has 3 associations to related views. It is exposed through 2 OData services (C_SALESORDERMANAGE_SD, UI_SLSORDERWITHOUTCHARGEMANAGE). Part of development package APOC_OUTPUT_CONTROL_IMPL.

Data Sources (1)

SourceAliasJoin Type
apoc_c_form apoc_c_form from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_OutputControlApplObjectType _OutputControlApplObjectType $projection.OutputControlApplObjectType = _OutputControlApplObjectType.OutputControlApplObjectType
[1..1] I_OutputControlOutputType _OutputControlOutputType $projection.OutputControlApplObjectType = _OutputControlOutputType.OutputControlApplObjectType and $projection.OutputDocumentType = _OutputControlOutputType.OutputDocumentType
[0..*] I_OCFormTemplateText _Text $projection.FormTemplate = _Text.FormTemplate

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IOCFORMTEMPLATE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
ObjectModel.representativeKey FormTemplate view
Search.searchable true view
EndUserText.label Form Template view

OData Services (2)

ServiceBindingVersionContractRelease
C_SALESORDERMANAGE_SD C_SALESORDERMANAGE_SRV V4 C1 NOT_RELEASED
UI_SLSORDERWITHOUTCHARGEMANAGE UI_SLSORDERWITHOUTCHARGEMANAGE V4 C1 NOT_RELEASED

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY OutputControlApplObjectType appl_obj_type
KEY OutputDocumentType output_type
KEY FormType form_type
KEY FormTemplate form_template_name
_OutputControlApplObjectType _OutputControlApplObjectType
_OutputControlOutputType _OutputControlOutputType
_Text _Text
@AbapCatalog.sqlViewName: 'IOCFORMTEMPLATE'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@ClientHandling.type: #INHERITED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
   usageType.serviceQuality: #A,
   usageType.sizeCategory: #S,
   usageType.dataClass: #META,
   representativeKey: 'FormTemplate'
}
@Search.searchable: true
@EndUserText.label: 'Form Template'
@UI.presentationVariant:[{sortOrder:[{by:'FormTemplate',direction:#DESC}]}]

define view I_OCFormTemplate
  as select from apoc_c_form
  association [0..1] to I_OutputControlApplObjectType as _OutputControlApplObjectType on  $projection.OutputControlApplObjectType = _OutputControlApplObjectType.OutputControlApplObjectType
  association [1..1] to I_OutputControlOutputType     as _OutputControlOutputType     on  $projection.OutputControlApplObjectType = _OutputControlOutputType.OutputControlApplObjectType
                                                                                      and $projection.OutputDocumentType          = _OutputControlOutputType.OutputDocumentType
  association [0..*] to I_OCFormTemplateText          as _Text                        on  $projection.FormTemplate                = _Text.FormTemplate
{
      @ObjectModel.foreignKey.association: '_OutputControlApplObjectType'
      @UI.hidden: true
  key appl_obj_type      as OutputControlApplObjectType,
  
      @ObjectModel.foreignKey.association: '_OutputControlOutputType'
      @UI.hidden: true
  key output_type        as OutputDocumentType,
  
      @UI.hidden: true
  key form_type          as FormType,
  
      @Search: { defaultSearchElement: true,
                 fuzzinessThreshold:   0.8,
                 ranking:              #HIGH }
      @ObjectModel.text.association: '_Text'                 
  key form_template_name as FormTemplate,
  
      //Association

      _OutputControlApplObjectType,
      _OutputControlOutputType,
      _Text      
}