LFA1_ACT

Master Data Consolidation: Best Record Table for LFA1 | #masterdata | #language | Component: Business Partner.
Column Name Description
MANDT Client
PARTNER Business Partner Number
ASSIGNMENT_ID Multiple Assignment ID (Number)
Column Name Description
Column Name Description
Column Name Description
ERDAT Date on which the Record Was Created
GBDAT Date of Birth of the Person Subject to Withholding Tax
REVDB Last External Review
UPDAT Date on Which the Changes Were Confirmed
UPTIM Time of Last Change Confirmation
QSSYSDAT Validity Date of Certification
RGDATE RG Issuing Date
RNEDATE RNE Issuing Date
Column Name Description
DTAMS Report key for data medium exchange Show values
LOEVM Central Deletion Flag for Master Record Show values
SPERR Central posting block Show values
SPERM Centrally imposed purchasing block Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
STKZU Liable for VAT Show values
XCPDK Indicator: Is the account a one-time account? Show values
XZEMP Indicator: Alternative Payee in Document Allowed? Show values
STKZN Natural Person Show values
SEXKZ Key for the Sex of the Person Subject to Withholding Tax Show values
LTSNA Indicator: vendor sub-range relevant Show values
WERKR Indicator: plant level relevant Show values
DUEFL Status of Data Transfer into Subsequent Release Show values
SPERZ Payment Block Show values
XLFZA Indicator: Alternative Payee Using Account Number Show values
REGSS Registered for Social Insurance Show values
IPISP Tax Split Show values
TAXBS Tax Base in Percentage Show values
NODEL Central deletion block for master record Show values
PODKZB Supplier indicator relevant for proof of delivery Show values
CARRIER_CONF Carrier confirmation is expected Show values
MIN_COMP Micro company indicator Show values
TERM_LI Terms of Liability Show values
CVP_XBLCK Business Purpose Completed Flag Show values
WEORA Acceptance At Origin Show values
CRTN CRT Number Show values
ALLOWANCE_TYPE TW: Allowance Type in Business Partner Extension Show values
Column Name Description Domain name
LIFNR Account Number of Supplier LIFNR
LAND1 Country/Region Key LAND1
NAME1 Name 1 NAME
NAME2 Name 2 NAME
NAME3 Name 3 NAME
NAME4 Name 4 NAME
ORT01 City TEXT35
ORT02 District TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
PSTLZ Postal Code PSTLZ
REGIO Region (State, Province, County) REGIO
SORTL Sort field CHAR10
STRAS Street and House Number TEXT35
ADRNR Address ADRNR
MCOD1 Search term for matchcode search CHAR25
MCOD2 Search term for matchcode search CHAR25
MCOD3 Search term for matchcode search CHAR25
ANRED Title TEXT15
BAHNS Train station BAHNH
BBBNR International location number (part 1) NUM07
BBSNR International location number (Part 2) NUM05
BEGRU Authorization Group BRGRU
BUBKZ Check digit for the international location number NUM01
DATLT Data communication line no. TEXT14
DTAWS Instruction Key for Data Medium Exchange DTAWS
ERNAM Name of Person who Created the Object USNAM
ESRNR ISR subscriber number ESRNR
KONZS Group key KONZS
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
TELBX Telebox number TEXT15
TELF1 First telephone number TEXT16
TELF2 Second telephone number TEXT16
TELFX Fax Number TEXT31
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
STCEG VAT Registration Number STCEG
GBORT Place of birth of the person subject to withholding tax TEXT25
KRAUS Credit Information Number CHAR11
PFORT PO Box city TEXT35
WERKS Plant (Own or External) WERKS
SCACD Standard carrier access code SCACD
STCD3 Tax Number 3 CHAR18
STCD4 Tax Number 4 CHAR18
STCD5 Tax Number 5 CHAR60
STCD6 Tax Number 6 CHAR20
PROFS Profession TEXT30
EMNFR External manufacturer code name or number CHAR10
LFURL Uniform resource locator TEXT132
J_1KFREPRE Name of Representative REPRES
CONFS Status of Change Authorization (Central) CHAR1
STENR Tax Number at Responsible Tax Authority CHAR18
CRC_NUM CRC number CHAR25
RG RG Number J_1BRG
EXP Issued by J_1BEXP
UF State J_1BUF
RIC RIC Number J_1BRIC
RNE Foreign National Registration J_1BRNE
PAYTRSN Payment Reason FARP_PAYT_RSN
RECENCY Master Data Consolidation: Recency TZNTSTMPS
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
TARGET_ASSIGNMENT_ID Multiple Assignment ID (Number) MDG_BP_ASSIGNMENT_ID
Master Data Relations | to Other Relations ↓ Join Conditions
Activation Code for Social Insurance
  • Activity Code for Social Insurance
  • Client
