FAC_DART_Z3_VENDOR

DDL: FAC_DART_Z3_VENDOR SQL: FAC_DZVENDOR Type: view
43 Fields 3 Data Sources

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.

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 Receiver Company Code
KEY Supplier I_SupplierCompany Supplier Supplier
OrganizationBPName1 I_Supplier OrganizationBPName1 Name 1
OrganizationBPName2 I_Supplier OrganizationBPName2 Name 2
TaxNumber1 I_Supplier TaxNumber1 VAT Reg. No.
TaxNumber2 I_Supplier TaxNumber2 Tax Number 2
TradingPartner I_Supplier TradingPartner Trading Partner
StreetName
CityName
District
Region
Country
PostalCode
POBox
POBoxPostalCode
TaxJurisdiction I_Supplier TaxJurisdiction Tax Jurisdiction
AlternativePayeeAccountNumber I_Supplier AlternativePayeeAccountNumber Alternat. Payee
ReconciliationAccount I_SupplierCompany ReconciliationAccount Recon. account
ClearCustomerSupplier I_SupplierCompany ClearCustomerSupplier Clrg with Cust.
Customer I_Supplier Customer Sold-to Party
IsOneTimeAccount I_Supplier IsOneTimeAccount One-time acct
SupplierHeadOffice I_SupplierCompany SupplierHeadOffice Head Office
AddressID I_Supplier AddressID Ship-to address
Industry I_Supplier Industry Industry Sector
SupplierAccountGroup I_Supplier SupplierAccountGroup Account group
AccountGroupName
PaymentTerms I_SupplierCompany PaymentTerms Pyt Terms
CreationDate I_Supplier CreationDate Time Stamp
TaxNumberResponsible I_Supplier TaxNumberResponsible
CreatedByUser I_Supplier CreatedByUser User Name
PaymentMethodsList I_SupplierCompany PaymentMethodsList Payment Methods
HouseNumber
HouseNumberSupplementText
BusinessPartnerName3
BusinessPartnerName4
AlternativePayeeIsAllowed I_Supplier AlternativePayeeIsAllowed Payee in doc.
SuplrTaxAuthorityAccountNumber I_Supplier SuplrTaxAuthorityAccountNumber Tax Office
_Supplier I_SupplierCompany _Supplier
AuthorizationGroup I_SupplierCompany AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_SupplierCompany IsBusinessPurposeCompleted Purpose Completed
PaymentMethodSupplement I_SupplierCompany PaymentMethodSupplement Pmnt Meth. Sup.
SystemClient System Client
MinorityGroup I_SupplierCompany MinorityGroup Minority Indic.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view FAC_DART_Z3_VENDOR.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: FAC_DZVENDOR
-- Parameters: P_Language : sylangu

CREATE VIEW FAC_DART_Z3_VENDOR AS
SELECT
  I_SupplierCompany.CompanyCode AS CompanyCode,
  I_SupplierCompany.Supplier AS Supplier,
  Supplier.OrganizationBPName1 AS OrganizationBPName1,
  Supplier.OrganizationBPName2 AS OrganizationBPName2,
  Supplier.TaxNumber1 AS TaxNumber1,
  Supplier.TaxNumber2 AS TaxNumber2,
  Supplier.TradingPartner AS TradingPartner,
  Supplier._StandardAddress.StreetName AS StreetName,
  Supplier._StandardAddress.CityName AS CityName,
  Supplier._StandardAddress.District AS District,
  Supplier._StandardAddress.Region AS Region,
  Supplier._StandardAddress.Country AS Country,
  Supplier._StandardAddress.PostalCode AS PostalCode,
  Supplier._StandardAddress.POBox AS POBox,
  Supplier._StandardAddress.POBoxPostalCode AS POBoxPostalCode,
  Supplier.TaxJurisdiction AS TaxJurisdiction,
  Supplier.AlternativePayeeAccountNumber AS AlternativePayeeAccountNumber,
  I_SupplierCompany.ReconciliationAccount AS ReconciliationAccount,
  I_SupplierCompany.ClearCustomerSupplier AS ClearCustomerSupplier,
  Supplier.Customer AS Customer,
  Supplier.IsOneTimeAccount AS IsOneTimeAccount,
  I_SupplierCompany.SupplierHeadOffice AS SupplierHeadOffice,
  Supplier.AddressID AS AddressID,
  Supplier.Industry AS Industry,
  Supplier.SupplierAccountGroup AS SupplierAccountGroup,
  SupplierAccountGroup._SupplierAccountGroupText[1: Language = $parameters.P_Language].AccountGroupName AS AccountGroupName,
  I_SupplierCompany.PaymentTerms AS PaymentTerms,
  Supplier.CreationDate AS CreationDate,
  Supplier.TaxNumberResponsible AS TaxNumberResponsible,
  Supplier.CreatedByUser AS CreatedByUser,
  I_SupplierCompany.PaymentMethodsList AS PaymentMethodsList,
  Supplier._StandardAddress.HouseNumber AS HouseNumber,
  Supplier._StandardAddress.HouseNumberSupplementText AS HouseNumberSupplementText,
  Supplier._StandardAddress.BusinessPartnerName3 AS BusinessPartnerName3,
  Supplier._StandardAddress.BusinessPartnerName4 AS BusinessPartnerName4,
  Supplier.AlternativePayeeIsAllowed AS AlternativePayeeIsAllowed,
  Supplier.SuplrTaxAuthorityAccountNumber AS SuplrTaxAuthorityAccountNumber,
  I_SupplierCompany._Supplier AS _Supplier,
  I_SupplierCompany.AuthorizationGroup AS AuthorizationGroup,
  I_SupplierCompany.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_SupplierCompany.PaymentMethodSupplement AS PaymentMethodSupplement,
  $session.client AS SystemClient,
  I_SupplierCompany.MinorityGroup AS MinorityGroup
FROM I_SupplierCompany
LEFT OUTER JOIN I_Supplier AS Supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierAccountGroup AS SupplierAccountGroup ON /* join condition not captured in parsed metadata */
;

Learn More