- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- 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)
OIAQB
Exchange Movements Index
|
#index
|
Component: Exchanges
- 🔑 Keys (16)
- 💰 Amounts
- ∑ Quantities
- 📅 Dates (3)
- ☰ Categorical (13)
- Other (28)
- 🔗 Relations (10)
| Column Name | Description | |
|---|---|---|
| MANDT | Client | |
| OIEXGPTR | Exchange partner (vendor number) | |
| BUDAT | Posting Date in the Document | |
| SPMON | Period to analyze - month | |
| SPTAG | Period to analyze - current date | |
| SPWOC | Period to analyze - week | |
| SPBUP | Period to analyze - posting period | |
| OIEXGNUM | Exchange agreement number | |
| OIEXGTYP | Exchange type | |
| OIMATREF | Material group reference for exchange balance reporting | |
| MATNR | Material Number | |
| OIBASPROD | Base product number | |
| WERKS | Plant | |
| MBLNR | Number of Material Document | |
| MJAHR | Material Document Year | |
| ZEILE | Item number |
| Column Name | Description |
|---|
| Column Name | Description |
|---|
| Column Name | Description | |
|---|---|---|
| BUDAT | Posting Date in the Document | |
| SPTAG | Period to analyze - current date | |
| _DATAAGING | Data Filter Value for Data Aging |
| Column Name | Description | |
|---|---|---|
| ITEM_TYPE | LIA item type | Show values |
| SHKZG | Debit/Credit Indicator | Show values |
| OIASTBW | Reversal movement type | Show values |
| OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | Show values |
| NOCYC1 | Invoice cycle not used indicator | Show values |
| NOCYC2 | Invoice cycle not used indicator | Show values |
| NOCYC3 | Invoice cycle not used indicator | Show values |
| NOCYC4 | Invoice cycle not used indicator | Show values |
| NOCYC5 | Invoice cycle not used indicator | Show values |
| NOCYC6 | Invoice cycle not used indicator | Show values |
| NOCYC7 | Invoice cycle not used indicator | Show values |
| NOCYC8 | Invoice cycle not used indicator | Show values |
| NOCYC9 | Invoice cycle not used indicator | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| OINETCYC | Netting cycle (FI blocking indicator) | ZAHLS | |
| EBELN | Purchasing Document Number | EBELN | |
| EBELP | Item Number of Purchasing Document | EBELP | |
| OIVBELN | Delivery | VBELN | |
| OIPOSNR | Delivery Item | POSNR | |
| KDAUF | Sales Order Number | VBELN | |
| KDPOS | Item number in Sales Order | NUM06 | |
| CLRNO | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| OIC_PORGIN | Tax origin | OIC_PORGIN | |
| OIC_PDESTN | Tax destination | OIC_PDESTN | |
| OIC_PTRIP | Pipeline trip number (external) | OIC_PTRIP | |
| OIC_PBATCH | Pipeline operator´s external batch number | OIC_PBATCH | |
| OIC_AORGIN | Alternate origin | OIC_PORGIN | |
| OIC_ADESTN | Alternate destination | OIC_PDESTN | |
| OIC_TRUCKN | Truck number | OIC_TRUCKN | |
| OIA_BASELO | Base location | OIA_BASELO | |
| CLRNO1 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO2 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO3 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO4 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO5 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO6 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO7 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO8 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| CLRNO9 | Doc. number of the netting document clearing the item/cycle | OIA_PREQNO | |
| PDUMMY | Dummy function in length 1 | DUMMY | |
| OID_EXTBOL | External bill of lading | OID_EXTBOL | |
| OID_MISCDL | Miscellaneous delivery number | OID_MISCDL |
| Master Data Relations | Join Conditions |
|---|---|
Destination city code
| |
Destination county code
| |
Destination country/Region
| |
Destination region
| |
| Account Number of Supplier | |
| IS-OIL MAP external details mode of transport | |
Origin city code
| |
Origin county code
| |
Origin Country/Region
| |
Origin region
|