FIAPSAD_ORDR_HD SAP (Order Number Header KSA) Table details

Dictionary Type: Table
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




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
ORDNOExpenditure/Payment Order Number FIAPSA_ORDNOCHAR10ALPHABELNR
GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
ORDTYPOrder Type FIAPSA_ORDTYPCHAR1FIAPSA_ORDTYP
BLARTDocument Type BLARTCHAR2Assigned to domainBLARTBAR
BLDATDocument Date in Document BLDATDATS8DATUM
BUDATPosting Date in the Document BUDATDATS8DATUM
AWKEYReference Key AWKEYCHAR20AWKEY
DOCTYPDocument Type FIAPSA_DOCTYPCHAR1FIAPSA_DOCTYP
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
METHPPayment Method FIAPSA_METHPCHAR1Assigned to domainZLSCH
CORRNCorrespondence No. FIAPSA_CORRNCHAR16
OSTATProcessing Status of Expenditure Order FIAPSA_STATCHAR1FIAPSA_STAT
PSTATProcessing Status for Payment Order FIAPSA_PSTATCHAR1FIAPSA_PSTAT
UMSKZSpecial G/L Indicator UMSKZCHAR1Assigned to domainUMSKZ
XBLNRReference Document Number XBLNRCHAR16XBLNR
REFINDReference Document Indicator FIAPSA_REFINDCHAR1FIAPSA_REFIND
ZFBDTBaseline Date for Due Date Calculation DZFBDTDATS8DATUM
BKTXTExpenditure Order Header Text FIAPSA_HD_TXTCHAR100CHAR100
WAERSExpenditure Order Currency FIAPSA_EXPCCUKY5Assigned to domainWAERS
KURSFExchange rate KURSFDEC9(5) EXCRTKURSF
WWERTTranslation Date WWERT_DDATS8DATUM
APRDATApproval Date FIAPSA_APRDATDATS8FIAPSA_APRDAT
APPROVERApprover FIAPSA_APPROVERCHAR12FIAPSA_APPROVER
SCSTDCustody Settled FIAPSA_SCSTDCHAR1FLAG
SDATSSettlement Date FIAPSA_SDATSDATS8DATUM
DCSTDSettlement Description FIAPSA_CSTD_TXTCHAR50CHAR50
ADVPNRAdvance Payment Request No. FIAPSA_ADVPNRNUMC10FIAPSA_ADVPNRADV
BANKSBank country key BANKSCHAR3Assigned to domainLAND1BKL
BANKLBank Keys BANKKCHAR15BANKKBNK
IBANIBAN (International Bank Account Number) IBANCHAR34IBAN
APRVTXTApprover Text FIAPSA_APPROVER_TEXTCHAR255
EOSTATExpenditure Order Clearing Status FIAPSA_EOSTATCHAR1FIAPSA_EOSTAT
CHECK_PRINTEDGeneral Flag FLAGCHAR1FLAG
PAYTYPPayment Type FIAPSA_PAYTYPCHAR2FIAPSA_PAYTYP
EXPCExpenditure Order Currency FIAPSA_EXPCCUKY5Assigned to domainWAERS
DELExp.Order Deleted FIAPSA_EO_DELCHAR1FLAG
SETBELNRSettlement document Number FIAPSA_SETBELNRCHAR10ALPHABELNR

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!