LFA1_PRC
Master Data Consolidation: Process Table for LFA1
LFA1_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for LFA1. It contains 203 fields. 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| E_BPSupplierProcess | view_entity | from | EXTENSION | BP Supplier Process - Extension |
| I_BPSupplierProcess | view_entity | from | BASIC | Business Partner Supplier Process Data |
Fields (203)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | process_id | MDC_PROCESS_ID | Process ID | |||
| KEY | process_step_no | MDC_PROCESS_STEP_NO | Step Number | |||
| KEY | source_system | MDC_BUSINESS_SYSTEM | Source System | |||
| KEY | source_id | MDC_SOURCE_ID | Source ID | |||
| KEY | assignment_id | MDG_BP_ASSIGNMENT_ID | Assignment ID | |||
| 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 | ||||
| source_recency | MDC_RECENCY | Last Changed On | ||||
| source_modified | MDC_SOURCE_MODIFIED | Modified | ||||
| source_modification_blip | MDC_MODIFICATION_BLIP | Modification | ||||
| source_index | MDC_SOURCE_INDEX | Index | ||||
| target_assignment_id | MDG_BP_ASSIGNMENT_ID | Assignment ID | ||||
| 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 | AEDAT | Changed On | ||||
| usnam | J_1IUSNAMC | Changed By | ||||
| 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. | ||||
| j_sc_capital | /SAPNEA/J_SC_CAPITAL | Capital Amount | ||||
| j_sc_currency | /SAPNEA/J_SC_CURRENCY | Currency | ||||
| 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 | ||||
| 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.
-- Master Data Consolidation: Process Table for LFA1
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFA1_PRC (
MANDT, -- Client [MANDT]
PROCESS_ID, -- Process ID [MDC_PROCESS_ID]
PROCESS_STEP_NO, -- Step Number [MDC_PROCESS_STEP_NO]
SOURCE_SYSTEM, -- Source System [MDC_BUSINESS_SYSTEM]
SOURCE_ID, -- Source ID [MDC_SOURCE_ID]
ASSIGNMENT_ID, -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
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]
SOURCE_RECENCY, -- Last Changed On [MDC_RECENCY]
SOURCE_MODIFIED, -- Modified [MDC_SOURCE_MODIFIED]
SOURCE_MODIFICATION_BLIP, -- Modification [MDC_MODIFICATION_BLIP]
SOURCE_INDEX, -- Index [MDC_SOURCE_INDEX]
TARGET_ASSIGNMENT_ID, -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
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, -- Changed On [AEDAT]
USNAM, -- Changed By [J_1IUSNAMC]
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]
J_SC_CAPITAL, -- Capital Amount [/SAPNEA/J_SC_CAPITAL]
J_SC_CURRENCY, -- Currency [/SAPNEA/J_SC_CURRENCY]
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]
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, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, ASSIGNMENT_ID)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- 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