C_DiffntAltvPyeAllwdSuplr

DDL: C_DIFFNTALTVPYEALLWDSUPLR SQL: CGRCALTVPYESUP Type: view CONSUMPTION

Supplier with payee in document enabled

C_DiffntAltvPyeAllwdSuplr is a Consumption CDS View that provides data about "Supplier with payee in document enabled" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 25 fields with key field Supplier.

1 data source(s) 25 fields

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName CGRCALTVPYESUP view
EndUserText.label Supplier with payee in document enabled view
VDM.viewType #CONSUMPTION view
OData.publish true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MASTER view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
SupplierName SupplierName
SupplierAccountGroup SupplierAccountGroup
CreatedByUser CreatedByUser
CreationDate CreationDate
IsOneTimeAccount IsOneTimeAccount
PostingIsBlocked PostingIsBlocked
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
CityName CityName
Country Country
PurchasingIsBlocked PurchasingIsBlocked
AlternativePayeeIsAllowed AlternativePayeeIsAllowed
DeletionIndicator DeletionIndicator
AuthorizationGroup AuthorizationGroup
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10 
@AbapCatalog.sqlViewName: 'CGRCALTVPYESUP'
@EndUserText.label: 'Supplier with payee in document enabled'
@VDM.viewType: #CONSUMPTION
@OData.publish: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Metadata.allowExtensions:true
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
define view C_DiffntAltvPyeAllwdSuplr as select from I_Supplier
{
  @Consumption.valueHelpDefinition: [{ entity:{ name: 'I_Supplier_VH', element:'Supplier' } }]
  key Supplier,
  @Semantics.text: true
  SupplierName,
  SupplierAccountGroup,
  @Semantics.user.createdBy: true
  CreatedByUser,
  @Semantics.systemDate.createdAt: true
  CreationDate,
  @Semantics.booleanIndicator: true
  IsOneTimeAccount,  
  PostingIsBlocked,
  @Semantics.booleanIndicator: true 
  IsBusinessPurposeCompleted,
  CityName,
  Country,
  PurchasingIsBlocked,
  AlternativePayeeIsAllowed,
  DeletionIndicator,
  AuthorizationGroup,
//added only for DCL check

  @Consumption.hidden:true
  @UI.hidden:true
  DataControllerSet,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController1,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController2,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController3,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController4,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController5,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController6,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController7,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController8,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController9,                                                                                                                                                                      
  @Consumption.hidden:true
  @UI.hidden:true
  DataController10                                                                                                                                                                           
}
where DeletionIndicator = ''
and AlternativePayeeIsAllowed = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More