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