SUPPLIER

54 Fields

SUPPLIER is an SAP database table in S/4HANA. It contains 54 fields.

Fields (54)

KeyField CDS FieldsUsed in Views
KEY AccountingDocument AccountingDocument 5
KEY CompanyCode CompanyCode 5
KEY Creditor Creditor 3
KEY FiscalYear FiscalYear 3
KEY LedgerGLLineItem LedgerGLLineItem 2
KEY MasterProject MasterProject 1
KEY Supplier Supplier 12
_CompanyCode _CompanyCode 2
_Supplier _Supplier 2
_SupplierText _SupplierText 1
AccountingDocumentType AccountingDocumentType 2
AuthorizationGroup AuthorizationGroup,SupplierAuthznGrp 6
BankAccount BankAccount 1
BankNumber BankNumber 1
BusinessPartner BusinessPartner 2
BusinessPartnerUUID BusinessPartnerUUID 2
CityName CityName 1
company_name supplier_name 1
CompanyCodeCurrency CompanyCodeCurrency 2
CostCenterAmount1 CostCenterAmount1 1
Country Country 4
Customer Customer 1
DataController1 DataController1 4
DataController10 DataController10 4
DataController2 DataController2 4
DataController3 DataController3 4
DataController4 DataController4 4
DataController5 DataController5 4
DataController6 DataController6 4
DataController7 DataController7 4
DataController8 DataController8 4
DataController9 DataController9 4
DataControllerSet DataControllerSet 4
DeletionIndicator DeletionIndicator 1
HouseNumber HouseNumber 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted 5
IsOneTimeAccount IsOneTimeAccount 2
NO_SAFTSupplierID NO_SAFTSupplierID 2
OrganizationBPName1 OrganizationBPName1 1
OrganizationBPName2 OrganizationBPName2 1
POBox POBox 2
POBoxPostalCode POBoxPostalCode 2
PostalCode PostalCode 1
PostingDate PostingDate 2
PurchasingGroup PurchasingGroup 1
PurchasingOrganization PurchasingOrganization 1
Region Region 2
RegionName RegionName 2
SupplierAccountGroup SupplierAccountGroup 4
SupplierAmount SupplierAmount 2
SupplierName SupplierName 5
TaxNumber1 TaxNumber1 2
TaxNumber2 TaxNumber2 2
VATRegistration SupplierVATRegistration,VATRegistration 2

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 (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    CREDITOR,
    FISCALYEAR,
    LEDGERGLLINEITEM,
    MASTERPROJECT,
    SUPPLIER,
    _COMPANYCODE,
    _SUPPLIER,
    _SUPPLIERTEXT,
    ACCOUNTINGDOCUMENTTYPE,
    AUTHORIZATIONGROUP,
    BANKACCOUNT,
    BANKNUMBER,
    BUSINESSPARTNER,
    BUSINESSPARTNERUUID,
    CITYNAME,
    COMPANY_NAME,
    COMPANYCODECURRENCY,
    COSTCENTERAMOUNT1,
    COUNTRY,
    CUSTOMER,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DELETIONINDICATOR,
    HOUSENUMBER,
    ISBUSINESSPURPOSECOMPLETED,
    ISONETIMEACCOUNT,
    NO_SAFTSUPPLIERID,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    POSTINGDATE,
    PURCHASINGGROUP,
    PURCHASINGORGANIZATION,
    REGION,
    REGIONNAME,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERAMOUNT,
    SUPPLIERNAME,
    TAXNUMBER1,
    TAXNUMBER2,
    VATREGISTRATION,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, CREDITOR, FISCALYEAR, LEDGERGLLINEITEM, MASTERPROJECT, SUPPLIER)
);

Learn More