SALESORDERITEMPARTNER

50 Fields

SALESORDERITEMPARTNER is an SAP database table in S/4HANA. It contains 50 fields.

Fields (50)

KeyField CDS FieldsUsed in Views
KEY PartnerFunction PartnerFunction 2
KEY SalesOrder SalesOrder 2
KEY SalesOrderItem SalesOrderItem 2
AddressID AddressID 1
AddressObjectType AddressObjectType 1
AddressPersonID AddressPersonID 1
CityName CityName 1
ContactPerson ContactPerson 2
Country Country 1
Customer Customer 2
DistributionChannel DistributionChannel 2
DistrictName DistrictName 1
EmailAddress EmailAddress 1
FaxNumber FaxNumber 1
FaxNumberCountry FaxNumberCountry 1
FaxNumberExtension FaxNumberExtension 1
FormOfAddress FormOfAddress 1
HouseNumber HouseNumber 1
InternationalFaxNumber InternationalFaxNumber 1
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 1
InternationalPhoneNumber InternationalPhoneNumber 1
MobilePhoneCountry MobilePhoneCountry 1
MobilePhoneNumber MobilePhoneNumber 1
OrganizationDivision OrganizationDivision 2
Partner Partner 1
PartnerFunctionForEdit PartnerFunctionForEdit 1
PartnerIsSpecificForSDDocItem PartnerIsSpecificForSDDocItem 2
Personnel Personnel 2
PhoneNumber PhoneNumber 1
PhoneNumberCountry PhoneNumberCountry 1
PhoneNumberExtension PhoneNumberExtension 1
POBox POBox 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
ReferenceBusinessPartner ReferenceBusinessPartner 2
Region Region 1
SalesOrderType SalesOrderType 2
SalesOrganization SalesOrganization 2
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 1
StreetName StreetName 1
StreetPrefixName1 StreetPrefixName1 1
StreetPrefixName2 StreetPrefixName2 1
StreetSuffixName1 StreetSuffixName1 1
StreetSuffixName2 StreetSuffixName2 1
Supplier Supplier 2
TaxJurisdiction TaxJurisdiction 1
TransportZone TransportZone 1
UnloadingPointName UnloadingPointName 1
VATRegistration VATRegistration 1
WorkAssignmentExternalID WorkAssignmentExternalID 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 SALESORDERITEMPARTNER (
    PARTNERFUNCTION,
    SALESORDER,
    SALESORDERITEM,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    CITYNAME,
    CONTACTPERSON,
    COUNTRY,
    CUSTOMER,
    DISTRIBUTIONCHANNEL,
    DISTRICTNAME,
    EMAILADDRESS,
    FAXNUMBER,
    FAXNUMBERCOUNTRY,
    FAXNUMBEREXTENSION,
    FORMOFADDRESS,
    HOUSENUMBER,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    MOBILEPHONECOUNTRY,
    MOBILEPHONENUMBER,
    ORGANIZATIONDIVISION,
    PARTNER,
    PARTNERFUNCTIONFOREDIT,
    PARTNERISSPECIFICFORSDDOCITEM,
    PERSONNEL,
    PHONENUMBER,
    PHONENUMBERCOUNTRY,
    PHONENUMBEREXTENSION,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    REFERENCEBUSINESSPARTNER,
    REGION,
    SALESORDERTYPE,
    SALESORGANIZATION,
    SDDOCPARTNERADDRISDOCSPECIFIC,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    SUPPLIER,
    TAXJURISDICTION,
    TRANSPORTZONE,
    UNLOADINGPOINTNAME,
    VATREGISTRATION,
    WORKASSIGNMENTEXTERNALID,
    PRIMARY KEY (PARTNERFUNCTION, SALESORDER, SALESORDERITEM)
);

Learn More