Industry key
  • Industry key
  • Client
  • LFA1_ACT.BRSCH == T016.BRSCH
  • LFA1_ACT.MANDT == T016.MANDT
CNAE
  • CNAE
  • Client
Company Size
  • Company Size
  • Client
Declaration Regimen for PIS/COFINS
  • Declaration Regimen for PIS/COFINS
  • Client
Service agent procedure group
  • LFA1_ACT.MANDT == TVFCD.MANDT
  • LFA1_ACT.DLGRP == TVFCD.DLGRP
Account number of the master record with fiscal address
  • LFA1_ACT.MANDT == LFA1.MANDT
  • LFA1_ACT.FISKN == LFA1.LIFNR
Account Number of Master Record of Tax Office Responsible
  • LFA1_ACT.MANDT == LFA1.MANDT
  • LFA1_ACT.FISKU == LFA1.LIFNR
Tax Type
  • Tax type
  • Client
  • ?
  • LFA1_ACT.FITYP == J_1AFITP.J_1AFITP
  • LFA1_ACT.MANDT == J_1AFITP.MANDT
  • LFA1_ACT.[column in domain "KOART"] == J_1AFITP.KOART
ICMS Taxpayer
Industry Main Type
Reference Account Group for One-Time Account (Vendor)
  • Reference Account Group for One-Time Account (Vendor)
  • Client
  • LFA1_ACT.KTOCK == T077K.KTOKK
  • LFA1_ACT.MANDT == T077K.MANDT
Vendor account group
  • Vendor account group
  • Client
  • LFA1_ACT.KTOKK == T077K.KTOKK
  • LFA1_ACT.MANDT == T077K.MANDT
Customer Number
  • LFA1_ACT.MANDT == KNA1.MANDT
  • LFA1_ACT.KUNNR == KNA1.KUNNR
Legal Nature
Account Number of the Alternative Payee
  • LFA1_ACT.MANDT == LFA1.MANDT
  • LFA1_ACT.LNRZA == LFA1.LIFNR
Transportation zone to or from which the goods are delivered
  • Country/Region Key
  • Client
  • Transportation zone to or from which the goods are delivered
  • LFA1_ACT.LAND1 == TZONE.LAND1
  • LFA1_ACT.MANDT == TZONE.MANDT
  • LFA1_ACT.LZONE == TZONE.ZONE1
Factory calendar key LFA1_ACT.PLKAL == TFACD.IDENT
Supplier's QM System
  • LFA1_ACT.MANDT == TQ02B.MANDT
  • LFA1_ACT.QSSYS == TQ02B.QSSYSFAM
Forwarding agent freight group
  • Forwarding agent freight group
  • Client
  • LFA1_ACT.SFRGR == TSFG.SFRGR
  • LFA1_ACT.MANDT == TSFG.MANDT
Function That Will Be Blocked
  • LFA1_ACT.MANDT == TQ04A.MANDT
  • LFA1_ACT.SPERQ == TQ04A.SPERRFKT
Language Key LFA1_ACT.SPRAS == T002.SPRAS
Possible Checks for Tax Number 1
Shipment: statistics group, transportation service agent
  • LFA1_ACT.MANDT == VTSGD.MANDT
  • LFA1_ACT.STGDL == VTSGD.STGDL
Tax Declaration Type
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • LFA1_ACT.MANDT == TTXJ.MANDT
  • LFA1_ACT.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • LFA1_ACT.TXJCD == TTXJ.TXJCD
Company ID of Trading Partner
  • LFA1_ACT.MANDT == T880.MANDT
  • LFA1_ACT.VBUND == T880.RCOMP
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
Type of Industry