Retrieve vendor details.

View-Specific Information

Select

The connector uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The connector processes other filters client-side within the connector.

• SMVendorId supports the '=' comparison operator.

For example, the following query is processed server side:

SELECT * FROM VendorDetails WHERE SMVendorId = 'S123456'

Columns

Name	Type	References	Description
SMVendorId [KEY]	String	Vendors.SMVendorId	A unique ID that SAP Ariba assigns automatically.
InternalId	String		The internal identifier.
DisplayId	String		Display identifier.
IsBlocked	Bool		Indicator for whether the record is blocked.
Roles	String		Roles associated with the record.
Purposes	String		Purposes associated with the record.
Identifications	String		Identifications associated with the record.
BankAccounts	String		Bank accounts associated with the record.
TaxNumbers	String		Tax numbers associated with the record.
AddressData	String		Address data associated with the record.
CustomerInformation	String		Customer information associated with the record.
SupplierInformation	String		Supplier information associated with the record.
BpKeyMappings	String		Business partner key mappings.
BusinessPartnerType	String		Type of business partner.
BusinessPartnerGroupGroupTypeCode	String		Code for the type of business partner group.
BusinessPartnerGroupPrimaryGroupName	String		Primary name of the business partner group.
BusinessPartnerGroupPrimaryGroupNameScriptVariants	String		Script variants for the primary name of the business partner group.
BusinessPartnerGroupSecondaryGroupName	String		Secondary name of the business partner group.
BusinessPartnerGroupSecondaryGroupNameScriptVariants	String		Script variants for the secondary name of the business partner group.
GroupingCode	String		The vendor's grouping code.
LifecycleStatusCode	String		Code indicating the lifecycle status.
OrganizationFoundationDate	Date		Foundation date of the organization.
OrganizationLiquidationDate	Date		Liquidation date of the organization.
OrganizationTradingPartnerId	String		Trading partner identifier of the organization.
OrganizationGlobalLocationNumber	String		Global Location Number (GLN) of the organization.
OrganizationIndustries	String		Industries associated with the organization.
OrganizationLegalFormCode	String		Code for the legal form of the organization.
OrganizationNameDetailsNameFormat	String		Name format in the organization name details.
OrganizationNameDetailsFormattedPersonName	String		Formatted person name in the organization details.
OrganizationNameDetailsInitials	String		Initials associated with the organization name details.
OrganizationNameDetailsFirstName	String		First name in the name details of the organization.
OrganizationNameDetailsBirthName	String		Birth name in the organization name details.
OrganizationNameDetailsNickName	String		Nickname in the organization name details.
OrganizationNameDetailsMiddleName	String		Middle name in the name details of the organization.
OrganizationNameDetailsLastName	String		Last name in the name details of the organization.
OrganizationNameDetailsSecondLastName	String		Second last name in the name details of the organization.
OrganizationNameDetailsScriptVariants	String		Script variants in the organization name details.
OrganizationNameDetailsAcademicTitle	String		Academic title associated with the organization name details.
OrganizationNameDetailsAdditionalAcademicTitle	String		Additional academic title associated with the organization name details.
OrganizationNameDetailsNamePrefix	String		Name prefix used in the organization name details.
OrganizationNameDetailsAdditionalNamePrefix	String		Additional name prefix in the organization name details.
OrganizationNameDetailsNameSuffix	String		Name suffix in the organization name details.
OrganizationNameDetailsNameCountry	String		Country associated with the organization name details.
OrganizationNameDetailsFormattedOrgName	String		Formatted organization name details.
OrganizationNameDetailsFormattedOrgNameLine1	String		Line 1 of the formatted organization name details.
OrganizationNameDetailsFormattedOrgNameLine2	String		Line 2 of the formatted organization name details.
OrganizationNameDetailsFormattedOrgNameLine3	String		Line 3 of the formatted organization name details.
OrganizationNameDetailsFormattedOrgNameLine4	String		Line 4 of the formatted organization name details.
OrganizationNameDetailsFormOfAddressCode	String		Code representing the form of address for the organization name.
PersonEmployerName	String		The person's employer's name.
PersonBirthDate	Date		Birth date of the person.
PersonBirthplaceName	String		The birthplace name of the person.
PersonOccupationCode	String		The occupation code of the person.
PersonNationalityCode	String		Code for the nationality of the person.
PersonLanguageCode	String		Code for the language of the person.
PersonCorrespondenceLanguageCode	String		Code for the correspondence language of the person.
PersonGenderCode	String		Code for the gender of the person.
PersonMaritalStatusCode	String		The marital status code of the person.
PersonNameDetailsInitials	String		Initials in the name details of the person.
PersonNameDetailsFormattedPersonName	String		Formatted name details of the person.
PersonNameDetailsFirstName	String		First name in the name details of the person.
PersonNameDetailsMiddleName	String		Middle name in the name details of the person.
PersonNameDetailsLastName	String		Last name in the name details of the person.
PersonNameDetailsSecondLastName	String		Second last name in the name details of the person.
PersonNameDetailsScriptVariants	String		Script variants in the name details of the person.
PersonNameDetailsAcademicTitleCode	String		Academic title code in the name details of the person.
PersonNameDetailsAdditionalAcademicTitleCode	String		Additional academic title code in the name details of the person.
PersonNameDetailsNamePrefixCode	String		Prefix code in the name details of the person.
PersonNameDetailsAdditionalNamePrefixCode	String		Additional prefix code in the name details of the person.
PersonNameDetailsNameSuffixCode	String		Suffix code in the name details of the person.
PersonNameDetailsFormOfAddressCode	String		Code for the form of address in the name details of the person.
SearchTermsSearchTerm1	String		Search term 1 for the vendor.
SearchTermsSearchTerm2	String		Search term 2 for the vendor.