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

J_3RFTAX_EXTRD Table in SAP | Tax Extract Detail Lines Table & Fields List

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

  • Table description : Tax Extract Detail Lines
  • Module : FI-LOC
  • Parent Module : FI
  • Package : J3RFTAX
  • Software Component : SAP_FIN
J_3RFTAX_EXTRD 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 J_3RFTAX_EXTRD Table Fields structure

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
EXTRTExtract nameJ_3RF_TAX_EXTRACTJ_3RF_TAX_EXTRACT
BUKRS1Company CodeBUKRSBUKRS
BELNR1Accounting Document NumberBELNR_DBELNR
GJAHR1Fiscal YearGJAHRGJAHR
BUZEI1Number of Line Item Within Accounting DocumentBUZEIBUZEI
.INCLUDELine Item data for Customer/Vendor/G/L Account    
ACTIVList Level in which the Line Item is ActiveACTIVNUM02
ANLN1Main Asset NumberANLN1ANLN1
ANLN2New asset subnumber, 4 charactersANLN2_4ANLN2_4
AUFNROrder NumberAUFNRAUFNR
AUGBLDocument Number of the Clearing DocumentAUGBLBELNR
AUGDTClearing DateAUGDTDATUM
BELNRAccounting Document NumberBELNR_DBELNR
BLARTDocument typeBLARTBLART
BLDATDocument Date in DocumentBLDATDATUM
BSCHLPosting KeyBSCHLBSCHL
BSTATDocument StatusBSTAT_DBSTAT
BUDATPosting Date in the DocumentBUDATDATUM
BUKRSCompany CodeBUKRSBUKRS
BUZEINumber of Line Item Within Accounting DocumentBUZEIBUZEI
BWWRTAmount Valuated in Local CurrencyBWWRTWRTV7
BWWR2Amount Valuated in Local Currency 2BWWR2WRTV7
BWWR3Amount Valuated in Local Currency 3BWWR3WRTV7
DMSHBAmount in Local Currency with +/- SignsDMSHBWRTV7
HWAERLocal CurrencyHWAERWAERS
DMBE2Amount in Second Local Currency with +/- SignDMBE2_VZWRTV7
HWAE2Currency Key of Second Local CurrencyHWAE2WAERS
DMBE3Amount in Third Local Currency with +/- SignDMBE3_VZWRTV7
HWAE3Currency Key of Third Local CurrencyHWAE3WAERS
EBELNPurchasing Document NumberEBELNEBELN
EBELPItem Number of Purchasing DocumentEBELPEBELP
ETEN2Schedule lineETENRETENR
FAEDTNet Due DateFAEDT_FPOSDATUM
FILKDAccount Number of the BranchFILKDMAXKK
GJAHRFiscal YearGJAHRGJAHR
GSBERBusiness AreaGSBERGSBER
JAMONFiscal Year/Posting Period from Posting DateJAMON_XPOJAMON_XPO
KOARTAccount typeKOARTKOART
KONTOAccount NumberKTONR_AVKTONR
KOSTLCost CenterKOSTLKOSTL
MABERDunning AreaMABERMABER
MADATDate of Last Dunning NoticeMADATDATUM
MANSPDunning blockMANSPMANSP
MANSTDunning LevelMAHNS_DMAHNS
MONATFiscal periodMONATMONAT
MSCHLDunning keyMSCHLMSCHL
MWSKZTax on sales/purchases codeMWSKZMWSKZ
POSN2Sales Document ItemPOSNR_VAPOSNR
PRCTRProfit CenterPRCTRPRCTR
QBSHBWithholding Tax Amount (in Doc. Currency) with +/- SignQBSHB_VZWRTV7
QSFBTAmount Free of Withhld.Tax (in Doc.Curr.) with +/- SignQSFBT_VZWRTV7
QSSHBWithholding Tax Base Amount with +/- SignQSSHB_VZWRTV7
REBZGNumber of the Invoice the Transaction Belongs toREBZGBELNR
SAMNRInvoice List NumberSAMNRSAMNR
SGTXTItem TextSGTXTTEXT50
SHKZGDebit/Credit IndicatorSHKZGSHKZG
SKFBTAmount Subject to Discount in Document Curr. with +/- SignSKFBT_VZWRTV7
SKNTOCash Discount Amount (+/-) in Local CurrencySKNTO_VZWRTV7
STAKZIndicator: Statistical document ?XSTKZXFELD
UMSKSSpecial G/L Transaction TypeUMSKSUMSKS
UMSKZSpecial G/L IndicatorUMSKZUMSKZ
UZAWEPayment method supplementUZAWEUZAWE
VALUTFixed Value DateVALUTDATUM
VBEL2Sales DocumentVBELN_VAVBELN
VBELNBilling documentVBELN_VFVBELN
VBEWAFlow TypeSBEWARTSBEWART
VBUNDCompany ID of trading partnerRASSCRCOMP
VERTNContract NumberRANLRANL
VERTTContract TypeRANTYPRANTYP
VERZ1Days in Arrears for Cash Discount Terms 1VERZ1WRTV3
VERZNDays in Arrears by Net Due DateVERZNWRTV3
WERKSPlantWERKS_DWERKS
WRSHBForeign Currency Amount with Signs (+/-)WRSHBWRTV7
WAERSCurrency KeyWAERSWAERS
WSKTOCash discount amount in document currency with +/- signWSKTO_VZWRTV7
WVERWBill of Exchange Usage TypeWVERWWVERW
XBLNRReference Document NumberXBLNR1XBLNR1
XSTRPIndicator: Disputed item?XSTRPXFELD
XZAHLIndicator: Is Posting Key Used in a Payment Transaction?XZAHLXFELD
ZALDTProbable Payment Date (Cash Discount 1 Due)DZALDTDATUM
ZBD1PCash discount percentage 1DZBD1PPRZ23
ZBD1TCash discount days 1DZBD1TZBDXT
ZBD2PCash Discount Percentage 2DZBD2PPRZ23
ZBD2TCash discount days 2DZBD2TZBDXT
ZBD3TNet Payment Terms PeriodDZBD3TZBDXT
ZFBDTBaseline date for due date calculationDZFBDTDATUM
ZINSZInterest Calculation Numerator (Days in Arrears * Amount)DZINSZWRTV8
ZLSCHPayment methodDZLSCHZLSCH
ZLSPRPayment Block KeyDZLSPRZAHLS
ZTERMTerms of payment keyDZTERMZTERM
ZUONRAssignment numberDZUONRZUONR
XREF1Business partner reference keyXREF1CHAR12
XREF2Business partner reference keyXREF2CHAR12
XARCHIndicator: Document already archived ?XARCHXFELD
RSTGRReason Code for PaymentsRSTGRRSTGR
ASKTOCurrent Cash Disc. Amount in Document Currency with +/- SignASKTO_VZWRTV7
KURSEEffective Exchange Rate in the Line ItemKURSEKURSF
REBZTFollow-On Document TypeREBZTREBZT
PSWSLUpdate Currency for General Ledger Transaction FiguresPSWSLWAERS
PSWBTAmount for Updating in General LedgerPSWBTWERT7
HKONTGeneral Ledger AccountHKONTSAKNR
XNEGPIndicator: Negative postingXNEGPXFELD
ZBFIXFixed Payment TermsDZBFIXZBFIX
RFZEIPayment Card ItemRFZEI_CCNUM03
CCBTCPayment cards: Settlement runCCBTCCCBTC
KKBERCredit control areaKKBERKKBER
XREF3Reference key for line itemXREF3CHAR20
DTWS1Instruction key 1DTAT16DTWSX
DTWS2Instruction key 2DTAT17DTWSX
DTWS3Instruction key 3DTAT18DTWSX
DTWS4Instruction key 4DTAT19DTWSX
ABSBTCredit Management: Hedged AmountABSBTWERT7
KKBWRCurrency of Credit Control AreaKKBWRWAERS
PROJKIndividual Structural Element (WBS Element) in Ext. FormatPROJK_EXTCHAR24
XPYPRIndicator: Items from Payment Program BlockedXPYPRXFELD
KIDNOPayment ReferenceKIDNOCHAR30
XAUGPIndicator: Item has been cleared?XAUGPXFELD
BUPLABusiness PlaceBUPLAJ_1BBRANCH
SECCOSection CodeSECCOSECCO
GKARTOffsetting Account TypeGKARTGKART
GKONTOffsetting Account NumberGKONTGKONT
PYCURCurrency for Automatic PaymentPYCURWAERS
PYAMTAmount in Payment CurrencyPYAMTWERT7
PYORDPayment OrderPYORDPYORD
XTEXTIndicator: Texts exist ?XTEXT_F02LXFELD
TDIDText IDTDIDTDID
XDUENIndicator: Item is due net?XDUENXFELD
XDUE1Indicator: Cash discount term 1 is due on item?XDUE1XFELD
XRAGLIndicator: Clearing was ReversedXRAGLXFELD
XSELPItem selected (selected, chosen, ...)XSELPXFELD
CESSION_KZAccounts Receivable Pledging IndicatorCESSION_KZCESSION_KZ
BUZIDIdentification of the Line ItemBUZIDCHAR1
AUGGJFiscal Year of Clearing DocumentAUGGJGJAHR
AGZEIClearing ItemAGZEIAGZEI
VNAMEJoint ventureJV_NAMEJV_NAME
EGRUPEquity groupJV_EGROUPJV_EGROUP
BTYPEPayroll TypeJV_BILINDJV_BILIND
VORGNTransaction Type for General LedgerVORGNVORGN

