LFA1
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Business Partner Migration: KNA1/LFA1 to BUT000
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA