Excel Add-In for SAP Ariba Source

Build 24.0.9060

VendorDetails

Retrieve vendor details.

View-Specific Information

Select

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

  • 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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060