SUPPLIERDATA

32 Fields

SUPPLIERDATA is an SAP database table in S/4HANA. It contains 32 fields.

Fields (32)

KeyField CDS FieldsUsed in Views
AuthorizationGroup AuthorizationGroup 1
BPIsOrganization BusinessPartnerIsOrganization,PartnerIsOrganization 2
BPSupplierName BPSupplierName 1
BusinessPartner BusinessPartner 1
Country SupplierCountry 1
Customer Customer 1
DataController1 BP2DataController1 1
DataController2 BP2DataController2 1
DataController3 BP2DataController3 1
DataController4 BP2DataController4 1
DataController5 BP2DataController5 1
DataController6 BP2DataController6 1
DataController7 BP2DataController7 1
DataController8 BP2DataController8 1
DataController9 BP2DataController9 1
DataControllerSet BP2DataControllerSet 1
FirstName FirstName,PartnerPersonName 2
IsNaturalPerson BusinessPartnerIsNaturalPerson 1
LastName LastName,PartnerPersonSurname 2
MiddleName MiddleName,PartnerPersonMiddleName 2
RU_PartnerOrganizationINN RU_PartnerOrganizationINN 2
RU_PartnerOrganizationKPP RU_PartnerOrganizationKPP 1
RU_PartnerPersonINN RU_PartnerPersonINN 2
SuplrCoIsBusPrpsCmpltd SuplrCoIsBusPrpsCmpltd 3
Supplier Supplier 1
SupplierAccountGroup SupplierAccountGroup 3
SupplierCompanyAuthznGroup SupplierCompanyAuthznGroup 3
SupplierFinsAuthorizationGrp SupplierAuthznGrp,SupplierFinsAuthorizationGrp 3
SupplierIsBusPrpsCmpltd SupplierIsBusPrpsCmpltd 3
SupplierName RU_PartnerOrganizationName,SupplierName 4
TaxNumber1 TaxNumber1 1
TaxNumber3 TaxNumber3 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 SUPPLIERDATA (
    AUTHORIZATIONGROUP,
    BPISORGANIZATION,
    BPSUPPLIERNAME,
    BUSINESSPARTNER,
    COUNTRY,
    CUSTOMER,
    DATACONTROLLER1,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    FIRSTNAME,
    ISNATURALPERSON,
    LASTNAME,
    MIDDLENAME,
    RU_PARTNERORGANIZATIONINN,
    RU_PARTNERORGANIZATIONKPP,
    RU_PARTNERPERSONINN,
    SUPLRCOISBUSPRPSCMPLTD,
    SUPPLIER,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERCOMPANYAUTHZNGROUP,
    SUPPLIERFINSAUTHORIZATIONGRP,
    SUPPLIERISBUSPRPSCMPLTD,
    SUPPLIERNAME,
    TAXNUMBER1,
    TAXNUMBER3
);

Learn More