- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Financial Supply Chain Management (FIN-FSCM)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Localization (FI-LOC)
- ACR Activities (FI-LOC-VAT)
- Audit Reporting (FI-LOC-AUR)
- Cash Flow Localization (FI-LOC-CF)
- Cash Management (FI-LOC-CM)
- Contract Accounts Receivable and Payable (FI-LOC-CA)
- Corporate Income Tax Framework (FI-LOC-CIT)
- Globalization Service: Business Place (FI-LOC-BUP)
- Golden Audit Interface (FI-LOC-GAI)
- Localization Asset Accounting (FI-LOC-AA)
- Localization E-Payment Integration (FI-LOC-EPI)
- Localization Financials (FI-LOC-FI)
- Financials Arabic Emirates (FI-LOC-FI-AE)
- Financials Argentina (FI-LOC-FI-AR)
- Financials Austria (FI-LOC-FI-AT)
- Financials Belgium (FI-LOC-FI-BE)
- Financials Brazil (FI-LOC-FI-BR)
- Financials Chile (FI-LOC-FI-CL)
- Financials China (FI-LOC-FI-CN)
- Financials Colombia (FI-LOC-FI-CO)
- Financials Czech Republic (FI-LOC-FI-CZ)
- Financials Denmark (FI-LOC-FI-DK)
- Financials Egypt (FI-LOC-FI-EG)
- Financials France (FI-LOC-FI-FR)
- Financials Germany (FI-LOC-FI-DE)
- Financials Great Britain (FI-LOC-FI-GB)
- Financials Hungary (FI-LOC-FI-HU)
- Financials Indonesia (FI-LOC-FI-ID)
- Financials Ireland (FI-LOC-FI-IE)
- Financials Israel (FI-LOC-FI-IL)
- Financials Italy (FI-LOC-FI-IT)
- Financials Japan (FI-LOC-FI-JP)
- Financials Kazakhastan (FI-LOC-FI-KZ)
- Financials Luxembourg (FI-LOC-FI-LU)
- Financials Malaysia (FI-LOC-FI-MY)
- Financials Mexico (FI-LOC-FI-MX)
- Financials Netherlands (FI-LOC-FI-NL)
- Financials New Zealand (FI-LOC-FI-NZ)
- Financials Norway (FI-LOC-FI-NO)
- Financials Peru (FI-LOC-FI-PE)
- Financials Philippines (FI-LOC-FI-PH)
- Financials Poland (FI-LOC-FI-PL)
- Financials Portugal (FI-LOC-FI-PT)
- Financials Qatar (FI-LOC-FI-QA)
- Financials Romania (FI-LOC-FI-RO)
- Financials Russia (FI-LOC-FI-RU)
- Financials Singapore (FI-LOC-FI-SG)
- Financials Slovak republic (FI-LOC-FI-SK)
- Financials Slovenia (FI-LOC-FI-SI)
- Financials South Korea (FI-LOC-FI-KR)
- Financials Spain (FI-LOC-FI-ES)
- Financials Sweden (FI-LOC-FI-SE)
- Financials Switzerland (FI-LOC-FI-CH)
- Financials Taiwan (FI-LOC-FI-TW)
- Financials Thailand (FI-LOC-FI-TH)
- Financials Turkey (FI-LOC-FI-TR)
- Financials USA (FI-LOC-FI-US)
- Financials Ukraine (FI-LOC-FI-UA)
- Financials Venezuela (FI-LOC-FI-VE)
- Localization Financials (generic parts) (FI-LOC-GEN)
- Localization Financials EC Sales List (FI-LOC-ECS)
- Localization Financials Statements (FI-LOC-FS)
- Localization Funds Management (FI-LOC-FM)
- Localization Logistics (FI-LOC-LO)
- Localization for Utilities Industry (FI-LOC-UT)
- Payment Receipt (FI-LOC-PR)
- SAF-T Reporting (Generic Part) (FI-LOC-SAF)
- Statutory Reporting (FI-LOC-IS)
- Statutory Reporting Framework (FI-LOC-SRF)
- Tax Invoice Management (FI-LOC-TIM)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Tax Subledger (FI-TXL)
- Financial Services (FS)
- Global Trade Services (SLL)
- Investment Management (IM)
- LOD Components (LOD)
- Legal Content Management (LCM)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Transportation Management (TM)
P_OrganizationAddress
Address Info
| view: PORGADDR
| Extraction:
Not supported
| Component: Financials Russia
Tables used:
ADRC
- 🔑 Keys
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (3)
- ☰ Categorical (20)
- Other (57)
- 🔗 Relations (22)
Column Name | Description |
---|
Column Name | Description |
---|
Column Name | Description |
---|
Column Name | Description | |
---|---|---|
date_from | Valid-from date - in current Release only 00010101 possible | |
date_to | Valid-to date in current Release only 99991231 possible | |
_dataaging | Data Filter Value for Data Aging |
Column Name | Description | |
---|---|---|
chckstatus | City file test status | Show values |
po_box_num | Flag: PO Box Without Number | Show values |
flaggroups | Flag: There are more address group assignments | Show values |
pers_addr | Flag: This is a personal address | Show values |
flagcomm2 | Flag: Telephone number(s) defined | Show values |
flagcomm3 | Flag: Fax number(s) defined | Show values |
flagcomm4 | Flag: Teletex number(s) defined | Show values |
flagcomm5 | Flag: Telex number(s) defined | Show values |
flagcomm6 | Flag: E-mail address(es) defined | Show values |
flagcomm7 | Flag: RML (remote mail) addresse(s) defined | Show values |
flagcomm8 | Flag: X.400 addresse(s) defined | Show values |
flagcomm9 | Flag: RFC destination(s) defined | Show values |
flagcomm10 | Flag: Printer defined | Show values |
flagcomm11 | Flag: SSF defined | Show values |
flagcomm12 | Flag: URI/FTP address defined | Show values |
flagcomm13 | Flag: Pager address defined | Show values |
uuid_belated | Indicator: UUID created later | Show values |
id_category | Category of an Address ID | Show values |
adrc_err_status | Error Status of Address | Show values |
xpcpt | Business Purpose Completed Flag | Show values |
Column Name | Description | Domain name | |
---|---|---|---|
addrnumber | Address Number | AD_ADDRNUM | |
name1 | Name 1 | TEXT40 | |
name2 | Name 2 | TEXT40 | |
name3 | Name 3 | TEXT40 | |
name4 | Name 4 | TEXT40 | |
name_text | Converted name field (with form of address) | TEXT50 | |
name_co | c/o name | TEXT40 | |
city1 | City | TEXT40 | |
city2 | District | TEXT40 | |
home_city | City (different from postal city) | TEXT40 | |
post_code1 | City postal code | CHAR10 | |
post_code2 | PO Box Postal Code | CHAR10 | |
post_code3 | Company Postal Code (for Large Customers) | CHAR10 | |
pcode1_ext | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | CHAR10 | |
pcode2_ext | (Not Supported) PO Box Postal Code Extension | CHAR10 | |
pcode3_ext | (Not Supported) Major Customer Postal Code Extension | CHAR10 | |
po_box | PO Box | CHAR10 | |
po_box_loc | PO Box city | TEXT40 | |
postalarea | (Not Supported) Post Delivery District | TEXT15 | |
street | Street | TEXT60 | |
house_num1 | House Number | TEXT10 | |
house_num2 | House number supplement | TEXT10 | |
house_num3 | (Not supported) House Number Range | TEXT10 | |
str_suppl1 | Street 2 | TEXT40 | |
str_suppl2 | Street 3 | TEXT40 | |
str_suppl3 | Street 4 | TEXT40 | |
location | Street 5 | TEXT40 | |
building | Building (Number or Code) | TEXT20 | |
floor | Floor in building | TEXT10 | |
roomnumber | Room or Apartment Number | TEXT10 | |
sort1 | Search Term 1 | CHAR20 | |
sort2 | Search Term 2 | CHAR20 | |
sort_phn | (Not Supported) Phonetic Search Sort Field | CHAR20 | |
tel_number | First telephone no.: dialling code+number | CHAR30 | |
tel_extens | First Telephone No.: Extension | CHAR10 | |
fax_number | First Fax No.: Area Code + Number | CHAR30 | |
fax_extens | First fax no.: extension | CHAR10 | |
mc_name1 | Name (Field NAME1) in Uppercase for Search Help | CHAR25 | |
mc_city1 | City name in Uppercase for Search Help | CHAR25 | |
mc_street | Street Name in Uppercase for Search Help | CHAR25 | |
extension1 | Extension (only for data conversion) (e.g. data line) | TEXT40 | |
extension2 | Extension (only for data conversion) (e.g. telebox) | TEXT40 | |
taxjurcode | Tax Jurisdiction | AD_TXJCD | |
address_id | (Not supported) Physical address ID | AD_ADDR_ID | |
langu_crea | Address record creation original language | SPRAS | |
adrc_uuid | UUID Used in the Address | SYSUUID | |
po_box_lobby | PO Box Lobby | TEXT40 | |
deli_serv_number | Number of Delivery Service | CHAR10 | |
county_code | County code for county | CNTY_CODE | |
county | County | TEXT40 | |
township_code | Township code for Township | TWSHP_CODE | |
township | Township | TEXT40 | |
mc_county | County name in upper case for search help | CHAR25 | |
mc_township | Township name in upper case for search help | CHAR25 | |
duns | Dun & Bradstreet number (DUNS) | CHAR9 | |
dunsp4 | DUNS+4 number (the last four digit) | CHAR4 | |
OrganizationName | null |
Master Data Relations | Join Conditions |
---|---|
Source of address data
| |
Address group | P_ORGANIZATIONADDRESS.ADDR_GROUP == TSAD7.ADDR_GROUP |
Different city for city/street file
| |
City code for city/street file
| |
City PO box code (City file)
| |
Country key
| |
Communication Method | P_ORGANIZATIONADDRESS.DEFLT_COMM == TSAC.COMM_TYPE |
Address Delivery service type text table
|
|
Non-Delivery Reason
| |
Non-Delivery Reason
| |
Language key | P_ORGANIZATIONADDRESS.LANGU == T002.SPRAS |
Version ID for International Addresses | P_ORGANIZATIONADDRESS.NATION == TSADV.NATION |
PO Box of Country/Region
| |
Region for PO Box (Country/Region, State, Province, ...)
| |
Regional structure grouping
| |
Region code
| |
(Not Supported) Abbreviation of Street Name
|
|
Street Number for City/Street File
| |
Address time zone
| |
Form-of-Address Key
| |
Transportation zone to or from which the goods are delivered
|
Other Relations | to Master Data Relations ↑ | Join Conditions |
---|---|
District code for City and Street file
|
|