SAP Table BUFFER_VICN01

Structure for Table Buffer for DB Table VICN01

BUFFER_VICN01 (Structure for Table Buffer for DB Table VICN01) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link BUFFER_VICN01 to other SAP tables.

BUFFER_VICN01 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
INTRENO Internal Real Estate Master Data Code VVINTRENO CHAR 13 0
BUKRS Company Code BUKRS T001 CHAR 4 0
RECNTYPE External Real Estate contract type SMVART TIV26 CHAR 4 0
RECNNR Real Estate Contract Number RECNNR CHAR 13 0
RECNDAT Date of Contract Conclusion RECNDAT DATS 8 0
RECNBEG Date of contract start RECNBEG DATS 8 0
RECNEND Date of contract end RECNEND DATS 8 0
RECNADJT Lease-Out Adjustment Type SMVAR CHAR 1 0
RECNTXT Contract name RECNTXT CHAR 80 0
RECNDPO Date of first posting RECNDPO DATS 8 0
RECNOBJNR Object number J_OBJNR CHAR 22 0
RECNNOTTYPE Notice Type of Lease-Out SMVKUEART CHAR 1 0
NULL No period of notice
1 Period reg.
2 Deadline reg.
3 free period reg.
4 free deadline reg.
RECNNOTKEY Notice rule SKUEKEY CHAR 12 0
RECNNOTPER Contract Notice Per DKUZU DATS 8 0
RECNAUTHGR Authorization group VVBERGRP CHAR 40 0
RECNBUSAREA Business Area GSBER TGSB CHAR 4 0
RECNPRCTR Profit Center PRCTR CEPC CHAR 10 0
RECNACCDETVAL Account determination key for account determination VVWERTN_ADCN TIVCN08 CHAR 10 0
RECNADMONTH Accrual/deferral method VVJMABGR CHAR 1 0
NULL No
X Yes
RECNDDUNNED Last dunned on MADAT DATS 8 0
RECNDCOMPLNT Date of complaint VVKLDATUM DATS 8 0
RECNDCOMPLRC Complaint reference code VVKLAKTZEI CHAR 20 0
RECNJURISDIC Jurisdiction VVXGERSTD CHAR 35 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
RERF Entered by RERF CHAR 12 0
DERF First Entered on DERF DATS 8 0
TERF Time of Initial Entry TERF TIMS 6 0
REHER Source of initial entry REHER CHAR 10 0
RBEAR Employee ID RBEAR CHAR 12 0
DBEAR Last Edited on DBEAR DATS 8 0
TBEAR Last Edited at TBEAR TIMS 6 0
RBHER Editing Source RBHER CHAR 10 0
RECNUNIT Area unit RECNUNIT T006 UNIT 3 0
RECNKUNNR Customer Number KUNNR KNA1 CHAR 10 0
RECNLIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
RECNTXJCD Tax Jurisdiction TXJCD CHAR 15 0
RECNCURR Currency key for local currency RECNWAERS_H TCURC CUKY 5 0
RECNTLAW Tenancy law SMIETR TIV03 CHAR 5 0
RECNCURR2 Currency key for the display currency RECNWAERS_D TCURC CUKY 5 0
RECNTXTOLD Number of old contract VVOSMIVE CHAR 20 0
RECNDACTIV Contract activation DAKTV DATS 8 0
RECNNRCOLLECT Number of Real Estate main contract RECNNRCOLLECT CHAR 13 0
RECNKOSTL Cost center of internal contract RECNKOSTL CHAR 10 0
ZLSCH Payment Method DZLSCH CHAR 1 0
RECNPREDATA Flag: Predefined rates RECNPREDATA CHAR 1 0
X Yes
NULL No
SPARTNR Business Partner Number BP_PARTNR CHAR 10 0
RECNNOTRECEIPT Receipt or issue date of notice DEKUEA DATS 8 0
RECNNOTREASON Reason for notice RKUEGRU TIV39 NUMC 2 0
RECNNOTINVREA Reason for rejection RABLGRU TIV41 NUMC 2 0
RECNJVSTOPT Input tax opting (indicator) VVJVSTOPT CHAR 1 0
NULL No
X Yes
RECNVSTSOND Input tax opting reason SVSTSOND TIV63 CHAR 1 0
RECNMANSP Dunning block MANSP T040S CHAR 1 0
RECNMABER Dunning Area MABER T047M CHAR 2 0
RECNMAHNA Dunning Procedure MAHNA T047A CHAR 4 0
RECNMAHNS_D Dunning level MAHNS_D NUMC 1 0
RECNNOTCAT Notice Type SKUAR CHAR 1 0
1 Tenant-side
2 Landlord-side
RECNGFZLSCH Payment method for credit memos RECNGFZLSCH CHAR 1 0
RECNZLSPR Payment Block Key DZLSPR T008 CHAR 1 0
RECNHBKID Short Key for a House Bank HBKID T012 CHAR 5 0
RECNXBLNR Note to payee RECNXBLNR1 CHAR 16 0
RECNDKUZUG Date notice approved VVDKUZUG DATS 8 0
RECNDKUABG Date notice rejected VVDKUABG DATS 8 0
RECNDWIKU Date of objection to notice VVDWIKU DATS 8 0
RECNDKUERCK Date of withdrawal of notice DKUERCK DATS 8 0
RECNDKREUEB Date notice submitted to legal department VVDKREUEB DATS 8 0
RECNDAKTKU Activation date VVDAKTKU DATS 8 0
RECNDSTKU Reversal date VVDSTKU DATS 8 0
RECNADJTTYPE Adjustment triggered by RECNADJTTYPE CHAR 1 0
NULL Tenant
1 Landlord
RECNADJTRUECK Retroactive adjustment possible RECNADJTRUECK CHAR 1 0
X Yes
NULL No
RECNBUKRSCOLLECT Company code of main contract RECNBUKRSCOLLECT T001 CHAR 4 0
RECNBASISAEZIF Base: equivalence number distribution RECNBASISAEZIF INT2 5 0
RECNXCROSS Gross amount indicator RECNXCROSS CHAR 1 0
X Yes
NULL No
RECNMANDAT Mandate RECNMANDAT CHAR 20 0
RECNMANDATTYP Role of Contract in Mandate RECNMANDATTYP NUMC 1 0
0 No Mandate Contract
1 Object Mandate (Simple Mandate)
5 Condominium Owners Association (COA)
6 Condominium Managemement (Separate Ownership)
9 Assessment Contract
RECNFLESR Activation of POR functions VVKZESR CHAR 1 0
NULL No
X Yes
RECNESRNROW POR participant number of owner VVESRNR_EIG TIV9I NUMC 9 0
RECNESRCUIDOW POR customer identification number VVESRKUID_EIG TIV9I CHAR 15 0
RECNVATNROW Value-added tax of owner VVMWSTNR_EIG CHAR 20 0
RECNBUKRSGKT Object and account CoCd VVBUKRS_GKT T001 CHAR 4 0
RECNKZEIGGKT Cash account control for owner VVKZEIGGKT CHAR 1 0
NULL No control is active
1 No owner account - Administrator has pool account
2 No owner account - Objects have pool account
3 Owner account with automatic payment (incoming/outgoing)
4 Owner account with automatic payment (incoming)
5 Owner account with automatic payment (outgoing)
6 Owner account without automatic payment
RELSKASSENZ RELSKASSENZ CHAR 30 0
RELSGRDNR RELSGRDNR CHAR 30 0
RELSSUBTYPE RELSSUBTYPE TIVLSCNSTYPE CHAR 4 0
RELSAKTZ RELSAKTZ CHAR 35 0
RELSDAT2 RELSDAT2 DATS 8 0
RELSWIRTUEBG RELSWIRTUEBG DATS 8 0
RELSNOTEARLY RELSNOTEARLY DATS 8 0
RELSOWNER Business Partner Number BP_PARTNR CHAR 10 0
RELSROLETYP Business Partner Role Category BP_ROLETYP CHAR 4 0
CREATIONTYPE How the Object Was Created RECACREATIONTYPE CHAR 1 0
NULL Object created in Classic RE
1 Object created in Classic RE or migrated from other system
2 Object created in Flexible Real Estate Management
RECNCNCURR Currency for Contract RECNWAERS_CN TCURC CUKY 5 0
RECNENDABS Term End Date RECNCNENDABS DATS 8 0
RECN2DAT Date of Second Signature RECN2DAT DATS 8 0
RESPONSIBLE Person Responsible RECARESPONSIBLE CHAR 12 0
USEREXCLUSIVE User with Exclusive Change Authorization RECAUSEREXCLUSIVE CHAR 12 0
SRRELEVANT Relevant to Sales RECNSALESRENTRELEVANT CHAR 1 0
X Yes
NULL No
CFARCHIVEDTO Date Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTO DATS 8 0
CFLOCKEDTO Date Until Which the Cash Flow Is Locked RECDCFLOCKEDTO DATS 8 0
INDUSTRY Industry BU_IND_SECTOR CHAR 10 0
DPTARGETTYPE Security Deposit Type RECNDPTYPE TIVCNDPTYPE CHAR 4 0
BIRELEASE RELUBIRELEASE CHAR 1 0
X Yes
NULL No
BIVALIDFROM RELUBIVALIDFROM DATS 8 0
BIVALIDTO RELUBIVALIDTO DATS 8 0
BIREPRTO RELUBIREPRTO DATS 8 0
BIREPRTOTIME RELUBIREPRTOTIME TIMS 6 0
BIRECAT RELUBIRECAT TIVLUBIRECAT CHAR 2 0
PUBLICTYPE RELUPUBLICTYPE TIVLUPUBLICTYPE CHAR 2 0
FILENO RELUFILENO CHAR 35 0
BIPURPOSE RELUBIPURPOSE TIVLUBIPURPOSE CHAR 2 0
BIPRICING RELUBIPRICING TIVLUBIPRICING CHAR 2 0
NOT_FOUND Checkbox XFELD CHAR 1 0
X Yes
NULL No

BUFFER_VICN01 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
BUFFER_VICN01 BIPRICING SYST MANDT TIVLUBIPRICING MANDT
BUFFER_VICN01 BIPRICING BUFFER_VICN01 BIPRICING TIVLUBIPRICING BIPRICING
BUFFER_VICN01 BIPURPOSE SYST MANDT TIVLUBIPURPOSE MANDT
BUFFER_VICN01 BIPURPOSE BUFFER_VICN01 BIPURPOSE TIVLUBIPURPOSE BIPURPOSE
BUFFER_VICN01 BIRECAT SYST MANDT TIVLUBIRECAT MANDT
BUFFER_VICN01 BIRECAT BUFFER_VICN01 BIRECAT TIVLUBIRECAT BIRECAT
BUFFER_VICN01 BUKRS BUFFER_VICN01 BUKRS T001 Company Codes BUKRS
BUFFER_VICN01 BUKRS BUFFER_VICN01 MANDT T001 Company Codes MANDT
BUFFER_VICN01 DPTARGETTYPE BUFFER_VICN01 DPTARGETTYPE TIVCNDPTYPE Security Deposit Type DPTYPE
BUFFER_VICN01 DPTARGETTYPE SYST MANDT TIVCNDPTYPE Security Deposit Type MANDT
BUFFER_VICN01 PUBLICTYPE SYST MANDT TIVLUPUBLICTYPE MANDT
BUFFER_VICN01 PUBLICTYPE BUFFER_VICN01 PUBLICTYPE TIVLUPUBLICTYPE PUBLICTYPE
BUFFER_VICN01 RECNACCDETVAL BUFFER_VICN01 MANDT TIVCN08 Account Determination Key 2 for General Contract AcctDet. MANDT
BUFFER_VICN01 RECNACCDETVAL BUFFER_VICN01 RECNACCDETVAL TIVCN08 Account Determination Key 2 for General Contract AcctDet. KOEIGR
BUFFER_VICN01 RECNBUKRSCOLLECT SYST MANDT T001 Company Codes MANDT
BUFFER_VICN01 RECNBUKRSCOLLECT BUFFER_VICN01 RECNBUKRSCOLLECT T001 Company Codes BUKRS
BUFFER_VICN01 RECNBUKRSGKT SYST MANDT T001 Company Codes MANDT
BUFFER_VICN01 RECNBUKRSGKT BUFFER_VICN01 RECNBUKRSGKT T001 Company Codes BUKRS
BUFFER_VICN01 RECNBUSAREA BUFFER_VICN01 MANDT TGSB Business Areas MANDT
BUFFER_VICN01 RECNBUSAREA BUFFER_VICN01 RECNBUSAREA TGSB Business Areas GSBER
BUFFER_VICN01 RECNCNCURR SYST MANDT TCURC Currency Codes MANDT
BUFFER_VICN01 RECNCNCURR BUFFER_VICN01 RECNCNCURR TCURC Currency Codes WAERS
BUFFER_VICN01 RECNCURR SYST MANDT TCURC Currency Codes MANDT
BUFFER_VICN01 RECNCURR BUFFER_VICN01 RECNCURR TCURC Currency Codes WAERS
BUFFER_VICN01 RECNCURR2 SYST MANDT TCURC Currency Codes MANDT
BUFFER_VICN01 RECNCURR2 BUFFER_VICN01 RECNCURR2 TCURC Currency Codes WAERS
BUFFER_VICN01 RECNESRCUIDOW SYST MANDT TIV9I RE: Owner POR Data (Switzerland) MANDT
BUFFER_VICN01 RECNESRCUIDOW BUFFER_VICN01 RECNESRNROW TIV9I RE: Owner POR Data (Switzerland) TEILN
BUFFER_VICN01 RECNESRCUIDOW BUFFER_VICN01 RECNESRCUIDOW TIV9I RE: Owner POR Data (Switzerland) KUNID
BUFFER_VICN01 RECNESRCUIDOW BUFFER_VICN01 BUKRS TIV9I RE: Owner POR Data (Switzerland) BUKRS
BUFFER_VICN01 RECNESRNROW BUFFER_VICN01 RECNESRCUIDOW TIV9I RE: Owner POR Data (Switzerland) KUNID
BUFFER_VICN01 RECNESRNROW BUFFER_VICN01 BUKRS TIV9I RE: Owner POR Data (Switzerland) BUKRS
BUFFER_VICN01 RECNESRNROW SYST MANDT TIV9I RE: Owner POR Data (Switzerland) MANDT
BUFFER_VICN01 RECNESRNROW BUFFER_VICN01 RECNESRNROW TIV9I RE: Owner POR Data (Switzerland) TEILN
BUFFER_VICN01 RECNHBKID BUFFER_VICN01 RECNHBKID T012 House Banks HBKID
BUFFER_VICN01 RECNHBKID BUFFER_VICN01 MANDT T012 House Banks MANDT
BUFFER_VICN01 RECNHBKID BUFFER_VICN01 BUKRS T012 House Banks BUKRS
BUFFER_VICN01 RECNKUNNR BUFFER_VICN01 MANDT KNA1 General Data in Customer Master MANDT
BUFFER_VICN01 RECNKUNNR BUFFER_VICN01 RECNKUNNR KNA1 General Data in Customer Master KUNNR
BUFFER_VICN01 RECNLIFNR BUFFER_VICN01 MANDT LFA1 Vendor Master (General Section) MANDT
BUFFER_VICN01 RECNLIFNR BUFFER_VICN01 RECNLIFNR LFA1 Vendor Master (General Section) LIFNR
BUFFER_VICN01 RECNMABER BUFFER_VICN01 MANDT T047M Dunning areas MANDT
BUFFER_VICN01 RECNMABER BUFFER_VICN01 BUKRS T047M Dunning areas BUKRS
BUFFER_VICN01 RECNMABER BUFFER_VICN01 RECNMABER T047M Dunning areas MABER
BUFFER_VICN01 RECNMAHNA BUFFER_VICN01 MANDT T047A Account Level Dunning Control MANDT
BUFFER_VICN01 RECNMAHNA BUFFER_VICN01 RECNMAHNA T047A Account Level Dunning Control MAHNA
BUFFER_VICN01 RECNMANSP BUFFER_VICN01 MANDT T040S Blocking reasons for dunning notices MANDT
BUFFER_VICN01 RECNMANSP BUFFER_VICN01 RECNMANSP T040S Blocking reasons for dunning notices MANSP
BUFFER_VICN01 RECNNOTINVREA BUFFER_VICN01 MANDT TIV41 Lease-out notice rejection reason MANDT
BUFFER_VICN01 RECNNOTINVREA BUFFER_VICN01 RECNNOTINVREA TIV41 Lease-out notice rejection reason RABLGRU
BUFFER_VICN01 RECNNOTREASON BUFFER_VICN01 RECNNOTREASON TIV39 Reason for notice RKUEGRU
BUFFER_VICN01 RECNNOTREASON BUFFER_VICN01 MANDT TIV39 Reason for notice MANDT
BUFFER_VICN01 RECNPRCTR BUFFER_VICN01 MANDT CEPC Profit Center Master Data Table MANDT
BUFFER_VICN01 RECNPRCTR BUFFER_VICN01 RECNPRCTR CEPC Profit Center Master Data Table PRCTR
BUFFER_VICN01 RECNPRCTR * CEPC Profit Center Master Data Table DATBI
BUFFER_VICN01 RECNPRCTR * CEPC Profit Center Master Data Table KOKRS
BUFFER_VICN01 RECNTLAW BUFFER_VICN01 MANDT TIV03 Country-specific tenancy law MANDT
BUFFER_VICN01 RECNTLAW BUFFER_VICN01 RECNTLAW TIV03 Country-specific tenancy law SMIETR
BUFFER_VICN01 RECNTYPE BUFFER_VICN01 MANDT TIV26 Real Estate Contract Type (Entities) MANDT
BUFFER_VICN01 RECNTYPE BUFFER_VICN01 RECNTYPE TIV26 Real Estate Contract Type (Entities) SMVART
BUFFER_VICN01 RECNUNIT BUFFER_VICN01 MANDT T006 Units of Measurement MANDT
BUFFER_VICN01 RECNUNIT BUFFER_VICN01 RECNUNIT T006 Units of Measurement MSEHI
BUFFER_VICN01 RECNVSTSOND BUFFER_VICN01 MANDT TIV63 Reasons for input tax option MANDT
BUFFER_VICN01 RECNVSTSOND BUFFER_VICN01 RECNVSTSOND TIV63 Reasons for input tax option SVSTSOND
BUFFER_VICN01 RECNZLSPR BUFFER_VICN01 MANDT T008 Blocking Reasons for Automatic Payment Transcations MANDT
BUFFER_VICN01 RECNZLSPR BUFFER_VICN01 RECNZLSPR T008 Blocking Reasons for Automatic Payment Transcations ZAHLS
BUFFER_VICN01 RELSSUBTYPE BUFFER_VICN01 RELSSUBTYPE TIVLSCNSTYPE RELSSUBTYPE
BUFFER_VICN01 RELSSUBTYPE * TIVLSCNSTYPE MANDT
BUFFER_VICN01 RELSSUBTYPE * TIVLSCNSTYPE RECNTYPE