CONFUSE

Former Member — Mon, 18 Jun 2007 08:21:05 GMT

Hello,

i am having big confusion about the mandatory fields of fico tables, i asked the question regarding the same in expert somebody told me that mandatory fields are already clikmark in the filed of key/intial there i am having doubt that ok some fileds are already cliked in the field and rest of the fields are uncliked i can understood that the cliked fields are already in the master table and rest of the user have to enter that field then how to know the which fields are mandatory i mean uncliked fields i.e. key/initial.

also sending the screenshort for one table there the key/intial fields are cliked in top of the two coloums i can understood that are already loaded in the master table again user not necessary to enter that, i want to know rest of the fileds which are mandatory that i want to know, please help me soon and oblige.

TABLE: LFA1 (Vendor Master (General Section)

FIELD Key Initial DATAELEMENT DTYPE LENGTH

MANDT √ √ MANDT CLNT 3 Client

LIFNR √ √ LIFNR CHAR 10 Account Number of Vendor or Creditor

LAND1 LAND1_GP CHAR 3 Country Key

NAME1 NAME1_GP CHAR 35 Name 1

NAME2 NAME2_GP CHAR 35 Name 2

NAME3 NAME3_GP CHAR 35 Name 3

NAME4 NAME4_GP CHAR 35 Name 4

ORT01 ORT01_GP CHAR 35 City

ORT02 ORT02_GP CHAR 35 District

PFACH PFACH CHAR 10 PO Box

PSTL2 PSTL2 CHAR 10 P.O. Box Postal Code

PSTLZ PSTLZ CHAR 10 Postal Code

REGIO REGIO CHAR 3 Region (State, Province, County)

SORTL SORTL CHAR 10 Sort field

STRAS STRAS_GP CHAR 35 House number and street

ADRNR ADRNR CHAR 10 Address

MCOD1 MCDK1 CHAR 25 Search term for matchcode search

MCOD2 MCDK2 CHAR 25 Search term for matchcode search

MCOD3 MCDK3 CHAR 25 Search term for matchcode search

.INCLUDE SI_LFA1 STRU 0 Vendor Master (General Section)

ANRED ANRED CHAR 15 Title

BAHNS BAHNS CHAR 25 Train station

BBBNR BBBNR NUMC 7 International location number (part 1)

BBSNR BBSNR NUMC 5 International location number (Part 2)

BEGRU BEGRU CHAR 4 Authorization Group

BRSCH BRSCH CHAR 4 Industry key

BUBKZ BUBKZ NUMC 1 Check digit for the international location number

DATLT DATLT CHAR 14 Data communication line no.

DTAMS DTAMS CHAR 1 Report key for data medium exchange

DTAWS DTAWS CHAR 2 Instruction key for data medium exchange

ERDAT ERDAT_RF DATS 8 Date on which the Record Was Created

ERNAM ERNAM_RF CHAR 12 Name of Person who Created the Object

ESRNR ESRNR CHAR 11 POR subscriber number

KONZS KONZS CHAR 10 Group key

KTOKK KTOKK CHAR 4 Vendor account group

KUNNR KUNNR CHAR 10 Customer Number 1

LNRZA LNRZA CHAR 10 Account Number of the Alternative Payee

LOEVM LOEVM_X CHAR 1 Central Deletion Flag for Master Record

SPERR SPERB_X CHAR 1 Central posting block

SPERM SPERM_X CHAR 1 Centrally imposed purchasing block

SPRAS SPRAS LANG 1 Language Key

STCD1 STCD1 CHAR 16 Tax Number 1

STCD2 STCD2 CHAR 11 Tax Number 2

STKZA STKZA CHAR 1 Indicator: Business Partner Subject to Equalization Tax?

STKZU STKZU CHAR 1 Liable for VAT

TELBX TELBX CHAR 15 Telebox number

TELF1 TELF1 CHAR 16 First telephone number

TELF2 TELF2 CHAR 16 Second telephone number

TELFX TELFX CHAR 31 Fax Number

TELTX TELTX CHAR 30 Teletex number

TELX1 TELX1 CHAR 30 Telex number

XCPDK XCPDK CHAR 1 Indicator: Is the account a one-time account?

XZEMP XZEMP CHAR 1 Indicator: Alternative payee in document allowed ?

VBUND RASSC CHAR 6 Company ID of Trading Partner

FISKN FISKN_K CHAR 10 Account number of the master record with fiscal address

STCEG STCEG CHAR 20 VAT registration number

STKZN STKZN CHAR 1 Natural Person

SPERQ QSPERRFKT CHAR 2 Function That Will Be Blocked

GBORT GBORT_Q CHAR 25 Place of birth of the person subject to withholding tax

GBDAT GBDAT_Q DATS 8 Date of birth of the person subject to withholding tax

SEXKZ SEXKZ CHAR 1 Key for the Sex of the Person Subject to Withholding Tax

KRAUS KRAUS_CM CHAR 11 Credit information number

REVDB REVDB_CM DATS 8 Last review (external)

QSSYS QSSYS_IST CHAR 4 Vendor's QM system

KTOCK KTOCK CHAR 4 Reference Account Group for One-Time Account (Vendor)

PFORT PFORT_GP CHAR 35 PO Box city

WERKS WERKS_EXT CHAR 4 Plant (Own or External)

LTSNA LTSNA CHAR 1 Indicator: vendor sub-range relevant

WERKR WERKR CHAR 1 Indicator: plant level relevant

PLKAL FABKL CHAR 2 Factory calendar key

DUEFL DUEFL_BKPF CHAR 1 Status of Data Transfer into Subsequent Release

TXJCD TXJCD CHAR 15 Jurisdiction for Tax Calculation - Tax Jurisdiction Code

SPERZ SPERZ CHAR 1 Payment Block

SCACD SCACD CHAR 4 Standard carrier access code

SFRGR SFRGR CHAR 4 Forwarding agent freight group

LZONE LZONE CHAR 10 Transportation zone to or from which the goods are delivered

XLFZA XLFZA CHAR 1 Indicator: Alternative payee using account number

DLGRP DLGRP CHAR 4 Service agent procedure group

FITYP J_1AFITP_D CHAR 2 Tax type

STCDT J_1ATOID CHAR 2 Tax Number Type

REGSS J_1AREGSS CHAR 1 Registered for Social Insurance

ACTSS J_1AACTSS CHAR 3 Activity Code for Social Insurance

STCD3 STCD3 CHAR 18 Tax Number 3

STCD4 STCD4 CHAR 18 Tax Number 4

IPISP J_1BINDEQU CHAR 1 Tax Split

TAXBS TAXBS NUMC 1 Tax Base in Percentage

PROFS PROFS CHAR 30 Profession

STGDL STGDL CHAR 2 Shipment: statistics group, transportation service agent

EMNFR EMNFR CHAR 10 External manufacturer code name or number

LFURL URL CHAR 132 Uniform resource locator

J_1KFREPRE REPRES CHAR 10 Name of Representative

J_1KFTBUS GESTYP CHAR 30 Type of Business

J_1KFTIND INDTYP CHAR 30 Type of Industry

CONFS CONFS_X CHAR 1 Status of Change Authorization (Central)

UPDAT UPDAT_RF DATS 8 Date on Which the Changes Were Confirmed

UPTIM UPTIM_RF TIMS 6 Time of Last Change Confirmation

NODEL NODEL_X CHAR 1 Central deletion block for master record

QSSYSDAT QQSSYSDAT DATS 8 Validity date of certification

PODKZB PODKZB CHAR 1 Vendor indicator relevant for proof of delivery

FISKU FISKU CHAR 10 Account Number of Master Record of Tax Office Responsible

STENR STENR CHAR 18 Tax Number at Responsible Tax Authority

.APPEND ALFA1_PSO STRU 0 Local Authority Additional Fields (Address)

PSOFG PSOFG CHAR 10 Processor group

PSOIS PSOIS CHAR 20 Subledger acct preprocessing procedure

.INCLUDE IADDR_PSO STRU 0 Local Authority Additional Fields (Address)

PSON1 NAME1_GP CHAR 35 Name 1

PSON2 NAME2_GP CHAR 35 Name 2

PSON3 NAME3_GP CHAR 35 Name 3

PSOVN PSOVN CHAR 35 First name

PSOTL PSOTL CHAR 20 Title

PSOHS PSOHS CHAR 6 House number: is no longer used from Release 4.6B

PSOST PSOST CHAR 28 Street: No longer used from Release 4.6B

Re: CONFUSE

Former Member — Mon, 18 Jun 2007 08:30:02 GMT

u click on the entry help/check

after that some table name r there,just click on the tables that r appeared so theat fileds is key fields for another table,so u may use that as key mandatory fields..in u r program..

not all fields according to u r requirement u sue that fields

topic CONFUSE in Application Development and Automation Discussions

CONFUSE

Re: CONFUSE