SAP TEMA01 Table in S/4 HANA - Internal: Structure for Open Item Selection









TEMA01 is a standard SAP Table which is used to store Internal: Structure for Open Item Selection data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TEMA01 table(ECC)

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: TEMA01


TEMA01 table structure field list

Below is the full TEMA01 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) Assigned to domainMANDT
OPBELNumber of Contract Accts Rec. & Payable Doc.OPBEL_KKCHAR12(0) Assigned to domainALPHAOPBEL_KK80B
OPUPWRepetition Item in Contract Account DocumentOPUPW_KKNUMC3(0) OPUPW_KK
OPUPKItem number in contract account documentOPUPK_KKNUMC4(0) OPUPK_KK
OPUPZSubitem for a Partial Clearing in DocumentOPUPZ_KKNUMC3(0) OPUPZ_KK
BUKRSCompany CodeBUKRSCHAR4(0) T001BUKRSBUKC_T001BUKRS
GSBERBusiness AreaGSBERCHAR4(0) TGSBGSBERGSB
BUPLABusiness PlaceBUPLACHAR4(0) J_1BBRANCHJ_1BBRANCH
SEGMENTSegment for Segmental ReportingSEGMT_KKCHAR10(0) FAGL_SEGMALPHAFB_SEGMENT
PRCTRProfit CenterPRCTRCHAR10(0) ALPHAPRCTRPRCPRCTR_EMPTYPRCTR
AUGSTClearing StatusAUGST_KKCHAR1(0) AUGST_KK
GPARTBusiness Partner NumberGPART_KKCHAR10(0) BUT000ALPHABU_PARTNERBPA
VTREFReference Specifications from ContractVTREF_KKCHAR20(0) ALPHAVTREF_KKVTZ
VTPOSContract: Item NumberVTPOS_KKNUMC6(0) VTPOS_KK
VTRE2Additional Reference InformationVTRE2_KKCHAR20(0) ALPHAVTREF_KK
VKONTContract Account NumberVKONT_KKCHAR12(0) FKKVKALPHAVKONT_KKKTOFKKVKP_F4VKONT
ABWBLNumber of the Substitute FI-CA DocumentABWBL_KKCHAR12(0) ALPHAABWBL_KK
ABWTPCategory of Substitute Document in FI-CAABWTP_KKCHAR1(0) ABWTP_KK
ABWKTAlternative Contract Account for Collective BillsABWVK_KKCHAR12(0) Assigned to domainALPHAVKONT_KK
APPLKApplication AreaAPPLK_KKCHAR1(0) APPLK_KK
HVORGMain Transaction for Line ItemHVORG_KKCHAR4(0) TFKHVOHVORG_KK8HV
TVORGSubtransaction for Document ItemTVORG_KKCHAR4(0) TFKTVOTVORG_KK
KOFIZAccount Determination IDKOFIZ_KKCHAR2(0) KOFIZ_KK
SPARTDivisionSPART_KKCHAR2(0) TSPASPARTSPA
HKONTGeneral ledger accountHKONT_KKCHAR10(0) SKA1ALPHASAKNRSAKOSAKNR
MWSKZTax on sales/purchases codeMWSKZCHAR2(0) T007AMWSKZ
MWSZKZSupplementary TaxMWSZKZ_KKCHAR2(0) Assigned to domainMWSKZ
XANZAItem is a Down Payment/Down Payment RequestXANZA_KKCHAR1(0) XFELD
STAKZType of statistical itemSTAKZ_KKCHAR1(0) STAKZ_KK
BLDATDocument Date in DocumentBLDATDATS8(0) DATUM
BUDATPosting Date in the DocumentBUDAT_KKDATS8(0) DATUM
OPTXTItem textOPTXT_KKCHAR50(0) TEXT50
WAERSTransaction CurrencyBLWAE_KKCUKY5(0) TCURCWAERSFWS
FAEDNDue date for net paymentFAEDN_KKDATS8(0) DATUM
FAEDSDue Date for Cash DiscountFAEDS_KKDATS8(0) DATUM
VERKZItem Can Only Be ClearedVERKZ_KKCHAR1(0) VERKZ_KK
STUDTDeferral toSTUDT_KKDATS8(0) DATUM
SKTPZCash Discount Percentage RateSKTPZ_KKDEC5(3) PRZ23
XMANLExclude Item from Dunning RunXMANL_KKCHAR1(0) XFELD
KURSFExchange rateKURSF_KKDEC9(5) EXCRTKURSF
BETRHAmount In Local Currency With +/- SignsBETRH_KKCURR13(2) WRTV7
BETRWAmount in Transaction Currency with +/- SignBETRW_KKCURR13(2) WRTV7
BETR2Amount in Second Parallel Currency with +/- SignBETR2_KKCURR13(2) WRTV7
BETR3Amount in Third Parallel Currency with +/- SignBETR3_KKCURR13(2) WRTV7
SKFBTAmount Eligible for Cash Discount in Document CurrencySKFBT_KKCURR13(2) WRTV7
SBETHTax Amount in Local Currency With +/- SignSBETH_KKCURR13(2) WRTV7
SBETWTax Amount in Transaction Currency with +/- SignSBETW_KKCURR13(2) WRTV7
SBET2Tax Amount in Second Parallel CurrencySBET2_KKCURR13(2) WRTV7
SBET3Tax Amount in Third Parallel CurrencySBET3_KKCURR13(2) WRTV7
MWSKOAccount for posting taxes for down paymentsMWSKO_KKCHAR10(0) SKA1ALPHASAKNR
MWVKOAccount for offsetting tax posting in down paymentsMWVKO_KKCHAR10(0) SKA1ALPHASAKNR
TXRULUpdate Rule for Tax and Tax ClearingTXRUL_KKCHAR1(0) TXRUL_KK
SPZAHLock Reason for Automatic PaymentSPZAH_KKCHAR1(0) TFK008SPZAH_KK
PYMETPayment MethodPYMET_KKCHAR1(0) Assigned to domainPYMET_KK
PYBUKCompany Code for Automatic Payment TransactionsPYBUK_KKCHAR4(0) T001BUKRS
PERNRPersonnel NumberPERNR_DNUMC8(0) PERNRPER
GRKEYGrouping Key for Displaying Open ItemsGRKEY_KKCHAR3(0) CHAR3
PERSLKey for Period AssignmentPERSL_KKCHAR4(0) TFK001PPERSL_KK
XAESPPrinting - No Changes PossibleXAESP_KKCHAR1(0) XFELD
AUGDTClearing DateAUGDT_KKDATS8(0) DATUM
AUGBLClearing Document or Printed DocumentAUGBL_KKCHAR12(0) ALPHAAUGBL_KK
AUGBDClearing Document Posting DateAUGBD_KKDATS8(0) DATUM
AUGRDClearing ReasonAUGRD_KKCHAR2(0) TFK001AAUGRD_KK
AUGWAClearing CurrencyAUGWA_KKCUKY5(0) Assigned to domainWAERS
AUGBTClearing Amount in Clearing CurrencyAUGBT_KKCURR13(2) WRTV7
AUGBSTax Amount in Clearing CurrencyAUGBS_KKCURR13(2) WRTV7
AUGSKCash Discount Granted/Surcharge Levied in Clearing CurrencyAUGSK_KKCURR13(2) WRTV7
AUGVDValue date for clearingAUGVD_KKDATS8(0) DATUM
AUGOBItem CanceledAUGOB_KKCHAR1(0) XFELD
WHANGNumber of repetition itemsWHANG_KKNUMC3(0) NUM03
WHGRPRepetition groupWHGRP_KKNUMC3(0) Assigned to domainWHGRP_KK
XEIPHCreate Line Item in General LedgerXEIPH_KKCHAR1(0) XFELD
MAHNVDunning ProcedureMAHNV_KKCHAR2(0) TFK047AMAHNV_KKFKK_MAHNVMAHNV
MANSPDunning Lock ReasonMANSP_KKCHAR1(0) TFK047SMANSP_KK
XAUGPCheck Sample Record ClearingXAUGP_KKCHAR1(0) XFELD
ABRZULower Limit of Billing PeriodABRZU_KKDATS8(0) DATUM
ABRZOUpper Limit of the Billing PeriodABRZO_KKDATS8(0) DATUM
FDGRPPlanning GroupFDGRP_KKCHAR10(0) T035ALPHAFDGRPFFG
FDLEVPlanning levelFDLEV_KKCHAR2(0) T036FDLEVFFE
FDZTGAdditional Days for Cash ManagementFDZTG_KKNUMC2(0) NUM2
FDWBTPlanned Amount in Document or G/L Account CurrencyFDWBT_KKCURR13(2) WERTV7
XTAUSItem SplitXTAUS_KKCHAR1(0) XFELD
AUGRSClearing restrictionAUGRS_KKCHAR1(0) AUGRS_KK
PYGRPGrouping field for automatic paymentsPYGRP_KKCHAR10(0) CHAR10
PDTYPCategory of Payment SpecificationPDTYP_KKCHAR1(0) PDTYP_KK
SPERZInterest Lock ReasonSPERZ_KKCHAR1(0) TFK056SSPERZ_KK
INFOZDoubtful Item Entry/Individual Value AdjustmentINFOZ_KKNUMC3(0) INFOZ_KK
TXJCDTax JurisdictionTXJCDCHAR15(0) TTXJTXJCDTXJ
TXDATDecisive Date for Calculating TaxesTXDAT_KKDATS8(0) DATUM
VBUNDCompany ID of Trading PartnerRASSCCHAR6(0) T880ALPHARCOMPPGS
KONTTAccount Assignment CategoryKONTT_KKCHAR2(0) TFK000KKONTT_KK
KONTLAcct assnmnt string for industry-specific account assngmentsKONTL_KKCHAR50(0) CHAR50
OPSTADunning indicatorOPSTA_KKCHAR3(0) OPSTA_KK
BLARTDocument TypeBLART_KKCHAR2(0) TFK003BLART_KK
EMGPAAlternative Business Partner for PaymentsEMGPA_KKCHAR10(0) BUT000ALPHABU_PARTNERBUPAPARTNER
EMBVTBank Details ID of PayeeEMBVT_KKCHAR4(0) BUT0BKCHAR4
EMADRAddress NumberAD_ADDRNUMCHAR10(0) Assigned to domainALPHAAD_ADDRNUMADR
IKEYInterest KeyIKEY_KKCHAR2(0) TFK056AIKEY_KK
EUROUStatus of Euro ConversionEUROU_KKCHAR1(0) EUROU_KK
XRAGLClearing posting reversedXRAGL_KKCHAR1(0) XFELD
XWHPOExpanded Repetition ItemXWHPO_KKCHAR1(0) XFELD
ASTKZStatistical Key of the Initiating ItemASTKZ_KKCHAR1(0) ASTKZ_KK
ASBLGNumber of Triggering DocumentASBLG_KKCHAR12(0) Assigned to domainALPHAOPBEL_KK
XBLNRReference document numberXBLNR_KKCHAR16(0) ALPHAXBLNR_KK
INKPSCollection ItemINKPS_KKNUMC3(0) NUM03
RNDPSType of Rounding ItemRNDPS_KKCHAR1(0) RNDPS_KK
QSSKZWithholding Tax CodeQSSKZCHAR2(0) T059QQSSKZ
QSSEWWithholding Tax SupplementQSSEW_KKCHAR2(0) Assigned to domainQSSEW_KK
QSPTPLine Item Category From Withholding Tax ViewQSPTP_KKCHAR1(0) QSPTP_KK
QSSHBTax Base AmountQSSHB_KKCURR13(2) WRTV7
QBSHBWithholding Tax Amount (in Document Currency)QBSHB_KKCURR13(2) WRTV7
QSPRZWithholding Tax PercentageQSPRZ_KKNUMC6(0) STPRZ_KK
QSZNRCertificate Number of the Withholding Tax ExemptionQSZNRCHAR10(0) CHAR10
XWHEXVariable Withholding Tax in DFKKOPWHXWHEX_KKCHAR1(0) XFELD
RFUPKReference Item In FI-CA DocumentRFUPK_KKNUMC4(0) OPUPK_KK
STRKZTax Code for Other TaxesSTRKZ_KKCHAR2(0) TFK007FSTRKZ_KK
FITPRTax typeJ_1AFITP_DCHAR2(0) J_1AFITPVJ_1AFITP
XPYORItem Included in a Payment OrderXPYOR_KKCHAR1(0) XPYOR_KK
LANDLCountry Supplied (for Tax Notifications)LANDL_KKCHAR3(0) T005LAND1
INTBUReason for Automatic Creation of PostingINTBU_KKCHAR1(0) INTBU_KK
EMCRDAlternative Payment Card ID in DocumentEMCRD_KKCHAR6(0) CHAR6
C4EYECheck Reason for Workflows Acc. to Dual Control PrincipleC4EYE_KKCHAR2(0) Assigned to domainC4EYE_KK
CFOPNCFOP Code and ExtensionJ_1BCFOPCHAR10(0) Assigned to domainCFOBRJ_1BCFOP
C4EYPEditing Process To Be ConfirmedC4EYP_KKCHAR1(0) C4EYP_KK
TXGRPGrouping Key for Tax ItemsTXGRP_KKCHAR6(0) CHAR6
SCTAXTax Portion in FI-CA Local CurrencySCTAX_KKCURR13(2) WRTV7
STTAXTax Amount as Statistical Information in Document CurrencySTTAX_KKCURR13(2) WRTV7
STZALStatus of Payment ProcessingSTZAL_KKCHAR1(0) STZAL_KK
ORUPZSubitem Number before Item SplitORUPZ_KKCHAR3(0) CHAR3
NEGBUControl Field for Negative PostingNEGBU_KKNUMC1(0) NEGBU_KK
SUBAPSubapplication in Contract Accounts Receivable and PayableSUBAP_KKCHAR1(0) SUBAP_KK8SA
PSWSLUpdate Currency for General Ledger Transaction FiguresPSWSL_KKCUKY5(0) Assigned to domainWAERS
PSWBTAmount for Updating in General LedgerPSWBT_KKCURR13(2) WRTV7
PSWTXTax Amount for Update in General LedgerPSWTX_KKCURR13(2) WRTV7
PSGRPGrouping Key for Document ItemsPSGRP_KKCHAR4(0) CHAR4
XCOLCItem Is Included in Collection CaseXCOLC_KKCHAR1(0) XFELD
AASTAControl Field for Account Assignment DistributionsAASTA_KKCHAR1(0) AASTA_KK
XCSHADocument Contains Assignments from Cash FlowsXCSHA_KKCHAR1(0) XFELD
REACCOriginating Account in Cash Flow AnlaysisREACC_KKCHAR10(0) Assigned to domainALPHASAKNR
REBUKPartner Company Code for Cash Flow AnalysisREBUK_KKCHAR4(0) Assigned to domainBUKRS
XUSTPDTax on Sales/Purchases Was Calculated by DocumentXUSTPD_KKCHAR1(0) XFELD
PTITMStatus of Partner Settlement Using Billable ItemsPTITM_KKCHAR1(0) PTITM_KK
EMMNDSEPA Mandate IdentifierEMMND_KKNUMC6(0) NUM06
PALIXItem Is Part of a Collaborative LiabilityPALIX_KKCHAR1(0) PALIX_KK
CLRLOCKClearing Lock ReasonCLRLO_KKCHAR1(0) TFK000SSPPOS_KK
PNNUMSEPA: Number of Direct Debit Pre-NotificationPNNUM_KKCHAR16(0) ALPHAPNNUM_KK
PNHKFSEPA: Origin of Direct Debit Pre-NotificationPNHKF_KKCHAR2(0) PNHKF_KK
PNEXDSEPA: Date of Execution of Direct Debit Pre-NotifcationPNEXD_KKDATS8(0) DATUM
PNCTRSEPA: Requirement for a Pre-NotificationPNCTR_KKCHAR1(0) PNCTR_KK
FINREContract Account of Final RecipientFINRE_KKCHAR12(0) ALPHAVKONT_KKFKKVKP_F4VKONT
RDSTACurrent Distribution StatusRDSTA_KKCHAR1(0) RDSTAT_KK
RDSTBLast Distribution Status ReportedRDSTB_KKCHAR1(0) RDSTAT_KK
FASTAFactoring: Current Status of ReceivableFASTA_KKCHAR1(0) FASTA_KK
PASTAFactoring: Check Status for Clearing InformationPASTA_KKCHAR1(0) PASTA_KK
OPUPFSubitems in FactoringOPUPF_KKNUMC3(0) OPUPZ_KK
FMTYPUpdate Method for FM - FI-CA IntegrationFMTYP_KKCHAR2(0) FMTYP_KK
ORIGFIKRSOriginal FM Area for FM Account AssignmentORIGFIKRS_KKCHAR4(0) Assigned to domainFIKRS
FIPEXCommitment itemFM_FIPEXCHAR24(0) Assigned to domainFM_FIPEXFPS
FISTLFunds CenterFISTLCHAR16(0) Assigned to domainFISTLFIS
FONDSFundBP_GEBERCHAR10(0) Assigned to domainBP_GEBERFIC
FKBERFunctional AreaFKBERCHAR16(0) Assigned to domainFKBERFBE
MEASUREFunded ProgramFM_MEASURECHAR24(0) Assigned to domainFM_MEASUREFM_MEASURE
GRANT_NBRGrantGM_GRANT_NBRCHAR20(0) ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERICGRANT_NUMBER
BUDGETYEAROriginal Year for FM Account AssignmentFM_START_OF_CHAINNUMC4(0) GJAHRGJAHR
BUDGET_PDBudget PeriodFM_BUDGET_PERIODCHAR10(0) Assigned to domainFM_BUDGET_PERIODBUDPER
APERDNon-Periodic PostingAPERI_SCCHAR1(0) BOOLE
COLOGRPColocation Group for Business PartnerCOLOGRP_BP_KKCHAR12(0) COLOGRP_KK
HERKF_KKDocument Origin KeyHERKF_KKCHAR2(0) Assigned to domainHERKF_KK
/SAPCE/FKRU_CNNumber of corrected document/SAPCE/FKRU_CBLNRCHAR12(0) ALPHAOPBEL_KKFKDCFOPBEL
/SAPCE/FKRU_CDPosting date of corrected document/SAPCE/FKRU_CUDATDATS8(0) DATUM
/SAPCE/FKRU_RNRevision Number/SAPCE/FKRU_RNUMNUMC2(0) /SAPCE/FKRU_RNUM
/SAPCE/FKRU_ABDate from which time slice is validABZEITSCHDATS8(0) DATUM
/SAPCE/FKRU_BISDate at Which a Time Slice ExpiresBISZEITSCHDATS8(0) DATUM
INTOPInternal Generation Characteristic for Document ItemINTOP_KKCHAR1(0) INTOP_KK
CPUDT_OPDocument Item Creation DateCPUDT_OP_KKDATS8(0) DATUM
CPUTM_OPTime of Document Item CreationCPUTM_OP_KKTIMS6(0) UZEIT
CPUDT_STDocument Item Reversal DateCPUDT_ST_KKDATS8(0) DATUM
CPUTM_STTime of Document Item ReversalCPUTM_ST_KKTIMS6(0) UZEIT
_DATAAGINGData Filter Value for Data AgingDATA_TEMPERATUREDATS8(0) DATA_TEMPERATURE
AUGREAdditional Clearing RestrictionAUGRE_KKCHAR3(0) TFK004ARAUGRE_KK
INTTXInternal Tax Characteristic for Tax HandlingINTTX_KKCHAR1(0) XFELD
TXDAT_FROMValid-From Date of the Tax RateFOT_TXDAT_FROMDATS8(0)
DUMMY_FKKOP_INCL_EEW_PSCustom Fields: Dummy for Use in Extension IncludesCFD_DUMMYCHAR1(0)
MAHNSDunning LevelMAHNS_KKNUMC2(0) MAHNS_KK
XDISCCreate Disconnection OrderEXDISCONCHAR1(0) XFELD




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!