SAP PAPLINEITEM1 Table in S/4 HANA - Generated Table for View









PAPLINEITEM1 is a standard SAP Table which is used to store Generated Table for View data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system

Even using an S/4 Hana system you can still view further information about the SAP PAPLINEITEM1 table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Not classified
Dictionary Type: Table view
Database Table: PAPLINEITEM1


PAPLINEITEM1 table structure field list

Below is the full PAPLINEITEM1 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field


Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP SHLP Field
MANDTClientMANDTCLNT3(0) T000MANDT
COMPANYCODECompany CodeFIS_BUKRSCHAR4(0) T001BUKRSBUKC_T001BUKRS
ACCOUNTINGDOCUMENTJournal EntryFARP_BELNR_DCHAR10(0) ALPHABELNRBLN
FISCALYEARFiscal YearFIS_GJAHRNUMC4(0) GJAHRGJAHR
ACCOUNTINGDOCUMENTITEMPosting View ItemFARP_BUZEINUMC3(0) BUZEIBUZ
LANGUAGELANG1(0)
KEYDT2DATS8(0)
PAYMENTDIFFERENCEREASONReason Code for PaymentsFARP_RSTGRCHAR3(0) T053RRSTGR
SUPPLIERSupplierFIS_LIFNRCHAR10(0) LFA1ALPHALIFNR
CLEARINGDATEClearing DateFARP_AUGDTDATS8(0) DATUM
CLEARINGDOCFISCALYEARFiscal Year of Clearing Journal EntryFIS_AUGGJNUMC4(0) GJAHRGJAHR
CLEARINGACCOUNTINGDOCUMENTClearing Document NumberFARP_AUGBLCHAR10(0) ALPHABELNR
POSTINGKEYPosting KeyFARP_BSCHLCHAR2(0) TBSLBSCHL
FINANCIALACCOUNTTYPEAccount TypeFARP_KOARTCHAR1(0) FARP_KOART
SPECIALGLCODESpecial G/L IndicatorFAC_UMSKZCHAR1(0) T074UUMSKZ
SPECIALGLTRANSACTIONTYPESpecial G/L Transaction TypeFARP_UMSKSCHAR1(0) UMSKS
DEBITCREDITCODEDebit/Credit CodeFIS_SHKZGCHAR1(0) SHKZG
BUSINESSAREABusiness AreaFIS_RBUSACHAR4(0) TGSBGSBERGSB
TAXCODESales/Purchases Tax CodeFARP_MWSKZCHAR2(0) T007AMWSKZ
TAXREPORTINGDATETax Reporting DateVATDATEDATS8(0) DATUM
AMOUNTINCOMPANYCODECURRENCYAmount in Company Code CurrencyFIS_HSLCURR23(2) WERTV12
AMOUNTINTRANSACTIONCURRENCYAmount in Transaction CurrencyFIS_WSLCURR23(2) WERTV12
AMOUNTINBALANCETRANSACCRCYAmount in Balance Transaction CurrencyFIS_TSLCURR23(2) WERTV12
BALANCETRANSACTIONCURRENCYUpdate Currency for General Ledger Transaction FiguresFARP_PSWSLCUKY5(0) TCURCWAERS
WITHHOLDINGTAXBASEAMOUNTWithholding Tax Base AmountFIS_QSSHBCURR23(2) WERTV12
VALUATIONDIFFAMTINCOCODECRCYValuation Difference Amount In Company Code CurrencyFIS_BDIFFCURR23(2) WERTV12
VALUATIONDIFFAMTINADDLCRCY1Valuation Difference Amount in Additional Currency 1FIS_BDIF2CURR23(2) WERTV12
VALUEDATEValue dateVALUTDATS8(0) DATUM
ASSIGNMENTREFERENCEAssignment ReferenceFIS_ZUONRCHAR18(0) ZUONR
DOCUMENTITEMTEXTItem TextFARP_SGTXTCHAR50(0) TEXT50
PARTNERCOMPANYCompany ID of Trading PartnerFIS_RASSCCHAR6(0) T880ALPHARCOMPPGS
COSTCENTERCost CenterFIS_KOSTLCHAR10(0) ALPHAKOSTLKOS
ORDERIDOrder IDFIS_AUFNRCHAR12(0) AUFKALPHAAUFNRANR
BILLINGDOCUMENTBilling DocumentVBELN_VFCHAR10(0) ALPHAVBELNVF
SALESDOCUMENTSales DocumentVBELN_VACHAR10(0) ALPHAVBELNAUN
SALESDOCUMENTITEMSales Document ItemFIS_POSNR_VANUMC6(0) POSNR
SCHEDULELINESchedule LineFIS_ETENRNUMC4(0) VBEPETENR
MASTERFIXEDASSETFixed AssetFIS_ANLN1CHAR12(0) ANLHALPHAANLN1AN1
FIXEDASSETAsset SubnumberFIS_ANLN2CHAR4(0) ANLAALPHAANLN2AN2
ISUSEDINPAYMENTTRANSACTIONIs Used In Payment TransactionFIS_XZAHLCHAR1(0) XFELD
GLACCOUNTG/L AccountFIS_RACCTCHAR10(0) SKB1ALPHASAKNR
BRANCHAccount Number of the BranchFARP_FILKDCHAR10(0) ALPHAMAXKK
DUECALCULATIONBASEDATEDue Calculation Base DateFIS_DZFBDTDATS8(0) DATUM
PAYMENTTERMSTerms of Payment KeyFARP_DZTERMCHAR4(0) ZTERM
CASHDISCOUNT1DAYSCash Discount Days 1FARP_DZBD1TDEC3(0) ZBDXT
CASHDISCOUNT2DAYSCash Discount Days 2FARP_DZBD2TDEC3(0) ZBDXT
NETPAYMENTDAYSNet Payment Terms PeriodFARP_DZBD3TDEC3(0) ZBDXT
CASHDISCOUNT1PERCENTCash Discount Percentage 1DZBD1P_FARPDEC5(3) PRZ23
CASHDISCOUNT2PERCENTCash Discount Percentage 2DZBD2P_FARPDEC5(3) PRZ23
CASHDISCOUNTBASEAMOUNTCash Discount Base AmountFIS_SKFBTCURR23(2) WERTV12
CASHDISCOUNTAMTINCOCODECRCYCash Discount Amount in Company Code CurrencyFIS_SKNTOCURR23(2) WERTV12
CASHDISCOUNTAMOUNTCash Discount AmountFIS_WSKTOCURR23(2) WERTV12
PAYMENTMETHODPayment MethodFARP_SCHZW_BSEGCHAR1(0) T042ZZLSCH
PAYMENTBLOCKINGREASONPayment Block on ItemFARP_DZLSPRCHAR1(0) T008ZAHLSSPE
FIXEDCASHDISCOUNTFixed Payment TermsFARP_DZBFIXCHAR1(0) ZBFIX
FOLLOWONDOCUMENTTYPEFollow-On Document TypeFARP_REBZTCHAR1(0) REBZT
INVOICELISTCollective Invoice List NumberFARP_SAMNRNUMC8(0) SAMNR
BILLOFEXCHANGEUSAGEBill of Exchange Usage TypeFARP_WVERWCHAR1(0) WVERW
DUNNINGKEYDunning KeyFARP_MSCHLCHAR1(0) T040MSCHL
DUNNINGBLOCKINGREASONDunning BlockFARP_MANSPCHAR1(0) T040SMANSP
LASTDUNNINGDATEDate of Last Dunning NoticeFARP_MADATDATS8(0) DATUM
DUNNINGLEVELDunning LevelFARP_MAHNS_DNUMC1(0) MAHNS
DUNNINGAREADunning AreaFARP_MABERCHAR2(0) T047MMABER
WITHHOLDINGTAXAMOUNTWithholding Tax AmountFIS_QBSHBCURR23(2) WERTV12
WITHHOLDINGTAXEXEMPTIONAMTWithholding Tax-Exemption AmountFIS_QSFBTCURR23(2) WERTV12
PLANTPlantWERKS_DCHAR4(0) T001WWERKSWRKH_T001W_CWERKS
PURCHASINGDOCUMENTPurchasing Document NumberFARP_EBELNCHAR10(0) EKKOALPHAEBELNBESMEKK_CEBELN
PURCHASINGDOCUMENTITEMItem Number of Purchasing DocumentFARP_EBELPNUMC5(0) EKPOEBELPBSP
PROFITCENTERProfit CenterFIS_PRCTRCHAR10(0) ALPHAPRCTRPRC
TREASURYCONTRACTTYPETreasury Contract TypeFIS_RANTYPCHAR1(0) RANTYP
ASSETCONTRACTAsset ContractFIS_RANLCHAR13(0) ALPHARANL
CASHFLOWTYPEFlow TypeFARP_SBEWARTCHAR4(0) SBEWART
WBSELEMENTWBS ElementPS_POSNRNUMC8(0) ABPSPPS_POSNR
ALTERNATIVEGLACCOUNTAlternative G/L Account Number In Company CodeFIS_ALTKT_SKB1CHAR10(0) ALPHASAKNR
AMOUNTINADDITIONALCURRENCY1Amount in Additional Currency 1DMBE2_FARPCURR23(2) WRTV12_FARP
AMOUNTINADDITIONALCURRENCY2Amount in Additional Currency 2DMBE3_FARPCURR23(2) WRTV12_FARP
VALUATIONDIFFAMTINADDLCRCY2Valuation Difference Amount in Additional Currency 2FIS_BDIF3CURR23(2) WERTV12
CLEARINGISREVERSEDIndicator: Clearing was ReversedFARP_XRAGLCHAR1(0) XFELD
PAYMENTMETHODSUPPLEMENTPayment Method SupplementFARP_UZAWECHAR2(0) T042FUZAWE
REFERENCE1IDBYBUSINESSPARTNERBusiness Partner Reference Key 1FARP_XREF1CHAR12(0) CHAR12
REFERENCE2IDBYBUSINESSPARTNERBusiness Partner Reference Key 2FARP_XREF2CHAR12(0) CHAR12
PAYMENTCARDITEMPayment Card ItemFARP_RFZEI_CCNUMC3(0) NUM03
PAYMENTCARDPAYMENTSETTLEMENTPayment Cards: Settlement RunFARP_CCBTCCHAR10(0) ALPHACCBTC
REFERENCE3IDBYBUSINESSPARTNERID of Reference 3 by Business PartnerFIS_XREF3CHAR20(0) CHAR20
DATAEXCHANGEINSTRUCTION1Instruction Key 1FARP_DTAT16NUMC2(0) DTWSX
DATAEXCHANGEINSTRUCTION2Instruction Key 2FARP_DTAT17NUMC2(0) DTWSX
DATAEXCHANGEINSTRUCTION3Instruction Key 3FARP_DTAT18NUMC2(0) DTWSX
DATAEXCHANGEINSTRUCTION4Instruction Key 4FARP_DTAT19NUMC2(0) DTWSX
HASPAYMENTORDERIndicator: Payment Order Exists for this ItemFARP_XPYPRCHAR1(0) XFELD
PAYMENTREFERENCEPayment ReferenceFARP_KIDNOCHAR30(0) CHAR30
HEDGEDAMOUNTCredit Management: Hedged AmountABSBT_FARPCURR23(2) WRTV12_FARP
PAYMENTCURRENCYCurrency for Automatic PaymentFARP_PYCURCUKY5(0) TCURCWAERS
AMOUNTINPAYMENTCURRENCYAmount in Payment CurrencyFIS_PYAMTCURR23(2) WERTV12
BUSINESSPLACEBusiness PlaceFARP_BUPLACHAR4(0) J_1BBRANCHJ_1BBRANCH
TAXSECTIONTax SectionFIS_SECCOCHAR4(0) SECCODESECCO
ACCOUNTSRECEIVABLEISPLEDGEDAccounts Receivable Pledging IndicatorFARP_CESSION_KZCHAR2(0) TCESSIONCESSION_KZ
REALESTATEOBJECTInternal Key for Real Estate ObjectFARP_IMKEYCHAR8(0) IMKEYIMKEY
FUNDSCENTERFunds Management CenterFARP_FISTLCHAR16(0) FISTLFIS
SETTLEMENTREFERENCEDATEReference Date for SettlementFARP_DABRBEZDATS8(0) DDAT
ISSALESRELATEDIndicator: Sales-Related Item ?FARP_XUMSWCHAR1(0) XFELD
POSTINGDATEPosting DateFIS_BUDATDATS8(0) DATUM
ACCOUNTINGDOCUMENTCATEGORYDocument StatusFARP_BSTAT_DCHAR1(0) BSTAT
FISCALPERIODFiscal PeriodFINS_FISCALPERIODNUMC3(0) POPERPOPR
DOCUMENTDATEJournal Entry DateFIS_BLDATDATS8(0) DATUM
ACCOUNTINGDOCUMENTTYPEJournal Entry TypeFARP_BLARTCHAR2(0) T003BLARTBAR
TRANSACTIONCURRENCYTransaction CurrencyFIS_RWCURCUKY5(0) TCURCWAERS
PLANNEDAMTINTRANSACTIONCRCYPlanned Amount in Transaction CurrencyFIS_FDWBTCURR23(2) WERTV12
NETDUEDATEDue Date for Net PaymentFARP_NETDTDATS8(0) DATUM
CASHDISCOUNT1DUEDATEDue Date for Cash Discount 1FARP_SK1DTDATS8(0) DATUM
SOURCECOMPANYCODECHAR1(0)
DOCUMENTREFERENCEIDDocument Reference IDFIS_XBLNR1CHAR16(0) XBLNR1
ACCOUNTINGDOCUMENTCREATIONDATEAccounting Document Entry DateFARP_CPUDTDATS8(0) DATUM
ACCOUNTINGDOCCREATEDBYUSERUser that created the journal entryFIS_USNAMCHAR12(0)
ADDITIONALCURRENCY1Additional Currency 1FIS_HWAE2CUKY5(0) WAERS
ADDITIONALCURRENCY2Additional Currency 2FIS_HWAE3CUKY5(0) WAERS
OFFSETTINGACCOUNTOffsetting AccountFIS_GKONTCHAR10(0) ALPHAGKONTGKONTGKONT
OFFSETTINGACCOUNTTYPEOffsetting Account TypeFARP_GKOARCHAR1(0) KOART
ITEM_TYPE_BRANCH30 CharactersCHAR30CHAR30(0) CHAR30
DPNOTDUECHAR1(0)
DOCUMENTISARCHIVEDCHAR1(0)
TARGETTAXCODETarget Tax Code (for Deferred Tax)FARP_DZMWSKCHAR2(0) T007AMWSKZ
KEYDATEOpen on Key DateFARP_KEYDTDATS8(0) DATS
COMPANYCODECURRENCYCompany Code CurrencyFIS_HWAERCUKY5(0) WAERS
ACCTGDOCTYPEAUTHORIZATIONGROUPAuthorization GroupBRGRUCHAR4(0) BRGRU
BPBANKACCOUNTINTERNALIDBusiness Partner Bank Account Internal IDFARP_BVTYPCHAR4(0) BVTYP
HOUSEBANKHouse Bank KeyFARP_HBKIDCHAR5(0) T012HBKID
ALTERNATIVEPAYEEISALLOWEDIndicator: Alternative Payee in Document Allowed?XZEMPCHAR1(0) XFELD
SUPPLIERSEARCHTEXTSort fieldSORTLCHAR10(0) CHAR10
SUPPLIERNAMEName of SupplierMD_SUPPLIER_NAMECHAR80(0) TEXT80
SUPPLIERINDUSTRYIndustry keyBRSCHCHAR4(0) T016BRSCH
SUPPLIERCREATIONDATEDate on which the Record Was CreatedERDAT_RFDATS8(0) DATUM
SUPPLIERCREATEDBYUSERName of Person who Created the ObjectERNAM_RFCHAR12(0) USNAM
SUPPLIERCORPORATEGROUPGroup keyKONZSCHAR10(0) KONZS
SUPPLIERACCOUNTGROUPVendor account groupKTOKKCHAR4(0) T077KKTOKKKGK
CUSTOMERCustomer NumberKUNNRCHAR10(0) KNA1ALPHAKUNNRKUNC_KUNNRKUNNR
POSTINGISBLOCKEDFORSUPPLIERCentral posting blockSPERB_XCHAR1(0) XFELD
SUPPLIERTAXID1Tax Number 1STCD1CHAR16(0) STCD1
SUPPLIERTAXID2Tax Number 2STCD2CHAR11(0) STCD2
SUPPLIERTAXID3Tax Number 3STCD3CHAR18(0) CHAR18
SUPPLIERTAXID4Tax Number 4STCD4CHAR18(0) CHAR18
SUPPLIERTAXID5Tax Number 5STCD5CHAR60(0) CHAR60
SUPPLIERISONETIMEACCOUNTIndicator: Is the account a one-time account?XCPDKCHAR1(0) XFELD
SUPPLIERVATREGISTRATIONVAT Registration NumberSTCEGCHAR20(0) STCEG
SUPPLIERTAXJURISDICTIONTax JurisdictionTXJCDCHAR15(0) TTXJTXJCDTXJ
SUPPLIERCOUNTRYCountry KeyLAND1CHAR3(0) T005LAND1LND
SUPPLIERCITYNAMECityAD_CITY1CHAR40(0) TEXT40CLCITYNAMECITY_NAME
SUPPLIERPOBOXPO BoxAD_POBXCHAR10(0) CHAR10
SUPPLIERPOBOXPOSTALCODEPO Box Postal CodeAD_PSTCD2CHAR10(0) CHAR10
SUPPLIERPOSTALCODECity postal codeAD_PSTCD1CHAR10(0) CHAR10
SUPPLIERREGIONRegion (State, Province, County)REGIOCHAR3(0) T005SREGIO
ACCOUNTINGCLERKAccounting Clerk AbbreviationBUSABCHAR2(0) T001SBUSAB
RECONCILIATIONACCOUNTReconciliation Account in General LedgerAKONTCHAR10(0) SKB1ALPHASAKNR
INTERESTCALCULATIONCODEInterest calculation indicatorVZSKZCHAR2(0) T056VZSKZ
SUPPLIERHEADOFFICEHead office account numberLNRZECHAR10(0) LFA1ALPHALIFNR
ALTERNATIVEPAYEEAccount number of the alternative payeeLNRZBCHAR10(0) LFA1ALPHALIFNR
SUPPLIERPAYMENTBLOCKINGREASONBlock Key for PaymentDZAHLSCHAR1(0) T008ZAHLS
INTERESTCALCULATIONDATEKey Date of Last Interest CalculationDZINDTDATS8(0) DATUM
INTRSTCALCFREQUENCYINMONTHSInterest Calculation Frequency in MonthsDZINRTNUMC2(0) ZINRT
APARTOLERANCEGROUPTolerance Group for Business Partner/G/L AccountTOGRUCHAR4(0) T043GTOGRU
ITEMISTOBEPAIDSEPARATELYIndicator: Pay All Items Separately?XPORECHAR1(0) XFELD
PAYMENTISTOBESENTBYEDIIndicator: Send Payment Advices by EDIXEDIPCHAR1(0) XFELD
SUPPLIERACCOUNTNOTEMemoKVERMCHAR30(0) TEXT30
SUPPLIERBASICAUTHORIZATIONGRPAuthorization GroupBRGRUCHAR4(0) BRGRU
SUPPLIERFINSAUTHORIZATIONGRPAuthorization GroupBRGRUCHAR4(0) BRGRU
COMPANYCODENAMEName of Company Code or CompanyBUTXTCHAR25(0) TEXT25
ISDISPUTEDIndicator: Disputed Item?XSTRPCHAR1(0) XFELD
CUSTOMERSUPPLIERACCOUNTSupplierFIS_LIFNRCHAR10(0) ALPHALIFNR
INVOICEREFERENCEDocument No. of the Invoice to Which the Transaction BelongsFARP_REBZGCHAR10(0) ALPHABELNR
FISCALYEARPERIODCHAR7(0)
ISCLEAREDCHAR1(0)
CREDITCONTROLAREACredit control areaKKBERCHAR4(0) KKBERKKB
NETDUEARREARSDAYSDEC5(0)
CASHDISCOUNT1ARREARSDAYSDEC5(0)
ZFBDT_TODAYINT410(0)
VALUATEDAMTINCOMPANYCODECRCYCURR24(2)
VALUATEDAMTINADDITIONALCRCY1CURR24(2)
VALUATEDAMTINADDITIONALCRCY2CURR24(2)
DUEITEMTYPECHAR1(0)
DEBTORCustomerFIS_KUNNRCHAR10(0) KNA1ALPHAKUNNR
ADDITIONALCURRENCY1ROLEAdditional Currency 1 Role (Currency Type)FIS_ADL1_CURROLECHAR2(0) FINS_CURTYPE
ADDITIONALCURRENCY2ROLEAdditional Currency 2 Role (Currency Type)FIS_ADL2_CURROLECHAR2(0) FINS_CURTYPE
BRANCHCODEBranch CodeBCODECHAR5(0) BCODE




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!