I_SRVCDOCPARTNERADDRESS
Service Transaction Partner Address
I_SRVCDOCPARTNERADDRESS is a CDS View in S/4HANA. Service Transaction Partner Address. It contains 37 fields. 10 CDS views read from this table.
CDS Views using this table (10)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_InhRepairItmPartnerAddressTP | view_entity | from | TRANSACTIONAL | Partner Addr for In-House Serv Obj - TP |
| R_InhRepairPartnerAddressTP | view_entity | from | TRANSACTIONAL | Partner Address For In-House Serv - TP |
| R_SrvcConfItemPartnerAddressTP | view_entity | from | TRANSACTIONAL | Partner Address For Service Conf Item |
| R_SrvcConfPartnerAddressTP | view_entity | from | TRANSACTIONAL | Partner Address For Service Confirmation |
| R_SrvcOrdItemPartnerAddressTP | view_entity | from | TRANSACTIONAL | Partner Address For Service Order Item |
| R_SrvcOrdPartnerAddressTP | view_entity | from | TRANSACTIONAL | Partner Address For Service Order - TP |
| R_SrvcOrdTmplItmPrtnAddressTP | view_entity | from | TRANSACTIONAL | Partner Address For SrvcOrd TmplItm - TP |
| R_SrvcOrdTmplPartnerAddressTP | view_entity | from | TRANSACTIONAL | Partner Address For Srvc Ord Tmpl - TP |
| R_SrvcQtanItemPartnerAddressTP | view_entity | inner | TRANSACTIONAL | Partner Addr of Srvc Qtan Item - TP |
| R_SrvcQtanPartnerAddressTP | view_entity | inner | TRANSACTIONAL | Partner Address of Srvc Quotation - TP |
Fields (37)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CustMgmtBusinessPartner | CustMgmtBusinessPartner | 4 |
| KEY | CustMgmtPartnerFunction | CustMgmtPartnerFunction | 4 |
| KEY | ServiceDocument | ServiceOrderTemplate | 2 |
| KEY | ServiceDocumentItem | ServiceOrderTemplateItem | 1 |
| AddresseeFullName | AddresseeFullName | 4 | |
| CityName | CityName | 4 | |
| CorrespondenceLanguage | CorrespondenceLanguage | 4 | |
| Country | Country | 4 | |
| DistrictName | DistrictName | 4 | |
| EmailAddress | EmailAddress | 4 | |
| FaxAreaCodeSubscriberNumber | FaxAreaCodeSubscriberNumber | 4 | |
| FaxExtensionNumber | FaxExtensionNumber | 4 | |
| FaxNumberCountry | FaxNumberCountry | 4 | |
| FormOfAddress | FormOfAddress | 4 | |
| HouseNumber | HouseNumber | 4 | |
| MobileNumber | MobileNumber | 4 | |
| MobilePhoneCountry | MobilePhoneCountry | 4 | |
| OrganizationName1 | OrganizationName1 | 4 | |
| OrganizationName2 | OrganizationName2 | 4 | |
| OrganizationName3 | OrganizationName3 | 4 | |
| OrganizationName4 | OrganizationName4 | 4 | |
| PersonFamilyName | PersonFamilyName | 4 | |
| PersonGivenName | PersonGivenName | 4 | |
| PhoneExtensionNumber | PhoneExtensionNumber | 4 | |
| PhoneNumber | PhoneNumber | 4 | |
| PhoneNumberCountry | PhoneNumberCountry | 3 | |
| POBox | POBox | 4 | |
| POBoxPostalCode | POBoxPostalCode | 4 | |
| PostalCode | PostalCode | 4 | |
| Region | Region | 4 | |
| StreetName | StreetName | 4 | |
| StreetPrefixName1 | StreetPrefixName1 | 4 | |
| StreetPrefixName2 | StreetPrefixName2 | 4 | |
| StreetSuffixName1 | StreetSuffixName1 | 4 | |
| StreetSuffixName2 | StreetSuffixName2 | 4 | |
| TaxJurisdiction | TaxJurisdiction | 4 | |
| TransportZone | TransportZone | 4 |
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.
-- Service Transaction Partner Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SRVCDOCPARTNERADDRESS (
CUSTMGMTBUSINESSPARTNER,
CUSTMGMTPARTNERFUNCTION,
SERVICEDOCUMENT,
SERVICEDOCUMENTITEM,
ADDRESSEEFULLNAME,
CITYNAME,
CORRESPONDENCELANGUAGE,
COUNTRY,
DISTRICTNAME,
EMAILADDRESS,
FAXAREACODESUBSCRIBERNUMBER,
FAXEXTENSIONNUMBER,
FAXNUMBERCOUNTRY,
FORMOFADDRESS,
HOUSENUMBER,
MOBILENUMBER,
MOBILEPHONECOUNTRY,
ORGANIZATIONNAME1,
ORGANIZATIONNAME2,
ORGANIZATIONNAME3,
ORGANIZATIONNAME4,
PERSONFAMILYNAME,
PERSONGIVENNAME,
PHONEEXTENSIONNUMBER,
PHONENUMBER,
PHONENUMBERCOUNTRY,
POBOX,
POBOXPOSTALCODE,
POSTALCODE,
REGION,
STREETNAME,
STREETPREFIXNAME1,
STREETPREFIXNAME2,
STREETSUFFIXNAME1,
STREETSUFFIXNAME2,
TAXJURISDICTION,
TRANSPORTZONE,
PRIMARY KEY (CUSTMGMTBUSINESSPARTNER, CUSTMGMTPARTNERFUNCTION, SERVICEDOCUMENT, SERVICEDOCUMENTITEM)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- 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