_SOLDTOPARTY

_SOLDTOPARTY is an SAP database table in S/4HANA. It contains 74 fields.

Fields (74)

KeyField CDS FieldsUsed in Views
KEY Product Product 1
KEY SoldToParty SoldToParty 1
_CustomerClassification _CustomerClassification 1
_GlobalCompany _GlobalCompany 2
AddressID AddressID,SoldToPartyAddressID 7
AlternativePayerAccount AlternativePayerAccount 2
AuthorizationGroup AuthorizationGroup 4
BillingIsBlockedForCustomer BillingIsBlockedForCustomer 2
BPCustomerName CustomerName 4
BusinessPartner BusinessPartner 1
BusinessPartnerFullName BusinessPartnerFullName,SoldToPartyName 5
BusinessPartnerName BusinessPartnerName,SoldToPartyName 15
CityName CityName 2
CompanyName SoldToPartyCompanyName 1
Country Country,SoldToPartyCountry 5
CreatedByUser SoldToPartyCreatedByUser 2
CreationDate SoldToPartyCreationDate 2
Customer Customer 1
CustomerAccountGroup CustomerAccountGroup 3
CustomerClassification CustomerClassification 4
CustomerCorporateGroup CustomerCorporateGroup 2
CustomerFullName CustomerFullName 4
CustomerName CustomerName,SoldToPartyName,SoldToPartyText 30
DataController1 DataController1 2
DataController10 DataController10 2
DataController2 DataController2 2
DataController3 DataController3 2
DataController4 DataController4 2
DataController5 DataController5 2
DataController6 DataController6 2
DataController7 DataController7 2
DataController8 DataController8 2
DataController9 DataController9 2
DataControllerSet DataControllerSet 2
DataMediumExchangeIndicator DataMediumExchangeIndicator 2
DeletionIndicator DeletionIndicator 2
DeliveryIsBlocked DeliveryIsBlocked 2
FirstName FirstName,SOLDTOFIRSTNAME,SOLDTOFNAME 12
FiscalAddress FiscalAddress 2
FullName CustomerName,SoldToPartyName 8
GroupBusinessPartnerName1 GroupBusinessPartnerName1 4
GroupBusinessPartnerName2 GroupBusinessPartnerName2 4
Industry Industry 2
IndustryCode1 IndustryCode1 2
IndustryCode2 IndustryCode2 2
IndustryCode3 IndustryCode3 2
IndustryCode4 IndustryCode4 2
IndustryCode5 IndustryCode5 2
InternationalLocationNumber1 InternationalLocationNumber1 2
IsBusinessPurposeCompleted IsBusinessPurposeCompleted,IsBusPrpsCmpltdCustomer 6
IsOneTimeAccount IsOneTimeAccount 2
Language Language 2
LastName LastName,SOLDTOLASTNAME,SOLDTOLNAME 12
NFPartnerIsNaturalPerson NFPartnerIsNaturalPerson 2
NielsenRegion NielsenRegion 2
OrderIsBlockedForCustomer OrderIsBlockedForCustomer 2
OrganizationBPName1 CustomerName,CustomerName_H,OrganizationBPName1,SOLDTOORGANIZATIONBPNAME1,SOLDTOORGFNAME,SoldToPartyName 53
OrganizationBPName2 OrganizationBPName2,SOLDTOORGANIZATIONBPNAME2,SOLDTOORGLNAME,SoldToPartyAdditionalName 49
PostalCode PostalCode 2
PostingIsBlocked PostingIsBlocked 2
Region SoldToPartyRegion 3
ResponsibleType ResponsibleType 2
StreetName StreetName 2
Supplier Supplier 2
TaxJurisdiction TaxJurisdiction 2
TaxNumber1 TaxNumber1 2
TaxNumber2 TaxNumber2 2
TaxNumber3 TaxNumber3 2
TaxNumber4 TaxNumber4 2
TaxNumber5 TaxNumber5 2
TaxNumberType TaxNumberType 2
TradingPartner PartnerCompany 1
VATLiability VATLiability 2
VATRegistration 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 _SOLDTOPARTY (
    PRODUCT,
    SOLDTOPARTY,
    _CUSTOMERCLASSIFICATION,
    _GLOBALCOMPANY,
    ADDRESSID,
    ALTERNATIVEPAYERACCOUNT,
    AUTHORIZATIONGROUP,
    BILLINGISBLOCKEDFORCUSTOMER,
    BPCUSTOMERNAME,
    BUSINESSPARTNER,
    BUSINESSPARTNERFULLNAME,
    BUSINESSPARTNERNAME,
    CITYNAME,
    COMPANYNAME,
    COUNTRY,
    CREATEDBYUSER,
    CREATIONDATE,
    CUSTOMER,
    CUSTOMERACCOUNTGROUP,
    CUSTOMERCLASSIFICATION,
    CUSTOMERCORPORATEGROUP,
    CUSTOMERFULLNAME,
    CUSTOMERNAME,
    DATACONTROLLER1,
    DATACONTROLLER10,
    DATACONTROLLER2,
    DATACONTROLLER3,
    DATACONTROLLER4,
    DATACONTROLLER5,
    DATACONTROLLER6,
    DATACONTROLLER7,
    DATACONTROLLER8,
    DATACONTROLLER9,
    DATACONTROLLERSET,
    DATAMEDIUMEXCHANGEINDICATOR,
    DELETIONINDICATOR,
    DELIVERYISBLOCKED,
    FIRSTNAME,
    FISCALADDRESS,
    FULLNAME,
    GROUPBUSINESSPARTNERNAME1,
    GROUPBUSINESSPARTNERNAME2,
    INDUSTRY,
    INDUSTRYCODE1,
    INDUSTRYCODE2,
    INDUSTRYCODE3,
    INDUSTRYCODE4,
    INDUSTRYCODE5,
    INTERNATIONALLOCATIONNUMBER1,
    ISBUSINESSPURPOSECOMPLETED,
    ISONETIMEACCOUNT,
    LANGUAGE,
    LASTNAME,
    NFPARTNERISNATURALPERSON,
    NIELSENREGION,
    ORDERISBLOCKEDFORCUSTOMER,
    ORGANIZATIONBPNAME1,
    ORGANIZATIONBPNAME2,
    POSTALCODE,
    POSTINGISBLOCKED,
    REGION,
    RESPONSIBLETYPE,
    STREETNAME,
    SUPPLIER,
    TAXJURISDICTION,
    TAXNUMBER1,
    TAXNUMBER2,
    TAXNUMBER3,
    TAXNUMBER4,
    TAXNUMBER5,
    TAXNUMBERTYPE,
    TRADINGPARTNER,
    VATLIABILITY,
    VATREGISTRATION,
    PRIMARY KEY (PRODUCT, SOLDTOPARTY)
);