C_SupplierVATRegistration

DDL: C_SUPPLIERVATREGISTRATION Type: view_entity CONSUMPTION

Supplier without VAT Registration

C_SupplierVATRegistration is a Consumption CDS View that provides data about "Supplier without VAT Registration" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 32 fields with key field Supplier. It has 1 association to related views.

1 data source(s) 32 fields

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Parameters (2)

NameTypeDefault
Country land1_gp
Region regio

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_DocNumberPerSupplier _DocNumberPerSupplier $projection.Supplier = _DocNumberPerSupplier.Supplier

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
OData.publish true view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Supplier without VAT Registration view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
SupplierName SupplierName
NumberOfDocuments _DocNumberPerSupplier NumberOfDocuments
PostingIsBlocked PostingIsBlocked
SupplierAccountGroup SupplierAccountGroup
CreatedByUser CreatedByUser
CreationDate CreationDate
IsOneTimeAccount IsOneTimeAccount
VATRegistration VATRegistration
Customer Customer
AddressID AddressID
Region Region
Country Country
OrganizationBPName1 OrganizationBPName1
OrganizationBPName2 OrganizationBPName2
CityName CityName
PostalCode PostalCode
StreetName StreetName
DeletionIndicator DeletionIndicator
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10 
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@OData.publish: true
@AccessControl.personalData.blocking: #REQUIRED
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'Supplier without VAT Registration'
define view entity C_SupplierVATRegistration

  --with parameters

  --Country:land1_gp,

  --Region:regio

  as select from I_Supplier

  association [0..1] to P_DocNumberPerSupplier as _DocNumberPerSupplier on $projection.Supplier = _DocNumberPerSupplier.Supplier

{


      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_Supplier_VH',
                     element: 'Supplier' }
        }]


  key Supplier,
      SupplierName,
      _DocNumberPerSupplier.NumberOfDocuments,
      PostingIsBlocked,
      SupplierAccountGroup,
      CreatedByUser,
      CreationDate,
      IsOneTimeAccount,
      VATRegistration,
      Customer,
      AddressID,
      Region,
      Country,
      OrganizationBPName1,
      OrganizationBPName2,
      CityName,
      PostalCode,
      StreetName,
      DeletionIndicator,
      AuthorizationGroup,
      IsBusinessPurposeCompleted,
      @UI.hidden: true
      @Consumption.filter.hidden: true      
      DataControllerSet,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController1,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController2,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController3,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController4,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController5,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController6,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController7,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController8,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController9,
      //added only for DCL check

      @UI.hidden: true
      @Consumption.filter.hidden: true
      DataController10
}

where
      VATRegistration                         = ''
  --and Region=$parameters.Region
  --and Country=$parameters.Country
  and _DocNumberPerSupplier.NumberOfDocuments is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_SUPPLIER",
"P_DOCNUMBERPERSUPPLIER"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More