ITEMPARTNER

56 Fields

ITEMPARTNER is an SAP database table in S/4HANA. It contains 56 fields.

Fields (56)

KeyField CDS FieldsUsed in Views
KEY CreditMemoRequest CreditMemoRequest 1
KEY CreditMemoRequestItem CreditMemoRequestItem 1
KEY CustomerReturn CustomerReturn 1
KEY CustomerReturnItem CustomerReturnItem 1
KEY PartnerFunction PartnerFunction 5
KEY SalesContract SalesContract 1
KEY SalesContractItem SalesContractItem 1
KEY SalesOrder SalesOrder 1
KEY SalesOrderItem SalesOrderItem 1
KEY SalesQuotation SalesQuotation 1
KEY SalesQuotationItem SalesQuotationItem 1
_CorrespondenceLanguage _CorrespondenceLanguage 5
_Country _Country 5
_FormOfAddress _FormOfAddress 5
_Region _Region 5
_TransportationZone _TransportationZone 5
AddressID AddressID 5
AddressObjectType AddressObjectType 5
AddressPersonID AddressPersonID 5
CityName CityName 5
ContactPerson ContactPerson 5
CorrespondenceLanguage CorrespondenceLanguage 5
Country Country 5
CreditMemoRequestType CreditMemoRequestType 1
Customer Customer 5
CustomerReturnType CustomerReturnType 1
DistributionChannel DistributionChannel 5
DistrictName DistrictName 5
EmailAddress EmailAddress 3
FormOfAddress FormOfAddress 3
FullName FullName 5
HouseNumber HouseNumber 5
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 3
InternationalPhoneNumber InternationalPhoneNumber 3
OrganizationDivision OrganizationDivision 5
Partner Partner 5
PartnerFunctionForEdit PartnerFunctionForEdit 5
PartnerIsSpecificForSDDocItem PartnerIsSpecificForSDDocItem 5
Personnel Personnel 5
POBox POBox 5
POBoxPostalCode POBoxPostalCode 5
PostalCode PostalCode 5
ReferenceBusinessPartner ReferenceBusinessPartner 5
Region Region 5
SalesContractType SalesContractType 1
SalesOrderType SalesOrderType 1
SalesOrganization SalesOrganization 5
SalesQuotationType SalesQuotationType 1
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 5
SDDocumentPartnerType SDDocumentPartnerType 5
StreetName StreetName 5
Supplier Supplier 5
TaxJurisdiction TaxJurisdiction 5
TransportZone TransportZone 5
UnloadingPointName UnloadingPointName 5
VATRegistration VATRegistration 5

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 ITEMPARTNER (
    CREDITMEMOREQUEST,
    CREDITMEMOREQUESTITEM,
    CUSTOMERRETURN,
    CUSTOMERRETURNITEM,
    PARTNERFUNCTION,
    SALESCONTRACT,
    SALESCONTRACTITEM,
    SALESORDER,
    SALESORDERITEM,
    SALESQUOTATION,
    SALESQUOTATIONITEM,
    _CORRESPONDENCELANGUAGE,
    _COUNTRY,
    _FORMOFADDRESS,
    _REGION,
    _TRANSPORTATIONZONE,
    ADDRESSID,
    ADDRESSOBJECTTYPE,
    ADDRESSPERSONID,
    CITYNAME,
    CONTACTPERSON,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    CREDITMEMOREQUESTTYPE,
    CUSTOMER,
    CUSTOMERRETURNTYPE,
    DISTRIBUTIONCHANNEL,
    DISTRICTNAME,
    EMAILADDRESS,
    FORMOFADDRESS,
    FULLNAME,
    HOUSENUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    ORGANIZATIONDIVISION,
    PARTNER,
    PARTNERFUNCTIONFOREDIT,
    PARTNERISSPECIFICFORSDDOCITEM,
    PERSONNEL,
    POBOX,
    POBOXPOSTALCODE,
    POSTALCODE,
    REFERENCEBUSINESSPARTNER,
    REGION,
    SALESCONTRACTTYPE,
    SALESORDERTYPE,
    SALESORGANIZATION,
    SALESQUOTATIONTYPE,
    SDDOCPARTNERADDRISDOCSPECIFIC,
    SDDOCUMENTPARTNERTYPE,
    STREETNAME,
    SUPPLIER,
    TAXJURISDICTION,
    TRANSPORTZONE,
    UNLOADINGPOINTNAME,
    VATREGISTRATION,
    PRIMARY KEY (CREDITMEMOREQUEST, CREDITMEMOREQUESTITEM, CUSTOMERRETURN, CUSTOMERRETURNITEM, PARTNERFUNCTION, SALESCONTRACT, SALESCONTRACTITEM, SALESORDER, SALESORDERITEM, SALESQUOTATION, SALESQUOTATIONITEM)
);

Learn More