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

T5A74 Table in SAP | E18 Consolidation File Table & Fields List

T5A74 is a SAP table coming under PY module and SAP_HRCAT component.View details, Fields & related tables of T5A74 in SAP.

  • Table description : E18 Consolidation File
  • Module : PY-AT
  • Parent Module : PY
  • Package : PC03
  • Software Component : SAP_HRCAT
T5A74 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 T5A74 Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
.INCLUDEKey of Person-Related Payslip-Dependent Revision Records    
PERNRPersonnel numberPERSNOPERSNO
REVTYRevision TypeP03_REVTYP03_REVTY
BEGDAStart DateBEGDADATUM
ENDDAEnd DateENDDADATUM
SEQNRSequence Document NumberP03_SEQNRP03_SEQNR
.INCLUDETechnical Information of a Payslip-Dependent Revision Record    
SETYPRecord Type for Electronic NotificationP03_SETYPP03_SETYP
READYRelease Status for Electronic TransferP03_READYP03_READY
SRTZAProcess Status for Consolidation and Notification CreationP03_SRTZAP03_SRTZA
EMETHElectronic Notification ProcedureP03_EMETHP03_EMETH
LZTYPPayslip Data CategoryP03_LZTYPP03_LZTYP
UNAMEUser NameP03_MUNAMUNAME
DATUMDateP03_MDATUDATUM
UZEITTimeP03_MTIMEUZEIT
PGMIDABAP Program NameP03_MPROGPROGNAME
.INCLUDEPayslip - General ELDA Consolidation Data    
EPRO2ELDA ProjectP03_EPRO2P03_EPRO2
ESVGRSI Group Transferring DataP03_ESVGRASVGR
EUSVAELDA: Insurance Agency as Data RecipientPC03_UVST0  
WOBD0Additional Classification Key for EmployerPB03_WOBD0TEXT12
ZOBD0Additional Classification Key for EmployerPB03_ZOBD0TEXT15
EDTNRELDA: Data Medium NumberPC03_DTRNRCHAR6
ESANRELDA: Sequence Record Number for Each Data MediumPC03_LFDNRNUM07
.INCLUDEInclude 1 E18 Consolidation Data    
ESANIELDA: Number of the Corresponding Information RecordP03_ESANINUM07
.INCLUDEGeneral Payslip Tax and Consolidation Data    
LFVERPayslip Tax: Structure VersionP03_LFVERNUMC2
TFDATDate of TransferP03_TFDATDATS
TFTIMTime of TransferP03C_P_TIMSYTIME
FEHL1Error ID for Electronic Notification RecordP03_LZEIDCHAR005
FEHL2Error ID for Electronic Notification RecordP03_LZEIDCHAR005
FEHL3Error ID for Electronic Notification RecordP03_LZEIDCHAR005
FEHL4Error ID for Electronic Notification RecordP03_LZEIDCHAR005
FEHL5Error ID for Electronic Notification RecordP03_LZEIDCHAR005
ESTATExternal Process StatusP03_EPSTACHAR1
ANZA0Payslip Tax: Number of Notifications (Current)P03_ANZA0NUM7
TTE18Total Number of Annual E18 Payslips for DMEP03_ANZE18NUM7
REFNRReference NumberP03_REFNRCHAR30
AUSVL1st part of SI number (sequential number)AUSVLNUM4
AUSVG2nd part of SI number (birthdate)AUSVGNUM8
ANNNALast NamePAD_NACHNPAD_NACHN
ANVNAFirst NamePAD_VORNAPAD_VORNM
ANTITTitleTITELTITEL
GESCHGender KeyGESCHGESCH
ANADREmployee's Residential AddressP03_ANLSTPAD_STRAS
ANLKZVehicle Country Key for Home AddressP03_ANLKZLANDK
ANPLZPostal Code of Residential AddressP03_ANPLZPSTLZ
ANORTType of ResidenceP03_ORT01PAD_ORT01
ANNUMTax Number - EmployeeP03_ANSTENUM7
ANFZATax Office Number of Employee (4-Digit)P03_ANFA0FZAMA
LOHNBEmployer Assignment UnitP03_LOHNBP03_LOHNB
AGNUMEmployer Tax NumberP03_AGNUMCHAR7
AGFZATax office numberFZAMAFZAMA
AGDVREmployer's Data Processing NumberP03_DVRNRCHAR7
AGNAMName of EmployerP03_NAMAGTEXT80
AGTITTitle of EmployerP03_TITAGTEXT30
AGADRAddress of Employer/Contracting Party/Benefits ProviderP03_ADRAGTEXT60
AGLKZVehicle Country Key for Company Address of Empl./Contr.PartyP03_AGLKZLANDK
AGZIPPostal Code in Company Address of Employer, Contractng PartyP03_AGPLZPSTLZ
AGORTCity in Company Address of EmployerP03_ORTAGPAD_ORT01
LBTELAddresses: telephone no.TLFNRTEXT30
LBFAXFax numberTELFX_BASTEXT31
LVNUMTax Number of Payroll Service ProviderP03_TRSTNCHAR7
LVFZATax Office Number of Payroll Service ProviderP03_TRFANFZAMA
LVDVRData Processing Number of Payroll Service ProviderP03_TRDVRCHAR7
ARTE0Type of Payslip E18 (Service Provided)P03_ARTE0P03_ARTE0
WAERSCurrency KeyWAERSWAERS
KZ341Remuneration (Without Sales Tax, Incl. Cost Reimb., P/K)P03_KZ341PRBETRG
KZ344Invoiced Sales Tax (KZ344)P03_KZ344PRBETRG
KZ270Employee's Contribution to Social InsuranceP03_KZ270PRBETRG
KZ271Paid Contribution to Company Pension Fund (BV)P03_KZ271PRBETRG
INPERLast In-Period of Payroll in the RecordP03_IPERICHAR6
REFN0Reference NumberP03_REFNRCHAR30

T5A74 related tables

TableNote
T5A74E18 Consolidation File
TF189AInactive Consolidation Units per Consolidation Group
T5A71L16 Consolidation File
T5A72BGN(GKK) Consolidation File
T5A73BGN(BVA) Consolidation File
DMC_OUTFDMC: File Paths and File Names
ESH_OM_IE_BUFFERFile Upload - Data Provider Metadata (File)
MDGD_FILE_CONVFile converter types in File Uploader Application
T5M8JFile entries for PBS file
T7EHS00_QSCANPFile Path for the Scanner ASCII File
TNS24IS-H: Log File for Totals Records File Services
/SAPDMC/LSOFILFile Paths and File Names
/UI5/CFS_FILEUI Theming: File in client-dependent file system
BUTEOPCONSStore the EOP details of Consolidation system id
CATS_APPR_FIELDSCATS Approval: Fields for Consolidation
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