REIS_CN_BP_L SAP (Reporting Fields: Contract Data and Partner) Structure details

Dictionary Type: Structure
Description: Reporting Fields: Contract Data and Partner




ABAP Code to SELECT data from REIS_CN_BP_L
Related tables to REIS_CN_BP_L
Access table REIS_CN_BP_L




Structure field list including key, data, relationships and ABAP select examples

REIS_CN_BP_L is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Reporting Fields: Contract Data and Partner" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_REIS_CN_BP_L TYPE REIS_CN_BP_L.

The REIS_CN_BP_L table consists of various fields, each holding specific information or linking keys about Reporting Fields: Contract Data and Partner data available in SAP. These include NAMEGROUP1 (Name 1 (group)), NAMEGROUP2 (Name 2 (group)), GROUPTYPE (Group type), MANDT (Client).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP REIS_CN_BP_L structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
NAMEGROUP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAMEGROUP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
GROUPTYPEGroup type BU_GRPTYPCHAR4TB025BU_GRPTYPH_TB025
MANDTClient MANDTCLNT3Assigned to domainMANDT
INTRENOInternal Key of Real Estate Object RECAINTRENOCHAR13RECAINTRENO
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
RECNNRContract Number RECNNUMBERCHAR13ALPHARECNNUMBERRECNNRRECNCN
OBJNRObject Number RECAOBJNRCHAR22Assigned to domainJ_OBJNRONR
IMKEYInternal Key of Real Estate Object (FI) RECAIMKEYCHAR8IMKEYIMKEYRECLFXCAIMKEY
CREATIONTYPEHow the Object Was Created RECACREATIONTYPECHAR1RECACREATIONTYPE
RERFEntered by RERFCHAR12SYCHAR12
DERFFirst Entered on DERFDATS8DATUM
TERFTime of Initial Entry TERFTIMS6TIMES
REHERSource of initial entry REHERCHAR10CHAR10
RBEAREmployee ID RBEARCHAR12SYCHAR12
DBEARLast Edited on DBEARDATS8DATUM
TBEARLast Edited at TBEARTIMS6TIMES
RBHEREditing Source RBHERCHAR10CHAR10
RESPONSIBLEPerson Responsible RECARESPONSIBLECHAR12USR02XUBNAMEUSER_COMP
USEREXCLUSIVEUser with Exclusive Change Authorization RECAUSEREXCLUSIVECHAR12USR02XUBNAMEUSER_COMP
AUTHGRPAuthorization Group RECAAUTHGRPCHAR40RECAAUTHGRP
RECNTYPEContract Type RECNCONTRACTTYPECHAR4TIV26SMVARTRECNTYPERECNCONTRACTTYPE
RECNBEGDate of contract start RECNCNBEGDATS8RECADATE
RECNENDABSTerm End Date RECNCNENDABSDATS8REDATRECADATEEND
RECNTXTContract name RECNTXTCHAR80XTEXT80
RECNDACTIVContract activation DAKTVDATS8DATUM
RECNTLAWTenancy law SMIETRCHAR5TIV03SMIETR
RECNTXTOLDNumber of old contract VVOSMIVECHAR20ALPHAVVOSMIVE
RECNBUKRSCOLLECTCompany code of main contract RECNBUKRSCOLLECTCHAR4T001BUKRS
RECNNRCOLLECTNumber of Real Estate Main Contract RECNNUMBERCOLLECTCHAR13ALPHARECNNUMBERRECNNR
RECNCNCURRCurrency for Contract RECNWAERS_CNCUKY5Assigned to domainWAERSFWS
INDUSTRYIndustry BU_IND_SECTORCHAR10Assigned to domainBU_INDSECTOR
SRRELEVANTRelevant to Sales RECNSALESRENTRELEVANTCHAR1RECABOOL
DPTARGETTYPESecurity Deposit Type RECNDPTYPECHAR4TIVCNDPTYPEALPHARECNDPTYPE
RECNDATDate of Contract Conclusion RECNDATDATS8DDAT
RECN2DATDate of Second Signature RECN2DATDATS8RECADATE
RECNDPOCash Flow Generated Starting On RECDCFSTARTFROMDATS8RECADATE
RECNEND1STDate of First Contract End RECNCNEND1STDATS8RECADATE
RECNNOTPERContract Notice Per RECNNTPERDATS8RECADATE
RECNNOTRECEIPTDate of receipt of notice RECNNTRECEIPTDATS8RECADATE
RECNNOTREASONReason for Notice RECNNTREASONNUMC2TIVCNNTRERECNNTREASONRECNNTREASON
RECNDAKTKUNotice: Date of Activation RECNNTACTIVATEDONDATS8RECADATE
CFARCHIVEDTODate Up to Which the Cash Flow Is Archived RECDCFARCHIVEDTODATS8RECADATE
CFLOCKEDTODate Until Which the Cash Flow Is Locked RECDCFLOCKEDTODATS8RECADATE
CFPOSTINGFROMFirst Posting From RECDCFPOSTINGFROMDATS8RECADATE
BENOCNSite That Belongs to Contract RECNBENOCNCHAR8Assigned to domainSWENRREBDBENOREBDBENO
TRANSPOSSFROMTransfer of Possession: Start Date RECNTRANSPOSSFROMDATS8RECADATEBEG
TRANSPOSSTOTransfer of Possession: End Date RECNTRANSPOSSTODATS8REDATRECADATEEND
HASMULTIASSIGNMultiple Assignment of Object to Group Allowed REBDHASMULTIASSIGNCHAR1RECABOOL
POSSDATEFROMDate From Which the Object Is Made Available for Use REBDPOSSDATEFROMDATS8RECADATE
POSSDATETODate Up to Which the Object Is Used REBDPOSSDATETODATS8RECADATE
.INCLU--AP 0
SECDEPRELEVANTRelevant to Security Deposit REXCESCDRELCHAR1XFELD
NOTADJSDCNNo Data Update in Security Deposit Contract REXCESCDNOTADJCHAR1RECABOOL
.INCLU--AP 0
REYCMAJORCNCAM Major Contract REYCMAJORCNCHAR13ALPHARECNNUMBER
REYCDEDUCTMEASDeduct Major Tenant Space in Den. when Calc. Subtenant Share REYCDEDUCTMEASCHAR1RECABOOL
REYCMAJORTNTMajor Tenant Contribution Indicator REYCMAJORTNTCHAR1RECABOOL
REYCISSUECREDITIssue Credit REYCISSUECREDITCHAR1REYCISSUECREDIT
REYCPOSDATERELPossession Date Relevant REYCPOSDATERELCHAR1RECABOOL
XRECNNRCOLContract name RECNTXTCHAR80XTEXT80
XBUKRSName of Company Code or Company BUTXTCHAR25TEXT25
XRECNTYPEDescription of type of RE contract type XMVARTMCHAR30XMBEZ
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
AUFNROrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
XTENANCYLAWTenancy law long text XMIETRCHAR50XTEXT50
XCOLLECTContract name RECNTXTCHAR80XTEXT80
XAUTHGRPDescription of Authorization Group RECAXAUTHGRPCHAR60RECAXLDESCRIPTION
XINDUSTRYIndustry Name RECNINDUSTRYCHAR20TEXT20
XTRANSPOSSPERIODProductive Holdings: Time Period RECNXTRANSPOSSPERIODCHAR30RECAXMDESCRIPTION
PARTNERBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
ROLEBusiness Partner: Role REBPROLECHAR6Assigned to domainBU_ROLE
SUBROLEBusiness Partner: Role Type REBPSUBROLECHAR4Assigned to domainREBPSUBROLE
APPLBusiness Partner: Application Category REBPAPPLCHAR4Assigned to domainBP_APPLREBPAPPL
VALIDFROMDate of Start of Relationship REBPVALIDFROMDATS8RECADATEBEG
VALIDTODate of End of Relationship REBPVALIDTODATS8REDATRECADATEEND
ADDRTYPEAddress Type REBPADDRTYPECHAR10TB009BU_ADRKIND
BRUTEILFractional share of property REBPBRUEIGDEC9(3) REBPOWNERSHIPSHARE
BMITEIGCo-ownership share REBPMITEIGDEC9(3) REBPOWNERSHIPSHARE
PANTEILOwnership share REBPANTEILDEC6(2) DEC4_2
RFAKTConversion factor for fractional share of property REBPFAKTEIGNUMC6VVRFAKT
XNAMEShort Name of Business Partner REBPXNAMECHAR50BU_TEXT50
XPARTNERName/Address of Business Partner REBPXPARTNERCHAR80TEXT80
ROLECATECategory of Role Category REBPROLECATECHAR1REBPROLECATE
XROLEName of Business Partner Role REBPXROLECHAR30RECAXMDESCRIPTION
XSUBROLEName of Role Type REBPXSUBROLECHAR30RECAXMDESCRIPTION
XOBJTYPEPartial Object Type ID, for example 'BE' RECAXOBJTYPECHAR3CHAR3
IDENTKEYID Part Key, for example '1000/123' RECAIDENTKEYCHAR45CHAR45
TEL_NUMBER_LONGComplete number: dialling code+number+extension AD_TELNRLGCHAR30CHAR30
FAX_NUMBER_LONGComplete number: dialling code+number+extension AD_FXNRLNGCHAR30CHAR30
SMTP_ADDRE-Mail Address AD_SMTPADRCHAR241SXIDNAD_SMTPADR
XTITLE_ACA1Academic Title: Written Form AD_TITLE1TCHAR20TEXT20
XTITLE_ACA22nd academic title: written form AD_TITLE2TCHAR20TEXT20
XTITLE_SPPLName supplement, e.g. noble title (written form) AD_TITLESTCHAR20TEXT20
XPREFIX1Name prefix AD_PREFIXTCHAR20TEXT20
XPREFIX2Name prefix AD_PREFIXTCHAR20TEXT20
STANDARDADDRESSIndicator: Address is standard address BU_XDFADRCHAR1XFELD
C_O_NAMEc/o name AD_NAME_COCHAR40TEXT40
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
DISTRICTDistrict AD_CITY2CHAR40TEXT40CITY_PART
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8ADRREGGRPREGIOGROUP
POSTL_COD1City postal code AD_PSTCD1CHAR10CHAR10
POSTL_COD2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POSTL_COD3Company Postal Code (for Large Customers) AD_PSTCD3CHAR10CHAR10
PCODE1_EXT(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code AD_PST1XTCHAR10CHAR10
PCODE2_EXT(Not Supported) PO Box Postal Code Extension AD_PST2XTCHAR10CHAR10
PCODE3_EXT(Not Supported) Major Customer Postal Code Extension AD_PST3XTCHAR10CHAR10
PO_BOXPO Box AD_POBXCHAR10CHAR10
PO_W_O_NOFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_CITPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3T005SREGIO
POBOX_CTRYPO box country AD_POBXCTYCHAR3T005LAND1
PO_CTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
STR_ABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2ADRSTRTYPESTRTYPEAB
HOUSE_NOHouse Number AD_HSNM1CHAR10TEXT10
HOUSE_NO2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NO3(Not supported) House Number Range AD_HSNM3CHAR10TEXT10
STR_SUPPL1Street 2 AD_STRSPP1CHAR40TEXT40
STR_SUPPL2Street 3 AD_STRSPP2CHAR40TEXT40
STR_SUPPL3Street 4 AD_STRSPP3CHAR40TEXT40
LOCATIONStreet 5 AD_LCTNCHAR40TEXT40
BUILDINGBuilding (Number or Code) AD_BLDNGCHAR20TEXT20
FLOORFloor in building AD_FLOORCHAR10TEXT10
ROOM_NORoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
COUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
TIME_ZONEAddress time zone AD_TZONECHAR6TTZZTZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10Assigned to domainZONE
LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002
LANGUISO2-Character SAP Language Code LAISOCHAR2LAISO
COMM_TYPECommunication Method (Key) (Business Address Services) AD_COMMCHAR3Assigned to domainAD_COMM
EXTADDRESSNUMBERAddress number in external system BU_ADEXTCHAR20BU_ADEXT
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4Assigned to domainAD_NO_USE
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4Assigned to domainAD_NO_USE
MOVE_DATEDate of Move BU_MOVEDATDATS8DATUM
MOVE_ADDRESSNumber of Move Target Address for Address Moves BU_MOVE_ADDRCHAR10Assigned to domainALPHAAD_ADDRNUMADR
VALIDFROMDATEValidity Date (Valid From) BU_DATFROMDATS8DATUM
VALIDTODATEValidity Date (Valid To) BU_DATTODATS8DATUM
MOVE_ADDR_GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
CITY_NOCity code for city/street file AD_CITYNUMCHAR12Assigned to domainALPHACITY_CODE
DISTRCT_NODistrict code for City and Street file AD_CITYPNMCHAR8Assigned to domainALPHACITYP_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
PBOXCIT_NOCity PO box code (City file) AD_CIT2NUMCHAR12Assigned to domainALPHACITY_CODE
STREET_NOStreet Number for City/Street File AD_STRNUMCHAR12Assigned to domainALPHASTRT_CODE
HOMECITYNODifferent city for city/street file AD_CITYHNMCHAR12Assigned to domainALPHACITY_CODE
PO_BOX_LOBBYPO Box Lobby AD_PO_BOX_LBYCHAR40TEXT40
DELI_SERV_TYPEType of Delivery Service AD_DELIVERY_SERVICE_TYPECHAR4AD_DELIVERY_SERVICE_TYPE
DELI_SERV_NUMBERNumber of Delivery Service AD_DELIVERY_SERVICE_NUMBERCHAR10CHAR10
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
COUNTY_NOCounty code for county AD_CNTYNUMCHAR8Assigned to domainALPHACNTY_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
TOWNSHIP_NOTownship code for Township AD_TWSHPNUMCHAR8Assigned to domainALPHATWSHP_CODE
FIRSTNAMEFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
LASTNAMELast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
BIRTHNAMEName at birth of business partner BU_BIRTHNMCHAR40BU_NAME
MIDDLENAMEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
SECONDNAMEOther Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4TSAD2AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4TSAD2AD_TITLE1
TITLE_SPPLName supplement, e.g. noble title (key) AD_TITLESCHAR4TSAD5AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4TSAD4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4TSAD4AD_PREFIX
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2T005NAD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3T005LAND1
NAMCOUNTRYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
SEXSex of business partner (person) BU_SEXIDCHAR1BU_SEXID
BIRTHPLACEBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
BIRTHDATEDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDATEDate of death of business partner BU_DEATHDTDATS8DATUM
MARITALSTATUSMarital Status of Business Partner BU_MARSTCHAR1TB027BU_MARST
CORRESPONDLANGUAGEBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1T002ISOLASPRAS
CORRESPONDLANGUAGEISO2-Character SAP Language Code LAISOCHAR2LAISO
FULLNAMEFull Name BU_NAME1TXCHAR80TEXT80
EMPLOYERName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
OCCUPATIONOccupation/group BU_JOBGRCHAR4Assigned to domainBU_JOBGR
NATIONALITYNationality BU_NATIOCHAR3Assigned to domainLAND1
NATIONALITYISOCountry ISO code INTCACHAR2INTCAF4_INTCA
COUNTRYORIGINCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3Assigned to domainLAND1
NAME1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGALFORMBP: Legal form of organization BU_LEGENTYCHAR2TB019BU_LEGENTYH_TB019
INDUSTRYSECTORIndustry sector BU_INDSECTCHAR10TB023BU_INDSECTH_TB023
FOUNDATIONDATEDate organization founded BU_FOUND_DATDATS8DATUM
LIQUIDATIONDATELiquidation date of organization BU_LIQUID_DATDATS8
LOC_NO_1International location number (part 1) BBBNRNUMC7NUM07
LOC_NO_2International location number (Part 2) BBSNRNUMC5NUM05
CHK_DIGITCheck digit for the international location number BUBKZNUMC1NUM01
LEGALORGLegal Entity of Organization BU_LEGAL_ORGCHAR2Assigned to domainBU_LEGAL_ORG
RECISVALIDFROMDisplayed Row Is Valid From REISRECVALIDFROMDATS8RECADATE
RECISVALIDTODisplayed Row Is Valid Until REISRECVALIDTODATS8RECADATE
XSEXName for Gender of Business Partner REISBPXSEXCHAR15RECAXSDESCRIPTION
MOB_NUMBERFirst Mobile Telephone No.: Dialing Code + Number AD_MBNMBR1CHAR30CHAR30

Key field Non-key field



How do I retrieve data from SAP structure REIS_CN_BP_L using ABAP code?

As REIS_CN_BP_L is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on REIS_CN_BP_L as there is no data to select.

How to access SAP table REIS_CN_BP_L

Within an ECC or HANA version of SAP you can also view further information about REIS_CN_BP_L and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!