Fields (56)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | BillingDocumentRequest | BillingDocumentRequest | 1 |
| KEY | CreditMemoRequest | CreditMemoRequest | 1 |
| KEY | PartnerFunction | PartnerFunction | 4 |
| KEY | SalesContract | SalesContract | 1 |
| KEY | SalesOrder | SalesOrder | 1 |
| KEY | SDDocPartnerSequenceNumber | SDDocPartnerSequenceNumber | 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 | |
| BusinessPartnerAddressUUID | BusinessPartnerAddressUUID | 1 | |
| CityName | CityName | 5 | |
| ContactPerson | ContactPerson | 6 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 5 | |
| Country | Country | 5 | |
| CreditMemoRequestType | CreditMemoRequestType | 1 | |
| Customer | Customer | 6 | |
| CustomerReturnType | CustomerReturnType | 1 | |
| DistributionChannel | DistributionChannel | 5 | |
| DistrictName | DistrictName | 5 | |
| EmailAddress | EmailAddress | 3 | |
| FormOfAddress | FormOfAddress | 3 | |
| FullName | FullName | 5 | |
| HouseNumber | HouseNumber | 5 | |
| InternationalFaxNumber | InternationalFaxNumber | 5 | |
| InternationalMobilePhoneNumber | InternationalMobilePhoneNumber | 3 | |
| InternationalPhoneNumber | InternationalPhoneNumber | 3 | |
| OrganizationDivision | OrganizationDivision | 5 | |
| Partner | Partner | 5 | |
| PartnerFunctionForEdit | PartnerFunctionForEdit | 5 | |
| Personnel | Personnel | 6 | |
| POBox | POBox | 5 | |
| POBoxPostalCode | POBoxPostalCode | 5 | |
| PostalCode | PostalCode | 5 | |
| ReferenceBusinessPartner | ReferenceBusinessPartner | 6 | |
| Region | Region | 5 | |
| SalesContractType | SalesContractType | 1 | |
| SalesOrderType | SalesOrderType | 1 | |
| SalesOrganization | SalesOrganization | 5 | |
| SalesQuotationType | SalesQuotationType | 1 | |
| SDDocPartnerAddrIsDocSpecific | SDDocPartnerAddrIsDocSpecific | 5 | |
| SDDocumentPartnerType | SDDocumentPartnerType | 5 | |
| StreetName | StreetName | 5 | |
| StreetPrefixName1 | StreetPrefixName1 | 5 | |
| StreetPrefixName2 | StreetPrefixName2 | 5 | |
| StreetSuffixName1 | StreetSuffixName1 | 5 | |
| StreetSuffixName2 | StreetSuffixName2 | 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 HEADERPARTNER (
BILLINGDOCUMENTREQUEST,
CREDITMEMOREQUEST,
PARTNERFUNCTION,
SALESCONTRACT,
SALESORDER,
SDDOCPARTNERSEQUENCENUMBER,
_CORRESPONDENCELANGUAGE,
_COUNTRY,
_FORMOFADDRESS,
_REGION,
_TRANSPORTATIONZONE,
ADDRESSID,
ADDRESSOBJECTTYPE,
ADDRESSPERSONID,
BUSINESSPARTNERADDRESSUUID,
CITYNAME,
CONTACTPERSON,
CORRESPONDENCELANGUAGE,
COUNTRY,
CREDITMEMOREQUESTTYPE,
CUSTOMER,
CUSTOMERRETURNTYPE,
DISTRIBUTIONCHANNEL,
DISTRICTNAME,
EMAILADDRESS,
FORMOFADDRESS,
FULLNAME,
HOUSENUMBER,
INTERNATIONALFAXNUMBER,
INTERNATIONALMOBILEPHONENUMBER,
INTERNATIONALPHONENUMBER,
ORGANIZATIONDIVISION,
PARTNER,
PARTNERFUNCTIONFOREDIT,
PERSONNEL,
POBOX,
POBOXPOSTALCODE,
POSTALCODE,
REFERENCEBUSINESSPARTNER,
REGION,
SALESCONTRACTTYPE,
SALESORDERTYPE,
SALESORGANIZATION,
SALESQUOTATIONTYPE,
SDDOCPARTNERADDRISDOCSPECIFIC,
SDDOCUMENTPARTNERTYPE,
STREETNAME,
STREETPREFIXNAME1,
STREETPREFIXNAME2,
STREETSUFFIXNAME1,
STREETSUFFIXNAME2,
SUPPLIER,
TAXJURISDICTION,
TRANSPORTZONE,
UNLOADINGPOINTNAME,
VATREGISTRATION,
PRIMARY KEY (BILLINGDOCUMENTREQUEST, CREDITMEMOREQUEST, PARTNERFUNCTION, SALESCONTRACT, SALESORDER, SDDOCPARTNERSEQUENCENUMBER)
);
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