SAP ISCD_BROK_ACCT_STR_CUS_DATA Customer Data Table data and field list

ISCD_BROK_ACCT_STR_CUS_DATA 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 "Customer Data" 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_ISCD_BROK_ACCT_STR_CUS_DATA TYPE ISCD_BROK_ACCT_STR_CUS_DATA.

The ISCD_BROK_ACCT_STR_CUS_DATA table consists of various fields, each holding specific information or linking keys about Customer Data data available in SAP. These include CLIENT (Client), INSOBJECT (Identification for an Insurance Object), PARTNER (Business Partner Number), CREATE_DATE (UTC Time Stamp in Short Form (YYYYMMDDhhmmss))... 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. .

ISCD_BROK_ACCT_STR_CUS_DATA structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


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

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ISCD_BROK_ACCT_STR_CUS_DATA table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
WA_CUS_DATA 0
CLIENTClient MANDTCLNT3MANDT
INSOBJECTIdentification for an Insurance Object INSOBJECT_MDCHAR20ALPHAINSOBJECT_MDINSOBJECTSHLP_INSOBJECT_COLL
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
CREATE_DATEUTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMPDEC15TZNTSTMPS
BROKERBusiness Partner Number for Reporting Broker BROKERPA_BROCHAR10ALPHABU_PARTNERBUPA
BRO_CONTRACTBroker Contract, Insurance Object for the Reporting Broker BROOBJ_BROCHAR20ALPHAINSOBJECT_MD
COLLECTFS-CD: Indicator: Broker Executes Collections/Disbursements COLLECT_MDCHAR1CHAR1
DATE_FROMFS-CD: Date from Which a Broker Is Responsible BROK_DATE_FROM_MDDATS8DATS
DATE_TOFS-CD: Date to Which a Broker Is Responsible BROK_DATE_TO_MDDATS8DATS
DOC_FROMFS-CD: Date from Which Open Items Are Invoiced with Broker BROK_DOC_FROM_MDDATS8DATS
DOC_TOFS-CD: Date to Which Open Items Are Invoiced with Broker BROK_DOC_TO_MDDATS8DATS
INACTIVATEDFS-CD: Date on Which a Broker Assignment Is Deactivated BROK_INACTIVATED_MDDATS8DATS
WA_CUS_CONTR 0
CLIENTClient MANDTCLNT3MANDT
INSOBJECTIdentification for an Insurance Object INSOBJECT_MDCHAR20ALPHAINSOBJECT_MDINSOBJECTSHLP_INSOBJECT_COLL
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ERNAMIO: Technical User That Creted Insurance Object CRNAME_TECH_MDCHAR12USNAM
ERNAM_BUSINESSBusiness User That Created IO CRNAME_BUS_MDCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
AENAMTechnical User That Used IO CHNAME_TECH_MDCHAR12USNAM
AENAM_BUSINESSBusiness User That Changed IO CHNAME_BUS_MDCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
INSOBJECTTYPExternal Insurance Object Category INSOBJECTTYPC_MDCHAR2INSOBJECTTYPC_MDINSOBJECTTYPSHLP_INSOBJECTTYPC_MD
PARTNERACCContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
PARTNERACCTYPContract Account Category VKTYP_KKCHAR2VKTYP_KKKTP
FROMDATETime Stamp (Date and Time) TIMST_VKCHAR14TIMST_VK
TODATETime Stamp (Date and Time) TIMST_VKCHAR14TIMST_VK
FDGRPPlanning Group FDGRP_KKCHAR10ALPHAFDGRPFFG
FDZTGAdditional Days for Cash Management FDZTG_KKNUMC2NUM2
XARCHIVEFS-CD: Deletion Flag XARCHIVE_MDCHAR1XARCHIVE_MD
AUGRPInsurance Object: Authorization Group AUGRP_MDCHAR4BU_AUGRP
MVARIDunning Variant MVARI_VKCHAR2MVARI_VK
CMGRPCollection Management: Master Data Group CMGRP_CM_KKCHAR2CMGRP_CM_KK
STRATCollection Strategy STRAT_CM_KKCHAR2STRAT_CM_KK
CPERSCollections Contact Person CPERS_CM_KKCHAR10ALPHABU_PARTNERBPA
IS_COVARCorrespondence Variant COPRC_KKCHAR4COPRC_KK
FAARTInvoicing Type ABART_VKCHAR2ABART_VK
BASE_DATEBase Date for Invoicing Frequency DARBT_VKDATS8DATS
CPAR_ACTIVEIO: Correspondence Params Active for Ins. Object-Partner CPAR_ACTIVE_MDCHAR1XFELD
DEF_RECAlternative Correspondence Recipient for Standard Case DEF_CORR_PARTNER_KKCHAR10ALPHABU_PARTNERBUPA
DEF_REC_INDFI-CA correspondence - activity key DEF_CORR_ACKEY_KKCHAR4CORR_ACKEY_KK
CB_GPARTBusiness partner in a collective invoice COLL_BILL_GPART_VKCHAR10ALPHABU_PARTNERBUPA
CB_VKONTContract acct in a collective invoice COLL_BILL_VKONT_VKCHAR12ALPHAVKONT_KKFKKVKP
CORR_MAHNVCorrespondence Dunning Procedure CORR_MAHNV_KKCHAR2MAHNV_KK
OBJ1X_XIO: Settings Active for Insurance Object Flag PAY_PAR_ACT_MDCHAR1XFELD
ADRNRAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
ABWRE_XAlternative Payer ABWRE_KKCHAR10ALPHABU_PARTNERBUPA
ADRRE_XAddress Number for Alternative Payer ADRRE_KKCHAR10ALPHAAD_ADDRNUM
EZAWE_XIncoming Payment Method EZAWE_KKCHAR1CHAR1
EBVTY_XBank Details ID for Incoming Payments EBVTY_KKCHAR4CHAR4
ABWRA_XAlternative Payee ABWRA_KKCHAR10ALPHABU_PARTNERBUPA
ADRRA_XAddress Number for Alternative Payee ADRRA_KKCHAR10ALPHAAD_ADDRNUM
AZAWE_XOutgoing Payment Methods AZAWE_KKCHAR5CHAR5
ANZRAMultiple Alternative Payment Recipients? ANZRA_KKCHAR1XFELD
ATARTSplit Type for Outgoing Payments ATKEY_KKCHAR4ATKEY
ABVTY_XBank Details ID for Outgoing Payments ABVTY_KKCHAR4CHAR4
TRANSFER_ACCClearing Account KTDEP_VKCHAR12ALPHAVKONT_KK
INDIRECT_TRANSIndicator: Clear Variable KZVER_VKCHAR1XFELD
CCARD_IDPayment Card ID for Incoming Payments CCID_IN_KKCHAR6CHAR6
CCARD_OUTPayment Card ID for Outgoing Payments CCID_OUT_KKCHAR6CHAR6
IKEYInterest Key IKEY_KKCHAR2IKEY_KK
INTPEROFFFS-CD: Interest Calculation Base Days INTPEROFF_MDCHAR4INTPEROFF_MD
INTPERFS-CD: Interest Calculation Base Period INTPER_MDCHAR1INTPER_MD
INTTOFS-CD: Date up to Which Interest Is Calculated INTTO_MDDATS8DATS
VKONVContract account used for payment transactions VKONV_KKCHAR12ALPHAVKONT_KK
GPARVBusiness Partner Acting as Payer in Payment Transactions GPARV_KKCHAR10ALPHABU_PARTNER
EIGBVOwn Bank Details EIGBV_KKCHAR25EIGBV_KK
MNDID_XUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
QSSKZ_EWithholding Tax Code For Incoming Payments QSSKZ_E_KKCHAR2QSSKZ
QSSKZ_AWitholding Tax Code For Outgoing Payments QSSKZ_A_KKCHAR2QSSKZ
PKEYPayment Plan Key PKEY_VKCHAR2PKEY_VKSHLP_PKEY
POKEYPayment Option Key POKEY_VKCHAR2POKEY_VKSHLP_POKEY
PP_FROMFS-CD: Date from Which Payment Plan Is Valid PPLAN_FROM_MDDATS8DATS
PP_FROM_TIMEPayment Plans: Payment Plan Change Event PP_FROM_TIME_SCTIMS6UZEIT
POGRUGrouping Category for Open Items POGRU_VKCHAR2PGRUP_VK
POVERSummarization Category for Open Items POVER_VKCHAR2VGRUP_VK
STUPEROFFDeferral Base Days STUPEROFF_SCDEC3STUPEROFF_SC
STUPERDeferral Base Period STUPER_SCCHAR1STUPER_SC
XAKONTOFS-CD: Reserve and Record Payments on Account XAKONTO_MDCHAR1XAKONTO_MD
SCFDGRPPlanning Group FDGRP_KKCHAR10ALPHAFDGRPFFG
SCFDZTGAdditional Days for Cash Management FDZTG_KKNUMC2NUM2
ALKEYAlgorithm Key ALKEY_VKCHAR2ALKEY_VK
RCL_INSOBJECTIdentification for an Insurance Object INSOBJECT_MDCHAR20ALPHAINSOBJECT_MDINSOBJECTSHLP_INSOBJECT_COLL
RCL_PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
DUMMYFIELDDummy function in length 1 DUMMYCHAR1DUMMY
WA_CUSTOMER 0
CLIENTClient MANDTCLNT3MANDT
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
TYPEBusiness partner category BU_TYPECHAR1BU_TYPEBPY
BPKINDBusiness Partner Type BU_BPKINDCHAR4BU_KIND
BU_GROUPBusiness Partner Grouping BU_GROUPCHAR4BU_GROUPBPP
BPEXTBusiness Partner Number in External System BU_BPEXTCHAR20CHAR20
BU_SORT1Search term 1 for business partner BU_SORT1CHAR20BU_SORT1
BU_SORT2Search term 2 for business partner BU_SORT2CHAR20BU_SORT1
SOURCEData Origin Types BU_SOURCECHAR4BU_SOURCE
TITLEForm-of-Address Key AD_TITLECHAR4AD_TITLE
XDELECentral Archiving Flag BU_XDELECHAR1XFELD
XBLCKCentral Block for Business Partner BU_XBLCKCHAR1XFELD
AUGRPAuthorization Group BU_AUGRPCHAR4BU_AUGRP
TITLE_LETSalutation BU_TITLE_LETCHAR50TEXT50
BU_LOGSYSLogical system LOGSYSCHAR10ALPHALOGSYS
CONTACTBusiness Partner: Contact Permission BU_CONTACTCHAR1BU_CONTACT
NOT_RELEASEDIndicator: Not Released BU_XNOT_RELEASEDCHAR1XFELD
NOT_LG_COMPETENTIndicator: Not Legally Competent BU_NOT_LEG_COMPETENTCHAR1BOOLE
PRINT_MODEBusiness Partner Print Format BU_PRINT_MODECHAR1BU_PRINT_MODE
BP_EEW_DUMMYDummy function in length 1 DUMMYCHAR1DUMMY
.INCLU--AP 0
NAPRBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
BBP_IPISPTax Split BBP_J_1BINDEQUCHAR1XFELD
.INCLU--AP 0
RATECost Rate/Revenue Rate for Project Costing DPR_TV_RATECHAR15DPR_RATE_TYPE
NAME_ORG1Name 1 of organization BU_NAMEOR1CHAR40BU_NAME
NAME_ORG2Name 2 of organization BU_NAMEOR2CHAR40BU_NAME
NAME_ORG3Name 3 of organization BU_NAMEOR3CHAR40BU_NAME
NAME_ORG4Name 4 of organization BU_NAMEOR4CHAR40BU_NAME
LEGAL_ENTYBP: Legal form of organization BU_LEGENTYCHAR2BU_LEGENTYH_TB019
IND_SECTORIndustry sector BU_INDSECTCHAR10BU_INDSECTH_TB023
LEGAL_ORGLegal Entity of Organization BU_LEGAL_ORGCHAR2BU_LEGAL_ORG
FOUND_DATDate organization founded BU_FOUND_DATDATS8DATUM
LIQUID_DATLiquidation date of organization BU_LIQUID_DATDATS8
LOCATION_1International location number (part 1) BBBNRNUMC7NUM07
LOCATION_2International location number (Part 2) BBSNRNUMC5NUM05
LOCATION_3Check digit for the international location number BUBKZNUMC1NUM01
NAME_LASTLast name of business partner (person) BU_NAMEP_LCHAR40BU_NAME
NAME_FIRSTFirst name of business partner (person) BU_NAMEP_FCHAR40BU_NAME
NAME_LST2Other Last Name of a Person BU_NAMEPL2CHAR40BU_NAME
NAME_LAST2Name at birth of business partner BU_BIRTHNMCHAR40BU_NAME
NAMEMIDDLEMiddle name or second forename of a person BU_NAMEMIDCHAR40BU_NAME
TITLE_ACA1Academic Title: Key AD_TITLE1CHAR4AD_TITLE1AD_TITLE1
TITLE_ACA2Second academic title (key) AD_TITLE2CHAR4AD_TITLE1
TITLE_ROYLName supplement, e.g. noble title (key) AD_TITLESCHAR4AD_TITLES
PREFIX1Name Prefix (Key) AD_PREFIXCHAR4AD_PREFIX
PREFIX22nd name prefix (key) AD_PREFIX2CHAR4AD_PREFIX
NAME1_TEXTFull Name BU_NAME1TXCHAR80TEXT80
NICKNAMENickname of Business Partner (Person) BU_NICKNAMCHAR40BU_NAME
INITIALS'Middle Initial' or personal initials AD_INITSCHAR10CHAR10
NAMEFORMATName format AD_FORMATCHAR2AD_NAMFORM
NAMCOUNTRYCountry for name format rule AD_NAMCTRYCHAR3LAND1
LANGU_CORRBusiness Partner: Correspondence Language BU_LANGU_CORRLANG1ISOLASPRAS
XSEXMSelection: Business partner is male BU_XSEXMCHAR1XFELD
XSEXFSelection: Business partner is female BU_XSEXFCHAR1XFELD
BIRTHPLBirthplace of business partner BU_BIRTHPLCHAR40TEXT40
MARSTMarital Status of Business Partner BU_MARSTCHAR1BU_MARST
EMPLOName of Employer of a Natural Person BU_EMPLOCHAR35BU_EMPLO
JOBGROccupation/group BU_JOBGRCHAR4BU_JOBGR
NATIONationality BU_NATIOCHAR3LAND1
CNTAXObsolete Field BU_CNTAXCHAR3LAND1
CNDSCCtry of Origin: Non-Res. Companies BU_CNDSCCHAR3LAND1
PERSNUMBERPerson number AD_PERSNUMCHAR10ALPHAAD_PERSNUMCDTADDRESS
XSEXUSelection: Sex of business partner is not known BU_XSEXUCHAR1XFELD
XUBNAMEObsolete Field BU_XUBNAMECHAR12XUBNAME
BU_LANGUBusiness partner: Language BU_LANGULANG1ISOLASPRAS
BIRTHDTDate of Birth of Business Partner BU_BIRTHDTDATS8DATUM
DEATHDTDate of death of business partner BU_DEATHDTDATS8DATUM
PERNOPersonnel Number BU_PERNONUMC8PERSONID
CHILDRENObsolete Field BU_CHILDRENNUMC2NUMC2
MEM_HOUSEObsolete Field BU_MEM_HOUSEDEC2DEC2
PARTGRPTYPGroup type BU_GRPTYPCHAR4BU_GRPTYPH_TB025
NAME_GRP1Name 1 (group) BU_NAMEGR1CHAR40BU_NAME
NAME_GRP2Name 2 (group) BU_NAMEGR2CHAR40BU_NAME
MC_NAME1Search Help Field 1 (Name 1/Last Name) BU_MCNAME1CHAR35CHAR35
MC_NAME2Search Help Field 2 (Name 2/First Name) BU_MCNAME2CHAR35CHAR35
CRUSRUser who created the object BU_CRUSRCHAR12USNAM
CRDATDate on which the object was created BU_CRDATDATS8DATUM
CRTIMTime at which the object was created BU_CRTIMTIMS6UZEIT
CHUSRLast user to change object BU_CHUSRCHAR12USNAM
CHDATDate when object was last changed BU_CHDATDATS8DATUM
CHTIMTime at which object was last changed BU_CHTIMTIMS6UZEIT
PARTNER_GUIDBusiness Partner GUID BU_PARTNER_GUIDRAW16SYSUUID
ADDRCOMMAddress Number BU_ADDRCOMMCHAR10ALPHAAD_ADDRNUMADR
TD_SWITCHPlanned Change Documents for Partner Were Converted BU_TD_SWITCHCHAR1CHAR1
IS_ORG_CENTREIndicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRECHAR1BU_IS_ORG_CENTRE
DB_KEYUUID in X form (binary) SYSUUID_XRAW16SYSUUID
VALID_FROMValidity Start BUT000 BP Data BU_BP_VALID_FROMDEC15TZNTSTMPS
VALID_TOValidity End BUT000 BP Data BU_BP_VALID_TODEC15TZNTSTMPS
XPCPTBusiness Purpose Completed Flag BU_XPCPTCHAR1BU_XPCPT
.INCLU--AP 0
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
.INCLU--AP 0
PAR_RELBusiness Partner Released BP_PAR_RELCHAR1BP_PAR_REL
BP_SORTSort Field for Phonetic Search; Obsolete BP_SORT_PHCHAR20CHAR20
.INCLU--AP 0
KBANKSBank country key BANKSCHAR3LAND1BKL
KBANKLBank Keys BANKKCHAR15BANKKBNK
.INCLU--AP 0
T_OP_ITEM_C 0
T_AUG_ITEM_C 0

Key field Non-key field



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

As ISCD_BROK_ACCT_STR_CUS_DATA 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 ISCD_BROK_ACCT_STR_CUS_DATA as there is no data to select.

How to access SAP table ISCD_BROK_ACCT_STR_CUS_DATA

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

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