OIUX3_RPT_PROF

Tax Reporting - Reporting Profile | #masterdata | Component: Tax Reporting
Column Name Description
MANDT FK Client
RPT_COMP FK Reporting Company
RPT_ID FK Report ID
EFF_FROM_DT Effective from date
Column Name Description
Column Name Description
Column Name Description
EFF_FROM_DT Effective from date
EFF_TO_DT Effective To Date
CHANGE_DATE Date of Last Change
CHANGE_TIME Time of Last Change
Column Name Description
TAXPAYER_ID_FEIN Boolean Variable (X = True, - = False, Space = Unknown) Show values
TAXPAYER_ID_SSN Boolean Variable (X = True, - = False, Space = Unknown) Show values
TAXPAYER_ID_ITIN Boolean Variable (X = True, - = False, Space = Unknown) Show values
CONTACT_ID_FEIN Boolean Variable (X = True, - = False, Space = Unknown) Show values
CONTACT_ID_SSN Boolean Variable (X = True, - = False, Space = Unknown) Show values
CONTACT_ID_ITIN Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
TAXPAYER_NUMBER Taxpayer Number TEXT20
TAXPAYER_NAME Taxpayer Name TEXT100
ADDRESS_LINE1 Taxpayer Address Line TEXT35
ADDRESS_LINE2 Taxpayer Address Line TEXT35
ADDRESS_LINE3 Taxpayer Address Line TEXT35
ORT01 City TEXT35
PSTLZ Postal Code PSTLZ
CONTACT_NAME Contact Name TEXT50
CONTACT_PHONE_NO Contact Telephone Number NUMC10
CONTACT_PHONE_EX Contact Telephone Extension CHAR5
CONTACT_EMAIL Contact E-Mail Address TEXT80
FEIN_SSN Tax 2.0 - FEIN/SSN
CHANGE_USER Last Changed By USNAM
CONTACT_FAX_NO Contact Fax Number NUMC10
BAN_NO Blanket Authorization Number CHAR4
ACCOUNT_NO Rpt 2.0 - Account Number NUMC10
TAXPAYER_PHONE_NO Taxpayer Telephone Number NUMC10
TAXPAYER_PHONE_EX Taxpayer Telephone Extension CHAR5
TAXPAYER_EMAIL Taxpayer E-Mail Address TEXT80
TAXPAYER_FEIN_SSN Taxpayer FEIN/SSN
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • OIUX3_RPT_PROF.LAND1 == T005.LAND1
  • OIUX3_RPT_PROF.MANDT == T005.MANDT
Client OIUX3_RPT_PROF.MANDT == T000.MANDT
Region (State, Province, County)
  • Country/Region Key
  • Region (State, Province, County)
  • OIUX3_RPT_PROF.MANDT == T005S.MANDT
  • OIUX3_RPT_PROF.LAND1 == T005S.LAND1
  • OIUX3_RPT_PROF.REGIO == T005S.BLAND
Reporting Company
  • Reporting Company
  • Client
  • Report ID
Report ID
  • Reporting Company
  • Client
  • Report ID