FIP_D_ORDER_LINE SAP (Order lines for FIP) Table details
Dictionary Type: Table
Description: Order lines for FIP
Description: Order lines for FIP
ABAP Code to SELECT data from FIP_D_ORDER_LINE
Related tables to FIP_D_ORDER_LINE
Access table FIP_D_ORDER_LINE
Related tables to FIP_D_ORDER_LINE
Access table FIP_D_ORDER_LINE
Table field list including key, data, relationships and ABAP select examples
FIP_D_ORDER_LINE is a standard SAP Table which is used to store Order lines for FIP data and is available within R/3 SAP systems depending on the version and release level.
The FIP_D_ORDER_LINE table consists of various fields, each holding specific information or linking keys about Order lines for FIP data available in SAP. These include DOC_TYPE (Document Type), DOC_NR (document number), DOC_ITEM (document item), DOC_SCHED (document schedule line).. 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 FIP_D_ORDER_LINE 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 | |||
DOC_TYPE | Document Type | FIP_DOC_TYPE | CHAR | 1 | FIP_DOC_TYPE | ||||
DOC_NR | document number | FIP_DOC_NUMBER | CHAR | 10 | ALPHA | FIP_DOC_NUMBER | |||
DOC_ITEM | document item | FIP_DOC_ITEM | NUMC | 5 | FIP_DOC_ITEM | ||||
DOC_SCHED | document schedule line | FIP_DOC_SCHED | NUMC | 4 | FIP_DOC_SCHED | ||||
SOURCE_ID | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
EKORG | Purchasing Organization | EKORG | CHAR | 4 | Assigned to domain | EKORG | EKO | ||
EKGRP | Purchasing Group | EKGRP | CHAR | 3 | Assigned to domain | EKGRP | EKG | ||
BUYER_ID | FIP Buyer | FIP_BUYER | CHAR | 12 | UNAME | ||||
RECIPIENT_TYPE | Delivery Relationship: Type of Goods Recipient | FIP_WDRD_RTYPE | CHAR | 1 | FIP_WDRD_RTYPE | ||||
RECIPIENT_ID | FIP Recipient Number | FIP_RECIPIENT_NUM | CHAR | 10 | CHAR10 | ||||
PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | Assigned to domain | PSTYP | |||
ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
DOC_QTY | Document Quantity | FIP_DOC_QTY | QUAN | 13(3) | MENG13 | ||||
MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
BPRME | Order Price Unit (Purchasing) | FIP_BBPRM | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
NETPR | Net price | FIP_NETPR | CURR | 11(2) | WERTV6 | ||||
PEINH | Price Unit | PEINH | DEC | 5 | PACK3 | ||||
EINDT | Item Delivery Date | EINDT | DATS | 8 | DATUM | ||||
BSART | Purchasing Document Type | FIP_ESART | CHAR | 4 | Assigned to domain | BSART | |||
AUART | Sales Document Type | AUART | CHAR | 4 | Assigned to domain | AUART | AUART | AAT | |
VKORG | Sales Organization | VKORG | CHAR | 4 | Assigned to domain | VKORG | VKO | C_VKORG | |
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | Assigned to domain | VTWEG | VTW | C_VTWEG | |
SPART | Division | SPART | CHAR | 2 | Assigned to domain | SPART | SPA | C_SPART | |
UZEIT | Time | UZEIT | TIMS | 6 | UZEIT | ||||
GI_DATE | Goods issue date | FIP_GI_DATE | DATS | 8 | DATUM | ||||
AEDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
WEMNG | Quantity of Goods Received | WEEMG | QUAN | 13(3) | MENG13 | ||||
KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | Assigned to domain | ALPHA | EBELN | KTR | |
KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | Assigned to domain | EBELP | |||
CPO_NR | document number | FIP_DOC_NUMBER | CHAR | 10 | ALPHA | FIP_DOC_NUMBER | |||
CPO_ITEM | document item | FIP_DOC_ITEM | NUMC | 5 | FIP_DOC_ITEM | ||||
STATUS | Order line status | FIP_ORDER_LINE_STATUS | CHAR | 1 | FIP_ORDER_LINE_STATUS | ||||
DB_MODIFY_TYPE | Indicates what should be done with a DB item line | FIP_DB_MODIFY_TYPE | CHAR | 1 | FIP_DB_MODIFY_TYPE |
Key field | Non-key field |
How do I retrieve data from SAP table FIP_D_ORDER_LINE using ABAP code
The following ABAP code Example will allow you to do a basic selection on FIP_D_ORDER_LINE to SELECT all data from the tableDATA: WA_FIP_D_ORDER_LINE TYPE FIP_D_ORDER_LINE.
SELECT SINGLE *
FROM FIP_D_ORDER_LINE
INTO CORRESPONDING FIELDS OF WA_FIP_D_ORDER_LINE
WHERE...
How to access SAP table FIP_D_ORDER_LINE
Within an ECC or HANA version of SAP you can also view further information about FIP_D_ORDER_LINE 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