R_BANKSCRIPTEDADDRESSTP

CDS View
27 Fields 4 CDS Views

Bank Scripted Address

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

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_BankScriptedAddress_3 view_entity projection CONSUMPTION Scripted Addresses
C_BankScriptedAddressTP view_entity projection CONSUMPTION Consumption Bank Address TP
C_CashBankScriptedAddress view_entity from CONSUMPTION Cash Bank Scripted Address
I_BankScriptedAddressTP view_entity projection TRANSACTIONAL Bank International Address Versions - TP

Fields (27)

KeyField CDS FieldsUsed in Views
KEY AddressRepresentationCode AddressRepresentationCode 1
KEY BankCountry BankCountry 1
KEY BankInternalID BankInternalID 1
AddressID AddressID 1
AddressSearchTerm1 AddressSearchTerm1 1
AddressSearchTerm2 AddressSearchTerm2 1
Building Building 1
CareOfName CareOfName 1
CityName CityName 1
Country Country 1
DistrictName DistrictName 1
Floor Floor 1
HouseNumber HouseNumber 1
HouseNumberSupplementText HouseNumberSupplementText 1
LongBankBranch LongBankBranch 1
LongBankName LongBankName 1
POBoxDeviatingCityName POBoxDeviatingCityName 1
POBoxLobbyName POBoxLobbyName 1
RoomNumber RoomNumber 1
SecondaryRegionName SecondaryRegionName 1
StreetName StreetName 1
StreetPrefixName1 StreetPrefixName1 1
StreetPrefixName2 StreetPrefixName2 1
StreetSuffixName1 StreetSuffixName1 1
StreetSuffixName2 StreetSuffixName2 1
TertiaryRegionName TertiaryRegionName 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 Scripted Address
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE R_BANKSCRIPTEDADDRESSTP (
    ADDRESSREPRESENTATIONCODE,
    BANKCOUNTRY,
    BANKINTERNALID,
    ADDRESSID,
    ADDRESSSEARCHTERM1,
    ADDRESSSEARCHTERM2,
    BUILDING,
    CAREOFNAME,
    CITYNAME,
    COUNTRY,
    DISTRICTNAME,
    FLOOR,
    HOUSENUMBER,
    HOUSENUMBERSUPPLEMENTTEXT,
    LONGBANKBRANCH,
    LONGBANKNAME,
    POBOXDEVIATINGCITYNAME,
    POBOXLOBBYNAME,
    ROOMNUMBER,
    SECONDARYREGIONNAME,
    STREETNAME,
    STREETPREFIXNAME1,
    STREETPREFIXNAME2,
    STREETSUFFIXNAME1,
    STREETSUFFIXNAME2,
    TERTIARYREGIONNAME,
    VILLAGENAME,
    PRIMARY KEY (ADDRESSREPRESENTATIONCODE, BANKCOUNTRY, BANKINTERNALID)
);

Learn More