I_SRVCDOCPARTNERADDRESS

CDS View

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)

ViewTypeJoinVDMDescription
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)

KeyField CDS FieldsUsed 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)
);