ISM_CA_SEC_DEP_STR_SECURITY SAP (Security Deposit) Structure details

Dictionary Type: Structure
Description: Security Deposit




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




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

ISM_CA_SEC_DEP_STR_SECURITY 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 "Security Deposit" 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_ISM_CA_SEC_DEP_STR_SECURITY TYPE ISM_CA_SEC_DEP_STR_SECURITY.

The ISM_CA_SEC_DEP_STR_SECURITY table consists of various fields, each holding specific information or linking keys about Security Deposit data available in SAP. These include MANDT (Client), SECURITY (Security Deposit), APPLK (Application area), NON_CASH (Choose: noncash security deposit).. 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 (Deep)


SAP ISM_CA_SEC_DEP_STR_SECURITY 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
WA_SECURITY 0
MANDTClient MANDTCLNT3MANDT
SECURITYSecurity Deposit SECURITY_KKCHAR12ALPHASECURITY_KKSECURITY
APPLKApplication area APPLK_KKCHAR1APPLK_KK
NON_CASHChoose: noncash security deposit NON_CASH_KKCHAR1XFELD
REASONReason for Requesting a Security Deposit REASON_KKCHAR4REASON_KK
VKONTContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
SEC_STARTStart date for security deposit SEC_START_KKDATS8DATUM
SEC_RETURNReturn date for security deposit SEC_RETURN_KKDATS8DATUM
WAERSCurrency Key WAERSCUKY5WAERSFWS
OPBELNumber of Contract Accts Rec. & Payable Doc. OPBEL_KKCHAR12ALPHAOPBEL_KK80B
REV_REASONReversal reason for security deposit REV_REASON_KKCHAR4REV_REASON_KK
NRZASPayment Form Number NRZAS_KKCHAR12ALPHANRZAS_KK
OBJTYPEObject Type SWO_OBJTYPCHAR10OJ_NAMEOBJ
OBJKEYObject Key for Cash Securities SEC_OBJTYP_KKCHAR70SWO_TYPEID
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATChanged On AEDATDATS8DATUM
AENAMName of Person Who Changed Object AENAMCHAR12USNAM
BRGRUAuthorization Group BRGRUCHAR4BRGRU
IKEYInterest Key IKEY_KKCHAR2IKEY_KK
X_SEC_REVSecurity Deposit Reversed X_SEC_REV_KKCHAR1XFELD
X_SEC_RELSecurity Deposits Released X_SEC_REL_KKCHAR1XFELD
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
EXT_REF_NOExternal Reference Number of Security Deposit SEC_XRFNR_KKCHAR20CHAR20
VTREFReference Specifications from Contract VTREF_KKCHAR20ALPHAVTREF_KKVTZ
REQUESTRequested Amount for Security Deposit REQUEST_KKCURR11(2) WERT6
C_STATUSCash security deposit status C_STATUS_KKNUMC2C_STATUS_KK
NC_STATUSNoncash security deposit status NC_STATUS_KKNUMC2NC_STATUS_KK
TYPNoncash security deposit category TYP_KKCHAR4ALPHATYP_KK
REFNOReference number for non-cash security deposit REFNO_KKCHAR40CHAR40
GPART_GUARANTORGuarantor of a noncash security deposit GPART_GUARANTOR_KKCHAR10ALPHABU_PARTNER
XBUPPIndicator: Guarantor is a Private Person XBUPP_KKCHAR1XFELD
VKONT_GUARANTORContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
SEC_EXPIREExpiration date of noncash security deposit SEC_EXPIRE_KKDATS8DATUM
TOTALTotal amount TOTAL_KKCURR11(2) WERT6
V_SECURITYSecurity Deposit SECURITY_KKCHAR12ALPHASECURITY_KKSECURITY
CASHChoose: cash security deposit CASH_KKCHAR1XFELD
PAIDCash security deposit payment PAID_KKCURR11(2) WERT6
SEC_INTERESTCash Security Deposit Interest SEC_INTEREST_KKCURR11(2) WERT6
GPARTBusiness Partner Number GPART_KKCHAR10ALPHABU_PARTNERBPA
TEXT1GPText for business partner TEXT1GP_KKCHAR132TEXT132
VKBEZContract account name VKBEZ_KKCHAR35TEXT35
VBEZText, length 40 TXT40CHAR40TEXT40
VKBEZ_GUARANTORContract account name VKBEZ_KKCHAR35TEXT35
TEXT1GP_GUARANTORText for business partner TEXT1GP_KKCHAR132TEXT132
APPLK_TXTText, length 40 TXT40CHAR40TEXT40
STATUS_TXTText, length 40 TXT40CHAR40TEXT40
REASON_TXTText, length 40 TXT40CHAR40TEXT40
REV_REASON_TXTText, length 40 TXT40CHAR40TEXT40
TYP_TXTText, length 40 TXT40CHAR40TEXT40
OJ_STEXTName OJ_STEXTCHAR20TEXT20
SWL_SHTEXTObject Name SWL_SHTEXTCHAR50TEXT50
SEC_MONTHValidity Period for Security Deposits in Months SEC_MONTH_KKNUMC2MONAT
MAX_BONITMax. creditworthiness for refunding a security MAX_BONIT_KKNUMC4BONIT_KK
XEVENTTrigger Event XEVENT_KKCHAR1CHAR1
RELEASEDReleased Part of Cash Security Deposit REL_PART_KKCURR11(2) WERT6
PYMETPayment Method PYMET_KKCHAR1PYMET_KK
TO_RELEASEPart of Cash Security Deposit to be Released TO_RELEASE_KKCURR11(2) WERT6
PWAERSPayment currency PWAERS_KKCUKY5WAERS
FWAERSPayment currency PWAERS_KKCUKY5WAERS
IWAERSPayment currency PWAERS_KKCUKY5WAERS
TWAERSPayment currency PWAERS_KKCUKY5WAERS
SEC_TAXESTaxes on Cash Security Deposits SEC_TAX_KKCURR11(2) WERT6
SEC_PAID_TAXESTaxes Paid on Cash Security Deposit SEC_PAID_TAX_KKCURR11(2) WERT6
TXWAERSTransaction Currency BLWAE_KKCUKY5WAERSFWS
SEC_NBETRWCash Security Deposit: Requested Amount Net SEC_NBETRW_KKCURR11(2) WERT6
NBTWWAERSTransaction Currency BLWAE_KKCUKY5WAERSFWS
REVERSEDDisplay Reversed Security Deposits REVSEC_KKCHAR1XFELD
TXT1GPText for business partner TEXT1GP_KKCHAR132TEXT132
S_STATUS_SStatus of Cash/Non-Cash Security Deposit S_STATUS_KK_SNUMC2NUM2
S_STATUS_TEXTDescription of Status of Cash/Non-Cash Security Deposit S_STATUS_TEXT_KK_CHAR40CHAR40
XARCHArchived Data Is Allowed XARCD_KKCHAR1XFELD
WA_CONT_ACCT 0
MANDTClient MANDTCLNT3MANDT
VKONTContract Account Number VKONT_KKCHAR12ALPHAVKONT_KKKTOFKKVKP_F4
GPARTBusiness Partner Number GPART_KKCHAR10ALPHABU_PARTNERBPA
VKBEZContract account name VKBEZ_KKCHAR35TEXT35
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
AEDATPChanged On AEDATDATS8DATUM
AENAMPName of Person Who Changed Object AENAMCHAR12USNAM
FDZTGAdditional Days for Cash Management FDZTG_KKNUMC2NUM2
STOPDProcessing lock until STOPD_KKDATS8STOPD_KK
QSZDTValidity Date for Withholding Tax Exemption Certificate QSZDTDATS8DATUM
GUIDBusiness Agreement GUID BUAG_GUIDRAW16SYSUUID
DDLAMDirect Debit Limit DDLAM_KKCURR13(2) WRTV7
DDLCUCurrency of Direct Debit Limit DDLCU_KKCUKY5WAERS
DDLNMNumber of Months for Calculation of Direct Debit Limit DDLNM_KKNUMC2NUM02
INV_CYCLE_STARTStart Date of Billing Cycle in Contract Account CYCLE_STARTDATE_KKDATS8DATS
INV_CHGDISC_XInt: Charges and Discounts Exist for BP-CrtAcct Relations CHGDISC_X_KKCHAR1XFELD
BPL_XPOCLBusiness Partner Lock for Postings/Clearing BPL_XPOCL_KKCHAR1BPL_XPOCL_KK
BPL_FDATELock valid from FDATE_KKDATS8DATUM
BPL_TDATELock valid to TDATE_KKDATS8DATUM
EXVKOReference number for business partner EXVKO_KKCHAR25CHAR25
OPBUKCompany Code Group OPBUK_KKCHAR4OPBUK_KKOPBUK
STDBKStandard Company Code STDBK_KKCHAR4BUKRS
ABWREAlternative Payer ABWRE_KKCHAR10ALPHABU_PARTNERBUPA
ABWRAAlternative Payee ABWRA_KKCHAR10ALPHABU_PARTNERBUPA
ABWMAAlternative dunning recipient ABWMA_KKCHAR10ALPHABU_PARTNERBUPA
EBVTYBank Details ID for Incoming Payments EBVTY_KKCHAR4CHAR4
ABVTYBank Details ID for Outgoing Payments ABVTY_KKCHAR4CHAR4
EZAWEIncoming Payment Method EZAWE_KKCHAR1CHAR1
EZASPLock Reason for Incoming Payments EZASP_OLD_KKCHAR1SPZAH_KK
AZAWEOutgoing Payment Methods AZAWE_KKCHAR5CHAR5
AZASPLock Reason for Outgoing Payments AZASP_OLD_KKCHAR1SPZAH_KK
EIGBVOwn Bank Details EIGBV_KKCHAR25EIGBV_KK
VWNZACreate Where-Used List For Line Items VWNZA_KKCHAR1VWNZA_KK
LOEVMMark Contract Account for Deletion LOEVM_KKCHAR1LOEVM_KK
ABWVKAlternative contract account for collective bills ABWVK_KKCHAR12ALPHAVKONT_KK
IKEYInterest Key IKEY_KKCHAR2IKEY_KK
MAHNVDunning Procedure MAHNV_KKCHAR2MAHNV_KKFKK_MAHNV
MANSPDunning Lock Reason MANSP_OLD_KKCHAR1MANSP_KK
MGRUPGrouping fur Dunning Notices MGRUP_KKCHAR2MGRUP_KK
FDGRPPlanning Group FDGRP_KKCHAR10ALPHAFDGRPFFG
VKPBZRelationship of Business Partner to Contract Account VKPBZ_KKCHAR2VKPBZ_KK
ADRNBAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
VKONVContract account used for payment transactions VKONV_KKCHAR12ALPHAVKONT_KK
GPARVBusiness Partner Acting as Payer in Payment Transactions GPARV_KKCHAR10ALPHABU_PARTNER
ADRREAddress Number for Alternative Payer ADRRE_KKCHAR10ALPHAAD_ADDRNUM
ADRRAAddress Number for Alternative Payee ADRRA_KKCHAR10ALPHAAD_ADDRNUM
ADRMAAddress number for alternative dunning notice recipient ADRMA_KKCHAR10ALPHAAD_ADDRNUM
ABWRHAlternative Invoice Recipient ABWRH_KKCHAR10ALPHABU_PARTNERBUPA
ADRRHAddress number for alternative bill recipient ADRRH_KKCHAR10ALPHAAD_ADDRNUM
ADRJDCAddress Number for Jurisdiction Code Address ADRJDC_KKCHAR10ALPHAAD_ADDRNUM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
TOGRUTolerance group for contract account TOGRU_KKCHAR4TOGRU_KK
STOPGReason for Processing Lock STOPG_KKCHAR1STOPG_KK
TXJCDJurisdiction for Tax Calculation - Tax Jurisdiction Code TXJCD_NOCD_KKCHAR15TXJCDTXJ
COPRCCorrespondence Variant COPRC_KKCHAR4COPRC_KK
VBUNDCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
CCARD_IDPayment Card ID for Incoming Payments CCID_IN_KKCHAR6CHAR6
CCARD_OUTPayment Card ID for Outgoing Payments CCID_OUT_KKCHAR6CHAR6
UEBTRItems Transferred To Another Account XUEBTR_KKCHAR1XFELD
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
QSSKZ_AWitholding Tax Code For Outgoing Payments QSSKZ_A_KKCHAR2QSSKZ
QSSKZ_EWithholding Tax Code For Incoming Payments QSSKZ_E_KKCHAR2QSSKZ
QSZNRCertificate Number of the Withholding Tax Exemption QSZNRCHAR10CHAR10
CORR_MAHNVCorrespondence Dunning Procedure CORR_MAHNV_KKCHAR2MAHNV_KK
FITYPTax type J_1AFITP_DCHAR2J_1AFITP
PROVINCESTATE (State, Province, County) REGIOCHAR3REGIO
COUNTYCounty Code COUNCCHAR3COUNC
VERTYPClearing Category For Clearing Postings VERTYP_KKCHAR4VERTYP_KK
AUGRS_DEFClearing Restriction AUGRS_DEF_KKCHAR1AUGRS_DEF_KK
LANDLCountry Supplied (for Tax Notifications) LANDL_KKCHAR3LAND1
BUPLABusiness Place BUPLACHAR4J_1BBRANCH
BPTAXTYPE1Tax Number Type 1 for Business Partner BPTAXTYPE1CHAR4BPTAXTYPE
BPTAXTYPE2Tax Number type 2 for Business Partner BPTAXTYPE2CHAR4BPTAXTYPE
PERSRClerk Responsible PERSR_KKCHAR10ALPHABU_PARTNERBUPA
INV_CATEGORYInvoicing Category INV_CATEGORY_KKCHAR4INV_CATEGORY_KK
DDLXGRolling Calculation of Direct Debit Limit DDLXG_KKCHAR1XFELD
CMGRPCollection Management: Master Data Group CMGRP_CM_KKCHAR2CMGRP_CM_KK
STRATCollection Strategy STRAT_CM_KKCHAR2STRAT_CM_KK
CPERSCollections Contact Person CPERS_CM_KKCHAR10ALPHABU_PARTNERBPA
BPCL_SUCCDuplicate Processing: Predecessor/Successor Business Partner BPCL_SUCC_KKCHAR1BPCL_SUCC_KK
INV_SCHEDULESelection Characteristic for Scheduling INV_SCHEDULE_KKCHAR4INV_SCHEDULE_KK
INV_CYCLEBilling Cycle CYCLE_KKCHAR4CYCLE_KK
INV_CYCLE_RULEField Is Not Used - CHAR4 CYCLE_RULE_KKCHAR4
INV_CYCLE_DAYDay of Period End CYCLE_DAY_KKCHAR2CYCLE_DAY_KK
INV_CYCLE_MONTHField Is Not Used - CHAR2 NOT_USED_CHAR2_KKCHAR2
MNDIDUnique Referene to Mandate per Payment Recipient SEPA_MNDIDCHAR35ID035
APPLKApplication area APPLK_KKCHAR1APPLK_KK
VKTYPContract Account Category VKTYP_KKCHAR2VKTYP_KKKTP
VKONAContract account number in legacy system VKONA_KKCHAR20CHAR20
WA_BUS_PART 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
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
LGTYPLegitimation Type BU_LGTYPCHAR4BU_LGTYP
LGNUMIdentification number of legitimation document BU_LGNUMCHAR16BU_LGNUM
INFCTResponsible local court BU_INFCTCHAR30BU_INFCT
COMRGEntry in commercial register BU_COMRGCHAR30CHAR30
CLBRGBP: Entry in register of associations BU_CLBRGCHAR30CHAR30
COPRGEntry in Register of Cooperatives BU_COPRGCHAR30CHAR30
COMREG_DATDate of entry in trade register BU_COMREG_DATDATS8DATUM
.INCLU--AP 0
M_BONIWERTCreditworthiness value set manually BONIWRT_KKNUMC4BONIT_KK
M_BONIDATDate on Which Creditworthiness was Manually Set BONIDAT_KKDATS8DATUM
NAME1Name field 1 (name1/last name) BU_NAME1CHAR40BU_NAME
NAME2Name field 2 (name2/first name) BU_NAME2CHAR40BU_NAME
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company 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
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(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
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
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
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
NATPERSBusiness Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSONCHAR1BU_NATURAL_PERSON
WA_BP_ADDRESS 0
PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
ADDRNUMBERAddress number AD_ADDRNUMCHAR10ALPHAAD_ADDRNUMADR
XDFADRIndicator: Address is standard address BU_XDFADRCHAR1XFELD
ADEXTAddress number in external system BU_ADEXTCHAR20BU_ADEXT
NATIONVersion ID for International Addresses AD_NATIONCHAR1AD_NATIONADDRESS_NATION
GUIDUUID in character form SYSUUID_CCHAR32SYSUUID_C
MOVE_ADDRNumber of Move Target Address for Address Moves BU_MOVE_ADDRCHAR10ALPHAAD_ADDRNUMADR
DATE_FROMDate Obsolete BU_DATE_OBSOLETEDATS8DATUM
ADDRESS_GUIDGUID of a Business Partner Address BU_ADDRESS_GUIDRAW16SYSUUID
ADDR_VALID_FROMValidity Start of a Business Partner Address BU_ADDR_VALID_FROMDEC15TZNTSTMPS
ADDR_VALID_TOValidity End of a Business Partner Address BU_ADDR_VALID_TODEC15TZNTSTMPS
ADDR_MOVE_DATEDate of Move for Address Moves BU_ADDR_MOVE_DATEDEC15TZNTSTMPS
NAME_COc/o name AD_NAME_COCHAR40TEXT40
CITY1City AD_CITY1CHAR40TEXT40CLCITYNAME
CITY2District AD_CITY2CHAR40TEXT40CITY_PART
CITY_CODECity code for city/street file AD_CITYNUMCHAR12ALPHACITY_CODE
CITYP_CODEDistrict code for City and Street file AD_CITYPNMCHAR8ALPHACITYP_CODE
HOME_CITYCity (different from postal city) AD_CITY3CHAR40TEXT40
CITYH_CODEDifferent city for city/street file AD_CITYHNMCHAR12ALPHACITY_CODE
CHCKSTATUSCity file test status AD_CHECKSTCHAR1AD_CHECKST
REGIOGROUPRegional structure grouping REGIOGROUPCHAR8REGIOGROUP
POST_CODE1City postal code AD_PSTCD1CHAR10CHAR10
POST_CODE2PO Box Postal Code AD_PSTCD2CHAR10CHAR10
POST_CODE3Company 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
DONT_USE_PPO Box Address Undeliverable Flag AD_NO_USEPCHAR4AD_NO_USE
PO_BOX_NUMFlag: PO Box Without Number AD_POBXNUMCHAR1XFELD
PO_BOX_LOCPO Box city AD_POBXLOCCHAR40TEXT40CITY_NAME
CITY_CODE2City PO box code (City file) AD_CIT2NUMCHAR12ALPHACITY_CODE
PO_BOX_REGRegion for PO Box (Country, State, Province, ...) AD_POBXREGCHAR3REGIO
PO_BOX_CTYPO box country AD_POBXCTYCHAR3LAND1
POSTALAREA(Not Supported) Post Delivery District AD_PSTLARCHAR15TEXT15
TRANSPZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
DONT_USE_SStreet Address Undeliverable Flag AD_NO_USESCHAR4AD_NO_USE
STREETCODEStreet Number for City/Street File AD_STRNUMCHAR12ALPHASTRT_CODE
STREETABBR(Not Supported) Abbreviation of Street Name AD_STRABBRCHAR2STRTYPEAB
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
HOUSE_NUM3(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
ROOMNUMBERRoom or Appartment Number AD_ROOMNUMCHAR10TEXT10
COUNTRYCountry Key LAND1CHAR3LAND1LND
LANGULanguage Key SPRASLANG1ISOLASPRASSPRH_T002
REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
SORT1Search Term 1 AD_SORT1ULCHAR20TEXT20
SORT2Search Term 2 AD_SORT2ULCHAR20TEXT20
SORT_PHN(Not Supported) Phonetic Search Sort Field AD_SRTPHNCHAR20CHAR20
ADDRORIGIN(Not Supported) Address Data Source (Key) AD_ORIGINACHAR4AD_ORIGIN
EXTENSION1Extension (only for data conversion) (e.g. data line) AD_EXTENS1CHAR40TEXT40
EXTENSION2Extension (only for data conversion) (e.g. telebox) AD_EXTENS2CHAR40TEXT40
TIME_ZONEAddress time zone AD_TZONECHAR6TZNZONE
TAXJURCODETax Jurisdiction AD_TXJCDCHAR15AD_TXJCDTXJ
ADDRESS_ID(Not supported) Physical address ID AD_ADDR_IDCHAR10ALPHAAD_ADDR_ID
REMARKAddress notes AD_REMARK1CHAR50TEXT50
LANGU_CREAAddress record creation original language AD_LANGUCRLANG1ISOLASPRAS
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
COUNTY_CODECounty code for county AD_CNTYNUMCHAR8ALPHACNTY_CODE
COUNTYCounty AD_COUNTYCHAR40TEXT40CLTCNTYNAME
TOWNSHIP_CODETownship code for Township AD_TWSHPNUMCHAR8ALPHATWSHP_CODE
TOWNSHIPTownship AD_TOWNSHIPCHAR40TEXT40CLTWSHPNAME
DEFLT_COMMStandard communication type AD_DFLTCMMCHAR3AD_COMTYPE
TEL_NUMBERTelephone no.: dialling code+number AD_TLNMBRCHAR30CHAR30
TEL_EXTENSTelephone no.: Extension AD_TLXTNSCHAR10CHAR10
FAX_NUMBERFax number: dialling code+number AD_FXNMBRCHAR30CHAR30
FAX_EXTENSFax no.: Extension AD_FXXTNSCHAR10CHAR10
VALID_FROMValid From BU_VALID_FROM_DATSDATS8DATUM
VALID_TOValid To BU_VALID_TO_DATSDATS8DATUM
WA_PAYMO 0
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
ZLSCHForm ID for Attached Payment Medium FIDZTCHAR1FIDZT
NACHATransmission Medium for Correspondence FI_NACHACHAR1FI_NACHA
APPLKApplication Indicator APPLK_BFCHAR6APPLK_BF
ZANRETitle of the payee DZANRECHAR15TEXT15
ZNME1Name of the payee DZNME1CHAR35TEXT35
ZNME2Name of the payee DZNME1CHAR35TEXT35
ZNME3Name of the payee DZNME1CHAR35TEXT35
ZNME4Name of the payee DZNME1CHAR35TEXT35
ZPSTLPostal code of the payee DZPSTLCHAR10PSTLZ
ZORT1City of the payee DZORT1CHAR35TEXT35
ZORT2Location from payee's address ORT02_ZCHAR35TEXT35
ZSTRAStreet and house number of the payee DZSTRACHAR35TEXT35
ZPST2P.O. box postal code of the payee DZPST2CHAR10PSTLZ
ZPFACP.O. box of the payee DZPFACCHAR10PFACH
ZPFORCity of payee's PO box PFORT_ZCHAR35TEXT35
ZLANDCountry Key DZLANDCHAR3LAND1LND
ZREGIRegional code of the payee DZREGICHAR3REGIO
ZSPRALanguage key of the payee DZSPRALANG1ISOLASPRAS
ZPLORPostal Code/City of the Payee's Display Field DZPLORCHAR46TEXT46
ZLNDXName of the Payee's Country DZLNDXCHAR15TEXT15
ZREGXRegion REGIXCHAR20TEXT20
ZNAMEShort Name of Payee NAMEZCHAR50TEXT50
KUNIDCustomer ID Number KUNID_49ECHAR15CHAR15
ESRNRISR Subscriber Number ESRNRCHAR11ESRNR
EMPZ1Payee on Form EMPZXCHAR30TEXT30
EMPZ2Payee on Form EMPZXCHAR30TEXT30
EMPZ3Payee on Form EMPZXCHAR30TEXT30
EMPZ4Payee on Form EMPZXCHAR30TEXT30
ZBNKSCountry Key DZBNKSCHAR3LAND1LND
ZBNKNBank account number of the payee DZBNKNCHAR18BANKN
ZBNKLBank number of the payee's bank DZBNKLCHAR15BANKL
ZBKONBank Control Key of the Payee's Bank DZBKONCHAR2BKONT
ZBNKYBank key of the payee's bank DZBNKYCHAR15BANKK
ZBNKAName of the Payee's Bank DZBNKACHAR60TEXT60
ZBSTRStreet of the Payee's Bank DZBSTRCHAR35TEXT35
ZBORTCity of the Payee's Bank DZBORTCHAR35TEXT35
ZBANKPayee Bank (Name and City) EBANKCHAR100TEXT100
ZBRCHBank Branch BRNCHCHAR40TEXT40
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
PSTLZPostal Code PSTLZCHAR10PSTLZ
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_GPCHAR35TEXT35
STRASHouse number and street STRAS_GPCHAR35TEXT35
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
PFACHPO Box PFACHCHAR10PFACH
PFORTPO Box city PFORT_GPCHAR35TEXT35
LAND1Country Key LAND1CHAR3LAND1LND
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
PLORTPostal code/city display field PLORTCHAR46TEXT46
LANDXCountry Name LANDXCHAR15TEXT15
REGIXRegion REGIXCHAR20TEXT20
WAERSCurrency Key WAERSCUKY5WAERSFWS
HWAERLocal Currency HWAERCUKY5WAERS
SHKZGDebit/Credit Indicator SHKZGCHAR1SHKZG
RBBTRGross Amount in Local Currency RBBTR_FICURR13(2) WRTV7
RSKONTotal Cash Discount for the Payment Trans. (Local Currency) RSKONCURR13(2) WRTV7
RBETRAmount in Local Currency RBETRCURR13(2) WRTV7
RWBBTGross Amount in the Payment Currency RWBBT_FICURR13(2) WRTV7
RWSKTTotal Cash Discount for the Pmnt Transactn in Pmnt Currency RWSKTCURR13(2) WRTV7
RWBTRAmount Paid in the Payment Currency RWBTRCURR13(2) WRTV7
ZWCK1Reason for payment DZWECK_015CHAR70TXT70
ZWCK2Reason for payment DZWECK_015CHAR70TXT70
VORIDTransaction ID VORIDCHAR4VORID
NUMBERWhole digits of the amount converted IN_NUMBERSNUMC15NUMC15
DECIMALDecimal places of the amount converted IN_DECINUMC3NUMC03
CURRDECNumber of decimal places CURRDECINT13CURRDEC
WORDAmount in words IN_WORDSCHAR255CHAR255
DECWORDDecimal places in words DECWORDCHAR128CHAR128
DIG01Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG02Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG03Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG04Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG05Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG06Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG07Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG08Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG09Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG10Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG11Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG12Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG13Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG14Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
DIG15Figure in words (units, tens, ...) DZWORTCHAR7TEXT7
KTEXTShort Text KTEXT_048WCHAR20TEXT20
LTEXTLong Text LTEXT_048WCHAR40TEXT40
OZWCKReference for OCRA Line OZWCKNUMC13NUMC13
OZBKTAccount Number of Customer/Vendor for OCRA Line OZBKTNUMC18NUM18
OZBKLBank Number of Customer/Vendor Bank for OCRA Line OZBKLNUMC15NUMC15
SOCRATotal for the OCRA Lines (OCRA/OCRB) SOCRANUMC11NUMC11
MBETRAmount field for ISR MBETRCHAR13CHAR13
MREFNReference number on the payment order MREFNCHAR27CHAR27
MKODZISR coding line MKODZCHAR53CHAR53
CODNLCode Line for Dutch Bank Transfer CODNLCHAR65TEXT65
SWIFTSWIFT/BIC for International Payments SWIFTCHAR11SWIFT
IBANIBAN (International Bank Account Number) IBANCHAR34IBAN
T_ITEMS 0

Key field Non-key field



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

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

How to access SAP table ISM_CA_SEC_DEP_STR_SECURITY

Within an ECC or HANA version of SAP you can also view further information about ISM_CA_SEC_DEP_STR_SECURITY 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!