FIP_D_ORDER_LINE SAP (Order lines for FIP) Table details

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




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
DOC_TYPEDocument Type FIP_DOC_TYPECHAR1FIP_DOC_TYPE
DOC_NRdocument number FIP_DOC_NUMBERCHAR10ALPHAFIP_DOC_NUMBER
DOC_ITEMdocument item FIP_DOC_ITEMNUMC5FIP_DOC_ITEM
DOC_SCHEDdocument schedule line FIP_DOC_SCHEDNUMC4FIP_DOC_SCHED
SOURCE_IDAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
WAERSCurrency Key WAERSCUKY5Assigned to domainWAERSFWS
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
EKGRPPurchasing Group EKGRPCHAR3Assigned to domainEKGRPEKG
BUYER_IDFIP Buyer FIP_BUYERCHAR12UNAME
RECIPIENT_TYPEDelivery Relationship: Type of Goods Recipient FIP_WDRD_RTYPECHAR1FIP_WDRD_RTYPE
RECIPIENT_IDFIP Recipient Number FIP_RECIPIENT_NUMCHAR10CHAR10
PSTYPItem Category in Purchasing Document PSTYPCHAR1Assigned to domainPSTYP
ATTYPMaterial Category ATTYPCHAR2ATTYPMTY
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
DOC_QTYDocument Quantity FIP_DOC_QTYQUAN13(3) MENG13
MEINSPurchase Order Unit of Measure BSTMEUNIT3Assigned to domainCUNITMEINS
BPRMEOrder Price Unit (Purchasing) FIP_BBPRMUNIT3Assigned to domainCUNITMEINS
NETPRNet price FIP_NETPRCURR11(2) WERTV6
PEINHPrice Unit PEINHDEC5PACK3
EINDTItem Delivery Date EINDTDATS8DATUM
BSARTPurchasing Document Type FIP_ESARTCHAR4Assigned to domainBSART
AUARTSales Document Type AUARTCHAR4Assigned to domainAUARTAUARTAAT
VKORGSales Organization VKORGCHAR4Assigned to domainVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2Assigned to domainVTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2Assigned to domainSPARTSPAC_SPART
UZEITTime UZEITTIMS6UZEIT
GI_DATEGoods issue date FIP_GI_DATEDATS8DATUM
AEDATDate on Which Record Was Created ERDATDATS8DATUM
WEMNGQuantity of Goods Received WEEMGQUAN13(3) MENG13
KONNRNumber of Principal Purchase Agreement KONNRCHAR10Assigned to domainALPHAEBELNKTR
KTPNRItem Number of Principal Purchase Agreement KTPNRNUMC5Assigned to domainEBELP
CPO_NRdocument number FIP_DOC_NUMBERCHAR10ALPHAFIP_DOC_NUMBER
CPO_ITEMdocument item FIP_DOC_ITEMNUMC5FIP_DOC_ITEM
STATUSOrder line status FIP_ORDER_LINE_STATUSCHAR1FIP_ORDER_LINE_STATUS
DB_MODIFY_TYPEIndicates what should be done with a DB item line FIP_DB_MODIFY_TYPECHAR1FIP_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 table
DATA: 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 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!