_SUPPLIER

80 Fields

_SUPPLIER is an SAP database table in S/4HANA. It contains 80 fields.

Fields (80)

KeyField CDS FieldsUsed in Views
KEY AuthorizationGroup AUTHGRPSUPPLIER,AuthorizationGroup,begru,SUPPLIERAUTHORIZATIONGROUP,SupplierAuthznGrp,SupplierBasicAuthorizationGrp,SupplierCompanyAuthznGroup,SupplierFinsAuthorizationGrp 94
KEY CompanyCode CompanyCode 1
KEY Supplier AssetSupplier,FixedSupplier,Supplier 25
KEY SupplierAccountGroup SupplierAccountGroup 71
_SupplierAccountGroup _SupplierAccountGroup 1
_SupplierAccountGroupText _SupplierAccountGroupText 1
_SupplierToBusinessPartner _SupplierToBusinessPartner 1
AccountingClerkEmailAddress SupplierClerkEmailAddress 1
AccountIsBlockedForPosting AccountIsBlockedForPosting 2
AddressID AddressID,SupplierAddressID 9
AlternativePayeeAccountNumber lnrza 1
AlternativePayeeIsAllowed AlternativePayeeIsAllowed 3
BirthDate BirthDate 2
BPAddrCityName BPAddrCityName 1
BPAddrStreetName BPAddrStreetName 1
BPSupplierFullName BPSupplierFullName,SupplierFullName,SupplierName 12
BPSupplierName BPSupplierName,InvoicingPartyName,SupplierName 35
BusinessPartnerName1 BPSupplierName,BusinessPartnerName1,OrganizationBPName1,SupplierName 7
BusinessPartnerName2 BusinessPartnerName2,OrganizationBPName2 3
CityName CityName 22
CompanyName SupplierCompanyName,SupplierName,SupplierT 5
Country BusinessPartnerCountry,Country,ShipToPartyCountry,SupplierCountry 38
CreatedByUser CreatedByUser,SupplierCreatedByUser 11
CreationDate CreationDate,SupplierCreationDate 14
Customer Customer,ShipToParty 8
DataController1 DataController1 17
DataController10 DataController10 17
DataController2 DataController2 17
DataController3 DataController3 17
DataController4 DataController4 17
DataController5 DataController5 17
DataController6 DataController6 17
DataController7 DataController7 17
DataController8 DataController8 17
DataController9 DataController9 17
DataControllerSet DataControllerSet 21
DeletionIndicator DeletionIndicator 3
EvaldReceiptSettlementIsActive EvaldReceiptSettlementIsActive 1
FaxNumber FaxNumber 1
FullName SupplierName 1
Industry Industry,SupplierIndustry 6
IsBusinessPurposeCompleted IsBusinessPurposeCompleted,IsEndOfPurposeBlocked,PURPOSECOMPLETEDSUPPLIER,SupplierIsBusPrpsCmpltd 31
IsNaturalPerson IsNaturalPerson 1
IsOneTimeAccount IsOneTimeAccount,OneTimeVendor,SupplierIsOneTimeAccount 13
name1 SupplierName 1
OrganizationBPName1 FIXEDSUPPLIERNAME,Name,OrganizationBPName1,PreferredSupplierName,SUPPLIER_NAME,SupplierName,SupplierName_H,SupplierSearchText 40
OrganizationBPName2 AdditionalName,OrganizationBPName2,SupplierAdditionalName 11
PaymentIsBlockedForSupplier PaymentIsBlockedForSupplier 6
PaymentReason PaymentReason 2
PhoneNumber1 ContactPersonPhoneNumber,SupplierPhoneNumber 4
PostalCode PostalCode 10
PostingIsBlocked PostingIsBlocked,PostingIsBlockedForSupplier 7
ProcmtHubSupplierName SupplierName 1
PurchasingIsBlocked PurchasingIsBlocked 5
Region Region 22
ResponsibleType ResponsibleType 3
SortField SearchTerm,SupplierSearchText 2
StreetName StreetName 5
SuplrProofOfDelivRlvtCode SuplrProofOfDelivRlvtCode 3
SuplrQltyInProcmtCertfnValidTo SuplrQltyInProcmtCertfnValidTo 2
SuplrQualityManagementSystem SuplrQualityManagementSystem 5
supplier_name name1_lfa1 2
SupplierCorporateGroup SupplierCorporateGroup 6
SupplierFullName SupplierFullName 15
SupplierIsPlantRelevant SupplierIsPlantRelevant 3
SupplierIsSubRangeRelevant SupplierIsSubRangeRelevant 3
SupplierLanguage SupplierLanguage 1
SupplierName AssetSupplierName,ContactPersonName,InvoicingPartyName,PreferredSupplierName,SubcontractorName,SupplierName 263
SupplierPlant SupplierPlant 1
SupplierProcurementBlock SupplierProcurementBlock 5
TaxJurisdiction SupplierTaxJurisdiction 1
TaxNumber1 SupplierTaxID1,TaxNumber1 3
TaxNumber2 SupplierTaxID2,TaxNumber2 3
TaxNumber3 SupplierTaxID3,TaxNumber3 2
TaxNumber4 SupplierTaxID4,TaxNumber4 2
TaxNumber5 SupplierTaxID5,SupplierVATRegistration,TaxNumber5 4
TaxNumber6 TaxNumber6 1
VATRegistration AuthorizationGroup,SupplierVATRegistration,VATRegistration 9
vendor_begru vend_owner_begru,vendor_begru 9
xdcset DataControllerSet 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SUPPLIER (
    AUTHORIZATIONGROUP,
    COMPANYCODE,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    _SUPPLIERACCOUNTGROUP,
    _SUPPLIERACCOUNTGROUPTEXT,
    _SUPPLIERTOBUSINESSPARTNER,
    ACCOUNTINGCLERKEMAILADDRESS,
    ACCOUNTISBLOCKEDFORPOSTING,
    ADDRESSID,
    ALTERNATIVEPAYEEACCOUNTNUMBER,
    ALTERNATIVEPAYEEISALLOWED,
    BIRTHDATE,
    BPADDRCITYNAME,
    BPADDRSTREETNAME,
    BPSUPPLIERFULLNAME,
    BPSUPPLIERNAME,
    BUSINESSPARTNERNAME1,
    BUSINESSPARTNERNAME2,
    CITYNAME,
    COMPANYNAME,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DELETIONINDICATOR,
    EVALDRECEIPTSETTLEMENTISACTIVE,
    FAXNUMBER,
    FULLNAME,
    INDUSTRY,
    ISBUSINESSPURPOSECOMPLETED,
    ISNATURALPERSON,
    ISONETIMEACCOUNT,
    NAME1,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    PAYMENTISBLOCKEDFORSUPPLIER,
    PAYMENTREASON,
    PHONENUMBER1,
    POSTALCODE,
    POSTINGISBLOCKED,
    PROCMTHUBSUPPLIERNAME,
    PURCHASINGISBLOCKED,
    REGION,
    RESPONSIBLETYPE,
    SORTFIELD,
    STREETNAME,
    SUPLRPROOFOFDELIVRLVTCODE,
    SUPLRQLTYINPROCMTCERTFNVALIDTO,
    SUPLRQUALITYMANAGEMENTSYSTEM,
    SUPPLIER_NAME,
    SUPPLIERCORPORATEGROUP,
    SUPPLIERFULLNAME,
    SUPPLIERISPLANTRELEVANT,
    SUPPLIERISSUBRANGERELEVANT,
    SUPPLIERLANGUAGE,
    SUPPLIERNAME,
    SUPPLIERPLANT,
    SUPPLIERPROCUREMENTBLOCK,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBER6,
    VATREGISTRATION,
    VENDOR_BEGRU,
    XDCSET,
    PRIMARY KEY (AUTHORIZATIONGROUP, COMPANYCODE, SUPPLIER, SUPPLIERACCOUNTGROUP)
);

Learn More