ISM_CUSTOMER_PI SAP (IS-M: Interface of SD Customer in PI modules) Structure details
Description: IS-M: Interface of SD Customer in PI modules
Related tables to ISM_CUSTOMER_PI
Access table ISM_CUSTOMER_PI
Structure field list including key, data, relationships and ABAP select examples
ISM_CUSTOMER_PI 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 "IS-M: Interface of SD Customer in PI modules" 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_CUSTOMER_PI TYPE ISM_CUSTOMER_PI.
The ISM_CUSTOMER_PI table consists of various fields, each holding specific information or linking keys about IS-M: Interface of SD Customer in PI modules data available in SAP. These include MANDT (Client), KUNNR (Customer Numbers), LAND1 (Country Key), NAME1 (Name 1).. 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_CUSTOMER_PI 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 |
KNA1 | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
LAND1 | Country Key | LAND1_GP | CHAR | 3 | LAND1 | C_LAND1 | |||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
XCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
ADRNR | Address | ADRNR | CHAR | 10 | ALPHA | ADRNR | |||
MCOD1 | Search term for matchcode search | MCDD1 | CHAR | 25 | CHAR25 | ||||
MCOD2 | Search Term for Matchcode Search | MCDD2 | CHAR | 25 | CHAR25 | ||||
MCOD3 | Search term for matchcode search | MCDD3 | CHAR | 25 | CHAR25 | ||||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
AUFSD | Central order block for customer | AUFSD_X | CHAR | 2 | KAUFS | ||||
BAHNE | Express train station | BAHNE | CHAR | 25 | BAHNH | ||||
BAHNS | Train station | BAHNS | CHAR | 25 | BAHNH | ||||
BBBNR | International location number (part 1) | BBBNR | NUMC | 7 | NUM07 | ||||
BBSNR | International location number (Part 2) | BBSNR | NUMC | 5 | NUM05 | ||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | BRGRU | ||||
BRSCH | Industry key | BRSCH | CHAR | 4 | BRSCH | ||||
BUBKZ | Check digit for the international location number | BUBKZ | NUMC | 1 | NUM01 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
EXABL | Indicator: Unloading points exist | EXABL | CHAR | 1 | XFELD | ||||
FAKSD | Central billing block for customer | FAKSD_X | CHAR | 2 | FAKSP | ||||
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10 | ALPHA | KUNNR | |||
KNAZK | Working Time Calendar | KNAZK | CHAR | 2 | WFCID | ||||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | ALPHA | KUNNR | |||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
KTOKD | Customer Account Group | KTOKD | CHAR | 4 | KTOKD | KGD | |||
KUKLA | Customer classification | KUKLA | CHAR | 2 | KUKLA | ||||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | ALPHA | LIFNR | LIF | KRED_C | |
LIFSD | Central delivery block for the customer | LIFSD_X | CHAR | 2 | LIFSP | ||||
LOCCO | City Coordinates | LOCCO | CHAR | 10 | LOCCO | ||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
NIELS | Nielsen ID | NIELS | CHAR | 2 | NIELS | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
COUNC | County Code | COUNC | CHAR | 3 | COUNC | ||||
CITYC | City Code | CITYC | CHAR | 4 | CITYC | ||||
RPMKR | Regional Market | RPMKR | CHAR | 5 | RPMKR | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | ISOLA | SPRAS | SPR | H_T002 | |
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
LZONE | Transportation zone to or from which the goods are delivered | LZONE | CHAR | 10 | ZONE | ||||
XZEMP | Indicator: Is an alternative payer allowed in document? | XREGU | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | ALPHA | RCOMP | PGS | ||
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
DEAR1 | Indicator: Competitor | DEAR1 | CHAR | 1 | XFELD | ||||
DEAR2 | Indicator: Sales partner | DEAR2 | CHAR | 1 | XFELD | ||||
DEAR3 | Indicator: Sales prospect | DEAR3 | CHAR | 1 | DEAR3 | ||||
DEAR4 | Indicator for customer type 4 | DEAR4 | CHAR | 1 | XFELD | ||||
DEAR5 | ID for default sold-to party | DEAR5 | CHAR | 1 | XFELD | ||||
GFORM | Legal status | GFORM | CHAR | 2 | GFORM | ||||
BRAN1 | Industry Code 1 | BRAN1_D | CHAR | 10 | BRACO | ||||
BRAN2 | Industry code 2 | BRAN2 | CHAR | 10 | BRACO | ||||
BRAN3 | Industry code 3 | BRAN3 | CHAR | 10 | BRACO | ||||
BRAN4 | Industry code 4 | BRAN4 | CHAR | 10 | BRACO | ||||
BRAN5 | Industry code 5 | BRAN5 | CHAR | 10 | BRACO | ||||
EKONT | Initial contact | EKONT | CHAR | 10 | ALPHA | VBELN | |||
UMSAT | Annual sales | UMSAT | CURR | 8(2) | UMSAT | ||||
UMJAH | Year For Which Sales are Given | UMJAH | NUMC | 4 | JAHR | ||||
UWAER | Currency of sales figure | UWAER | CUKY | 5 | WAERS | ||||
JMZAH | Yearly number of employees | JMZAH | NUMC | 6 | JMZAH | ||||
JMJAH | Year for which the number of employees is given | JMJAH | NUMC | 4 | JAHR | ||||
KATR1 | Attribute 1 | KATR1 | CHAR | 2 | ATTR1 | ||||
KATR2 | Attribute - 2 | KATR2 | CHAR | 2 | ATTR2 | ||||
KATR3 | Attribute 3 | KATR3 | CHAR | 2 | ATTR3 | ||||
KATR4 | Attribute 4 | KATR4 | CHAR | 2 | ATTR4 | ||||
KATR5 | Attribute 5 | KATR5 | CHAR | 2 | ATTR5 | ||||
KATR6 | Attribute 6 | KATR6 | CHAR | 3 | ATTR6 | ||||
KATR7 | Attribute 7 | KATR7 | CHAR | 3 | ATTR7 | ||||
KATR8 | Attribute 8 | KATR8 | CHAR | 3 | ATTR8 | ||||
KATR9 | Attribute 9 | KATR9 | CHAR | 3 | ATTR9 | ||||
KATR10 | Attribute 10 | KATR10 | CHAR | 3 | ATTR10 | ||||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
UMSA1 | Annual sales | UMSA1 | CURR | 15(2) | UMSA1 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TXJCD | TXJ | |||
PERIV | Fiscal Year Variant | PERIV | CHAR | 2 | PERIV | ||||
ABRVW | Usage Indicator | ABRVW | CHAR | 3 | ABRVW | ||||
INSPBYDEBI | Inspection Carried Out By Customer (No Inspection Lot) | QINSPBYDEB | CHAR | 1 | QKZ | ||||
INSPATDEBI | Inspection for a Delivery Note After Outbound Delivery | QINSPATDEB | CHAR | 1 | QKZ | ||||
KTOCD | Reference Account Group for One-Time Account (Customer) | KTOCD | CHAR | 4 | KTOKD | ||||
PFORT | PO Box city | PFORT_GP | CHAR | 35 | TEXT35 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | WERKS | WRK | H_T001W_C | ||
DTAMS | Indicator for Data Medium Exchange | DTAMS | CHAR | 1 | DTAMS | ||||
DTAWS | Instruction key for data medium exchange | DTAWS | CHAR | 2 | DTAWS | ||||
DUEFL | Status of Data Transfer into Subsequent Release | DUEFL_BKPF | CHAR | 1 | DUEFL_BKPF | ||||
HZUOR | Assignment to Hierarchy | HZUOR | NUMC | 2 | HZUOR | ||||
SPERZ | Payment Block | SPERZ | CHAR | 1 | XFELD | ||||
ETIKG | IS-R Labeling: customer/plant group | ETIKG | CHAR | 10 | ETIKG | ||||
CIVVE | ID for mainly non-military use | CIVVE | CHAR | 1 | XFELD | ||||
MILVE | ID for mainly military use | MILVE | CHAR | 1 | XFELD | ||||
KDKG1 | Customer condition group 1 | KDKG1 | CHAR | 2 | KDKGR | ||||
KDKG2 | Customer condition group 2 | KDKG2 | CHAR | 2 | KDKGR | ||||
KDKG3 | Customer condition group 3 | KDKG3 | CHAR | 2 | KDKGR | ||||
KDKG4 | Customer condition group 4 | KDKG4 | CHAR | 2 | KDKGR | ||||
KDKG5 | Customer condition group 5 | KDKG5 | CHAR | 2 | KDKGR | ||||
XKNZA | Indicator: Alternative payer using account number | XKNZA | CHAR | 1 | XFELD | ||||
FITYP | Tax type | J_1AFITP_D | CHAR | 2 | J_1AFITP | ||||
STCDT | Tax Number Type | J_1ATOID | CHAR | 2 | J_1ATOID | ||||
STCD3 | Tax Number 3 | STCD3 | CHAR | 18 | CHAR18 | ||||
STCD4 | Tax Number 4 | STCD4 | CHAR | 18 | CHAR18 | ||||
STCD5 | Tax Number 5 | STCD5 | CHAR | 60 | CHAR60 | ||||
XICMS | Customer is ICMS-exempt | J_1BTCICMS | CHAR | 1 | XFELD | ||||
XXIPI | Customer is IPI-exempt | J_1BTCIPI | CHAR | 1 | XFELD | ||||
XSUBT | Customer group for Substituiçao Tributária calculation | J_1BTCST | CHAR | 3 | J_1BTCST1 | ||||
CFOPC | Customer's CFOP category | J_1BINDUS1 | CHAR | 2 | ALPHA | J_1BINDUS1 | |||
TXLW1 | Tax law: ICMS | J_1BTAXLW1 | CHAR | 3 | ALPHA | J_1BTAXLW1 | |||
TXLW2 | Tax law: IPI | J_1BTAXLW2 | CHAR | 3 | ALPHA | J_1BTAXLW2 | |||
CCC01 | Indicator for biochemical warfare for legal control | CCC01 | CHAR | 1 | XFELD | ||||
CCC02 | Indicator for nuclear nonproliferation for legal control | CCC02 | CHAR | 1 | XFELD | ||||
CCC03 | Indicator for national security for legal control | CCC03 | CHAR | 1 | XFELD | ||||
CCC04 | Indicator for missile technology for legal control | CCC04 | CHAR | 1 | XFELD | ||||
CASSD | Central sales block for customer | CASSD_X | CHAR | 2 | CASSP | ||||
KNURL | Uniform Resource Locator | URL | CHAR | 132 | TEXT132 | ||||
J_1KFREPRE | Name of Representative | REPRES | CHAR | 10 | REPRES | ||||
J_1KFTBUS | Type of Business | GESTYP | CHAR | 30 | GESTYP | ||||
J_1KFTIND | Type of Industry | INDTYP | CHAR | 30 | INDTYP | ||||
CONFS | Status of Change Authorization (Central) | CONFS_X | CHAR | 1 | CHAR1 | ||||
UPDAT | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS | 8 | DATUM | ||||
UPTIM | Time of Last Change Confirmation | UPTIM_RF | TIMS | 6 | AS4TIME | ||||
NODEL | Central deletion block for master record | NODEL_X | CHAR | 1 | XFELD | ||||
DEAR6 | Indicator: Consumer | DEAR6 | CHAR | 1 | XFELD | ||||
SUFRAMA | Suframa Code | J_1BSUFRAMA | CHAR | 9 | J_1BSUFRAMA | ||||
RG | RG Number | J_1BRG | CHAR | 11 | J_1BRG | ||||
EXP | Issued by | J_1BEXP | CHAR | 3 | J_1BEXP | ||||
UF | State | J_1BUF | CHAR | 2 | J_1BUF | ||||
RGDATE | RG Issue Date | J_1BRGDATE | DATS | 8 | DATUM | ||||
RIC | RIC Number | J_1BRIC | NUMC | 11 | J_1BRIC | ||||
RNE | Foreign National Registration | J_1BRNE | CHAR | 10 | J_1BRNE | ||||
RNEDATE | RNE Issue Date | J_1BRNEDATE | DATS | 8 | DATUM | ||||
CNAE | CNAE | J_1BCNAE | CHAR | 7 | J_1BCNAE | ||||
LEGALNAT | Legal Nature | J_1BLEGALNAT | NUMC | 4 | J_1BLEGALNAT | ||||
CRTN | CRT Number | J_1BCRTN | CHAR | 1 | J_1BCRTN | ||||
ICMSTAXPAY | ICMS Taxpayer | J_1BICMSTAXPAY | CHAR | 2 | J_1BICMSTAXPAY | ||||
INDTYP | Industry Main Type | J_1BINDTYP | CHAR | 2 | J_1BINDTYP | ||||
TDT | Tax Declaration Type | J_1BTDT | CHAR | 2 | J_1BTDT | ||||
COMSIZE | Company Size | J_1BCOMSIZE | CHAR | 2 | J_1BCOMSIZE | ||||
DECREGPC | Declaration Regimen for PIS/COFINS | J_1BDECREGPC | CHAR | 2 | J_1BDECREGPC | ||||
.INCLU--AP | 0 | ||||||||
/VSO/R_PALHGT | Maximum Stacking Height of the Packaging Material (VSO) | /VSO/R_PAL_BIN_HGT | QUAN | 13(3) | MENG13 | ||||
/VSO/R_PAL_UL | Unit of Length for Packaging Material (VSO) | /VSO/R_PAL_UNIT_L | UNIT | 3 | CUNIT | MEINS | |||
/VSO/R_PK_MAT | Customer-Related Packing for Each Packaging Material (VSO) | /VSO/M_PACK_BY_MAT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_MATPAL | Packaging Material of the Customer in VSO | /VSO/M_MATNR_PAL | CHAR | 18 | MATN1 | MATNR | |||
/VSO/R_I_NO_LYR | Number Layers Under an Inter-Pallet (VSO) | /VSO/M_IPAL_NO_LYR | NUMC | 2 | /VSO/M_IPAL_NO_LYR | ||||
/VSO/R_ONE_MAT | Packing Material-Specific for Each Packaging Material | /VSO/M_ONE_MAT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_ONE_SORT | Pack Only One Package Type for Each PKM (VSO) | /VSO/M_ONE_SORT | CHAR | 1 | /VSO/M_XFIELD | ||||
/VSO/R_ULD_SIDE | Side Preference of Loading/Unloading (VSO) | /VSO/M_UNLOAD_SIDE_PREF | NUMC | 1 | /VSO/M_SIDE_PREF | ||||
/VSO/R_LOAD_PREF | Front/Back Preference of Loading/Unloading (VSO) | /VSO/M_LOAD_PREF | NUMC | 1 | /VSO/M_LOAD_PREF | ||||
/VSO/R_DPOINT | Collective Unloading Point for VSO | /VSO/R_DELIVERYPOINT | CHAR | 10 | /VSO/R_DELIVERYPOINT | /VSO/R_SH_DPOINT | |||
.INCLU--AP | 0 | ||||||||
/XLSO/CUSTOMER | Data element to differentiate customer | /XLSO/E_CUSTOMER | CHAR | 1 | /XLSO/D_CUSTOMER | ||||
/XLSO/SYSID | Name of SAP System | SYSYSID | CHAR | 8 | SYCHAR08 | ||||
/XLSO/CLIENT | Client | MANDT | CLNT | 3 | MANDT | ||||
/XLSO/PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | ALPHA | BU_PARTNER | BPA | BUPA | |
/XLSO/PREF_PAY | Version Number Component | CHAR2 | CHAR | 2 | CHAR2 | ||||
.INCLU--AP | 0 | ||||||||
ALC | Agency Location Code | FMFG_ALC | CHAR | 8 | FMFG_ALC | FMFG_ALC | |||
PMT_OFFICE | Payment Office | FMFG_PMT_OFF | CHAR | 5 | FMFG_PMT_OFF | FMFG_PMT_OFFICE | |||
FEE_SCHEDULE | Fee schedule | FM_FEE_SCHED | CHAR | 4 | FM_FEE_SCHED | FM_FEE_SCHEDULE | |||
DUNS | DUNS Number | FMCCRDUNS | CHAR | 9 | |||||
DUNS4 | DUNS+4 | FMCCRDUNS4 | CHAR | 4 | |||||
.INCLU--AP | 0 | ||||||||
PSOFG | Processor group | PSOFG | CHAR | 10 | PSOFG | ||||
PSOIS | Subledger acct preprocessing procedure | PSOIS | CHAR | 20 | CHAR20 | ||||
PSON1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
PSON2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
PSON3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
PSOVN | First Name | PSOVN | CHAR | 35 | NAME | ||||
PSOTL | Title | PSOTL | CHAR | 20 | FMPSOTL | ||||
PSOHS | House number: is no longer used from Release 4.6B | PSOHS | CHAR | 6 | CHAR06 | ||||
PSOST | Street: No longer used from Release 4.6B | PSOST | CHAR | 28 | PSOST | ||||
PSOO1 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO2 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO3 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO4 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
PSOO5 | Description | PSOO1 | CHAR | 50 | TEXT50 | ||||
.INCLU--AP | 0 | ||||||||
J_3GETYP | Recipient Type | J_3GETYP | CHAR | 2 | J_3GETYP | ||||
J_3GREFTYP | Reference Type for Recipient | J_3GREFTYP | CHAR | 2 | J_3GREFTYP | ||||
PSPNR | WBS Element | PS_POSNR | NUMC | 8 | ABPSP | PS_POSNR | |||
COAUFNR | Order Number | AUFNR | CHAR | 12 | ALPHA | AUFNR | ANR | ||
J_3GAGEXT | External Sold-to Party | J_3GAGEXT | CHAR | 10 | ALPHA | KUNNR | |||
J_3GAGINT | Customer Internal Settlement | J_3GAGINT | CHAR | 10 | ALPHA | KUNNR | |||
J_3GAGDUMI | Dummy Recipient | J_3GDEMPST | CHAR | 10 | ALPHA | KUNNR | |||
J_3GAGSTDI | Standard Recipient | J_3GAGSTDI | CHAR | 10 | ALPHA | KUNNR | |||
LGORT | Storage Location | LGORT_D | CHAR | 4 | LGORT | LAG | |||
KOKRS | Controlling Area | KOKRS | CHAR | 4 | CACCD | CAC | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | ALPHA | KOSTL | KOS | ||
J_3GABGLG | Retirement Date Counts for Performance-Based Equipment | J_3GABGLG | CHAR | 1 | X | ||||
J_3GABGVG | Retirement Date Counts for Time-Based Equipment | J_3GABGVG | CHAR | 1 | X | ||||
J_3GABRART | Settlement Type | J_3GABRART | CHAR | 1 | J_3GABRART | ||||
J_3GSTDMON | Hours per Month | J_3GSTDMON | DEC | 5(2) | DEC03_2 | ||||
J_3GSTDTAG | Hours per Day | J_3GSTDTAG | DEC | 5(2) | DEC03_2 | ||||
J_3GTAGMON | Number of Days/Month | J_3GTAGMON | DEC | 5(2) | DEC3_2 | ||||
J_3GZUGTAG | Function for Settlement on Acquisition Date/PBE | J_3GZUGTAG | CHAR | 1 | X | ||||
J_3GMASCHB | 'Fill PBE Documents' Indicator | J_3GMASCHB | CHAR | 1 | J_3GMASCHB | ||||
J_3GMEINSA | Indicator: Take Multiple Usage Periods into Account | J_3GMEINSA | CHAR | 1 | X | ||||
J_3GKEINSA | Indicator - Relevant to Short Operation Periods | J_3GKEINSA | CHAR | 1 | X | ||||
J_3GBLSPER | Blocking Indicator for Document Entry | J_3GBLSPER | CHAR | 1 | X | ||||
J_3GKLEIVO | Indicator: Calculate PBE as TBE | J_3GKLEIVO | CHAR | 1 | X | ||||
J_3GCALID | Calendar ID | J_3GCALID | CHAR | 2 | WFCID | ||||
J_3GVMONAT | Indicator for Complete Month | J_3GVMONAT | NUMC | 1 | J_3GVMONAT | ||||
J_3GABRKEN | Settlement Indicator | J_3GABRKEN | CHAR | 1 | J_3GABRKEN | ||||
J_3GLABRECH | Date of Last Settlement | J_3GLABRECH | DATS | 8 | DATUM | ||||
J_3GAABRECH | Date of Current Settlement | J_3GAABRECH | DATS | 8 | DATUM | ||||
J_3GZUTVHLG | Ind.: Acquisition Date Counts (as Daily Settlement for PBE) | J_3GZUTVHLG | CHAR | 1 | X | ||||
J_3GNEGMEN | Negative Quantities Allowed Even for Chronolog. Inv. Mgmt | J_3GNEGMEN | CHAR | 1 | X | ||||
J_3GFRISTLO | Indicator: Deadline Logic | J_3GFRISTLO | CHAR | 1 | X | ||||
J_3GEMINBE | Minimum Usage Period for Restricted Usage (Days) | J_3GEMINBE | NUMC | 5 | NUMC | ||||
J_3GFMGUE | Release Notification Allowance for Unrestricted Usage (Days) | J_3GFMGUE | NUMC | 5 | NUMC | ||||
J_3GZUSCHUE | Surcharge for Unrestricted Usage (Days) | J_3GZUSCHUE | NUMC | 5 | NUMC | ||||
J_3GSCHPRS | Indicator: Shift Price | J_3GSCHPRS | CHAR | 1 | X | ||||
J_3GINVSTA | Status of Construction Site Inventory | J_3GINVSTA | CHAR | 1 | J_3GINVSTA | ||||
/SAPCEM/DBER | Planning Area | /SAPCEM/DBER | CHAR | 8 | /SAPCEM/DBER | ||||
/SAPCEM/KVMEQ | Indicator: Settlement Qty Relevant to Equipment | /SAPCEM/KVMEQ | CHAR | 1 | /SAPCEM/KVMEQ | ||||
.INCLU--AP | 0 | ||||||||
OIDRC | Differential Reference Code (DRC) | OIC_DRC | CHAR | 5 | NUMCV | OIC_DRC | |||
.INCLU--AP | 0 | ||||||||
OID_POREQD | Purchase order required: X = Yes, Blank = No | OID_POREQD | CHAR | 1 | OI0_XFELD | ||||
.INCLU--AP | 0 | ||||||||
OIPBL | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | ALPHA | OIF_PBLNR | OI0 | OIFB | |
.INCLU--AP | 0 | ||||||||
KNB1 | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
BUKRS | Company Code | BUKRS | CHAR | 4 | BUKRS | BUK | C_T001 | ||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
ERDAT | Date on which the Record Was Created | ERDAT_RF | DATS | 8 | DATUM | ||||
ERNAM | Name of Person who Created the Object | ERNAM_RF | CHAR | 12 | USNAM | ||||
SPERR | Posting block for company code | SPERB_B | CHAR | 1 | XFELD | ||||
LOEVM | Deletion Flag for Master Record (Company Code Level) | LOEVM_B | CHAR | 1 | XFELD | ||||
ZUAWA | Key for sorting according to assignment numbers | DZUAWA | CHAR | 3 | ZUAWA | ||||
BUSAB | Accounting clerk | BUSAB | CHAR | 2 | BUSAB | ||||
AKONT | Reconciliation Account in General Ledger | AKONT | CHAR | 10 | ALPHA | SAKNR | |||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | BRGRU | ||||
KNRZE | Head office account number (in branch accounts) | KNRZE | CHAR | 10 | ALPHA | KUNNR | |||
KNRZB | Account number of an alternative payer | KNRZB | CHAR | 10 | ALPHA | KUNNR | |||
ZAMIM | Indicator: Payment notice to customer (with cleared items)? | DZAMIM | CHAR | 1 | XFELD | ||||
ZAMIV | Indicator: payment notice to sales department? | DZAMIV | CHAR | 1 | XFELD | ||||
ZAMIR | Indicator: payment notice to legal department? | DZAMIR | CHAR | 1 | XFELD | ||||
ZAMIB | Indicator: Payment notice to the accounting department ? | DZAMIB | CHAR | 1 | XFELD | ||||
ZAMIO | Indicator: payment notice to customer (w/o cleared items)? | DZAMIO | CHAR | 1 | XFELD | ||||
ZWELS | List of the Payment Methods to be Considered | DZWELS | CHAR | 10 | ZWELS | ||||
XVERR | Indicator: Clearing between customer and vendor ? | XVERR_KNB1 | CHAR | 1 | XFELD | ||||
ZAHLS | Block Key for Payment | DZAHLS | CHAR | 1 | ZAHLS | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
WAKON | Terms of payment key for bill of exchange charges | WAKON | CHAR | 4 | ZTERM | ||||
VZSKZ | Interest calculation indicator | VZSKZ | CHAR | 2 | VZSKZ | ||||
ZINDT | Key date of the last interest calculation | DZINDT | DATS | 8 | DATUM | ||||
ZINRT | Interest calculation frequency in months | DZINRT | NUMC | 2 | ZINRT | ||||
EIKTO | Our account number at customer | EIKTO_D | CHAR | 12 | CHAR12 | ||||
ZSABE | User at customer | DZSABE_D | CHAR | 15 | TEXT15 | ||||
KVERM | Memo | KVERM | CHAR | 30 | TEXT30 | ||||
FDGRV | Planning group | FDGRV | CHAR | 10 | ALPHA | FDGRP | |||
VRBKZ | Export credit insurance institution number | VRBKZ | CHAR | 2 | VRBKZ | ||||
VLIBB | Amount Insured | VLIBB | CURR | 13(2) | WERT7 | ||||
VRSZL | Insurance lead months | VRSZL | DEC | 3 | PACK2 | ||||
VRSPR | Deductible percentage rate | VRSPR | DEC | 3 | PACK2 | ||||
VRSNR | Insurance number | VRSNR | CHAR | 10 | CHAR10 | ||||
VERDT | Insurance validity date | VERDT | DATS | 8 | DATUM | ||||
PERKZ | Collective invoice variant | PERKZ_KNB1 | CHAR | 1 | PERKZ_KNB1 | ||||
XDEZV | Indicator: Local processing? | XDEZV | CHAR | 1 | XFELD | ||||
XAUSZ | Indicator for periodic account statements | XAUSZ | CHAR | 1 | AUSZG | ||||
WEBTR | Bill of exchange limit (in local currency) | WEBTR | CURR | 13(2) | WERT7 | ||||
REMIT | Next payee | REMIT | CHAR | 10 | ALPHA | KUNNR | |||
DATLZ | Date of the last interest calculation run | DATLZ | DATS | 8 | DATUM | ||||
XZVER | Indicator: Record Payment History ? | XZVER | CHAR | 1 | XFELD | ||||
TOGRU | Tolerance group for the business partner/G/L account | TOGRU | CHAR | 4 | TOGRU | ||||
KULTG | Probable time until check is paid | KULTG | DEC | 3 | PACK2 | ||||
HBKID | Short Key for a House Bank | HBKID | CHAR | 5 | HBKID | ||||
XPORE | Indicator: Pay all items separately ? | XPORE | CHAR | 1 | XFELD | ||||
BLNKZ | Subsidy indicator for determining the reduction rates | BLNKZ | CHAR | 2 | BLNKZ | ||||
ALTKN | Previous Master Record Number | ALTKN | CHAR | 10 | CHAR10 | ||||
ZGRUP | Key for Payment Grouping | DZGRUP | CHAR | 2 | ZGRUP | ||||
URLID | Short Key for Known/Negotiated Leave | URLID | CHAR | 4 | URLID | ||||
MGRUP | Key for dunning notice grouping | MGRUP | CHAR | 2 | MGRUP | ||||
LOCKB | Key of the Lockbox to Which the Customer Is To Pay | LOCKB | CHAR | 7 | LCKID | ||||
UZAWE | Payment Method Supplement | UZAWE | CHAR | 2 | UZAWE | ||||
EKVBD | Account Number of Buying Group | EKVBD | CHAR | 10 | ALPHA | KUNNR | |||
SREGL | Selection Rule for Payment Advices | SREGL | CHAR | 3 | SREGL | ||||
XEDIP | Indicator: Send Payment Advices by EDI | XEDIP | CHAR | 1 | XFELD | ||||
FRGRP | Release Approval Group | FRGRP | CHAR | 4 | FRGRP | ||||
VRSDG | Reason Code Conversion Version | VRSDG | CHAR | 3 | VRSDG | ||||
TLFXS | Accounting clerk's fax number at the customer/vendor | TLFXS | CHAR | 31 | TEXT31 | ||||
INTAD | Internet address of partner company clerk | INTAD | CHAR | 130 | TXT130 | ||||
XKNZB | Indicator: Alternative payer using account number | XKNZB | CHAR | 1 | XFELD | ||||
GUZTE | Payment Terms Key for Credit Memos | GUZTE | CHAR | 4 | ZTERM | ||||
GRICD | Activity Code for Gross Income Tax | J_1AGICD_D | CHAR | 2 | J_1AGICD2 | ||||
GRIDT | Distribution Type for Employment Tax | J_1ADTYP_D | CHAR | 2 | J_1ADTYP | ||||
WBRSL | Value Adjustment Key | WBRSL | CHAR | 2 | WBRSL | ||||
CONFS | Status of Change Authorization (Company Code Level) | CONFS_B | CHAR | 1 | CHAR1 | ||||
UPDAT | Date on Which the Changes Were Confirmed | UPDAT_RF | DATS | 8 | DATUM | ||||
UPTIM | Time of Last Change Confirmation | UPTIM_RF | TIMS | 6 | AS4TIME | ||||
NODEL | Deletion bock for master record (company code level) | NODEL_B | CHAR | 1 | XFELD | ||||
TLFNS | Accounting clerk's telephone number at business partner | TLFNS | CHAR | 30 | CHAR30 | ||||
CESSION_KZ | Accounts Receivable Pledging Indicator | CESSION_KZ | CHAR | 2 | CESSION_KZ | ||||
AVSND | Indicator: Send Payment Advice by XML | AVSND | CHAR | 1 | AVSND | ||||
AD_HASH | E-Mail Address for Avis: Hash Value | ADHASH | CHAR | 10 | ADHASH | ||||
QLAND | Withholding Tax Country Key | QLAND | CHAR | 3 | QLAND | ||||
.INCLU--AP | 0 | ||||||||
GMVKZD | Customer is in execution | GMVKZD | CHAR | 1 | XFELD | ||||
KNVV | 0 | ||||||||
MANDT | Client | MANDT | CLNT | 3 | MANDT | ||||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | ALPHA | KUNNR | KUN | C_KUNNR | |
VKORG | Sales Organization | VKORG | CHAR | 4 | VKORG | VKO | C_VKORG | ||
VTWEG | Distribution Channel | VTWEG | CHAR | 2 | VTWEG | VTW | C_VTWEG | ||
SPART | Division | SPART | CHAR | 2 | SPART | SPA | C_SPART | ||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
BEGRU | Authorization Group | BEGRU | CHAR | 4 | BEGRU | ||||
LOEVM | Deletion flag for customer (sales level) | LOEVM_V | CHAR | 1 | XFELD | ||||
VERSG | Customer Statistics Group | STGKU | CHAR | 1 | STGKU | ||||
AUFSD | Customer order block (sales area) | AUFSD_V | CHAR | 2 | KAUFS | ||||
KALKS | Pricing procedure assigned to this customer | KALKS | CHAR | 1 | KALKS | ||||
KDGRP | Customer group | KDGRP | CHAR | 2 | KDGRP | VKD | |||
BZIRK | Sales district | BZIRK | CHAR | 6 | BZIRK | BZI | |||
KONDA | Price group (customer) | KONDA | CHAR | 2 | KONDA | VKA | |||
PLTYP | Price list type | PLTYP | CHAR | 2 | PLTYP | VPL | |||
AWAHR | Order probability of the item | AWAHR | NUMC | 3 | AWAHR | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | INCO1 | ||||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
LIFSD | Customer delivery block (sales area) | LIFSD_V | CHAR | 2 | LIFSP | ||||
AUTLF | Complete delivery defined for each sales order? | AUTLF | CHAR | 1 | XFELD | ||||
ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | ANTLF | ||||
KZTLF | Partial delivery at item level | KZTLF | CHAR | 1 | KZTLF | ||||
KZAZU | Order Combination Indicator | KZAZU_D | CHAR | 1 | XFELD | ||||
CHSPL | Batch split allowed | CHSPL | CHAR | 1 | XFELD | ||||
LPRIO | Delivery Priority | LPRIO | NUMC | 2 | LPRIO | ||||
EIKTO | Shipper's (Our) Account Number at the Customer or Vendor | EIKTO | CHAR | 12 | CHAR12 | ||||
VSBED | Shipping Conditions | VSBED | CHAR | 2 | VSBED | ||||
FAKSD | Billing block for customer (sales and distribution) | FAKSD_V | CHAR | 2 | FAKSP | ||||
MRNKZ | Manual invoice maintenance | MRNKZ | CHAR | 1 | XFELD | ||||
PERFK | Invoice dates (calendar identification) | PERFK | CHAR | 2 | WFCID | ||||
PERRL | Invoice list schedule (calendar identification) | PERRL | CHAR | 2 | WFCID | ||||
KVAKZ | Cost estimate indicator (inactive) | KVAKZ | CHAR | 1 | XFELD | ||||
KVAWT | Value limit for cost estimate (inactive) | KVAWT | CURR | 13(2) | WERT7 | ||||
WAERS | Currency | WAERS_V02D | CUKY | 5 | WAERS | ||||
KLABC | Customer classification (ABC analysis) | KLABC | CHAR | 2 | KLABC | ||||
KTGRD | Account assignment group for this customer | KTGRD | CHAR | 2 | KTGRD | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
VWERK | Delivering Plant (Own or External) | DWERK_EXT | CHAR | 4 | WERKS | SH_DWERK_EXTS | |||
VKGRP | Sales Group | VKGRP | CHAR | 3 | VKGRP | VKG | |||
VKBUR | Sales Office | VKBUR | CHAR | 4 | VKBUR | VKB | |||
VSORT | Item proposal | VSORT | CHAR | 10 | ALPHA | VBELN | |||
KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | KVGR1 | ||||
KVGR2 | Customer group 2 | KVGR2 | CHAR | 3 | KVGR2 | ||||
KVGR3 | Customer group 3 | KVGR3 | CHAR | 3 | KVGR3 | ||||
KVGR4 | Customer group 4 | KVGR4 | CHAR | 3 | KVGR4 | ||||
KVGR5 | Customer group 5 | KVGR5 | CHAR | 3 | KVGR5 | ||||
BOKRE | Indicator: Customer Is Rebate-Relevant | BOKRE | CHAR | 1 | XFELD | ||||
BOIDT | Start of validity per.for the rebate index for the customer | BOIDT | DATS | 8 | DATUM | ||||
KURST | Exchange Rate Type | KURST | CHAR | 4 | KURST | KUT | |||
PRFRE | Relevant for price determination ID | PRFRE | CHAR | 1 | XFELD | ||||
PRAT1 | ID for product attribute 1 | KUAT1 | CHAR | 1 | PRATK | ||||
PRAT2 | ID for product attribute 2 | KUAT2 | CHAR | 1 | PRATK | ||||
PRAT3 | ID for product attribute 3 | KUAT3 | CHAR | 1 | PRATK | ||||
PRAT4 | ID for product attribute 4 | KUAT4 | CHAR | 1 | PRATK | ||||
PRAT5 | ID for product attribute 5 | KUAT5 | CHAR | 1 | PRATK | ||||
PRAT6 | ID for product attribute 6 | KUAT6 | CHAR | 1 | PRATK | ||||
PRAT7 | ID for product attribute 7 | KUAT7 | CHAR | 1 | PRATK | ||||
PRAT8 | ID for product attribute 8 | KUAT8 | CHAR | 1 | PRATK | ||||
PRAT9 | ID for product attribute 9 | KUAT9 | CHAR | 1 | PRATK | ||||
PRATA | ID for product attribute 10 | KUATA | CHAR | 1 | PRATK | ||||
KABSS | Customer payment guarantee procedure | KABSSCH_CM | CHAR | 4 | KABSSCH_CM | ||||
KKBER | Credit control area | KKBER | CHAR | 4 | KKBER | KKB | |||
CASSD | Sales block for customer (sales area) | CASSD_V | CHAR | 2 | CASSP | ||||
RDOFF | Switch off rounding? | RDOFF | CHAR | 1 | XFELD | ||||
AGREL | Indicator: Relevant for agency business | AGREL | CHAR | 1 | XFELD | ||||
MEGRU | Unit of Measure Group | MEGRU | CHAR | 4 | MEGRU | ||||
UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
UEBTK | Unlimited overdelivery allowed | UEBTK_V | CHAR | 1 | XFELD | ||||
PVKSM | Customer procedure for product proposal | PVKSM | CHAR | 2 | PVKSM | ||||
PODKZ | Relevant for POD processing | PODKZ | CHAR | 1 | XFELD | ||||
PODTG | Timeframe for Confirmation of POD | PODTG | DEC | 11 | TSTRG | TSTRDURAG | |||
BLIND | Index Structure Active for Subsequent Settlement (in AB) | BLIND_SD | CHAR | 1 | XFELD | ||||
CARRIER_NOTIF | Carrier is to be notified | /SPE/CARRIER_NOTIF | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
/BEV1/EMLGPFAND | Deposit on Empties | /BEV1/EMGPFAND | CHAR | 1 | /BEV1/EMGPFAND | ||||
/BEV1/EMLGFORTS | Indicator for Empties Update | /BEV1/EMGFORTS | CHAR | 1 | /BEV1/EMGFORTS | ||||
.INCLU--AP | 0 | ||||||||
J_1NBOESL | Exchange Key for NF Processing | /NFM/BOESL | CHAR | 3 | /NFM/BOESL | ||||
.INCLU--AP | 0 | ||||||||
PROFILE | DRM profile | /SAPHT/DRM_PROFILE | CHAR | 4 | /SAPHT/DRM_PROFILE | ||||
.INCLU--AP | 0 | ||||||||
FPART | Billing/Invoicing Plan Type | FPART | CHAR | 2 | FPART | ||||
.INCLU--AP | 0 | ||||||||
/XLSO/CUST_DIS | Rate (condition amount or percentage) where no scale exists | KBETR_KOND | CURR | 11(2) | WERTV6 | ||||
/XLSO/COMP_NAME | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
/XLSO/INDUSTRY | Industry key | BRSCH | CHAR | 4 | BRSCH | ||||
/XLSO/H_NUMBER | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
/XLSO/STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
/XLSO/POST_CODE | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
/XLSO/CITY | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
/XLSO/REGION | STATE (State, Province, County) | REGIO | CHAR | 3 | REGIO | ||||
/XLSO/COUNTRY | Country Key | LAND1_GP | CHAR | 3 | LAND1 | C_LAND1 | |||
/XLSO/INACTIVE | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
FKNAS_TAB | 0 | ||||||||
FKNB5_TAB | 0 | ||||||||
FKNBK_TAB | 0 | ||||||||
FKNVA_TAB | 0 | ||||||||
FKNVI_TAB | 0 | ||||||||
FKNVP_TAB | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure ISM_CUSTOMER_PI using ABAP code?
As ISM_CUSTOMER_PI 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_CUSTOMER_PI as there is no data to select.How to access SAP table ISM_CUSTOMER_PI
Within an ECC or HANA version of SAP you can also view further information about ISM_CUSTOMER_PI 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