LFB1_PRC

Transparent Table Application Table
105 Fields 2 CDS Views

Master Data Consolidation: Process Table for LFB1

LFB1_PRC is an SAP database table in S/4HANA. Master Data Consolidation: Process Table for LFB1. It contains 105 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_BPSupplierCompanyProcess view_entity from EXTENSION BP Supplier Company Process - Extension
I_BPSupplierCompanyProcess view_entity from BASIC BP Supplier Company Code Process Data

Fields (105)

KeyField Data ElementDescription DomainTypeLength
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 bukrs BUKRS Company Code
KEY assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
pernr PERNR_D Personnel No.
erdat ERDAT_RF Created On
ernam ERNAM_RF Created by
sperr SPERB_B Co.code post.block
loevm LOEVM_B Co.Cde Deletion Flag
zuawa DZUAWA Sort key
akont AKONT Recon. account
begru BRGRU Authorization
vzskz VZSKZ Interest Indic.
zwels DZWELS Payment Methods
xverr XVERR_LFB1 Clrg with Cust.
zahls DZAHLS Payment Block
zterm DZTERM Pyt Terms
eikto EIKTO_K Acct w/ vendor
zsabe DZSABE_K Clerk at vendor
kverm KVERM Account Memo
fdgrv FDGRV Planning Group
busab BUSAB Clerk Abbrev.
lnrze LNRZE Head Office
lnrzb LNRZB Alternat.payee
zindt DZINDT Last Key Date
zinrt DZINRT Int.Calc.Freq.
datlz DATLZ Last Int. Calc.
xdezv XDEZV Local Process.
webtr WEBTR_CS Bill/Ex. Limit
kultg KULTG Chk cashng time
reprf REPRF Chk Double Inv.
togru TOGRU Tolerance Group
hbkid HBKID House Bank
xpore XPORE Individual Payt
qsznr QSZNR Exemption No.
qszdt QSZDT Valid Until
qsskz QSSKZ WTax Code
blnkz BLNKZ Subs.ind.
mindk MINDK Minority Indic.
altkn ALTKN Prev.Acct No.
zgrup DZGRUP Grouping key
mgrup MGRUP Grouping Key
uzawe UZAWE Pmnt Meth. Sup.
qsrec QSREC Recipient Type
qsbgr QSBGR Exmpt.Authority
qland QLAND WTax C/R Key
xedip XEDIP Pmt adv. by EDI
frgrp FRGRP Release Group
togrr TOGRR Tolerance Grp
tlfxs TLFXS Clerk's fax
intad INTAD Clrk's internet
xlfzb XLFZB Alt.Payee(Doc.)
guzte GUZTE Cr Memo Terms
gricd J_1AGICD_D Activity Code
gridt J_1ADTYP_D Distr. Type
xausz XAUSZ Acct Statement
cerdt CERDT Certifictn Date
confs CONFS_B ConfirmSt (CCd)
updat UPDAT_RF Confirm.date
uptim UPTIM_RF Confirm.time
nodel NODEL_B CoCd del.block
tlfns TLFNS Act.clk tel.no.
avsnd AVSND PmtAdv. XML
ad_hash ADHASH E-Mail for Avis
cvp_xblck_b CVP_XBLCK Purpose Completed
ciiucode CIIUCODE main economic act.
paymentclearinggrpid FAR_PAYMENT_CLEARING_GROUP Payment Clrg Grp ID
paytrsn FARP_PAYT_RSN Payment Reason
lfb1_eew_cc LFB1_EEW_CC Dataelement for the Extension Company Code
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
lifnr LIFNR Supplier
target_assignment_id MDG_BP_ASSIGNMENT_ID Assignment ID
brsch BRSCH Industry
wrbtr KR_AMOUNT_CS Amount for Pmt Progr
waers WAERS Currency
forgn FIWTKW_LOCALITY Foreign Shareholder
share_in_foreign FIWTKW_OWNED_SHARE Foreign Share
notes FIWTKW_NOTES Notes
active FIWTKW_SHR_ACTIVE Shr. is Active
us_rec_country LAND1 Country/Reg.
us_giin FIWTUS_RECIPIENT_GIIN US Recipient GIIN
us_ftid FIWTUS_RECIPIENT_FTID US Recipient FTID
us_rec_dob FIWTUS_RECIPIENT_DOB US Recipient DOB
us_lob_code FIWTUS_LOB_CODE LOB Treaty Code
us_w8_recvdate FIWTUS_W8_RECV_DATE W8 Form Rec Date
us_w9_recvdate FIWTUS_W9_RECV_DATE W9 Form Rec Date
us_tin_notice FIWTUS_SECOND_TIN_NOTICE Second TIN Notice
us_partnership_ind FIWTUS_PARTNERSHIP_IND Partnership Int Ind
zbokd /ATL/VBOKD Ledger Exp. date
zqsskz /ATL/VQSSKZ Future W.tax code
zqszdt /ATL/VQSZDT Valid until
zqsznr /ATL/VQSZNR F.Exemption no.
zmindat /ATL/VMINDAT Cer.date min.wage
j_sc_subcontype /SAPNEA/J_SC_SUBCONTYPE Subcontractor Type
j_sc_compdate /SAPNEA/J_SC_COMPLETIONDATE Completion Date
j_sc_offsm /SAPNEA/J_SC_OFFSM Offset Method
j_sc_offsr /SAPNEA/J_SC_OFFSR Offset %
prepay_relevant WRF_PREPAY_RELEVANT Prepayment Relevant
assign_test WRF_MRM_ASSIGN_GROUP Assignm. Test Group

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 LFB1
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE LFB1_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]
    BUKRS,                     -- Company Code [BUKRS]
    ASSIGNMENT_ID,             -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    PERNR,                     -- Personnel No. [PERNR_D]
    ERDAT,                     -- Created On [ERDAT_RF]
    ERNAM,                     -- Created by [ERNAM_RF]
    SPERR,                     -- Co.code post.block [SPERB_B]
    LOEVM,                     -- Co.Cde Deletion Flag [LOEVM_B]
    ZUAWA,                     -- Sort key [DZUAWA]
    AKONT,                     -- Recon. account [AKONT]
    BEGRU,                     -- Authorization [BRGRU]
    VZSKZ,                     -- Interest Indic. [VZSKZ]
    ZWELS,                     -- Payment Methods [DZWELS]
    XVERR,                     -- Clrg with Cust. [XVERR_LFB1]
    ZAHLS,                     -- Payment Block [DZAHLS]
    ZTERM,                     -- Pyt Terms [DZTERM]
    EIKTO,                     -- Acct w/ vendor [EIKTO_K]
    ZSABE,                     -- Clerk at vendor [DZSABE_K]
    KVERM,                     -- Account Memo [KVERM]
    FDGRV,                     -- Planning Group [FDGRV]
    BUSAB,                     -- Clerk Abbrev. [BUSAB]
    LNRZE,                     -- Head Office [LNRZE]
    LNRZB,                     -- Alternat.payee [LNRZB]
    ZINDT,                     -- Last Key Date [DZINDT]
    ZINRT,                     -- Int.Calc.Freq. [DZINRT]
    DATLZ,                     -- Last Int. Calc. [DATLZ]
    XDEZV,                     -- Local Process. [XDEZV]
    WEBTR,                     -- Bill/Ex. Limit [WEBTR_CS]
    KULTG,                     -- Chk cashng time [KULTG]
    REPRF,                     -- Chk Double Inv. [REPRF]
    TOGRU,                     -- Tolerance Group [TOGRU]
    HBKID,                     -- House Bank [HBKID]
    XPORE,                     -- Individual Payt [XPORE]
    QSZNR,                     -- Exemption No. [QSZNR]
    QSZDT,                     -- Valid Until [QSZDT]
    QSSKZ,                     -- WTax Code [QSSKZ]
    BLNKZ,                     -- Subs.ind. [BLNKZ]
    MINDK,                     -- Minority Indic. [MINDK]
    ALTKN,                     -- Prev.Acct No. [ALTKN]
    ZGRUP,                     -- Grouping key [DZGRUP]
    MGRUP,                     -- Grouping Key [MGRUP]
    UZAWE,                     -- Pmnt Meth. Sup. [UZAWE]
    QSREC,                     -- Recipient Type [QSREC]
    QSBGR,                     -- Exmpt.Authority [QSBGR]
    QLAND,                     -- WTax C/R Key [QLAND]
    XEDIP,                     -- Pmt adv. by EDI [XEDIP]
    FRGRP,                     -- Release Group [FRGRP]
    TOGRR,                     -- Tolerance Grp [TOGRR]
    TLFXS,                     -- Clerk's fax [TLFXS]
    INTAD,                     -- Clrk's internet [INTAD]
    XLFZB,                     -- Alt.Payee(Doc.) [XLFZB]
    GUZTE,                     -- Cr Memo Terms [GUZTE]
    GRICD,                     -- Activity Code [J_1AGICD_D]
    GRIDT,                     -- Distr. Type [J_1ADTYP_D]
    XAUSZ,                     -- Acct Statement [XAUSZ]
    CERDT,                     -- Certifictn Date [CERDT]
    CONFS,                     -- ConfirmSt (CCd) [CONFS_B]
    UPDAT,                     -- Confirm.date [UPDAT_RF]
    UPTIM,                     -- Confirm.time [UPTIM_RF]
    NODEL,                     -- CoCd del.block [NODEL_B]
    TLFNS,                     -- Act.clk tel.no. [TLFNS]
    AVSND,                     -- PmtAdv. XML [AVSND]
    AD_HASH,                   -- E-Mail for Avis [ADHASH]
    CVP_XBLCK_B,               -- Purpose Completed [CVP_XBLCK]
    CIIUCODE,                  -- main economic act. [CIIUCODE]
    PAYMENTCLEARINGGRPID,      -- Payment Clrg Grp ID [FAR_PAYMENT_CLEARING_GROUP]
    PAYTRSN,                   -- Payment Reason [FARP_PAYT_RSN]
    LFB1_EEW_CC,               -- Dataelement for the Extension Company Code [LFB1_EEW_CC]
    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]
    LIFNR,                     -- Supplier [LIFNR]
    TARGET_ASSIGNMENT_ID,      -- Assignment ID [MDG_BP_ASSIGNMENT_ID]
    BRSCH,                     -- Industry [BRSCH]
    WRBTR,                     -- Amount for Pmt Progr [KR_AMOUNT_CS]
    WAERS,                     -- Currency [WAERS]
    FORGN,                     -- Foreign Shareholder [FIWTKW_LOCALITY]
    SHARE_IN_FOREIGN,          -- Foreign Share [FIWTKW_OWNED_SHARE]
    NOTES,                     -- Notes [FIWTKW_NOTES]
    ACTIVE,                    -- Shr. is Active [FIWTKW_SHR_ACTIVE]
    US_REC_COUNTRY,            -- Country/Reg. [LAND1]
    US_GIIN,                   -- US Recipient GIIN [FIWTUS_RECIPIENT_GIIN]
    US_FTID,                   -- US Recipient FTID [FIWTUS_RECIPIENT_FTID]
    US_REC_DOB,                -- US Recipient DOB [FIWTUS_RECIPIENT_DOB]
    US_LOB_CODE,               -- LOB Treaty Code [FIWTUS_LOB_CODE]
    US_W8_RECVDATE,            -- W8 Form Rec Date [FIWTUS_W8_RECV_DATE]
    US_W9_RECVDATE,            -- W9 Form Rec Date [FIWTUS_W9_RECV_DATE]
    US_TIN_NOTICE,             -- Second TIN Notice [FIWTUS_SECOND_TIN_NOTICE]
    US_PARTNERSHIP_IND,        -- Partnership Int Ind [FIWTUS_PARTNERSHIP_IND]
    ZBOKD,                     -- Ledger Exp. date [/ATL/VBOKD]
    ZQSSKZ,                    -- Future W.tax code [/ATL/VQSSKZ]
    ZQSZDT,                    -- Valid until [/ATL/VQSZDT]
    ZQSZNR,                    -- F.Exemption no. [/ATL/VQSZNR]
    ZMINDAT,                   -- Cer.date min.wage [/ATL/VMINDAT]
    J_SC_SUBCONTYPE,           -- Subcontractor Type [/SAPNEA/J_SC_SUBCONTYPE]
    J_SC_COMPDATE,             -- Completion Date [/SAPNEA/J_SC_COMPLETIONDATE]
    J_SC_OFFSM,                -- Offset Method [/SAPNEA/J_SC_OFFSM]
    J_SC_OFFSR,                -- Offset % [/SAPNEA/J_SC_OFFSR]
    PREPAY_RELEVANT,           -- Prepayment Relevant [WRF_PREPAY_RELEVANT]
    ASSIGN_TEST,               -- Assignm. Test Group [WRF_MRM_ASSIGN_GROUP]
    PRIMARY KEY (MANDT, PROCESS_ID, PROCESS_STEP_NO, SOURCE_SYSTEM, SOURCE_ID, BUKRS, ASSIGNMENT_ID)
);

Learn More