P_SUPPLIER_FS

CDS View
35 Fields 1 CDS Views

P_SUPPLIER_FS is a CDS View in S/4HANA. It contains 35 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_Supplier_Fs view from CONSUMPTION Consumption Factsheet - Supplier Facet

Fields (35)

KeyField CDS FieldsUsed in Views
KEY Supplier Supplier 1
AccountGroupName AccountGroupName 1
AdditionalName AdditionalName 1
AddressID AddressID 1
BusinessPartner BusinessPartner 1
CountryName CountryName 1
DocumentKeyForUnitCnvrsn DocumentKeyForUnitCnvrsn 1
FaxNumber FaxNumber 1
InternationalFaxNumber InternationalFaxNumber 1
InternationalLocationNumber1 InternationalLocationNumber1 1
InternationalLocationNumber2 InternationalLocationNumber2 1
InternationalLocationNumber3 InternationalLocationNumber3 1
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 1
InternationalPhoneNumber InternationalPhoneNumber 1
Language Language 1
LocationTimeZone LocationTimeZone 1
Material Material 1
PhoneNumber2 PhoneNumber2 1
Plant Plant 1
PlantName PlantName 1
POBox POBox 1
PostalCode PostalCode 1
PostingIsBlocked PostingIsBlocked 1
PurchasingIsBlockedForSupplier PurchasingIsBlockedForSupplier 1
RegionName RegionName 1
RoleOwnerEmailAddress RoleOwnerEmailAddress 1
StreetAddressName StreetAddressName 1
SupplierAccountGroup SupplierAccountGroup 1
SupplierCityName SupplierCityName 1
SupplierIndustry SupplierIndustry 1
SupplierIndustryName SupplierIndustryName 1
SupplierName SupplierName 1
SupplierTaxID1 SupplierTaxID1 1
SupplierVATRegistration SupplierVATRegistration 1
UniformResourceLocator UniformResourceLocator 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 P_SUPPLIER_FS (
    SUPPLIER,
    ACCOUNTGROUPNAME,
    ADDITIONALNAME,
    ADDRESSID,
    BUSINESSPARTNER,
    COUNTRYNAME,
    DOCUMENTKEYFORUNITCNVRSN,
    FAXNUMBER,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALLOCATIONNUMBER1,
    INTERNATIONALLOCATIONNUMBER2,
    INTERNATIONALLOCATIONNUMBER3,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    LANGUAGE,
    LOCATIONTIMEZONE,
    MATERIAL,
    PHONENUMBER2,
    PLANT,
    PLANTNAME,
    POBOX,
    POSTALCODE,
    POSTINGISBLOCKED,
    PURCHASINGISBLOCKEDFORSUPPLIER,
    REGIONNAME,
    ROLEOWNEREMAILADDRESS,
    STREETADDRESSNAME,
    SUPPLIERACCOUNTGROUP,
    SUPPLIERCITYNAME,
    SUPPLIERINDUSTRY,
    SUPPLIERINDUSTRYNAME,
    SUPPLIERNAME,
    SUPPLIERTAXID1,
    SUPPLIERVATREGISTRATION,
    UNIFORMRESOURCELOCATOR,
    PRIMARY KEY (SUPPLIER)
);

Learn More