FAC_DART_Z3_VENDOR

DDL: FAC_DART_Z3_VENDOR SQL: FAC_DZVENDOR Type: view

Vendor Master Data

FAC_DART_Z3_VENDOR is a CDS View that provides data about "Vendor Master Data" in SAP S/4HANA. It reads from 3 data sources (I_SupplierCompany, I_Supplier, I_SupplierAccountGroup) and exposes 43 fields with key fields CompanyCode, Supplier.

3 data source(s) 43 fields

Data Sources (3)

SourceAliasJoin Type
I_SupplierCompany I_SupplierCompany from
I_Supplier Supplier left_outer
I_SupplierAccountGroup SupplierAccountGroup left_outer

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName FAC_DZVENDOR view
EndUserText.label Vendor Master Data view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SupplierCompany CompanyCode
KEY Supplier I_SupplierCompany Supplier
OrganizationBPName1 I_Supplier OrganizationBPName1
OrganizationBPName2 I_Supplier OrganizationBPName2
TaxNumber1 I_Supplier TaxNumber1
TaxNumber2 I_Supplier TaxNumber2
TradingPartner I_Supplier TradingPartner
StreetName
CityName
District
Region
Country
PostalCode
POBox
POBoxPostalCode
TaxJurisdiction I_Supplier TaxJurisdiction
AlternativePayeeAccountNumber I_Supplier AlternativePayeeAccountNumber
ReconciliationAccount I_SupplierCompany ReconciliationAccount
ClearCustomerSupplier I_SupplierCompany ClearCustomerSupplier
Customer I_Supplier Customer
IsOneTimeAccount I_Supplier IsOneTimeAccount
SupplierHeadOffice I_SupplierCompany SupplierHeadOffice
AddressID I_Supplier AddressID
Industry I_Supplier Industry
SupplierAccountGroup I_Supplier SupplierAccountGroup
AccountGroupName
PaymentTerms I_SupplierCompany PaymentTerms
CreationDate I_Supplier CreationDate
TaxNumberResponsible I_Supplier TaxNumberResponsible
CreatedByUser I_Supplier CreatedByUser
PaymentMethodsList I_SupplierCompany PaymentMethodsList
HouseNumber
HouseNumberSupplementText
BusinessPartnerName3
BusinessPartnerName4
AlternativePayeeIsAllowed I_Supplier AlternativePayeeIsAllowed
SuplrTaxAuthorityAccountNumber I_Supplier SuplrTaxAuthorityAccountNumber
_Supplier I_SupplierCompany _Supplier
AuthorizationGroup I_SupplierCompany AuthorizationGroup
IsBusinessPurposeCompleted I_SupplierCompany IsBusinessPurposeCompleted
PaymentMethodSupplement I_SupplierCompany PaymentMethodSupplement
SystemClient System Client
MinorityGroup I_SupplierCompany MinorityGroup 
@AbapCatalog.sqlViewName: 'FAC_DZVENDOR'
@EndUserText.label: 'Vendor Master Data'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@AbapCatalog.preserveKey: true
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
define view FAC_DART_Z3_VENDOR
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from    I_SupplierCompany
    left outer join I_Supplier             as Supplier             on I_SupplierCompany.Supplier = Supplier.Supplier
    left outer join I_SupplierAccountGroup as SupplierAccountGroup on Supplier.SupplierAccountGroup = SupplierAccountGroup.SupplierAccountGroup
{

  key I_SupplierCompany.CompanyCode,
  key I_SupplierCompany.Supplier,
      Supplier.OrganizationBPName1,
      Supplier.OrganizationBPName2,
      Supplier.TaxNumber1,
      Supplier.TaxNumber2,

      Supplier.TradingPartner,

      Supplier._StandardAddress.StreetName,
      Supplier._StandardAddress.CityName,
      Supplier._StandardAddress.District,
      Supplier._StandardAddress.Region,
      Supplier._StandardAddress.Country,
      Supplier._StandardAddress.PostalCode,
      Supplier._StandardAddress.POBox,
      Supplier._StandardAddress.POBoxPostalCode,

      Supplier.TaxJurisdiction,
      Supplier.AlternativePayeeAccountNumber,
      I_SupplierCompany.ReconciliationAccount,
      I_SupplierCompany.ClearCustomerSupplier,
      Supplier.Customer,
      Supplier.IsOneTimeAccount,
      I_SupplierCompany.SupplierHeadOffice,
      Supplier.AddressID,
      Supplier.Industry,
      Supplier.SupplierAccountGroup,
      SupplierAccountGroup._SupplierAccountGroupText[1: Language = $parameters.P_Language].AccountGroupName,
      I_SupplierCompany.PaymentTerms,
      Supplier.CreationDate,
      Supplier.TaxNumberResponsible,
      Supplier.CreatedByUser,
      I_SupplierCompany.PaymentMethodsList,
      Supplier._StandardAddress.HouseNumber,
      Supplier._StandardAddress.HouseNumberSupplementText,
      Supplier._StandardAddress.BusinessPartnerName3,
      Supplier._StandardAddress.BusinessPartnerName4,
      Supplier.AlternativePayeeIsAllowed,
      Supplier.SuplrTaxAuthorityAccountNumber,

      /*Add for auth check */
      I_SupplierCompany._Supplier,
      I_SupplierCompany.AuthorizationGroup,
      I_SupplierCompany.IsBusinessPurposeCompleted,
      I_SupplierCompany.PaymentMethodSupplement,

      @EndUserText.label: 'System Client'
      $session.client as SystemClient,
      I_SupplierCompany.MinorityGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_SUPPLIER",
"I_SUPPLIERACCOUNTGROUP",
"I_SUPPLIERACCOUNTGROUPTEXT",
"I_SUPPLIERCOMPANY"
],
"ASSOCIATED":
[
"I_SUPPLIER"
],
"BASE":
[
"I_SUPPLIERCOMPANY"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More