ITEMPARTNER

70 Fields

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

Fields (70)

KeyField CDS FieldsUsed in Views
KEY BillingDocument BillingDocument 1
KEY BillingDocumentItem BillingDocumentItem 1
KEY BillingDocumentRequest BillingDocumentRequest 2
KEY BillingDocumentRequestItem BillingDocumentRequestItem 2
KEY CreditMemoRequest CreditMemoRequest 1
KEY CreditMemoRequestItem CreditMemoRequestItem 1
KEY CustomerReturn CustomerReturn 1
KEY CustomerReturnItem CustomerReturnItem 1
KEY DebitMemoRequest DebitMemoRequest 1
KEY DebitMemoRequestItem DebitMemoRequestItem 1
KEY PartnerFunction PartnerFunction 9
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 6
_Country _Country 6
_FormOfAddress _FormOfAddress 6
_Region _Region 6
_TransportationZone _TransportationZone 6
AddressID AddressID 6
AddressObjectType AddressObjectType 6
AddressPersonID AddressPersonID 6
BusinessPartnerAddressUUID BusinessPartnerAddressUUID 3
CityName CityName 6
ContactPerson ContactPerson 9
CorrespondenceLanguage CorrespondenceLanguage 6
Country Country 6
CreditMemoRequestType CreditMemoRequestType 1
Customer Customer 9
CustomerReturnType CustomerReturnType 1
DebitMemoRequestType DebitMemoRequestType 1
DistributionChannel DistributionChannel 6
DistrictName DistrictName 6
EmailAddress EmailAddress 4
FormOfAddress FormOfAddress 4
FullName FullName 6
HouseNumber HouseNumber 6
InternationalFaxNumber InternationalFaxNumber 1
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 4
InternationalPhoneNumber InternationalPhoneNumber 4
OrganizationDivision OrganizationDivision 6
Partner Partner 6
PartnerFunctionForEdit PartnerFunctionForEdit 6
PartnerIsOneTimeAccount PartnerIsOneTimeAccount 1
PartnerIsSpecificForSDDocItem PartnerIsSpecificForSDDocItem 9
Personnel Personnel 9
POBox POBox 6
POBoxPostalCode POBoxPostalCode 6
PostalCode PostalCode 6
ReferenceBusinessPartner ReferenceBusinessPartner 9
Region Region 6
SalesContractType SalesContractType 1
SalesOrderType SalesOrderType 1
SalesOrganization SalesOrganization 6
SalesQuotationType SalesQuotationType 1
SDDocPartnerAddrIsDocSpecific SDDocPartnerAddrIsDocSpecific 6
SDDocumentPartnerType SDDocumentPartnerType 6
StreetName StreetName 6
StreetPrefixName1 StreetPrefixName1 1
StreetPrefixName2 StreetPrefixName2 1
StreetSuffixName1 StreetSuffixName1 1
StreetSuffixName2 StreetSuffixName2 1
Supplier Supplier 9
TaxJurisdiction TaxJurisdiction 6
TransportZone TransportZone 6
UnloadingPointName UnloadingPointName 6
VATRegistration VATRegistration 6

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

Learn More