ISM_CA_SEC_DEP_STR_SECURITY SAP (Security Deposit) Structure details
Description: Security Deposit
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 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
SECURITY | Security Deposit | SECURITY_KK | CHAR | 12 | ALPHA | SECURITY_KK | SECURITY | ||
APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
NON_CASH | Choose: noncash security deposit | NON_CASH_KK | CHAR | 1 | XFELD | ||||
REASON | Reason for Requesting a Security Deposit | REASON_KK | CHAR | 4 | REASON_KK | ||||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
SEC_START | Start date for security deposit | SEC_START_KK | DATS | 8 | DATUM | ||||
SEC_RETURN | Return date for security deposit | SEC_RETURN_KK | DATS | 8 | DATUM | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
OPBEL | Number of Contract Accts Rec. & Payable Doc. | OPBEL_KK | CHAR | 12 | ALPHA | OPBEL_KK | 80B | ||
REV_REASON | Reversal reason for security deposit | REV_REASON_KK | CHAR | 4 | REV_REASON_KK | ||||
NRZAS | Payment Form Number | NRZAS_KK | CHAR | 12 | ALPHA | NRZAS_KK | |||
OBJTYPE | Object Type | SWO_OBJTYP | CHAR | 10 | OJ_NAME | OBJ | |||
OBJKEY | Object Key for Cash Securities | SEC_OBJTYP_KK | CHAR | 70 | SWO_TYPEID | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDAT | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
BRGRU | Authorization Group | BRGRU | CHAR | 4 | BRGRU | ||||
IKEY | Interest Key | IKEY_KK | CHAR | 2 | IKEY_KK | ||||
X_SEC_REV | Security Deposit Reversed | X_SEC_REV_KK | CHAR | 1 | XFELD | ||||
X_SEC_REL | Security Deposits Released | X_SEC_REL_KK | CHAR | 1 | XFELD | ||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
EXT_REF_NO | External Reference Number of Security Deposit | SEC_XRFNR_KK | CHAR | 20 | CHAR20 | ||||
VTREF | Reference Specifications from Contract | VTREF_KK | CHAR | 20 | ALPHA | VTREF_KK | VTZ | ||
REQUEST | Requested Amount for Security Deposit | REQUEST_KK | CURR | 11(2) | WERT6 | ||||
C_STATUS | Cash security deposit status | C_STATUS_KK | NUMC | 2 | C_STATUS_KK | ||||
NC_STATUS | Noncash security deposit status | NC_STATUS_KK | NUMC | 2 | NC_STATUS_KK | ||||
TYP | Noncash security deposit category | TYP_KK | CHAR | 4 | ALPHA | TYP_KK | |||
REFNO | Reference number for non-cash security deposit | REFNO_KK | CHAR | 40 | CHAR40 | ||||
GPART_GUARANTOR | Guarantor of a noncash security deposit | GPART_GUARANTOR_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
XBUPP | Indicator: Guarantor is a Private Person | XBUPP_KK | CHAR | 1 | XFELD | ||||
VKONT_GUARANTOR | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
SEC_EXPIRE | Expiration date of noncash security deposit | SEC_EXPIRE_KK | DATS | 8 | DATUM | ||||
TOTAL | Total amount | TOTAL_KK | CURR | 11(2) | WERT6 | ||||
V_SECURITY | Security Deposit | SECURITY_KK | CHAR | 12 | ALPHA | SECURITY_KK | SECURITY | ||
CASH | Choose: cash security deposit | CASH_KK | CHAR | 1 | XFELD | ||||
PAID | Cash security deposit payment | PAID_KK | CURR | 11(2) | WERT6 | ||||
SEC_INTEREST | Cash Security Deposit Interest | SEC_INTEREST_KK | CURR | 11(2) | WERT6 | ||||
GPART | Business Partner Number | GPART_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
TEXT1GP | Text for business partner | TEXT1GP_KK | CHAR | 132 | TEXT132 | ||||
VKBEZ | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
VBEZ | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
VKBEZ_GUARANTOR | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
TEXT1GP_GUARANTOR | Text for business partner | TEXT1GP_KK | CHAR | 132 | TEXT132 | ||||
APPLK_TXT | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
STATUS_TXT | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
REASON_TXT | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
REV_REASON_TXT | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
TYP_TXT | Text, length 40 | TXT40 | CHAR | 40 | TEXT40 | ||||
OJ_STEXT | Name | OJ_STEXT | CHAR | 20 | TEXT20 | ||||
SWL_SHTEXT | Object Name | SWL_SHTEXT | CHAR | 50 | TEXT50 | ||||
SEC_MONTH | Validity Period for Security Deposits in Months | SEC_MONTH_KK | NUMC | 2 | MONAT | ||||
MAX_BONIT | Max. creditworthiness for refunding a security | MAX_BONIT_KK | NUMC | 4 | BONIT_KK | ||||
XEVENT | Trigger Event | XEVENT_KK | CHAR | 1 | CHAR1 | ||||
RELEASED | Released Part of Cash Security Deposit | REL_PART_KK | CURR | 11(2) | WERT6 | ||||
PYMET | Payment Method | PYMET_KK | CHAR | 1 | PYMET_KK | ||||
TO_RELEASE | Part of Cash Security Deposit to be Released | TO_RELEASE_KK | CURR | 11(2) | WERT6 | ||||
PWAERS | Payment currency | PWAERS_KK | CUKY | 5 | WAERS | ||||
FWAERS | Payment currency | PWAERS_KK | CUKY | 5 | WAERS | ||||
IWAERS | Payment currency | PWAERS_KK | CUKY | 5 | WAERS | ||||
TWAERS | Payment currency | PWAERS_KK | CUKY | 5 | WAERS | ||||
SEC_TAXES | Taxes on Cash Security Deposits | SEC_TAX_KK | CURR | 11(2) | WERT6 | ||||
SEC_PAID_TAXES | Taxes Paid on Cash Security Deposit | SEC_PAID_TAX_KK | CURR | 11(2) | WERT6 | ||||
TXWAERS | Transaction Currency | BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
SEC_NBETRW | Cash Security Deposit: Requested Amount Net | SEC_NBETRW_KK | CURR | 11(2) | WERT6 | ||||
NBTWWAERS | Transaction Currency | BLWAE_KK | CUKY | 5 | WAERS | FWS | |||
REVERSED | Display Reversed Security Deposits | REVSEC_KK | CHAR | 1 | XFELD | ||||
TXT1GP | Text for business partner | TEXT1GP_KK | CHAR | 132 | TEXT132 | ||||
S_STATUS_S | Status of Cash/Non-Cash Security Deposit | S_STATUS_KK_S | NUMC | 2 | NUM2 | ||||
S_STATUS_TEXT | Description of Status of Cash/Non-Cash Security Deposit | S_STATUS_TEXT_KK_ | CHAR | 40 | CHAR40 | ||||
XARCH | Archived Data Is Allowed | XARCD_KK | CHAR | 1 | XFELD | ||||
WA_CONT_ACCT | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
VKONT | Contract Account Number | VKONT_KK | CHAR | 12 | ALPHA | VKONT_KK | KTO | FKKVKP_F4 | |
GPART | Business Partner Number | GPART_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
VKBEZ | Contract account name | VKBEZ_KK | CHAR | 35 | TEXT35 | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
AEDATP | Changed On | AEDAT | DATS | 8 | DATUM | ||||
AENAMP | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
FDZTG | Additional Days for Cash Management | FDZTG_KK | NUMC | 2 | NUM2 | ||||
STOPD | Processing lock until | STOPD_KK | DATS | 8 | STOPD_KK | ||||
QSZDT | Validity Date for Withholding Tax Exemption Certificate | QSZDT | DATS | 8 | DATUM | ||||
GUID | Business Agreement GUID | BUAG_GUID | RAW | 16 | SYSUUID | ||||
DDLAM | Direct Debit Limit | DDLAM_KK | CURR | 13(2) | WRTV7 | ||||
DDLCU | Currency of Direct Debit Limit | DDLCU_KK | CUKY | 5 | WAERS | ||||
DDLNM | Number of Months for Calculation of Direct Debit Limit | DDLNM_KK | NUMC | 2 | NUM02 | ||||
INV_CYCLE_START | Start Date of Billing Cycle in Contract Account | CYCLE_STARTDATE_KK | DATS | 8 | DATS | ||||
INV_CHGDISC_X | Int: Charges and Discounts Exist for BP-CrtAcct Relations | CHGDISC_X_KK | CHAR | 1 | XFELD | ||||
BPL_XPOCL | Business Partner Lock for Postings/Clearing | BPL_XPOCL_KK | CHAR | 1 | BPL_XPOCL_KK | ||||
BPL_FDATE | Lock valid from | FDATE_KK | DATS | 8 | DATUM | ||||
BPL_TDATE | Lock valid to | TDATE_KK | DATS | 8 | DATUM | ||||
EXVKO | Reference number for business partner | EXVKO_KK | CHAR | 25 | CHAR25 | ||||
OPBUK | Company Code Group | OPBUK_KK | CHAR | 4 | OPBUK_KK | OPBUK | |||
STDBK | Standard Company Code | STDBK_KK | CHAR | 4 | BUKRS | ||||
ABWRE | Alternative Payer | ABWRE_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ABWRA | Alternative Payee | ABWRA_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ABWMA | Alternative dunning recipient | ABWMA_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
EBVTY | Bank Details ID for Incoming Payments | EBVTY_KK | CHAR | 4 | CHAR4 | ||||
ABVTY | Bank Details ID for Outgoing Payments | ABVTY_KK | CHAR | 4 | CHAR4 | ||||
EZAWE | Incoming Payment Method | EZAWE_KK | CHAR | 1 | CHAR1 | ||||
EZASP | Lock Reason for Incoming Payments | EZASP_OLD_KK | CHAR | 1 | SPZAH_KK | ||||
AZAWE | Outgoing Payment Methods | AZAWE_KK | CHAR | 5 | CHAR5 | ||||
AZASP | Lock Reason for Outgoing Payments | AZASP_OLD_KK | CHAR | 1 | SPZAH_KK | ||||
EIGBV | Own Bank Details | EIGBV_KK | CHAR | 25 | EIGBV_KK | ||||
VWNZA | Create Where-Used List For Line Items | VWNZA_KK | CHAR | 1 | VWNZA_KK | ||||
LOEVM | Mark Contract Account for Deletion | LOEVM_KK | CHAR | 1 | LOEVM_KK | ||||
ABWVK | Alternative contract account for collective bills | ABWVK_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
IKEY | Interest Key | IKEY_KK | CHAR | 2 | IKEY_KK | ||||
MAHNV | Dunning Procedure | MAHNV_KK | CHAR | 2 | MAHNV_KK | FKK_MAHNV | |||
MANSP | Dunning Lock Reason | MANSP_OLD_KK | CHAR | 1 | MANSP_KK | ||||
MGRUP | Grouping fur Dunning Notices | MGRUP_KK | CHAR | 2 | MGRUP_KK | ||||
FDGRP | Planning Group | FDGRP_KK | CHAR | 10 | ALPHA | FDGRP | FFG | ||
VKPBZ | Relationship of Business Partner to Contract Account | VKPBZ_KK | CHAR | 2 | VKPBZ_KK | ||||
ADRNB | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
VKONV | Contract account used for payment transactions | VKONV_KK | CHAR | 12 | ALPHA | VKONT_KK | |||
GPARV | Business Partner Acting as Payer in Payment Transactions | GPARV_KK | CHAR | 10 | ALPHA | BU_PARTNER | |||
ADRRE | Address Number for Alternative Payer | ADRRE_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRRA | Address Number for Alternative Payee | ADRRA_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRMA | Address number for alternative dunning notice recipient | ADRMA_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ABWRH | Alternative Invoice Recipient | ABWRH_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
ADRRH | Address number for alternative bill recipient | ADRRH_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
ADRJDC | Address Number for Jurisdiction Code Address | ADRJDC_KK | CHAR | 10 | ALPHA | AD_ADDRNUM | |||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
TOGRU | Tolerance group for contract account | TOGRU_KK | CHAR | 4 | TOGRU_KK | ||||
STOPG | Reason for Processing Lock | STOPG_KK | CHAR | 1 | STOPG_KK | ||||
TXJCD | Jurisdiction for Tax Calculation - Tax Jurisdiction Code | TXJCD_NOCD_KK | CHAR | 15 | TXJCD | TXJ | |||
COPRC | Correspondence Variant | COPRC_KK | CHAR | 4 | COPRC_KK | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
CCARD_ID | Payment Card ID for Incoming Payments | CCID_IN_KK | CHAR | 6 | CHAR6 | ||||
CCARD_OUT | Payment Card ID for Outgoing Payments | CCID_OUT_KK | CHAR | 6 | CHAR6 | ||||
UEBTR | Items Transferred To Another Account | XUEBTR_KK | CHAR | 1 | XFELD | ||||
DEF_REC | Alternative Correspondence Recipient for Standard Case | DEF_CORR_PARTNER_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
DEF_REC_IND | FI-CA correspondence - activity key | DEF_CORR_ACKEY_KK | CHAR | 4 | CORR_ACKEY_KK | ||||
QSSKZ_A | Witholding Tax Code For Outgoing Payments | QSSKZ_A_KK | CHAR | 2 | QSSKZ | ||||
QSSKZ_E | Withholding Tax Code For Incoming Payments | QSSKZ_E_KK | CHAR | 2 | QSSKZ | ||||
QSZNR | Certificate Number of the Withholding Tax Exemption | QSZNR | CHAR | 10 | CHAR10 | ||||
CORR_MAHNV | Correspondence Dunning Procedure | CORR_MAHNV_KK | CHAR | 2 | MAHNV_KK | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | ||||
PROVINCE | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
COUNTY | County Code | COUNC | CHAR | 3 | COUNC | ||||
VERTYP | Clearing Category For Clearing Postings | VERTYP_KK | CHAR | 4 | VERTYP_KK | ||||
AUGRS_DEF | Clearing Restriction | AUGRS_DEF_KK | CHAR | 1 | AUGRS_DEF_KK | ||||
LANDL | Country Supplied (for Tax Notifications) | LANDL_KK | CHAR | 3 | LAND1 | ||||
BUPLA | Business Place | BUPLA | CHAR | 4 | J_1BBRANCH | ||||
BPTAXTYPE1 | Tax Number Type 1 for Business Partner | BPTAXTYPE1 | CHAR | 4 | BPTAXTYPE | ||||
BPTAXTYPE2 | Tax Number type 2 for Business Partner | BPTAXTYPE2 | CHAR | 4 | BPTAXTYPE | ||||
PERSR | Clerk Responsible | PERSR_KK | CHAR | 10 | ALPHA | BU_PARTNER | BUPA | ||
INV_CATEGORY | Invoicing Category | INV_CATEGORY_KK | CHAR | 4 | INV_CATEGORY_KK | ||||
DDLXG | Rolling Calculation of Direct Debit Limit | DDLXG_KK | CHAR | 1 | XFELD | ||||
CMGRP | Collection Management: Master Data Group | CMGRP_CM_KK | CHAR | 2 | CMGRP_CM_KK | ||||
STRAT | Collection Strategy | STRAT_CM_KK | CHAR | 2 | STRAT_CM_KK | ||||
CPERS | Collections Contact Person | CPERS_CM_KK | CHAR | 10 | ALPHA | BU_PARTNER | BPA | ||
BPCL_SUCC | Duplicate Processing: Predecessor/Successor Business Partner | BPCL_SUCC_KK | CHAR | 1 | BPCL_SUCC_KK | ||||
INV_SCHEDULE | Selection Characteristic for Scheduling | INV_SCHEDULE_KK | CHAR | 4 | INV_SCHEDULE_KK | ||||
INV_CYCLE | Billing Cycle | CYCLE_KK | CHAR | 4 | CYCLE_KK | ||||
INV_CYCLE_RULE | Field Is Not Used - CHAR4 | CYCLE_RULE_KK | CHAR | 4 | |||||
INV_CYCLE_DAY | Day of Period End | CYCLE_DAY_KK | CHAR | 2 | CYCLE_DAY_KK | ||||
INV_CYCLE_MONTH | Field Is Not Used - CHAR2 | NOT_USED_CHAR2_KK | CHAR | 2 | |||||
MNDID | Unique Referene to Mandate per Payment Recipient | SEPA_MNDID | CHAR | 35 | ID035 | ||||
APPLK | Application area | APPLK_KK | CHAR | 1 | APPLK_KK | ||||
VKTYP | Contract Account Category | VKTYP_KK | CHAR | 2 | VKTYP_KK | KTP | |||
VKONA | Contract account number in legacy system | VKONA_KK | CHAR | 20 | CHAR20 | ||||
WA_BUS_PART | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
TYPE | Business partner category | BU_TYPE | CHAR | 1 | BU_TYPE | BPY | |||
BPKIND | Business Partner Type | BU_BPKIND | CHAR | 4 | BU_KIND | ||||
BU_GROUP | Business Partner Grouping | BU_GROUP | CHAR | 4 | BU_GROUP | BPP | |||
BPEXT | Business Partner Number in External System | BU_BPEXT | CHAR | 20 | CHAR20 | ||||
BU_SORT1 | Search term 1 for business partner | BU_SORT1 | CHAR | 20 | BU_SORT1 | ||||
BU_SORT2 | Search term 2 for business partner | BU_SORT2 | CHAR | 20 | BU_SORT1 | ||||
SOURCE | Data Origin Types | BU_SOURCE | CHAR | 4 | BU_SOURCE | ||||
TITLE | Form-of-Address Key | AD_TITLE | CHAR | 4 | AD_TITLE | ||||
XDELE | Central Archiving Flag | BU_XDELE | CHAR | 1 | XFELD | ||||
XBLCK | Central Block for Business Partner | BU_XBLCK | CHAR | 1 | XFELD | ||||
AUGRP | Authorization Group | BU_AUGRP | CHAR | 4 | BU_AUGRP | ||||
TITLE_LET | Salutation | BU_TITLE_LET | CHAR | 50 | TEXT50 | ||||
BU_LOGSYS | Logical system | LOGSYS | CHAR | 10 | ALPHA | LOGSYS | |||
CONTACT | Business Partner: Contact Permission | BU_CONTACT | CHAR | 1 | BU_CONTACT | ||||
NOT_RELEASED | Indicator: Not Released | BU_XNOT_RELEASED | CHAR | 1 | XFELD | ||||
NOT_LG_COMPETENT | Indicator: Not Legally Competent | BU_NOT_LEG_COMPETENT | CHAR | 1 | BOOLE | ||||
PRINT_MODE | Business Partner Print Format | BU_PRINT_MODE | CHAR | 1 | BU_PRINT_MODE | ||||
BP_EEW_DUMMY | Dummy function in length 1 | DUMMY | CHAR | 1 | DUMMY | ||||
.INCLU--AP | 0 | ||||||||
NAPR | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
BBP_IPISP | Tax Split | BBP_J_1BINDEQU | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
RATE | Cost Rate/Revenue Rate for Project Costing | DPR_TV_RATE | CHAR | 15 | DPR_RATE_TYPE | ||||
NAME_ORG1 | Name 1 of organization | BU_NAMEOR1 | CHAR | 40 | BU_NAME | ||||
NAME_ORG2 | Name 2 of organization | BU_NAMEOR2 | CHAR | 40 | BU_NAME | ||||
NAME_ORG3 | Name 3 of organization | BU_NAMEOR3 | CHAR | 40 | BU_NAME | ||||
NAME_ORG4 | Name 4 of organization | BU_NAMEOR4 | CHAR | 40 | BU_NAME | ||||
LEGAL_ENTY | BP: Legal form of organization | BU_LEGENTY | CHAR | 2 | BU_LEGENTY | H_TB019 | |||
IND_SECTOR | Industry sector | BU_INDSECT | CHAR | 10 | BU_INDSECT | H_TB023 | |||
LEGAL_ORG | Legal Entity of Organization | BU_LEGAL_ORG | CHAR | 2 | BU_LEGAL_ORG | ||||
FOUND_DAT | Date organization founded | BU_FOUND_DAT | DATS | 8 | DATUM | ||||
LIQUID_DAT | Liquidation date of organization | BU_LIQUID_DAT | DATS | 8 | |||||
LOCATION_1 | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
LOCATION_2 | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
LOCATION_3 | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
NAME_LAST | Last name of business partner (person) | BU_NAMEP_L | CHAR | 40 | BU_NAME | ||||
NAME_FIRST | First name of business partner (person) | BU_NAMEP_F | CHAR | 40 | BU_NAME | ||||
NAME_LST2 | Other Last Name of a Person | BU_NAMEPL2 | CHAR | 40 | BU_NAME | ||||
NAME_LAST2 | Name at birth of business partner | BU_BIRTHNM | CHAR | 40 | BU_NAME | ||||
NAMEMIDDLE | Middle name or second forename of a person | BU_NAMEMID | CHAR | 40 | BU_NAME | ||||
TITLE_ACA1 | Academic Title: Key | AD_TITLE1 | CHAR | 4 | AD_TITLE1 | AD_TITLE1 | |||
TITLE_ACA2 | Second academic title (key) | AD_TITLE2 | CHAR | 4 | AD_TITLE1 | ||||
TITLE_ROYL | Name supplement, e.g. noble title (key) | AD_TITLES | CHAR | 4 | AD_TITLES | ||||
PREFIX1 | Name Prefix (Key) | AD_PREFIX | CHAR | 4 | AD_PREFIX | ||||
PREFIX2 | 2nd name prefix (key) | AD_PREFIX2 | CHAR | 4 | AD_PREFIX | ||||
NAME1_TEXT | Full Name | BU_NAME1TX | CHAR | 80 | TEXT80 | ||||
NICKNAME | Nickname of Business Partner (Person) | BU_NICKNAM | CHAR | 40 | BU_NAME | ||||
INITIALS | 'Middle Initial' or personal initials | AD_INITS | CHAR | 10 | CHAR10 | ||||
NAMEFORMAT | Name format | AD_FORMAT | CHAR | 2 | AD_NAMFORM | ||||
NAMCOUNTRY | Country for name format rule | AD_NAMCTRY | CHAR | 3 | LAND1 | ||||
LANGU_CORR | Business Partner: Correspondence Language | BU_LANGU_CORR | LANG | 1 | ISOLA | SPRAS | |||
XSEXM | Selection: Business partner is male | BU_XSEXM | CHAR | 1 | XFELD | ||||
XSEXF | Selection: Business partner is female | BU_XSEXF | CHAR | 1 | XFELD | ||||
BIRTHPL | Birthplace of business partner | BU_BIRTHPL | CHAR | 40 | TEXT40 | ||||
MARST | Marital Status of Business Partner | BU_MARST | CHAR | 1 | BU_MARST | ||||
EMPLO | Name of Employer of a Natural Person | BU_EMPLO | CHAR | 35 | BU_EMPLO | ||||
JOBGR | Occupation/group | BU_JOBGR | CHAR | 4 | BU_JOBGR | ||||
NATIO | Nationality | BU_NATIO | CHAR | 3 | LAND1 | ||||
CNTAX | Obsolete Field | BU_CNTAX | CHAR | 3 | LAND1 | ||||
CNDSC | Ctry of Origin: Non-Res. Companies | BU_CNDSC | CHAR | 3 | LAND1 | ||||
PERSNUMBER | Person number | AD_PERSNUM | CHAR | 10 | ALPHA | AD_PERSNUM | CDT | ADDRESS | |
XSEXU | Selection: Sex of business partner is not known | BU_XSEXU | CHAR | 1 | XFELD | ||||
XUBNAME | Obsolete Field | BU_XUBNAME | CHAR | 12 | XUBNAME | ||||
BU_LANGU | Business partner: Language | BU_LANGU | LANG | 1 | ISOLA | SPRAS | |||
BIRTHDT | Date of Birth of Business Partner | BU_BIRTHDT | DATS | 8 | DATUM | ||||
DEATHDT | Date of death of business partner | BU_DEATHDT | DATS | 8 | DATUM | ||||
PERNO | Personnel Number | BU_PERNO | NUMC | 8 | PERSONID | ||||
CHILDREN | Obsolete Field | BU_CHILDREN | NUMC | 2 | NUMC2 | ||||
MEM_HOUSE | Obsolete Field | BU_MEM_HOUSE | DEC | 2 | DEC2 | ||||
PARTGRPTYP | Group type | BU_GRPTYP | CHAR | 4 | BU_GRPTYP | H_TB025 | |||
NAME_GRP1 | Name 1 (group) | BU_NAMEGR1 | CHAR | 40 | BU_NAME | ||||
NAME_GRP2 | Name 2 (group) | BU_NAMEGR2 | CHAR | 40 | BU_NAME | ||||
LGTYP | Legitimation Type | BU_LGTYP | CHAR | 4 | BU_LGTYP | ||||
LGNUM | Identification number of legitimation document | BU_LGNUM | CHAR | 16 | BU_LGNUM | ||||
INFCT | Responsible local court | BU_INFCT | CHAR | 30 | BU_INFCT | ||||
COMRG | Entry in commercial register | BU_COMRG | CHAR | 30 | CHAR30 | ||||
CLBRG | BP: Entry in register of associations | BU_CLBRG | CHAR | 30 | CHAR30 | ||||
COPRG | Entry in Register of Cooperatives | BU_COPRG | CHAR | 30 | CHAR30 | ||||
COMREG_DAT | Date of entry in trade register | BU_COMREG_DAT | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
M_BONIWERT | Creditworthiness value set manually | BONIWRT_KK | NUMC | 4 | BONIT_KK | ||||
M_BONIDAT | Date on Which Creditworthiness was Manually Set | BONIDAT_KK | DATS | 8 | DATUM | ||||
NAME1 | Name field 1 (name1/last name) | BU_NAME1 | CHAR | 40 | BU_NAME | ||||
NAME2 | Name field 2 (name2/first name) | BU_NAME2 | CHAR | 40 | BU_NAME | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
NATPERS | Business Partner Is a Natural Person Under the Tax Laws | BU_NATURAL_PERSON | CHAR | 1 | BU_NATURAL_PERSON | ||||
WA_BP_ADDRESS | 0 | ||||||||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
XDFADR | Indicator: Address is standard address | BU_XDFADR | CHAR | 1 | XFELD | ||||
ADEXT | Address number in external system | BU_ADEXT | CHAR | 20 | BU_ADEXT | ||||
NATION | Version ID for International Addresses | AD_NATION | CHAR | 1 | AD_NATION | ADDRESS_NATION | |||
GUID | UUID in character form | SYSUUID_C | CHAR | 32 | SYSUUID_C | ||||
MOVE_ADDR | Number of Move Target Address for Address Moves | BU_MOVE_ADDR | CHAR | 10 | ALPHA | AD_ADDRNUM | ADR | ||
DATE_FROM | Date Obsolete | BU_DATE_OBSOLETE | DATS | 8 | DATUM | ||||
ADDRESS_GUID | GUID of a Business Partner Address | BU_ADDRESS_GUID | RAW | 16 | SYSUUID | ||||
ADDR_VALID_FROM | Validity Start of a Business Partner Address | BU_ADDR_VALID_FROM | DEC | 15 | TZNTSTMPS | ||||
ADDR_VALID_TO | Validity End of a Business Partner Address | BU_ADDR_VALID_TO | DEC | 15 | TZNTSTMPS | ||||
ADDR_MOVE_DATE | Date of Move for Address Moves | BU_ADDR_MOVE_DATE | DEC | 15 | TZNTSTMPS | ||||
NAME_CO | c/o name | AD_NAME_CO | CHAR | 40 | TEXT40 | ||||
CITY1 | City | AD_CITY1 | CHAR | 40 | TEXT40 | CLCITYNAME | |||
CITY2 | District | AD_CITY2 | CHAR | 40 | TEXT40 | CITY_PART | |||
CITY_CODE | City code for city/street file | AD_CITYNUM | CHAR | 12 | ALPHA | CITY_CODE | |||
CITYP_CODE | District code for City and Street file | AD_CITYPNM | CHAR | 8 | ALPHA | CITYP_CODE | |||
HOME_CITY | City (different from postal city) | AD_CITY3 | CHAR | 40 | TEXT40 | ||||
CITYH_CODE | Different city for city/street file | AD_CITYHNM | CHAR | 12 | ALPHA | CITY_CODE | |||
CHCKSTATUS | City file test status | AD_CHECKST | CHAR | 1 | AD_CHECKST | ||||
REGIOGROUP | Regional structure grouping | REGIOGROUP | CHAR | 8 | REGIOGROUP | ||||
POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | CHAR10 | ||||
POST_CODE2 | PO Box Postal Code | AD_PSTCD2 | CHAR | 10 | CHAR10 | ||||
POST_CODE3 | Company Postal Code (for Large Customers) | AD_PSTCD3 | CHAR | 10 | CHAR10 | ||||
PCODE1_EXT | (Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code | AD_PST1XT | CHAR | 10 | CHAR10 | ||||
PCODE2_EXT | (Not Supported) PO Box Postal Code Extension | AD_PST2XT | CHAR | 10 | CHAR10 | ||||
PCODE3_EXT | (Not Supported) Major Customer Postal Code Extension | AD_PST3XT | CHAR | 10 | CHAR10 | ||||
PO_BOX | PO Box | AD_POBX | CHAR | 10 | CHAR10 | ||||
DONT_USE_P | PO Box Address Undeliverable Flag | AD_NO_USEP | CHAR | 4 | AD_NO_USE | ||||
PO_BOX_NUM | Flag: PO Box Without Number | AD_POBXNUM | CHAR | 1 | XFELD | ||||
PO_BOX_LOC | PO Box city | AD_POBXLOC | CHAR | 40 | TEXT40 | CITY_NAME | |||
CITY_CODE2 | City PO box code (City file) | AD_CIT2NUM | CHAR | 12 | ALPHA | CITY_CODE | |||
PO_BOX_REG | Region for PO Box (Country, State, Province, ...) | AD_POBXREG | CHAR | 3 | REGIO | ||||
PO_BOX_CTY | PO box country | AD_POBXCTY | CHAR | 3 | LAND1 | ||||
POSTALAREA | (Not Supported) Post Delivery District | AD_PSTLAR | CHAR | 15 | TEXT15 | ||||
TRANSPZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
DONT_USE_S | Street Address Undeliverable Flag | AD_NO_USES | CHAR | 4 | AD_NO_USE | ||||
STREETCODE | Street Number for City/Street File | AD_STRNUM | CHAR | 12 | ALPHA | STRT_CODE | |||
STREETABBR | (Not Supported) Abbreviation of Street Name | AD_STRABBR | CHAR | 2 | STRTYPEAB | ||||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM3 | (Not supported) House Number Range | AD_HSNM3 | CHAR | 10 | TEXT10 | ||||
STR_SUPPL1 | Street 2 | AD_STRSPP1 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL2 | Street 3 | AD_STRSPP2 | CHAR | 40 | TEXT40 | ||||
STR_SUPPL3 | Street 4 | AD_STRSPP3 | CHAR | 40 | TEXT40 | ||||
LOCATION | Street 5 | AD_LCTN | CHAR | 40 | TEXT40 | ||||
BUILDING | Building (Number or Code) | AD_BLDNG | CHAR | 20 | TEXT20 | ||||
FLOOR | Floor in building | AD_FLOOR | CHAR | 10 | TEXT10 | ||||
ROOMNUMBER | Room or Appartment Number | AD_ROOMNUM | CHAR | 10 | TEXT10 | ||||
COUNTRY | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
LANGU | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORT1 | Search Term 1 | AD_SORT1UL | CHAR | 20 | TEXT20 | ||||
SORT2 | Search Term 2 | AD_SORT2UL | CHAR | 20 | TEXT20 | ||||
SORT_PHN | (Not Supported) Phonetic Search Sort Field | AD_SRTPHN | CHAR | 20 | CHAR20 | ||||
ADDRORIGIN | (Not Supported) Address Data Source (Key) | AD_ORIGINA | CHAR | 4 | AD_ORIGIN | ||||
EXTENSION1 | Extension (only for data conversion) (e.g. data line) | AD_EXTENS1 | CHAR | 40 | TEXT40 | ||||
EXTENSION2 | Extension (only for data conversion) (e.g. telebox) | AD_EXTENS2 | CHAR | 40 | TEXT40 | ||||
TIME_ZONE | Address time zone | AD_TZONE | CHAR | 6 | TZNZONE | ||||
TAXJURCODE | Tax Jurisdiction | AD_TXJCD | CHAR | 15 | AD_TXJCD | TXJ | |||
ADDRESS_ID | (Not supported) Physical address ID | AD_ADDR_ID | CHAR | 10 | ALPHA | AD_ADDR_ID | |||
REMARK | Address notes | AD_REMARK1 | CHAR | 50 | TEXT50 | ||||
LANGU_CREA | Address record creation original language | AD_LANGUCR | LANG | 1 | ISOLA | SPRAS | |||
PO_BOX_LOBBY | PO Box Lobby | AD_PO_BOX_LBY | CHAR | 40 | TEXT40 | ||||
DELI_SERV_TYPE | Type of Delivery Service | AD_DELIVERY_SERVICE_TYPE | CHAR | 4 | AD_DELIVERY_SERVICE_TYPE | ||||
DELI_SERV_NUMBER | Number of Delivery Service | AD_DELIVERY_SERVICE_NUMBER | CHAR | 10 | CHAR10 | ||||
COUNTY_CODE | County code for county | AD_CNTYNUM | CHAR | 8 | ALPHA | CNTY_CODE | |||
COUNTY | County | AD_COUNTY | CHAR | 40 | TEXT40 | CLTCNTYNAME | |||
TOWNSHIP_CODE | Township code for Township | AD_TWSHPNUM | CHAR | 8 | ALPHA | TWSHP_CODE | |||
TOWNSHIP | Township | AD_TOWNSHIP | CHAR | 40 | TEXT40 | CLTWSHPNAME | |||
DEFLT_COMM | Standard communication type | AD_DFLTCMM | CHAR | 3 | AD_COMTYPE | ||||
TEL_NUMBER | Telephone no.: dialling code+number | AD_TLNMBR | CHAR | 30 | CHAR30 | ||||
TEL_EXTENS | Telephone no.: Extension | AD_TLXTNS | CHAR | 10 | CHAR10 | ||||
FAX_NUMBER | Fax number: dialling code+number | AD_FXNMBR | CHAR | 30 | CHAR30 | ||||
FAX_EXTENS | Fax no.: Extension | AD_FXXTNS | CHAR | 10 | CHAR10 | ||||
VALID_FROM | Valid From | BU_VALID_FROM_DATS | DATS | 8 | DATUM | ||||
VALID_TO | Valid To | BU_VALID_TO_DATS | DATS | 8 | DATUM | ||||
WA_PAYMO | 0 | ||||||||
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
ZLSCH | Form ID for Attached Payment Medium | FIDZT | CHAR | 1 | FIDZT | ||||
NACHA | Transmission Medium for Correspondence | FI_NACHA | CHAR | 1 | FI_NACHA | ||||
APPLK | Application Indicator | APPLK_BF | CHAR | 6 | APPLK_BF | ||||
ZANRE | Title of the payee | DZANRE | CHAR | 15 | TEXT15 | ||||
ZNME1 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME2 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME3 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZNME4 | Name of the payee | DZNME1 | CHAR | 35 | TEXT35 | ||||
ZPSTL | Postal code of the payee | DZPSTL | CHAR | 10 | PSTLZ | ||||
ZORT1 | City of the payee | DZORT1 | CHAR | 35 | TEXT35 | ||||
ZORT2 | Location from payee's address | ORT02_Z | CHAR | 35 | TEXT35 | ||||
ZSTRA | Street and house number of the payee | DZSTRA | CHAR | 35 | TEXT35 | ||||
ZPST2 | P.O. box postal code of the payee | DZPST2 | CHAR | 10 | PSTLZ | ||||
ZPFAC | P.O. box of the payee | DZPFAC | CHAR | 10 | PFACH | ||||
ZPFOR | City of payee's PO box | PFORT_Z | CHAR | 35 | TEXT35 | ||||
ZLAND | Country Key | DZLAND | CHAR | 3 | LAND1 | LND | |||
ZREGI | Regional code of the payee | DZREGI | CHAR | 3 | REGIO | ||||
ZSPRA | Language key of the payee | DZSPRA | LANG | 1 | ISOLA | SPRAS | |||
ZPLOR | Postal Code/City of the Payee's Display Field | DZPLOR | CHAR | 46 | TEXT46 | ||||
ZLNDX | Name of the Payee's Country | DZLNDX | CHAR | 15 | TEXT15 | ||||
ZREGX | Region | REGIX | CHAR | 20 | TEXT20 | ||||
ZNAME | Short Name of Payee | NAMEZ | CHAR | 50 | TEXT50 | ||||
KUNID | Customer ID Number | KUNID_49E | CHAR | 15 | CHAR15 | ||||
ESRNR | ISR Subscriber Number | ESRNR | CHAR | 11 | ESRNR | ||||
EMPZ1 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
EMPZ2 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
EMPZ3 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
EMPZ4 | Payee on Form | EMPZX | CHAR | 30 | TEXT30 | ||||
ZBNKS | Country Key | DZBNKS | CHAR | 3 | LAND1 | LND | |||
ZBNKN | Bank account number of the payee | DZBNKN | CHAR | 18 | BANKN | ||||
ZBNKL | Bank number of the payee's bank | DZBNKL | CHAR | 15 | BANKL | ||||
ZBKON | Bank Control Key of the Payee's Bank | DZBKON | CHAR | 2 | BKONT | ||||
ZBNKY | Bank key of the payee's bank | DZBNKY | CHAR | 15 | BANKK | ||||
ZBNKA | Name of the Payee's Bank | DZBNKA | CHAR | 60 | TEXT60 | ||||
ZBSTR | Street of the Payee's Bank | DZBSTR | CHAR | 35 | TEXT35 | ||||
ZBORT | City of the Payee's Bank | DZBORT | CHAR | 35 | TEXT35 | ||||
ZBANK | Payee Bank (Name and City) | EBANK | CHAR | 100 | TEXT100 | ||||
ZBRCH | Bank Branch | BRNCH | CHAR | 40 | TEXT40 | ||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
LAND1 | Country Key | LAND1 | CHAR | 3 | LAND1 | LND | |||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
PLORT | Postal code/city display field | PLORT | CHAR | 46 | TEXT46 | ||||
LANDX | Country Name | LANDX | CHAR | 15 | TEXT15 | ||||
REGIX | Region | REGIX | CHAR | 20 | TEXT20 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | WAERS | FWS | |||
HWAER | Local Currency | HWAER | CUKY | 5 | WAERS | ||||
SHKZG | Debit/Credit Indicator | SHKZG | CHAR | 1 | SHKZG | ||||
RBBTR | Gross Amount in Local Currency | RBBTR_FI | CURR | 13(2) | WRTV7 | ||||
RSKON | Total Cash Discount for the Payment Trans. (Local Currency) | RSKON | CURR | 13(2) | WRTV7 | ||||
RBETR | Amount in Local Currency | RBETR | CURR | 13(2) | WRTV7 | ||||
RWBBT | Gross Amount in the Payment Currency | RWBBT_FI | CURR | 13(2) | WRTV7 | ||||
RWSKT | Total Cash Discount for the Pmnt Transactn in Pmnt Currency | RWSKT | CURR | 13(2) | WRTV7 | ||||
RWBTR | Amount Paid in the Payment Currency | RWBTR | CURR | 13(2) | WRTV7 | ||||
ZWCK1 | Reason for payment | DZWECK_015 | CHAR | 70 | TXT70 | ||||
ZWCK2 | Reason for payment | DZWECK_015 | CHAR | 70 | TXT70 | ||||
VORID | Transaction ID | VORID | CHAR | 4 | VORID | ||||
NUMBER | Whole digits of the amount converted | IN_NUMBERS | NUMC | 15 | NUMC15 | ||||
DECIMAL | Decimal places of the amount converted | IN_DECI | NUMC | 3 | NUMC03 | ||||
CURRDEC | Number of decimal places | CURRDEC | INT1 | 3 | CURRDEC | ||||
WORD | Amount in words | IN_WORDS | CHAR | 255 | CHAR255 | ||||
DECWORD | Decimal places in words | DECWORD | CHAR | 128 | CHAR128 | ||||
DIG01 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG02 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG03 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG04 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG05 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG06 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG07 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG08 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG09 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG10 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG11 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG12 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG13 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG14 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
DIG15 | Figure in words (units, tens, ...) | DZWORT | CHAR | 7 | TEXT7 | ||||
KTEXT | Short Text | KTEXT_048W | CHAR | 20 | TEXT20 | ||||
LTEXT | Long Text | LTEXT_048W | CHAR | 40 | TEXT40 | ||||
OZWCK | Reference for OCRA Line | OZWCK | NUMC | 13 | NUMC13 | ||||
OZBKT | Account Number of Customer/Vendor for OCRA Line | OZBKT | NUMC | 18 | NUM18 | ||||
OZBKL | Bank Number of Customer/Vendor Bank for OCRA Line | OZBKL | NUMC | 15 | NUMC15 | ||||
SOCRA | Total for the OCRA Lines (OCRA/OCRB) | SOCRA | NUMC | 11 | NUMC11 | ||||
MBETR | Amount field for ISR | MBETR | CHAR | 13 | CHAR13 | ||||
MREFN | Reference number on the payment order | MREFN | CHAR | 27 | CHAR27 | ||||
MKODZ | ISR coding line | MKODZ | CHAR | 53 | CHAR53 | ||||
CODNL | Code Line for Dutch Bank Transfer | CODNL | CHAR | 65 | TEXT65 | ||||
SWIFT | SWIFT/BIC for International Payments | SWIFT | CHAR | 11 | SWIFT | ||||
IBAN | IBAN (International Bank Account Number) | IBAN | CHAR | 34 | IBAN | ||||
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 asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects