- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- ABAP Runtime Environment - ABAP Language Issues Only (BC-ABA)
- ABAP Workbench, Java IDE and Infrastructure (BC-DWB)
- BW Service API (BC-BW)
- Basis Services / Communication Interfaces (BC-SRV)
- ABAP Search Engine for ERP Solution Database (BC-SRV-SEN)
- Address Management/Business Address (BC-SRV-ADR)
- Application Interface Framework (BC-SRV-AIF)
- ArchiveLink (BC-SRV-ARL)
- BRFplus - ABAP-Based Business Rules (BC-SRV-BR)
- Basis Application Log (BC-SRV-BAL)
- Business Document Service (BC-SRV-BDS)
- Business Partner Foundation (BC-SRV-BP)
- Business Rule Framework (use BC-SRV-BR for BRF+) (BC-SRV-BRF)
- Business Service Functions (BC-SRV-BSF)
- Business Text Framework (BC-SRV-BTF)
- Business User Management - Foundation (BC-SRV-BUM)
- Case Management (BC-SRV-CM)
- Cloud based Application Services (BC-SRV-APS)
- Communication Services: Mail, Fax, SMS, Telephony (BC-SRV-COM)
- Cross System Lock (BC-SRV-CSL)
- Data Controller (BC-SRV-DC)
- Development Reporting Tools (BC-SRV-DRT)
- Fast Search Infrastructure (BC-SRV-FSI)
- Forms Processing (BC-SRV-FP)
- General Service Functions (BC-SRV-ASF)
- Generic Business Tools (BC-SRV-GBT)
- Generic Utility Tools (BC-SRV-GEN)
- Geographical Functions (BC-SRV-GEO)
- Initial Data Transfer (BC-SRV-DX)
- Knowledge Provider (BC-SRV-KPR)
- License Measurement (BC-SRV-LIM)
- NetWeaver Business Content (BC-SRV-NBC)
- NetWeaver Demonstration (BC-SRV-NWD)
- Number Range Management (BC-SRV-NUM)
- Obsolete. Only for internal use. (BC-SRV-CP)
- Online Text Repository (BC-SRV-OTR)
- Productivity Services (BC-SRV-PS)
- Report Tree (BC-SRV-REP)
- Report/Report Interface (BC-SRV-BBS)
- SAP List Viewer (BC-SRV-ALV)
- SAP Mobile Documents – please use subcomponents (BC-SRV-MCM)
- SAP Query (BC-SRV-QUE)
- SAP Records Management (BC-SRV-RM)
- SAPscript (BC-SRV-SCR)
- Smart Forms (BC-SRV-SSF)
- Social Media ABAP Integration Library (BC-SRV-STW)
- Standardized Key Mapping (BC-SRV-UKM)
- Time and Scheduling Functions (BC-SRV-TIM)
- User Interface Framework (BC-SRV-UIF)
- Basis pieces of Central Business Configuration (BC-CBC)
- Business Management (BC-BMT)
- Business Server Pages (BC-BSP)
- Change & Transport System (BC-CTS)
- Client/Server Technology (BC-CST)
- Component Integration / Installation Windows Components (BC-CI)
- Customizing (Use Subcomponents) (BC-CUS)
- Database Interface, Database Platforms (BC-DB)
- Documentation and Translation Tools (BC-DOC)
- Enterprise Content Management (ECM) (BC-ECM)
- Enterprise Information Management (use subcomponents) (BC-EIM)
- Enterprise Service Infrastructure (BC-ESI)
- Exchange Infrastructure - Use subcomponents (BC-XI)
- Frontend Services - Use subcomponents (see SAP Note 1322184) (BC-FES)
- Guided Procedure (BC-GP)
- Help Infrastructure (BC-HLP)
- Information Lifecycle Management (BC-ILM)
- Installation Tools (Use Subcomponents) (BC-INS)
- Intelligent Scenario Lifecycle Management (BC-ISM)
- Internationalization (I18N) (BC-I18)
- Middleware (BC-MID)
- Musing Tools (BC-MUS)
- Operating System Platforms (BC-OP)
- Ready-to-Run R/3 (BC-RRR)
- SAP NetWeaver Mobile - Use subcomponents (BC-MOB)
- SAP Screen Personas (BC-PER)
- Security (BC-SEC)
- TREX (BC-TRX)
- Test Workbench (BC-TWB)
- Upgrade - General (BC-UPG)
- Use Subcomponents (BC-CCM)
- Use subcomponents (BC-NWA)
- Virtual Machine Container (BC-VMC)
- Web Dynpro (BC-WD)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- 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 HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
/SAPQUERY/T000
Flight schedule
|
#masterdata
|
Component: SAP Query
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| CARRID FK | Airline Code | |
| CONNID | Flight Connection Number |
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| 📏 Mass unit of distance (kms, miles) (DISTID): | ||
| DISTANCE | Distance | |
| Column Name | Description | |
|---|---|---|
| DEPTIME | Departure time | |
| ARRTIME | Arrival time |
| Column Name | Description | |
|---|---|---|
| FLTYPE | Flight type | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| FLTIME | Flight time | /SAPQUERY/S_DURA | |
| PERIOD | Arrival n day(s) later | INT1 |
| Master Data Relations | Join Conditions |
|---|---|
| Check against airport |
|
| Check against airport |
|
| Check Against Airline |
|
Check against city
|
|
Check against city
|
|
Check against country of departure city
|
|
Check against country of arrival city
|
|
| Check against client | /SAPQUERY/T000.MANDT == T000.MANDT |