Fields (74)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA