LFA1_SRC

Master Data Consolidation: Source Table for LFA1 | #masterdata | #language | Component: Business Partner.
Column Name Description
MANDT Client
SOURCE_SYSTEM Source System
SOURCE_ID Master Data Consolidation: ID of a Source Objects
ASSIGNMENT_ID Multiple Assignment ID (Number)
Column Name Description
💲 Currency (LFA1.J_SC_CURRENCY):
J_SC_CAPITAL Capital Amount
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
BORGR_DATUN Date Limit for External Document Identification
AEDAT Last Changed On
J_1IPANVALDT PAN Valid From Date
DVALSS Social Security certificate validity 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
BORGR_YEAUN Annual Repetition of Date Limit Show values
AU_CARRYING_ENT Is payer making payment in course of carrying on enterprise Show values
AU_IND_UNDER_18 Is an individual under 18 and payment does not exceed $350 Show values
AU_PAYMENT_NOT_EXCEED_75 The payment does not exceed $75, excl. GST Show values
AU_WHOLLY_INP_TAXED The supply that the payment relates to is wholly input taxed Show values
AU_PARTNER_WITHOUT_GAIN The supply is made by an individual without gain Show values
AU_NOT_ENTITLED_ABN The supplier is not entitled to an ABN Show values
AU_PAYMENT_EXEMPT The whole of the payment is exempt income. Show values
AU_PRIVATE_HOBBY An activity done as a private recreational pursuit Show values
AU_DOMESTIC_NATURE wholly of a private or domestic nature Show values
CATEG Subcontractor's Business Type Show values
STATUS Verification Status Show values
VFNID Tax Status of the Verified Subcontractor Show values
J_1ISSIST SSI Status Show values
J_1IVTYP Type of Vendor Show values
J_1IVENCRE CENVAT Scheme Participant Show values
J_1I_CUSTOMS Customs Vendor Show values
VEN_CLASS Vendor Classification for GST Show values
ENTPUB Vendor is public entity? Show values
AUSDIV Absence of debt Show values
SCHEDULING_TYPE Scheduling Procedure Show values
SUBMI_RELEVANT Cross Docking: Relevant for Collective Numbering 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
LFA1_EEW_SUPP Dataelement Exstensibility for Supplier LFA1_EEW_SUPP
SOURCE_RECENCY Master Data Consolidation: Recency TZNTSTMPS
TARGET_ASSIGNMENT_ID Multiple Assignment ID (Number) MDG_BP_ASSIGNMENT_ID
ADDR2_STREET Street TEXT60
ADDR2_HOUSE_NUM House Number TEXT10
ADDR2_POST City postal code CHAR10
ADDR2_CITY City TEXT40
ADDR2_COUNTRY Country/Region Key LAND1
PARTNER_NAME Partner's Trading Name TEXT30
PARTNER_UTR Partner's Unique Tax Reference (UTR) CHAR20
VFNUM Verification Number CHAR20
CRN Companies House Registration Number
FR_OCCUPATION Organisation Occupation
J_1IEXCD ECC Number CHAR40
J_1IEXRN Excise Registration Number CHAR40
J_1IEXRG Excise Range CHAR60
J_1IEXDI Excise Division CHAR60
J_1IEXCO Excise Commissionerate CHAR60
J_1ICSTNO Central Sales Tax Number CHAR40
J_1ILSTNO Local Sales Tax Number CHAR40
J_1IPANNO Permanent Account Number CHAR40
J_1IEXCIVE Excise tax indicator for vendor J_1IINDTAX
USNAM Changed by the user CHAR12
J_1ISERN Service Tax Registration Number CHAR40
J_1IPANREF PAN Reference Number CHAR40
J_1IDEDREF Deductee Reference Number CHAR10
ESCRIT Deed of public use CHAR80K
FRMCSS Social Security certificate submission form BU_TEXT50
CODCAE CAE code PFM_12CODCAE
STAGING_TIME Staging Time in Days WRF_PSCD_MST
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_SRC.BRSCH == T016.BRSCH
  • LFA1_SRC.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_SRC.MANDT == TVFCD.MANDT
  • LFA1_SRC.DLGRP == TVFCD.DLGRP
Account number of the master record with fiscal address
  • LFA1_SRC.MANDT == LFA1.MANDT
  • LFA1_SRC.FISKN == LFA1.LIFNR
Account Number of Master Record of Tax Office Responsible
  • LFA1_SRC.MANDT == LFA1.MANDT
  • LFA1_SRC.FISKU == LFA1.LIFNR
Tax Type
  • Tax type
  • Client
  • ?
  • LFA1_SRC.FITYP == J_1AFITP.J_1AFITP
  • LFA1_SRC.MANDT == J_1AFITP.MANDT
  • LFA1_SRC.[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_SRC.KTOCK == T077K.KTOKK
  • LFA1_SRC.MANDT == T077K.MANDT
Vendor account group
  • Vendor account group
  • Client
  • LFA1_SRC.KTOKK == T077K.KTOKK
  • LFA1_SRC.MANDT == T077K.MANDT
Customer Number
  • LFA1_SRC.MANDT == KNA1.MANDT
  • LFA1_SRC.KUNNR == KNA1.KUNNR
Legal Nature
Account Number of the Alternative Payee
  • LFA1_SRC.MANDT == LFA1.MANDT
  • LFA1_SRC.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_SRC.LAND1 == TZONE.LAND1
  • LFA1_SRC.MANDT == TZONE.MANDT
  • LFA1_SRC.LZONE == TZONE.ZONE1
Factory calendar key LFA1_SRC.PLKAL == TFACD.IDENT
Supplier's QM System
  • LFA1_SRC.MANDT == TQ02B.MANDT
  • LFA1_SRC.QSSYS == TQ02B.QSSYSFAM
Forwarding agent freight group
  • Forwarding agent freight group
  • Client
  • LFA1_SRC.SFRGR == TSFG.SFRGR
  • LFA1_SRC.MANDT == TSFG.MANDT
Function That Will Be Blocked
  • LFA1_SRC.MANDT == TQ04A.MANDT
  • LFA1_SRC.SPERQ == TQ04A.SPERRFKT
Language Key LFA1_SRC.SPRAS == T002.SPRAS
Possible Checks for Tax Number 1
Shipment: statistics group, transportation service agent
  • LFA1_SRC.MANDT == VTSGD.MANDT
  • LFA1_SRC.STGDL == VTSGD.STGDL
Tax Declaration Type
Transportation Chain
  • Transportation Chain
  • Client
  • ?
Tax Jurisdiction
  • ?
  • Tax Jurisdiction
  • LFA1_SRC.MANDT == TTXJ.MANDT
  • LFA1_SRC.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • LFA1_SRC.TXJCD == TTXJ.TXJCD
Company ID of Trading Partner
  • LFA1_SRC.MANDT == T880.MANDT
  • LFA1_SRC.VBUND == T880.RCOMP
Other Relations | to Master Data Relations ↑ Join Conditions
Type of Business
Type of Industry