C_SalesQuotationTypeManageVH

DDL: C_SALESQUOTATIONTYPEMANAGEVH SQL: CSLSQUTTYMANVH Type: view CONSUMPTION Package: ODATA_SD_QUOTATION

Sales Quotation Types for Manage Sales Quotation

C_SalesQuotationTypeManageVH is a Consumption CDS View that provides data about "Sales Quotation Types for Manage Sales Quotation" in SAP S/4HANA. It reads from 1 data source (I_SDAllwdSlsDocTypeMnggSlsDoc) and exposes 3 fields with key field SalesQuotationType. It has 2 associations to related views. It is exposed through 1 OData service (UI_SALESQUOTATIONMANAGE). Part of development package ODATA_SD_QUOTATION.

1 data source(s) Exposed by 1 service(s) 3 fields

Data Sources (1)

SourceAliasJoin Type
I_SDAllwdSlsDocTypeMnggSlsDoc I_SDAllwdSlsDocTypeMnggSlsDoc from

Associations (2)

CardinalityTargetAliasCondition
[1] I_SalesDocumentType _SalesDocumentType $projection.SalesQuotationType = _SalesDocumentType.SalesDocumentType
[0..*] I_SalesDocumentTypeText _Text $projection.SalesQuotationType = _Text.SalesDocumentType

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName CSLSQUTTYMANVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.resultSet.sizeCategory #XS view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Sales Quotation Type view
UI.headerInfo.typeNamePlural Sales Quotation Types view
ObjectModel.representativeKey SalesQuotationType view
ObjectModel.dataCategory #VALUE_HELP view
Search.searchable true view
Consumption.valueHelpDefault.fetchValues #AUTOMATICALLY_WHEN_DISPLAYED view
EndUserText.label Sales Quotation Types for Manage Sales Quotation view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SALESQUOTATIONMANAGE UI_SALESQUOTATIONMANAGE V4 C1 NOT_RELEASED

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY SalesQuotationType
SalesDocumentTypeLangDepdnt
_Text _Text 
@AbapCatalog.sqlViewName: 'CSLSQUTTYMANVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType.dataClass: #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.resultSet.sizeCategory: #XS

//@Metadata.ignorePropagatedAnnotations: true


@VDM: {
  viewType: #CONSUMPTION
}

@UI.headerInfo:{
  typeName:       'Sales Quotation Type',
  typeNamePlural: 'Sales Quotation Types'
}

@ObjectModel.representativeKey: 'SalesQuotationType'
@ObjectModel.dataCategory: #VALUE_HELP

@Search.searchable: true
@Consumption.valueHelpDefault.fetchValues:#AUTOMATICALLY_WHEN_DISPLAYED

@EndUserText.label: 'Sales Quotation Types for Manage Sales Quotation'
define view C_SalesQuotationTypeManageVH
  as select from I_SDAllwdSlsDocTypeMnggSlsDoc

  association [1]    to I_SalesDocumentType     as _SalesDocumentType on $projection.SalesQuotationType = _SalesDocumentType.SalesDocumentType
  association [0..*] to I_SalesDocumentTypeText as _Text on $projection.SalesQuotationType = _Text.SalesDocumentType

{

      @Search.defaultSearchElement: true
      @UI.selectionField: [{exclude: true}]
      @ObjectModel.text.association: '_Text'
      @UI.textArrangement: #TEXT_FIRST
  key cast( SalesDocumentType as sales_quotation_type preserving type ) as SalesQuotationType,

      @Search.defaultSearchElement: true
      @UI.hidden: true
      _SalesDocumentType._SalesDocumentTypeLangDepdnt[1:Language=$session.system_language].SalesDocumentTypeLangDepdnt,

      _Text
}
where
      _SalesDocumentType.SDDocumentCategory            = 'B'          //Restrict only to sales quotation

  and _SalesDocumentType.IsLocked                      is initial     //Could have been locked in the meantime (after configuration)

  and _SalesDocumentType.NumberRangeForIntIDAssignment is not initial //Could have been changed in the meantime (after configuration)


//once this black-list is modified the lock method in cl_sd_behv_salestationmanage needs to be adjusted accordingly

//Currently we do not support external number range

Learn More