SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

FPRL_ITEM Table in SAP | Item Data Table & Fields List

FPRL_ITEM is a SAP table coming under FI module and SAP_FIN component.View details, Fields & related tables of FPRL_ITEM in SAP.

  • Table description : Item Data
  • Module : FI-AP-AP-PT
  • Parent Module : FI
  • Package : FIN_PRL
  • Software Component : SAP_FIN
FPRL_ITEM table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

Definitions

What is SAP ?

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

What is table in SAP ?

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

SAP FPRL_ITEM Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
GUIDUUID in X form (binary)SYSUUID_XSYSUUID
.INCLUDEItem Status    
LIST_IDPayment Release List IDFPRL_LIST_IDNUMC10
STATUSItem Status IDFPRL_ITEM_STATUSCHAR3
ALEVELApproval LevelFPRL_LEVELNUM02
.INCLUDEList Data    
CREA_USERCreated ByFPRL_USERUSNAM
CREA_TIMECreated OnFPRL_CREA_TIMEFPRL_TIMESTAMP
CHANGE_USERLast Changed ByFPRL_USER_CHUSNAM
CHANGE_TIMELast Changed OnFPRL_CHANGE_TIMEFPRL_TIMESTAMP
APPLICPayment Release List Application IDFPRL_APPLICATIONFPRL_APPLICATION
.INCLUDEItem Data    
BUKRSCompany CodeBUKRSBUKRS
BELNRAccounting Document NumberBELNR_DBELNR
GJAHRFiscal YearGJAHRGJAHR
BUZEINumber of Line Item Within Accounting DocumentBUZEIBUZEI
LIFNRAccount Number of Vendor or CreditorLIFNRLIFNR
KUNNRCustomer NumberKUNNRKUNNR
FILKDAccount Number of the BranchFILKDMAXKK
EMPFBPayee/PayerEMPFBMAXKK
VBUNDCompany ID of trading partnerRASSCRCOMP
SHKZGDebit/Credit IndicatorSHKZGSHKZG
WAERSCurrency KeyWAERSWAERS
WRBTRAmount in document currencyWRBTRWERT7
SKFBTAmount Eligible for Cash Discount in Document CurrencySKFBTWERT7
WSKTOCash Discount Amount in Document CurrencyWSKTOWERT7
QBSHBWithholding Tax Amount (in Document Currency)QBSHBWERT7
PSWSLUpdate Currency for General Ledger Transaction FiguresPSWSLWAERS
PSWBTAmount for Updating in General LedgerPSWBTWERT7
PSSKTCash Discount Deduction for the ItemPSSKTWRTV7
BLARTDocument typeBLARTBLART
BUDATPosting Date in the DocumentBUDATDATUM
BLDATDocument Date in DocumentBLDATDATUM
KOARTAccount typeKOARTKOART
BSCHLPosting KeyBSCHLBSCHL
HKONTGeneral Ledger AccountHKONTSAKNR
SAKNRG/L Account NumberSAKNRSAKNR
UMSKZSpecial G/L IndicatorUMSKZUMSKZ
GSBERBusiness AreaGSBERGSBER
MWSKZTax on sales/purchases codeMWSKZMWSKZ
QSSKZWithholding Tax CodeQSSKZQSSKZ
SGTXTItem TextSGTXTTEXT50
ZFBDTBaseline date for due date calculationDZFBDTDATUM
ZBD1TCash discount days 1DZBD1TZBDXT
ZBD2TCash discount days 2DZBD2TZBDXT
ZBD3TNet Payment Terms PeriodDZBD3TZBDXT
ZBD1PCash discount percentage 1DZBD1PPRZ23
ZBD2PCash Discount Percentage 2DZBD2PPRZ23
XREBZIndicator: Item is an Invoice-Related Credit MemoXREBZXFELD
ESRNRPOR subscriber numberESRNRESRNR
ESRREPOR reference numberESRREESRRE
ESRPZPOR check digitESRPZCHAR2
EBELNPurchasing Document NumberEBELNEBELN
EBELPItem Number of Purchasing DocumentEBELPEBELP
STCEGVAT Registration NumberSTCEGSTCEG
XBLNRReference Document NumberXBLNR1XBLNR1
LZBKZState central bank indicatorLZBKZLZBKZ
LANDLSupplying CountryLANDLLAND1
NPLNRNetwork Number for Account AssignmentNPLNRAUFNR
AUFPLRouting number of operations in the orderCO_AUFPLAUFPL
ZUONRAssignment numberDZUONRZUONR
VERTNContract NumberRANLRANL
REBZTFollow-On Document TypeREBZTREBZT
REBZGNumber of the Invoice the Transaction Belongs toREBZGBELNR
REBZJFiscal Year of the Relevant Invoice (for Credit Memo)REBZJGJAHR
REBZZLine Item in the Relevant InvoiceREBZZBUZEI
KOSTLCost CenterKOSTLKOSTL
VBEL2Sales DocumentVBELN_VAVBELN
POSN2Sales Document ItemPOSNR_VAPOSNR
PRCTRProfit CenterPRCTRPRCTR
XREF1Business partner reference keyXREF1CHAR12
XREF2Business partner reference keyXREF2CHAR12
XREF3Reference key for line itemXREF3CHAR20
DTWS1Instruction key 1DTAT16DTWSX
DTWS2Instruction key 2DTAT17DTWSX
DTWS3Instruction key 3DTAT18DTWSX
DTWS4Instruction key 4DTAT19DTWSX
XCPDDIndicator: Address and Bank Data Set IndividuallyXCPDDXFELD
BUPLABusiness PlaceBUPLAJ_1BBRANCH
PPRCTPartner Profit CenterPPRCTRPRCTR
GRANT_NBRGrantGM_GRANT_NBRGM_GRANT_NBR
FKBERFunctional AreaFKBERFKBER
GEBERFundBP_GEBERBP_GEBER
XINVEIndicator: Capital Goods Affected?XINVEXFELD
KEYNOKey Number for Payment RequestPRQ_KEYNOPRQ_KEYNO
PAMTFPayment Request Amount in Payment CurrencyPRQ_AMTFCWERT7
ORIGINOrigin IndicatorFIBL_ORIGINFIBL_ORIGIN
.INCLU--APEPIC Append Structure for FPRLS_ITEM_DATA    
EPIC_PROCESSORProcessorEPIC_PROCESSORXUBNAME
EPIC_STATUSItem StatusEPIC_ITEM_STATUSEPIC_ITEM_STATUS
.INCLU--APChorus Erweiterungen    
EBELN_COPurchasing Document NumberEBELNEBELN
SAPLONGNUMSmart Number/SAPPSPRO/LONGNUM/SAPPSPRO/LONGNUM
KBLNRDocument Number for Earmarked FundsKBLNRKBLNR
ACCOUNTANTAccountantFPCR_ACCOUNTANTFPCR_ACCOUNTANT
CO_STATUSStatus of GarnishmentFPCL_CO_STATFPCL_CO_STAT
STCD2Tax Number 2STCD2STCD2
.INCLUDEException Data    
POKENItem IndicatorPOKENCHAR3
ZLSPRPayment Block KeyDZLSPRZAHLS
.INCLUDEPayment Data    
LAUFD_PAYDate on Which the Program Is to Be RunLAUFDDATUM
LAUFI_PAYAdditional IdentificationLAUFILAUFI
VBLNR_PAYDocument Number of the Payment DocumentVBLNRBELNR
PYORD_PAYPayment OrderPYORDPYORD
XF110_EXECGeneral FlagFLAGFLAG
LAUFDDate of Proposal RunFPRL_LAUFDDATUM
LAUFIPayment ProposalFPRL_LAUFILAUFI
JOBCOUNTJob IDBTCJOBCNTCHAR8
ZBUKRPaying company codeDZBUKRBUKRS
ABSBUSending company codeABSBUBUKRS
ZNME1Name of the payeeDZNME1TEXT35
ZPSTLPostal code of the payeeDZPSTLPSTLZ
ZORT1City of the payeeDZORT1TEXT35
ZLANDCountry KeyDZLANDLAND1
ZREGIRegional code of the payeeDZREGIREGIO
ZSPRALanguage key of the payeeDZSPRASPRAS
NAME1Name 1NAME1_GPNAME
ZBVTYBank Data Indicator for the PayeeDZBVTYBVTYP
ZBNKSCountry KeyDZBNKSLAND1
ZBNKYBank key of the payee's bankDZBNKYBANKK
ZBNKLBank number of the payee's bankDZBNKLBANKL
ZBNKNBank account number of the payeeDZBNKNBANKN
ZBKONBank Control Key of the Payee's BankDZBKONBKONT
BKREFReference specifications for bank detailsBKREFCHAR20
ZSWIFSWIFT/BIC for International PaymentsSWIFTSWIFT
ZIBANIBAN (International Bank Account Number)IBANIBAN
KOINHAccount Holder NameKOINH_FIKOINH
HKTIDID for account detailsHKTIDHKTID
HBKIDShort key for a house bankHBKIDHBKID
UBNKSBank country keyBANKSLAND1
UBNKYBank key of our bankUBNKYBANKK
UBNKLBank number of our bankUBNKLBANKL
UBKNTOur account number at the bankUBKNTBANKN
UBKONBank control key at our bankUBKONBKONT
UBHKTG/L Account Number for Our Bank Account / Bank Sub-AccountUBHKTSAKNR
RZAWEPayment methodDZLSCHZLSCH
UZAWEPayment method supplementUZAWEUZAWE
DTAWSInstruction key for data medium exchangeDTAWSDTAWS
ZALDTPosting date of the payment documentDZALDT_ZHLDATUM
VALUTFixed Value DateVALUTDATUM
AUSFDDue date of the paid itemsAUSFDDATUM
ANFAEBill of Exchange Payment Request Due DateANFAEDATUM
WEFAEBill of Exchange Due DateWEFAEDATUM
WDATEBill of Exchange Issue DateWDATEDATUM
BUSABAccounting clerkBUSABBUSAB
EIKTOShipper's (Our) Account Number at the Customer or VendorEIKTOCHAR12
KIDNOPayment ReferenceKIDNOCHAR30
RFTTRNPayment codeRFTTRN_BFRFTTRN_BF
BTYP1Type of bank in a bank chain (correspondent, intermediary)BNTYPBNTYP
BNKS1Bank country keyBANKSLAND1
BNKL1Bank KeysBANKKBANKK
BNKN1Bank account numberBANKNBANKN
BTYP2Type of bank in a bank chain (correspondent, intermediary)BNTYPBNTYP
BNKS2Bank country keyBANKSLAND1
BNKL2Bank KeysBANKKBANKK
BNKN2Bank account numberBANKNBANKN
BTYP3Type of bank in a bank chain (correspondent, intermediary)BNTYPBNTYP
BNKS3Bank country keyBANKSLAND1
BNKL3Bank KeysBANKKBANKK
BNKN3Bank account numberBANKNBANKN
MGUIDSEPA Mandate: GUID of MandateSEPA_MGUID  
MNDIDUnique Referene to Mandate per Payment RecipientSEPA_MNDIDID035
.INCLUDEItem Data Invoice Reference    
INV_NODocument Number or Invoice Reference NumberFPRL_REBZGBELNR
INV_YEARFiscal Year of DocNo/Inf.ref.FPRL_REBZJGJAHR
INV_ITEMLine Item within Accounting Document or Relevant InvoiceFPRL_REBZZBUZEI
.INCLUDE   

FPRL_ITEM related tables

TableNote
CDBD_SRV_ICDB table for Item Extension - Transaction Item - Service
CMP_POSTYPItem Category Customizing Complaints Proc. Credit Memo Item
CRMC_FICA_AR_ITMItem Categories (Adjustment Request Item - FI-CA Document)
CRMC_FS_MGP_MGItem Grouping Assignment to Item Grouping Profile
CRMC_IT_COPY_IFCopy Item Categories - Item Category Determination
CRMC_UIU_IL_CNTLFunction Profile to control item list and item search
CRMC_UIU_IL_CNTTFunction Profile to control item list and item search
CWTY012ZAssignment Item Type - Item Types Group
DBERDLBReference of a Print Doc. Line Item to a Bill.Doc. Line Item
HUMSEGReference-HU-Item for Material Doc.Item that was Posted Last
LSOTACASEGRPITEMAssignment: Test - Section - Item Group - Item
LSOTACITEM200Item and Item Attributes
OIJEDIITYPAssign nomination item type to IDoc item
RSZWMDITEMBW Web Metadata: Template Item ( Dataprovider, Item, ... ).
TFMIG04Allocation: FS Item -> FS Item
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com