A_Supplier

DDL: A_SUPPLIER SQL: ASUPPLIER Type: view BASIC Package: ODATA_MASTER_DATA_BP

Supplier

A_Supplier is a Basic CDS View that provides data about "Supplier" in SAP S/4HANA. It reads from 1 data source (I_Supplier) and exposes 53 fields with key field Supplier. It has 4 associations to related views. Part of development package ODATA_MASTER_DATA_BP.

Data Sources (1)

SourceAliasJoin Type
I_Supplier I_Supplier from

Associations (4)

CardinalityTargetAliasCondition
[0..1] E_Supplier _SupplierExtension $projection.Supplier = _SupplierExtension.Supplier
[0..*] A_SupplierCompany _SupplierCompany $projection.Supplier = _SupplierCompany.Supplier
[0..*] A_SupplierPurchasingOrg _SupplierPurchasingOrg $projection.Supplier = _SupplierPurchasingOrg.Supplier
[0..*] A_SupplierText _SupplierText $projection.Supplier = _SupplierText.Supplier

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ASUPPLIER view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Supplier view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.updateEnabled true view

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY Supplier Supplier
AlternativePayeeAccountNumber AlternativePayeeAccountNumber
AuthorizationGroup AuthorizationGroup
BusinessPartnerPanNumber BusinessPartnerPanNumber
CreatedByUser CreatedByUser
CreationDate CreationDate
Customer Customer
PaymentIsBlockedForSupplier PaymentIsBlockedForSupplier
PostingIsBlocked PostingIsBlocked
PurchasingIsBlocked PurchasingIsBlocked
SupplierAccountGroup SupplierAccountGroup
SupplierFullName SupplierFullName
SupplierName SupplierName
VATRegistration VATRegistration
BirthDate BirthDate
DeletionIndicator DeletionIndicator
FiscalAddress FiscalAddress
Industry Industry
InternationalLocationNumber1 InternationalLocationNumber1
InternationalLocationNumber2 InternationalLocationNumber2
InternationalLocationNumber3 InternationalLocationNumber3
IsNaturalPerson IsNaturalPerson
PaymentReason PaymentReason
ResponsibleType ResponsibleType
SuplrQltyInProcmtCertfnValidTo SuplrQltyInProcmtCertfnValidTo
SuplrQualityManagementSystem SuplrQualityManagementSystem
SupplierCorporateGroup SupplierCorporateGroup
SupplierProcurementBlock SupplierProcurementBlock
TaxNumber1 TaxNumber1
TaxNumber2 TaxNumber2
TaxNumber3 TaxNumber3
TaxNumber4 TaxNumber4
TaxNumber5 TaxNumber5
TaxNumberResponsible TaxNumberResponsible
TaxNumberType TaxNumberType
SuplrProofOfDelivRlvtCode SuplrProofOfDelivRlvtCode
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
BR_TaxIsSplit BR_TaxIsSplit
DataExchangeInstructionKey DataExchangeInstructionKey
DataControllerSet DataControllerSet
DataController1 DataController1
DataController2 DataController2
DataController3 DataController3
DataController4 DataController4
DataController5 DataController5
DataController6 DataController6
DataController7 DataController7
DataController8 DataController8
DataController9 DataController9
DataController10 DataController10
_SupplierCompany _SupplierCompany
_SupplierPurchasingOrg _SupplierPurchasingOrg
_SupplierText _SupplierText
@AbapCatalog.sqlViewName: 'ASUPPLIER'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck:#MANDATORY
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations:true
@EndUserText.label: 'Supplier'
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type:#PUBLIC_REMOTE_API
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #MASTER
//@ObjectModel.createEnabled:true

@ObjectModel.updateEnabled:true
//@ObjectModel.deleteEnabled:true

@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

define view A_Supplier as select from I_Supplier

  association [0..1] to E_Supplier as _SupplierExtension on $projection.Supplier = _SupplierExtension.Supplier

  association [0..*] to A_SupplierCompany as _SupplierCompany on $projection.Supplier = _SupplierCompany.Supplier

  association [0..*] to A_SupplierPurchasingOrg as _SupplierPurchasingOrg on $projection.Supplier = _SupplierPurchasingOrg.Supplier

  association [0..*] to A_SupplierText as _SupplierText on $projection.Supplier = _SupplierText.Supplier

{ 
  key Supplier,
      AlternativePayeeAccountNumber, 
      AuthorizationGroup, 
      BusinessPartnerPanNumber,
      @ObjectModel.readOnly: true
      CreatedByUser,
      @ObjectModel.readOnly: true 
      CreationDate, 
      Customer, 
      PaymentIsBlockedForSupplier, 
      PostingIsBlocked, 
      PurchasingIsBlocked,  
      SupplierAccountGroup, 
      @ObjectModel.readOnly: true 
      SupplierFullName,  
      @ObjectModel.readOnly: true
      SupplierName, 
      @ObjectModel.readOnly: true
      VATRegistration,
      BirthDate,  
      @ObjectModel.readOnly: true
      ConcatenatedInternationalLocNo, 
      DeletionIndicator, 
      FiscalAddress, 
      @ObjectModel.readOnly: true
      Industry, 
      @ObjectModel.readOnly: true
      InternationalLocationNumber1, 
      @ObjectModel.readOnly: true
      InternationalLocationNumber2,
      @ObjectModel.readOnly: true 
      InternationalLocationNumber3, 
      @ObjectModel.readOnly: true
      IsNaturalPerson,  
      PaymentReason,
      ResponsibleType, 
      SuplrQltyInProcmtCertfnValidTo, 
      SuplrQualityManagementSystem, 
      SupplierCorporateGroup, 
      SupplierProcurementBlock, 
      @ObjectModel.readOnly: true
      TaxNumber1, 
      @ObjectModel.readOnly: true
      TaxNumber2, 
      @ObjectModel.readOnly: true
      TaxNumber3, 
      @ObjectModel.readOnly: true
      TaxNumber4, 
      @ObjectModel.readOnly: true
      TaxNumber5, 
      TaxNumberResponsible, 
      TaxNumberType, 
      SuplrProofOfDelivRlvtCode,
      @Consumption.hidden: true
      IsBusinessPurposeCompleted,
      BR_TaxIsSplit,
      DataExchangeInstructionKey,
      @Consumption.hidden:true
      DataControllerSet,
      @Consumption.hidden:true
      DataController1,
      @Consumption.hidden:true
      DataController2,
      @Consumption.hidden:true
      DataController3,
      @Consumption.hidden:true
      DataController4,
      @Consumption.hidden:true
      DataController5,
      @Consumption.hidden:true
      DataController6,
      @Consumption.hidden:true
      DataController7,
      @Consumption.hidden:true
      DataController8,
      @Consumption.hidden:true
      DataController9,
      @Consumption.hidden:true
      DataController10,  
      _SupplierCompany,
      _SupplierPurchasingOrg,
      _SupplierText
}