J_3RFTAX_EXTRD related tables

TableNote
J_3RFTAX_EXTRDTax Extract Detail Lines
OIUX6_WY_CRPDTDTTax 2.0 - Wyoming Conservation Tax Report Detail Detail
OIUX6_WY_SRPDTDTTax 2.0 - Wyoming Severance Tax Report Detail Detail
COAT_E_TY_TCOAT: Extract Text Table to Extract Types
ERCHZ_SHORTBilling Document Individual Lines Extract
ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data
TINV_LINEB_SHORTExtract of Bill Receipt (Evaluation System): Bill Lines
PPMIXIndex Payroll Results Lines -> Posting Lines for Payment
PPOIXIndex of Payroll Result Lines -> Posting Lines
PRSD_CO_MAPPINGEM: Mapping original DMR lines to Carry Over lines
/ISDFPS/CFDPDA02Detail Area - Customizing Detail Screens
OIUX3_TX_PRDTBTax Reporting - Texas PRA Detail Txns-Tier Tax Below
OIUX3_TX_PRDTITax Reporting - Texas PRA Detail Txns-Tier Tax Incremental
OIUX3_TX_PRDTNTax Reporting - Texas PRA Detail Txns - No Tier Tax
OIUX5_OK_PRDTTax 2.0 - Oklahoma PRA Detail Tax Transactions
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