R_BANKADDRESSTP

CDS View
55 Fields 4 CDS Views

Bank Address

R_BANKADDRESSTP is a CDS View in S/4HANA. Bank Address. It contains 55 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_BankAddress_3 view_entity projection CONSUMPTION Bank Address
C_BankAddressTP view_entity projection CONSUMPTION Consumption Bank Address TP
C_CashBankAddress view_entity from CONSUMPTION Cash Bank Address
I_BankAddressTP view_entity projection TRANSACTIONAL Bank Address - TP

Fields (55)

KeyField CDS FieldsUsed in Views
KEY BankCountry BankCountry 1
KEY BankInternalID BankInternalID 1
_Bank _Bank 1
AddressID AddressID 1
AddressRepresentationCode AddressRepresentationCode 1
AddressSearchTerm1 AddressSearchTerm1 1
AddressSearchTerm2 AddressSearchTerm2 1
AddressTimeZone AddressTimeZone 1
Building Building 1
CareOfName CareOfName 1
CityName CityName 1
CompanyPostalCode CompanyPostalCode 1
CorrespondenceLanguage CorrespondenceLanguage 1
Country Country 1
DeliveryServiceNumber DeliveryServiceNumber 1
DeliveryServiceTypeCode DeliveryServiceTypeCode 1
DistrictName DistrictName 1
EmailAddress EmailAddress 1
FaxAreaCodeSubscriberNumber FaxAreaCodeSubscriberNumber 1
FaxExtensionNumber FaxExtensionNumber 1
FaxNumberCountry FaxNumberCountry 1
Floor Floor 1
FormOfAddress FormOfAddress 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
InternationalFaxNumber InternationalFaxNumber 1
InternationalMobilePhoneNumber InternationalMobilePhoneNumber 1
InternationalPhoneNumber InternationalPhoneNumber 1
MobilePhoneCountry MobilePhoneCountry 1
MobilePhoneNumber MobilePhoneNumber 1
PhoneExtensionNumber PhoneExtensionNumber 1
PhoneNumber PhoneNumber 1
PhoneNumberCountry PhoneNumberCountry 1
POBox POBox 1
POBoxAddrNonDeliverableReason POBoxAddrNonDeliverableReason 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxDeviatingCountry POBoxDeviatingCountry 1
POBoxDeviatingRegion POBoxDeviatingRegion 1
POBoxIsWithoutNumber POBoxIsWithoutNumber 1
POBoxLobbyName POBoxLobbyName 1
POBoxPostalCode POBoxPostalCode 1
PostalCode PostalCode 1
Region Region 1
RoomNumber RoomNumber 1
SecondaryRegionName SecondaryRegionName 1
StreetAddrNonDeliverableReason StreetAddrNonDeliverableReason 1
StreetName StreetName 1
StreetPrefixName1 StreetPrefixName1 1
StreetPrefixName2 StreetPrefixName2 1
StreetSuffixName1 StreetSuffixName1 1
StreetSuffixName2 StreetSuffixName2 1
TaxJurisdiction TaxJurisdiction 1
TertiaryRegionName TertiaryRegionName 1
TransportZone TransportZone 1
VillageName VillageName 1

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.

-- Bank Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_BANKADDRESSTP (
    BANKCOUNTRY,
    BANKINTERNALID,
    _BANK,
    ADDRESSID,
    ADDRESSREPRESENTATIONCODE,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    ADDRESSTIMEZONE,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    COMPANYPOSTALCODE,
    CORRESPONDENCELANGUAGE,
    COUNTRY,
    DELIVERYSERVICENUMBER,
    DELIVERYSERVICETYPECODE,
    DISTRICTNAME,
    EMAILADDRESS,
    FAXAREACODESUBSCRIBERNUMBER,
    FAXEXTENSIONNUMBER,
    FAXNUMBERCOUNTRY,
    FLOOR,
    FORMOFADDRESS,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    INTERNATIONALFAXNUMBER,
    INTERNATIONALMOBILEPHONENUMBER,
    INTERNATIONALPHONENUMBER,
    MOBILEPHONECOUNTRY,
    MOBILEPHONENUMBER,
    PHONEEXTENSIONNUMBER,
    PHONENUMBER,
    PHONENUMBERCOUNTRY,
    POBOX,
    POBOXADDRNONDELIVERABLEREASON,
    POBOXDEVIATINGCITYNAME,
    POBOXDEVIATINGCOUNTRY,
    POBOXDEVIATINGREGION,
    POBOXISWITHOUTNUMBER,
    POBOXLOBBYNAME,
    POBOXPOSTALCODE,
    POSTALCODE,
    REGION,
    ROOMNUMBER,
    SECONDARYREGIONNAME,
    STREETADDRNONDELIVERABLEREASON,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TAXJURISDICTION,
    TERTIARYREGIONNAME,
    TRANSPORTZONE,
    VILLAGENAME,
    PRIMARY KEY (BANKCOUNTRY, BANKINTERNALID)
);

Learn More