FIAPSAD_ORDR_HD SAP (Order Number Header KSA) Table details
Dictionary Type: Table
Description: Order Number Header KSA
Description: Order Number Header KSA
ABAP Code to SELECT data from FIAPSAD_ORDR_HD
Related tables to FIAPSAD_ORDR_HD
Access table FIAPSAD_ORDR_HD
Related tables to FIAPSAD_ORDR_HD
Access table FIAPSAD_ORDR_HD
Table field list including key, data, relationships and ABAP select examples
FIAPSAD_ORDR_HD is a standard SAP Table which is used to store Order Number Header KSA data and is available within R/3 SAP systems depending on the version and release level.
The FIAPSAD_ORDR_HD table consists of various fields, each holding specific information or linking keys about Order Number Header KSA data available in SAP. These include BUKRS (Company Code), ORDNO (Expenditure/Payment Order Number), GJAHR (Fiscal Year), ORDTYP (Order Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP FIAPSAD_ORDR_HD table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
ORDNO | Expenditure/Payment Order Number | FIAPSA_ORDNO | CHAR | 10 | ALPHA | BELNR | |||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
ORDTYP | Order Type | FIAPSA_ORDTYP | CHAR | 1 | FIAPSA_ORDTYP | ||||
BLART | Document Type | BLART | CHAR | 2 | Assigned to domain | BLART | BAR | ||
BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
BUDAT | Posting Date in the Document | BUDAT | DATS | 8 | DATUM | ||||
AWKEY | Reference Key | AWKEY | CHAR | 20 | AWKEY | ||||
DOCTYP | Document Type | FIAPSA_DOCTYP | CHAR | 1 | FIAPSA_DOCTYP | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
METHP | Payment Method | FIAPSA_METHP | CHAR | 1 | Assigned to domain | ZLSCH | |||
CORRN | Correspondence No. | FIAPSA_CORRN | CHAR | 16 | |||||
OSTAT | Processing Status of Expenditure Order | FIAPSA_STAT | CHAR | 1 | FIAPSA_STAT | ||||
PSTAT | Processing Status for Payment Order | FIAPSA_PSTAT | CHAR | 1 | FIAPSA_PSTAT | ||||
UMSKZ | Special G/L Indicator | UMSKZ | CHAR | 1 | Assigned to domain | UMSKZ | |||
XBLNR | Reference Document Number | XBLNR | CHAR | 16 | XBLNR | ||||
REFIND | Reference Document Indicator | FIAPSA_REFIND | CHAR | 1 | FIAPSA_REFIND | ||||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
BKTXT | Expenditure Order Header Text | FIAPSA_HD_TXT | CHAR | 100 | CHAR100 | ||||
WAERS | Expenditure Order Currency | FIAPSA_EXPC | CUKY | 5 | Assigned to domain | WAERS | |||
KURSF | Exchange rate | KURSF | DEC | 9(5) | EXCRT | KURSF | |||
WWERT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
APRDAT | Approval Date | FIAPSA_APRDAT | DATS | 8 | FIAPSA_APRDAT | ||||
APPROVER | Approver | FIAPSA_APPROVER | CHAR | 12 | FIAPSA_APPROVER | ||||
SCSTD | Custody Settled | FIAPSA_SCSTD | CHAR | 1 | FLAG | ||||
SDATS | Settlement Date | FIAPSA_SDATS | DATS | 8 | DATUM | ||||
DCSTD | Settlement Description | FIAPSA_CSTD_TXT | CHAR | 50 | CHAR50 | ||||
ADVPNR | Advance Payment Request No. | FIAPSA_ADVPNR | NUMC | 10 | FIAPSA_ADVPNR | ADV | |||
BANKS | Bank country key | BANKS | CHAR | 3 | Assigned to domain | LAND1 | BKL | ||
BANKL | Bank Keys | BANKK | CHAR | 15 | BANKK | BNK | |||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
APRVTXT | Approver Text | FIAPSA_APPROVER_TEXT | CHAR | 255 | |||||
EOSTAT | Expenditure Order Clearing Status | FIAPSA_EOSTAT | CHAR | 1 | FIAPSA_EOSTAT | ||||
CHECK_PRINTED | General Flag | FLAG | CHAR | 1 | FLAG | ||||
PAYTYP | Payment Type | FIAPSA_PAYTYP | CHAR | 2 | FIAPSA_PAYTYP | ||||
EXPC | Expenditure Order Currency | FIAPSA_EXPC | CUKY | 5 | Assigned to domain | WAERS | |||
DEL | Exp.Order Deleted | FIAPSA_EO_DEL | CHAR | 1 | FLAG | ||||
SETBELNR | Settlement document Number | FIAPSA_SETBELNR | CHAR | 10 | ALPHA | BELNR |
Key field | Non-key field |
How do I retrieve data from SAP table FIAPSAD_ORDR_HD using ABAP code
The following ABAP code Example will allow you to do a basic selection on FIAPSAD_ORDR_HD to SELECT all data from the tableDATA: WA_FIAPSAD_ORDR_HD TYPE FIAPSAD_ORDR_HD.
SELECT SINGLE *
FROM FIAPSAD_ORDR_HD
INTO CORRESPONDING FIELDS OF WA_FIAPSAD_ORDR_HD
WHERE...
How to access SAP table FIAPSAD_ORDR_HD
Within an ECC or HANA version of SAP you can also view further information about FIAPSAD_ORDR_HD and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects