Replaced in S/4HANA
This table is replaced by BUT000

Vendor master replaced by Business Partner (BUT000). LFA1 exists as compatibility view. Use BP transaction instead of XK01.

View all S/4HANA migration mappings →

LFA1

Transparent Table Application Table

Supplier Master (General Section)

LFA1 is an SAP database table in S/4HANA. Supplier Master (General Section). It contains 210 fields. 111 CDS views read from this table.

CDS Views using this table (111)

ViewTypeJoinVDMDescription
/dmbe/i_BusinessPartner_Vendor view inner Vendor of a Business Partner
/SCMTMS/CV_BP_Common view left_outer Obsolete: Use CDS View /SCMTMS/VE_BPCMN
/SCMTMS/VE_BPCMN view_entity left_outer BOPF: Business Partner Common TM Data
arun_i_so_reqmt view left_outer Sales Order selection in Normal mode
ARUN_I_SO_REQMT_PREV view left_outer Sales Order selection from Preview table
Arun_I_Sto_1 view left_outer STO Item level Data selection
Arun_Spo_Reqmt view inner Subcontracting PO Requirement
ARUNI_CONF_LINE view inner Confirmations selection at date level
aruni_po_line view left_outer PO selection at date level
aruni_sto_line view inner PO selection at date level
ARUNI_STO_LINE_STK view inner STO as stock
C_Manufctrnmbrtemp view from CONSUMPTION Manufacturer number Value help
C_Purdoclistsuppaddr view from CONSUMPTION Supplier Address
CTE_CDS_INV_MON_VD view_entity inner Monitoring Vendor export to Concur
E_Supplier view from EXTENSION Extensibility Supplier Core
F3_Mmim_Supplier_Vh view from Help-View Supplier (LFA1)
fac_ad_cds_account_buv view left_outer Help View for Account in Trans-Key BUV
fac_ad_cds_vendor view from Value-Help for Suppliers
Fclm_Mm_Vendgrp view inner Supplier Group
Fclm_Mmpo_Pgrp view inner Planning group
fiscds_gllit_02 view left_outer GL Line Item (other Ledger)
FISTRPGSTR3BITEM view left_outer
FISVD_OPNIT_01 view left_outer Open Items of Manual Clearing
FISVD_OPNITM_01 view left_outer Open Items of Manual Clearing
FNDEI_LFA1_BLOCKINGINFO view from Blocking Info View for table LFA1
FNDEI_LFA1_FILTER view from Filter View for table LFA1
FSH_V_Inforecord_Sos_B view inner MM-PUR: Basic CDS View for SOS
I_ACMInboundDeliveryVH view_entity inner BASIC ACM Inbound Delivery
I_ACMPurchaseCounterparty view_entity from BASIC Trading Contract Purchase Counterparty
I_ACMSupPartnerFunction view from BASIC Link Supplier to Partner Function
I_BalanceAuditTrailSupplier view from BASIC Suppliers for Balance Audit Trail
I_BPSupplierFullName view_entity from BASIC Base for reduced Supplier Data
I_CommoditySupplier view from BASIC Supplier Master for Commodity Management
I_CustSuplrDataControllerusge view_entity inner BASIC Customer and Supplier Datacntrlr Usge
I_FreightContractVH view left_outer BASIC Value Help for Freight Contract
I_PrmtHbSupplierContactCard view from BASIC Supplier Data for Contact Card
I_RFM_InboundDeliveryVH view_entity inner BASIC Inbound Delivery
I_SupDmndAllDocPurReqnBsc view left_outer BASIC Basic View for Purchase Requisition
I_SupDmndAllDocPurReqnComp view left_outer BASIC View for Sub Contracting Purchase Requisition Components
I_SuplrContactCard view from BASIC Supplier Contact Card
I_Supplier view from BASIC Supplier
I_SupplierAddress view from COMPOSITE Supplier
I_SupplierDataControllerUsage view_entity inner BASIC Supplier DataController Usage
I_SupplierMaster view from BASIC Supplier master (General Section)
I_TrdgContrSupplier view from BASIC Trading Contract Supplier Description
I_TripPartnerInfo view from BASIC Cds for partner information
J2G_SHSM_KRED1 view from
J2G_SHSM_KRED2 view from
m_v_eop_vendor view from EOP Check CDS View: Vendor Master
M_V_inforecord view left_outer MM-PUR: CDS View for Purchasing Info Record
m_v_inforecord_sos view inner MM-PUR: CDS View for SOS
M_V_Inforecord_Sos_B view inner MM-PUR: Basic CDS View for SOS
m_v_m2s_pd_hdr view left_outer View for Purchasing Document Header
m_v_m2s_pd_itm view left_outer View for Purchasing Document Item
m_v_m2s_pr_itm view left_outer CDS View for Purchase Requisition
m_v_outline_agreement_sos view inner MM-PUR: CDS View for SOS
M_V_Outline_Agreement_Sos_B view left_outer MM-PUR: Basic CDS View for SOS
MDGI_Supplier_BPMultiAssgn view from Supplier for BP Multiple Assignment
Mmim_Supplier_Data view from Get Supplier Data
Oij05_GNominations view left_outer To fetch nominations
OIJ05_GSCHED view left_outer CDS for Global Sim in OIJ_SCHED
OIJ05_GSCHED_LO view left_outer CDS for Location Balancing Global Sim in OIJ_SCHED
OIJ05_ICSCHED view left_outer To fetch global simulation of type IC
Oij05_Nominations view left_outer To fetch nominations
Oij05_Oijgsched view left_outer CDSV for GSched
Oij05_Oijgsched_Sim view left_outer CDS View for Oij05_Oijgsched_Sim
Oij05_Oijsched view left_outer CDSV for OIJSCHED
Oij05_Oijsched_Sim view left_outer CDSV for OIJ05_SCHED_SIM
Oij05_Sched view left_outer CDS for OIJ_SCHED
P_ACMApplicationCounterparty view_entity union BASIC Counterparty in ACM Maintain Application
P_ACMCounterparty view_entity union BASIC ACM Counterparty Value help
P_ACMCounterPartyName view union COMPOSITE Counter Party Name
P_ACMCtptyTxt view_entity union COMPOSITE Counter Party Name
P_ACMPurchaseCounterparty view_entity from BASIC Trading Contract Purchase Counterparty
P_ACMSupplier view_entity from BASIC ACM Supplier Value help
P_ACMTrdgContrCounterPty view_entity union BASIC
P_ARBSITMCLRITEM01 view left_outer BASIC
P_AUDIT_AT_LFA1 view from BASIC
P_CounterPartyWithSide view union COMPOSITE
P_CustSuplrNameCombinedSDMSts view_entity union_all BASIC
P_ECMCA_CTR_01 view left_outer COMPOSITE
P_Manufctrnmbr view from BASIC
P_MDChgProcSuplrClAssmtWthNmbr view inner BASIC
P_MDChgProcSuplrValnWthBusPart view inner BASIC
P_Prchinforecords_FS view left_outer BASIC
P_Prchinforecordslang_Fs view from BASIC
P_SuplrNameCombinedSDMSts view_entity from COMPOSITE
P_Supplier_Fs view from BASIC
P_Supplierbp_Fs view from BASIC
P_SupplierPRDetails view from BASIC
P_TradingContractCounterparty view union BASIC
P_Uk_WhldgCisInfoSDM view inner BASIC
pp_mrp_read_planned_order_comp view left_outer Read Planned Order Components
SHSM_FAP_SUPPLIER view from Value-Help for Suppliers
SHSM_FAP_SUPPLIER_COMPANY view from Value-Help for Suppliers in Company Code
SHSM_IAOM_OM_AUFK view left_outer CO Production Orders Created from OM
SHSM_K_KBUKA view inner Search help for CoCde with regard to suppliers
SHSM_M_KREDE view from CDS View replacing M_KREDE in search help KREDE
SHSM_M_KREDI view from CDS View replacing M_KREDI in search help KREDI
SHSM_M_KREDK view from CDS View replacing M_KREDK in search help KREDK
SHSM_M_KREDL view from CDS View replacing M_KREDL in search help KREDL
SHSM_SHP_VIEW_BOLN view left_outer CDS-based Value Help Selection Method SHP_VIEW_BOLN
SHSM_SHP_VIEW_EXIB view left_outer CDS-based Value Help Selection Method SHP_VIEW_EXIB
SHSM_SHP_VIEW_GDRC view left_outer CDS-based Value Help Selection Method SHP_VIEW_GDRC
SHSM_SHP_VIEW_LIKP_IN view left_outer CDS-based Value Help Selection Method SHSM_SHP_VIEW_LIKP_IN
SHSM_SHP_VIEW_PUTA view left_outer CDS-based Value Help Selection Method SHP_VIEW_PUTA
SHSM_SHP_VIEW_TRAI view left_outer CDS-based Value Help Selection Method SHP_VIEW_TRAI
TSI_BSEGK_entry view left_outer
V_Mmim_Ddl_Om_Or_Grmail view inner Output Management GR Mail
view_lfa1_name_p view from Display Name of Supplier
WLF_VIEW_LFA1_BG view from Provides field BEGRU

Fields (210)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY lifnr LIFNR Supplier
land1 LAND1_GP Country/Region Key
name1 NAME1_GP Name
name2 NAME2_GP Name 2
name3 NAME3_GP Name 3
name4 NAME4_GP Name 4
ort01 ORT01_GP City
ort02 ORT02_GP District
pfach PFACH PO Box
pstl2 PSTL2 PO Box PCode
pstlz PSTLZ Postal Code
regio REGIO Region
sortl SORTL Search term
stras STRAS_GP Street
adrnr ADRNR Address
mcod1 MCDK1 Name
mcod2 MCDK2 Name 2
mcod3 MCDK3 City
anred ANRED Title
bahns BAHNS Train station
bbbnr BBBNR Location no. 1
bbsnr BBSNR Location no. 2
begru BRGRU Authorization
brsch BRSCH Industry
bubkz BUBKZ Check digit
datlt DATLT Data line
dtams DTAMS DME Rec. Code
dtaws DTAWS Instruction Key
erdat ERDAT_RF Created On
ernam ERNAM_RF Created by
esrnr ESRNR ISR Number
konzs KONZS Group
ktokk KTOKK Account group
kunnr KUNNR Customer
lnrza LNRZA Alternat. Payee
loevm LOEVM_X Deletion Flag
sperr SPERB_X Posting Block
sperm SPERM_X Purch. block
spras SPRAS Language
stcd1 STCD1 Tax Number 1
stcd2 STCD2 Tax Number 2
stkza STKZA Equalizatn tax
stkzu STKZU Liable for VAT
telbx TELBX Telebox
telf1 TELF1 Telephone 1
telf2 TELF2 Telephone 2
telfx TELFX Fax Number
teltx TELTX Teletex
telx1 TELX1 Telex
xcpdk XCPDK One-time acct
xzemp XZEMP Payee in doc.
vbund RASSC Trading Partner
fiskn FISKN_K Fiscal address
stceg STCEG VAT Reg. No.
stkzn STKZN Natural person
sperq QSPERRFKT Block Function
gbort GBORT_Q Place of birth
gbdat GBDAT_Q Date of Birth
sexkz SEXKZ Sex
kraus KRAUS_CM Info Number
revdb REVDB_CM Last Ext.Review
qssys QSSYS_IST Actual QM Sys.
ktock KTOCK Ref.Acct Group
pfort PFORT_GP P.O.Box city
werks WERKS_EXT Plant
ltsna LTSNA VSR relevant
werkr WERKR Plant relevant
plkal FABKL Factory Calend.
duefl DUEFL_BKPF Data Transfer Status
txjcd TXJCD Tax Jur.
sperz SPERZ Payment block
scacd SCACD SCAC
sfrgr SFRGR Car.freight grp
lzone LZONE Transport Zone
xlfza XLFZA Alt.Payee(Doc.)
dlgrp DLGRP ServAgntProcGrp
fityp J_1AFITP_D Tax Type
stcdt J_1ATOID Tax number type
regss J_1AREGSS Social Ins.
actss J_1AACTSS Soc. Ins. Code
stcd3 STCD3 Tax Number 3
stcd4 STCD4 Tax Number 4
stcd5 STCD5 Tax Number 5
stcd6 STCD6 Tax Number 6
ipisp J_1BINDEQU Tax split
taxbs TAXBS Tax Base
profs PROFS Profession
stgdl STGDL Stat.grp, agent
emnfr EMNFR External manuf.
lfurl URL URL
j_1kfrepre REPRES Rep's Name
j_1kftbus GESTYP Type of Business
j_1kftind INDTYP Type of Industry
confs CONFS_X Confirm.status
updat UPDAT_RF Confirm.date
uptim UPTIM_RF Confirm.time
nodel NODEL_X Deletion block
qssysdat QQSSYSDAT QM System To
podkzb PODKZB POD-Relevant
fisku FISKU Tax Office
stenr STENR Tax Number
carrier_conf /SPE/CARRIER_CNF Carrier confirmation
min_comp J_1BMICRO_COMP Micro Comp.
term_li J_1BTERMS_LIAB Terms Liab.
crc_num J_1BCRC_NUM CRC number
cvp_xblck CVP_XBLCK Purpose Completed
weora WEORA Origin Accept.
rg J_1BRG RG Number
exp J_1BEXP Issued by
uf J_1BUF State
rgdate J_1BRGDATE RG Issuing Date
ric J_1BRIC RIC Number
rne J_1BRNE Foreign National Reg
rnedate J_1BRNEDATE RNE Issuing Date
cnae J_1BCNAE CNAE
legalnat J_1BLEGALNAT Legal Nature
crtn J_1BCRTN CRT Number
icmstaxpay J_1BICMSTAXPAY ICMS Taxpayer
indtyp J_1BINDTYP Industry Main Type
tdt J_1BTDT Tax Declaration Type
comsize J_1BCOMSIZE Company Size
decregpc J_1BDECREGPC Decl. Reg. PIS/COFI
allowance_type TWVAT_ALLOWANCE_TYPE Allowance Type
paytrsn FARP_PAYT_RSN Payment Reason
lfa1_eew_supp LFA1_EEW_SUPP Dataelement Exstensibility for Supplier
data_ctrlr1 BU_DATA_CONTROLLER Data Controller
data_ctrlr2 BU_DATA_CONTROLLER Data Controller
data_ctrlr3 BU_DATA_CONTROLLER Data Controller
data_ctrlr4 BU_DATA_CONTROLLER Data Controller
data_ctrlr5 BU_DATA_CONTROLLER Data Controller
data_ctrlr6 BU_DATA_CONTROLLER Data Controller
data_ctrlr7 BU_DATA_CONTROLLER Data Controller
data_ctrlr8 BU_DATA_CONTROLLER Data Controller
data_ctrlr9 BU_DATA_CONTROLLER Data Controller
data_ctrlr10 BU_DATA_CONTROLLER Data Controller
xdcset BU_XDCSET Data Ctrlr. Set
dummy_lfa1_addr_incl_eew_ps CFD_DUMMY Dummy
j_sc_capital /SAPNEA/J_SC_CAPITAL Capital Amount
j_sc_currency /SAPNEA/J_SC_CURRENCY Currency
alc FMFG_ALC Agency Loc Cd
pmt_office FMFG_PMT_OFF Payment Office
ppa_relevant FMFG_PPA_RELEVANT PPA Relevant
sam_ue_id FMFG_UNIQUE_ENTITY_ID SAM UE Identifier
sam_eft_ind FMFG_EFT_IND SAM EFT Indicator
psofg PSOFG Processor group
psois PSOIS SLAPrepr.Proced
pson1 NAME1_GP Name
pson2 NAME2_GP Name 2
pson3 NAME3_GP Name 3
psovn PSOVN First Name
psotl PSOTL Title
psohs PSOHS House number
psost PSOST Street
borgr_datun BORGR_DATUN DteLimit ext.ID
borgr_yeaun BORGR_YEAUN Repetition
au_carrying_ent FIAPAU_CARRY_ENT Enterprise in AU
au_ind_under_18 FIAPAU_IND_UNDER_18 Individual
au_payment_not_exceed_75 FIAPAU_PMNT_NOT_EXCEED Payment does not exc
au_wholly_inp_taxed FIAPAU_INPUT_TAXED Wholly Input Taxed
au_partner_without_gain FIAPAU_PARTNER_NO_GAIN Individual w/o gain
au_not_entitled_abn FIAPAU_ABN_ELIGIBLE ABN Eligible
au_payment_exempt FIAPAU_PMNT_EXEMPT Payment Exempt
au_private_hobby FIAPAU_PVT_HOBBY Hobby
au_domestic_nature FIAPAU_DOM_NATURE Domestic
addr2_street AD_STREET Street
addr2_house_num AD_HSNM1 House Number
addr2_post AD_PSTCD1 Postal Code
addr2_city AD_CITY1 City
addr2_country LAND1 Country/Reg.
categ CIS_CATEGORY Business Type
partner_name CIS_PARTNER_NAME Prtnr Trad Name
partner_utr CIS_PARTNER_UTR Partner's UTR
status CIS_VFNSTATUS Verif. Status
vfnum GB_CIS_SC_VFNNUM Verification N.
vfnid CIS_VFN_ID Tax Status
crn GB_CIS_CRN Comp. House Reg. No.
fr_occupation FIWTFR_OCC Occupation
j_1iexcd J_1IEXCD ECC No.
j_1iexrn J_1IEXRN Excise Reg. No.
j_1iexrg J_1IEXRG Excise Range
j_1iexdi J_1IEXDI Excise Division
j_1iexco J_1IEXCO Commissionerate
j_1icstno J_1ICSTNO CST no.
j_1ilstno J_1ILSTNO LST no.
j_1ipanno J_1IPANNO PAN
j_1iexcive J_1IEXCIVE Exc.Ind.Vendor
j_1issist J_1ISSIST SSI status
j_1ivtyp J_1IVTYP Type of Vendor
j_1ivencre J_1IVENCRE CENVAT
aedat J_1IAEDAT_OBSOLETE Obsolete
usnam J_1IUSNAM_OBSOLETE Obsolete
j_1isern J_1ISERN Service Tax Regn.No.
j_1ipanref J_1IPANREF PAN Reference
j_1ipanvaldt J_1IPANVALDT PAN Valid From Date
j_1i_customs J_1I_CUSTOMS Customs Vendor
j_1idedref J_1IDEDREF Deductee Ref No.
ven_class J_1IGTAKLD GST Ven Class.
entpub PFM_12ENTPUB Public entity
escrit PFM_12ESCRIT Deed public use
dvalss PFM_12DVALSS SS certif.valid.date
frmcss PFM_12FRMCSS SS certificate form
codcae PFM_12CODCAE CAE code
ausdiv PFM_12AUSDIV Absence of debt
sc_capital JSUG_SC_CAPITAL Capital Amount
sc_currency JSUG_SC_CURRENCY Currency
transport_chain WRF_PSCD_TC_ID Transportation Chain
staging_time WRF_PSCD_MST Staging Time
scheduling_type WRF_PSCD_SCHED_TYPE Scheduling Procedure
submi_relevant WRF_SUBMI_RELEVANT Rel. for Coll. No.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Supplier Master (General Section)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFA1 (
    MANDT,                        -- Client [MANDT]
    LIFNR,                        -- Supplier [LIFNR]
    LAND1,                        -- Country/Region Key [LAND1_GP]
    NAME1,                        -- Name [NAME1_GP]
    NAME2,                        -- Name 2 [NAME2_GP]
    NAME3,                        -- Name 3 [NAME3_GP]
    NAME4,                        -- Name 4 [NAME4_GP]
    ORT01,                        -- City [ORT01_GP]
    ORT02,                        -- District [ORT02_GP]
    PFACH,                        -- PO Box [PFACH]
    PSTL2,                        -- PO Box PCode [PSTL2]
    PSTLZ,                        -- Postal Code [PSTLZ]
    REGIO,                        -- Region [REGIO]
    SORTL,                        -- Search term [SORTL]
    STRAS,                        -- Street [STRAS_GP]
    ADRNR,                        -- Address [ADRNR]
    MCOD1,                        -- Name [MCDK1]
    MCOD2,                        -- Name 2 [MCDK2]
    MCOD3,                        -- City [MCDK3]
    ANRED,                        -- Title [ANRED]
    BAHNS,                        -- Train station [BAHNS]
    BBBNR,                        -- Location no. 1 [BBBNR]
    BBSNR,                        -- Location no. 2 [BBSNR]
    BEGRU,                        -- Authorization [BRGRU]
    BRSCH,                        -- Industry [BRSCH]
    BUBKZ,                        -- Check digit [BUBKZ]
    DATLT,                        -- Data line [DATLT]
    DTAMS,                        -- DME Rec. Code [DTAMS]
    DTAWS,                        -- Instruction Key [DTAWS]
    ERDAT,                        -- Created On [ERDAT_RF]
    ERNAM,                        -- Created by [ERNAM_RF]
    ESRNR,                        -- ISR Number [ESRNR]
    KONZS,                        -- Group [KONZS]
    KTOKK,                        -- Account group [KTOKK]
    KUNNR,                        -- Customer [KUNNR]
    LNRZA,                        -- Alternat. Payee [LNRZA]
    LOEVM,                        -- Deletion Flag [LOEVM_X]
    SPERR,                        -- Posting Block [SPERB_X]
    SPERM,                        -- Purch. block [SPERM_X]
    SPRAS,                        -- Language [SPRAS]
    STCD1,                        -- Tax Number 1 [STCD1]
    STCD2,                        -- Tax Number 2 [STCD2]
    STKZA,                        -- Equalizatn tax [STKZA]
    STKZU,                        -- Liable for VAT [STKZU]
    TELBX,                        -- Telebox [TELBX]
    TELF1,                        -- Telephone 1 [TELF1]
    TELF2,                        -- Telephone 2 [TELF2]
    TELFX,                        -- Fax Number [TELFX]
    TELTX,                        -- Teletex [TELTX]
    TELX1,                        -- Telex [TELX1]
    XCPDK,                        -- One-time acct [XCPDK]
    XZEMP,                        -- Payee in doc. [XZEMP]
    VBUND,                        -- Trading Partner [RASSC]
    FISKN,                        -- Fiscal address [FISKN_K]
    STCEG,                        -- VAT Reg. No. [STCEG]
    STKZN,                        -- Natural person [STKZN]
    SPERQ,                        -- Block Function [QSPERRFKT]
    GBORT,                        -- Place of birth [GBORT_Q]
    GBDAT,                        -- Date of Birth [GBDAT_Q]
    SEXKZ,                        -- Sex [SEXKZ]
    KRAUS,                        -- Info Number [KRAUS_CM]
    REVDB,                        -- Last Ext.Review [REVDB_CM]
    QSSYS,                        -- Actual QM Sys. [QSSYS_IST]
    KTOCK,                        -- Ref.Acct Group [KTOCK]
    PFORT,                        -- P.O.Box city [PFORT_GP]
    WERKS,                        -- Plant [WERKS_EXT]
    LTSNA,                        -- VSR relevant [LTSNA]
    WERKR,                        -- Plant relevant [WERKR]
    PLKAL,                        -- Factory Calend. [FABKL]
    DUEFL,                        -- Data Transfer Status [DUEFL_BKPF]
    TXJCD,                        -- Tax Jur. [TXJCD]
    SPERZ,                        -- Payment block [SPERZ]
    SCACD,                        -- SCAC [SCACD]
    SFRGR,                        -- Car.freight grp [SFRGR]
    LZONE,                        -- Transport Zone [LZONE]
    XLFZA,                        -- Alt.Payee(Doc.) [XLFZA]
    DLGRP,                        -- ServAgntProcGrp [DLGRP]
    FITYP,                        -- Tax Type [J_1AFITP_D]
    STCDT,                        -- Tax number type [J_1ATOID]
    REGSS,                        -- Social Ins. [J_1AREGSS]
    ACTSS,                        -- Soc. Ins. Code [J_1AACTSS]
    STCD3,                        -- Tax Number 3 [STCD3]
    STCD4,                        -- Tax Number 4 [STCD4]
    STCD5,                        -- Tax Number 5 [STCD5]
    STCD6,                        -- Tax Number 6 [STCD6]
    IPISP,                        -- Tax split [J_1BINDEQU]
    TAXBS,                        -- Tax Base [TAXBS]
    PROFS,                        -- Profession [PROFS]
    STGDL,                        -- Stat.grp, agent [STGDL]
    EMNFR,                        -- External manuf. [EMNFR]
    LFURL,                        -- URL [URL]
    J_1KFREPRE,                   -- Rep's Name [REPRES]
    J_1KFTBUS,                    -- Type of Business [GESTYP]
    J_1KFTIND,                    -- Type of Industry [INDTYP]
    CONFS,                        -- Confirm.status [CONFS_X]
    UPDAT,                        -- Confirm.date [UPDAT_RF]
    UPTIM,                        -- Confirm.time [UPTIM_RF]
    NODEL,                        -- Deletion block [NODEL_X]
    QSSYSDAT,                     -- QM System To [QQSSYSDAT]
    PODKZB,                       -- POD-Relevant [PODKZB]
    FISKU,                        -- Tax Office [FISKU]
    STENR,                        -- Tax Number [STENR]
    CARRIER_CONF,                 -- Carrier confirmation [/SPE/CARRIER_CNF]
    MIN_COMP,                     -- Micro Comp. [J_1BMICRO_COMP]
    TERM_LI,                      -- Terms Liab. [J_1BTERMS_LIAB]
    CRC_NUM,                      -- CRC number [J_1BCRC_NUM]
    CVP_XBLCK,                    -- Purpose Completed [CVP_XBLCK]
    WEORA,                        -- Origin Accept. [WEORA]
    RG,                           -- RG Number [J_1BRG]
    EXP,                          -- Issued by [J_1BEXP]
    UF,                           -- State [J_1BUF]
    RGDATE,                       -- RG Issuing Date [J_1BRGDATE]
    RIC,                          -- RIC Number [J_1BRIC]
    RNE,                          -- Foreign National Reg [J_1BRNE]
    RNEDATE,                      -- RNE Issuing Date [J_1BRNEDATE]
    CNAE,                         -- CNAE [J_1BCNAE]
    LEGALNAT,                     -- Legal Nature [J_1BLEGALNAT]
    CRTN,                         -- CRT Number [J_1BCRTN]
    ICMSTAXPAY,                   -- ICMS Taxpayer [J_1BICMSTAXPAY]
    INDTYP,                       -- Industry Main Type [J_1BINDTYP]
    TDT,                          -- Tax Declaration Type [J_1BTDT]
    COMSIZE,                      -- Company Size [J_1BCOMSIZE]
    DECREGPC,                     -- Decl. Reg. PIS/COFI [J_1BDECREGPC]
    ALLOWANCE_TYPE,               -- Allowance Type [TWVAT_ALLOWANCE_TYPE]
    PAYTRSN,                      -- Payment Reason [FARP_PAYT_RSN]
    LFA1_EEW_SUPP,                -- Dataelement Exstensibility for Supplier [LFA1_EEW_SUPP]
    DATA_CTRLR1,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR2,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR3,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR4,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR5,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR6,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR7,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR8,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR9,                  -- Data Controller [BU_DATA_CONTROLLER]
    DATA_CTRLR10,                 -- Data Controller [BU_DATA_CONTROLLER]
    XDCSET,                       -- Data Ctrlr. Set [BU_XDCSET]
    DUMMY_LFA1_ADDR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    J_SC_CAPITAL,                 -- Capital Amount [/SAPNEA/J_SC_CAPITAL]
    J_SC_CURRENCY,                -- Currency [/SAPNEA/J_SC_CURRENCY]
    ALC,                          -- Agency Loc Cd [FMFG_ALC]
    PMT_OFFICE,                   -- Payment Office [FMFG_PMT_OFF]
    PPA_RELEVANT,                 -- PPA Relevant [FMFG_PPA_RELEVANT]
    SAM_UE_ID,                    -- SAM UE Identifier [FMFG_UNIQUE_ENTITY_ID]
    SAM_EFT_IND,                  -- SAM EFT Indicator [FMFG_EFT_IND]
    PSOFG,                        -- Processor group [PSOFG]
    PSOIS,                        -- SLAPrepr.Proced [PSOIS]
    PSON1,                        -- Name [NAME1_GP]
    PSON2,                        -- Name 2 [NAME2_GP]
    PSON3,                        -- Name 3 [NAME3_GP]
    PSOVN,                        -- First Name [PSOVN]
    PSOTL,                        -- Title [PSOTL]
    PSOHS,                        -- House number [PSOHS]
    PSOST,                        -- Street [PSOST]
    BORGR_DATUN,                  -- DteLimit ext.ID [BORGR_DATUN]
    BORGR_YEAUN,                  -- Repetition [BORGR_YEAUN]
    AU_CARRYING_ENT,              -- Enterprise in AU [FIAPAU_CARRY_ENT]
    AU_IND_UNDER_18,              -- Individual [FIAPAU_IND_UNDER_18]
    AU_PAYMENT_NOT_EXCEED_75,     -- Payment does not exc [FIAPAU_PMNT_NOT_EXCEED]
    AU_WHOLLY_INP_TAXED,          -- Wholly Input Taxed [FIAPAU_INPUT_TAXED]
    AU_PARTNER_WITHOUT_GAIN,      -- Individual w/o gain [FIAPAU_PARTNER_NO_GAIN]
    AU_NOT_ENTITLED_ABN,          -- ABN Eligible [FIAPAU_ABN_ELIGIBLE]
    AU_PAYMENT_EXEMPT,            -- Payment Exempt [FIAPAU_PMNT_EXEMPT]
    AU_PRIVATE_HOBBY,             -- Hobby [FIAPAU_PVT_HOBBY]
    AU_DOMESTIC_NATURE,           -- Domestic [FIAPAU_DOM_NATURE]
    ADDR2_STREET,                 -- Street [AD_STREET]
    ADDR2_HOUSE_NUM,              -- House Number [AD_HSNM1]
    ADDR2_POST,                   -- Postal Code [AD_PSTCD1]
    ADDR2_CITY,                   -- City [AD_CITY1]
    ADDR2_COUNTRY,                -- Country/Reg. [LAND1]
    CATEG,                        -- Business Type [CIS_CATEGORY]
    PARTNER_NAME,                 -- Prtnr Trad Name [CIS_PARTNER_NAME]
    PARTNER_UTR,                  -- Partner's UTR [CIS_PARTNER_UTR]
    STATUS,                       -- Verif. Status [CIS_VFNSTATUS]
    VFNUM,                        -- Verification N. [GB_CIS_SC_VFNNUM]
    VFNID,                        -- Tax Status [CIS_VFN_ID]
    CRN,                          -- Comp. House Reg. No. [GB_CIS_CRN]
    FR_OCCUPATION,                -- Occupation [FIWTFR_OCC]
    J_1IEXCD,                     -- ECC No. [J_1IEXCD]
    J_1IEXRN,                     -- Excise Reg. No. [J_1IEXRN]
    J_1IEXRG,                     -- Excise Range [J_1IEXRG]
    J_1IEXDI,                     -- Excise Division [J_1IEXDI]
    J_1IEXCO,                     -- Commissionerate [J_1IEXCO]
    J_1ICSTNO,                    -- CST no. [J_1ICSTNO]
    J_1ILSTNO,                    -- LST no. [J_1ILSTNO]
    J_1IPANNO,                    -- PAN [J_1IPANNO]
    J_1IEXCIVE,                   -- Exc.Ind.Vendor [J_1IEXCIVE]
    J_1ISSIST,                    -- SSI status [J_1ISSIST]
    J_1IVTYP,                     -- Type of Vendor [J_1IVTYP]
    J_1IVENCRE,                   -- CENVAT [J_1IVENCRE]
    AEDAT,                        -- Obsolete [J_1IAEDAT_OBSOLETE]
    USNAM,                        -- Obsolete [J_1IUSNAM_OBSOLETE]
    J_1ISERN,                     -- Service Tax Regn.No. [J_1ISERN]
    J_1IPANREF,                   -- PAN Reference [J_1IPANREF]
    J_1IPANVALDT,                 -- PAN Valid From Date [J_1IPANVALDT]
    J_1I_CUSTOMS,                 -- Customs Vendor [J_1I_CUSTOMS]
    J_1IDEDREF,                   -- Deductee Ref No. [J_1IDEDREF]
    VEN_CLASS,                    -- GST Ven Class. [J_1IGTAKLD]
    ENTPUB,                       -- Public entity [PFM_12ENTPUB]
    ESCRIT,                       -- Deed public use [PFM_12ESCRIT]
    DVALSS,                       -- SS certif.valid.date [PFM_12DVALSS]
    FRMCSS,                       -- SS certificate form [PFM_12FRMCSS]
    CODCAE,                       -- CAE code [PFM_12CODCAE]
    AUSDIV,                       -- Absence of debt [PFM_12AUSDIV]
    SC_CAPITAL,                   -- Capital Amount [JSUG_SC_CAPITAL]
    SC_CURRENCY,                  -- Currency [JSUG_SC_CURRENCY]
    TRANSPORT_CHAIN,              -- Transportation Chain [WRF_PSCD_TC_ID]
    STAGING_TIME,                 -- Staging Time [WRF_PSCD_MST]
    SCHEDULING_TYPE,              -- Scheduling Procedure [WRF_PSCD_SCHED_TYPE]
    SUBMI_RELEVANT,               -- Rel. for Coll. No. [WRF_SUBMI_RELEVANT]
    PRIMARY KEY (MANDT, LIFNR)
);