ISM_CUSTOMER_PI SAP (IS-M: Interface of SD Customer in PI modules) Structure details

Dictionary Type: Structure
Description: IS-M: Interface of SD Customer in PI modules




ABAP Code to SELECT data from ISM_CUSTOMER_PI
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
MANDTClient MANDTCLNT3MANDT
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
LAND1Country Key LAND1_GPCHAR3LAND1C_LAND1
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
ORT01City ORT01_GPCHAR35TEXT35
PSTLZPostal Code PSTLZCHAR10PSTLZ
REGIOSTATE (State, Province, County) REGIOCHAR3REGIO
SORTLSort field SORTLCHAR10CHAR10
STRASHouse number and street STRAS_GPCHAR35TEXT35
TELF1First telephone number TELF1CHAR16TEXT16
TELFXFax Number TELFXCHAR31TEXT31
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
ADRNRAddress ADRNRCHAR10ALPHAADRNR
MCOD1Search term for matchcode search MCDD1CHAR25CHAR25
MCOD2Search Term for Matchcode Search MCDD2CHAR25CHAR25
MCOD3Search term for matchcode search MCDD3CHAR25CHAR25
ANREDTitle ANREDCHAR15TEXT15
AUFSDCentral order block for customer AUFSD_XCHAR2KAUFS
BAHNEExpress train station BAHNECHAR25BAHNH
BAHNSTrain station BAHNSCHAR25BAHNH
BBBNRInternational location number (part 1) BBBNRNUMC7NUM07
BBSNRInternational location number (Part 2) BBSNRNUMC5NUM05
BEGRUAuthorization Group BRGRUCHAR4BRGRU
BRSCHIndustry key BRSCHCHAR4BRSCH
BUBKZCheck digit for the international location number BUBKZNUMC1NUM01
DATLTData communication line no. DATLTCHAR14TEXT14
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
EXABLIndicator: Unloading points exist EXABLCHAR1XFELD
FAKSDCentral billing block for customer FAKSD_XCHAR2FAKSP
FISKNAccount number of the master record with the fiscal address FISKN_DCHAR10ALPHAKUNNR
KNAZKWorking Time Calendar KNAZKCHAR2WFCID
KNRZAAccount number of an alternative payer KNRZACHAR10ALPHAKUNNR
KONZSGroup key KONZSCHAR10KONZS
KTOKDCustomer Account Group KTOKDCHAR4KTOKDKGD
KUKLACustomer classification KUKLACHAR2KUKLA
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10ALPHALIFNRLIFKRED_C
LIFSDCentral delivery block for the customer LIFSD_XCHAR2LIFSP
LOCCOCity Coordinates LOCCOCHAR10LOCCO
LOEVMCentral Deletion Flag for Master Record LOEVM_XCHAR1XFELD
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
NIELSNielsen ID NIELSCHAR2NIELS
ORT02District ORT02_GPCHAR35TEXT35
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
COUNCCounty Code COUNCCHAR3COUNC
CITYCCity Code CITYCCHAR4CITYC
RPMKRRegional Market RPMKRCHAR5RPMKR
SPERRCentral posting block SPERB_XCHAR1XFELD
SPRASLanguage Key SPRASLANG1ISOLASPRASSPRH_T002
STCD1Tax Number 1 STCD1CHAR16STCD1
STCD2Tax Number 2 STCD2CHAR11STCD2
STKZAIndicator: Business Partner Subject to Equalization Tax? STKZACHAR1STKZA
STKZULiable for VAT STKZUCHAR1XFELD
TELBXTelebox number TELBXCHAR15TEXT15
TELF2Second telephone number TELF2CHAR16TEXT16
TELTXTeletex number TELTXCHAR30TEXT30
TELX1Telex number TELX1CHAR30TEXT30
LZONETransportation zone to or from which the goods are delivered LZONECHAR10ZONE
XZEMPIndicator: Is an alternative payer allowed in document? XREGUCHAR1XFELD
VBUNDCompany ID of trading partner RASSCCHAR6ALPHARCOMPPGS
STCEGVAT Registration Number STCEGCHAR20STCEG
DEAR1Indicator: Competitor DEAR1CHAR1XFELD
DEAR2Indicator: Sales partner DEAR2CHAR1XFELD
DEAR3Indicator: Sales prospect DEAR3CHAR1DEAR3
DEAR4Indicator for customer type 4 DEAR4CHAR1XFELD
DEAR5ID for default sold-to party DEAR5CHAR1XFELD
GFORMLegal status GFORMCHAR2GFORM
BRAN1Industry Code 1 BRAN1_DCHAR10BRACO
BRAN2Industry code 2 BRAN2CHAR10BRACO
BRAN3Industry code 3 BRAN3CHAR10BRACO
BRAN4Industry code 4 BRAN4CHAR10BRACO
BRAN5Industry code 5 BRAN5CHAR10BRACO
EKONTInitial contact EKONTCHAR10ALPHAVBELN
UMSATAnnual sales UMSATCURR8(2) UMSAT
UMJAHYear For Which Sales are Given UMJAHNUMC4JAHR
UWAERCurrency of sales figure UWAERCUKY5WAERS
JMZAHYearly number of employees JMZAHNUMC6JMZAH
JMJAHYear for which the number of employees is given JMJAHNUMC4JAHR
KATR1Attribute 1 KATR1CHAR2ATTR1
KATR2Attribute - 2 KATR2CHAR2ATTR2
KATR3Attribute 3 KATR3CHAR2ATTR3
KATR4Attribute 4 KATR4CHAR2ATTR4
KATR5Attribute 5 KATR5CHAR2ATTR5
KATR6Attribute 6 KATR6CHAR3ATTR6
KATR7Attribute 7 KATR7CHAR3ATTR7
KATR8Attribute 8 KATR8CHAR3ATTR8
KATR9Attribute 9 KATR9CHAR3ATTR9
KATR10Attribute 10 KATR10CHAR3ATTR10
STKZNNatural Person STKZNCHAR1STKZN
UMSA1Annual sales UMSA1CURR15(2) UMSA1
TXJCDTax Jurisdiction TXJCDCHAR15TXJCDTXJ
PERIVFiscal Year Variant PERIVCHAR2PERIV
ABRVWUsage Indicator ABRVWCHAR3ABRVW
INSPBYDEBIInspection Carried Out By Customer (No Inspection Lot) QINSPBYDEBCHAR1QKZ
INSPATDEBIInspection for a Delivery Note After Outbound Delivery QINSPATDEBCHAR1QKZ
KTOCDReference Account Group for One-Time Account (Customer) KTOCDCHAR4KTOKD
PFORTPO Box city PFORT_GPCHAR35TEXT35
WERKSPlant WERKS_DCHAR4WERKSWRKH_T001W_C
DTAMSIndicator for Data Medium Exchange DTAMSCHAR1DTAMS
DTAWSInstruction key for data medium exchange DTAWSCHAR2DTAWS
DUEFLStatus of Data Transfer into Subsequent Release DUEFL_BKPFCHAR1DUEFL_BKPF
HZUORAssignment to Hierarchy HZUORNUMC2HZUOR
SPERZPayment Block SPERZCHAR1XFELD
ETIKGIS-R Labeling: customer/plant group ETIKGCHAR10ETIKG
CIVVEID for mainly non-military use CIVVECHAR1XFELD
MILVEID for mainly military use MILVECHAR1XFELD
KDKG1Customer condition group 1 KDKG1CHAR2KDKGR
KDKG2Customer condition group 2 KDKG2CHAR2KDKGR
KDKG3Customer condition group 3 KDKG3CHAR2KDKGR
KDKG4Customer condition group 4 KDKG4CHAR2KDKGR
KDKG5Customer condition group 5 KDKG5CHAR2KDKGR
XKNZAIndicator: Alternative payer using account number XKNZACHAR1XFELD
FITYPTax type J_1AFITP_DCHAR2J_1AFITP
STCDTTax Number Type J_1ATOIDCHAR2J_1ATOID
STCD3Tax Number 3 STCD3CHAR18CHAR18
STCD4Tax Number 4 STCD4CHAR18CHAR18
STCD5Tax Number 5 STCD5CHAR60CHAR60
XICMSCustomer is ICMS-exempt J_1BTCICMSCHAR1XFELD
XXIPICustomer is IPI-exempt J_1BTCIPICHAR1XFELD
XSUBTCustomer group for Substituiçao Tributária calculation J_1BTCSTCHAR3J_1BTCST1
CFOPCCustomer's CFOP category J_1BINDUS1CHAR2ALPHAJ_1BINDUS1
TXLW1Tax law: ICMS J_1BTAXLW1CHAR3ALPHAJ_1BTAXLW1
TXLW2Tax law: IPI J_1BTAXLW2CHAR3ALPHAJ_1BTAXLW2
CCC01Indicator for biochemical warfare for legal control CCC01CHAR1XFELD
CCC02Indicator for nuclear nonproliferation for legal control CCC02CHAR1XFELD
CCC03Indicator for national security for legal control CCC03CHAR1XFELD
CCC04Indicator for missile technology for legal control CCC04CHAR1XFELD
CASSDCentral sales block for customer CASSD_XCHAR2CASSP
KNURLUniform Resource Locator URLCHAR132TEXT132
J_1KFREPREName of Representative REPRESCHAR10REPRES
J_1KFTBUSType of Business GESTYPCHAR30GESTYP
J_1KFTINDType of Industry INDTYPCHAR30INDTYP
CONFSStatus of Change Authorization (Central) CONFS_XCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELCentral deletion block for master record NODEL_XCHAR1XFELD
DEAR6Indicator: Consumer DEAR6CHAR1XFELD
SUFRAMASuframa Code J_1BSUFRAMACHAR9J_1BSUFRAMA
RGRG Number J_1BRGCHAR11J_1BRG
EXPIssued by J_1BEXPCHAR3J_1BEXP
UFState J_1BUFCHAR2J_1BUF
RGDATERG Issue Date J_1BRGDATEDATS8DATUM
RICRIC Number J_1BRICNUMC11J_1BRIC
RNEForeign National Registration J_1BRNECHAR10J_1BRNE
RNEDATERNE Issue Date J_1BRNEDATEDATS8DATUM
CNAECNAE J_1BCNAECHAR7J_1BCNAE
LEGALNATLegal Nature J_1BLEGALNATNUMC4J_1BLEGALNAT
CRTNCRT Number J_1BCRTNCHAR1J_1BCRTN
ICMSTAXPAYICMS Taxpayer J_1BICMSTAXPAYCHAR2J_1BICMSTAXPAY
INDTYPIndustry Main Type J_1BINDTYPCHAR2J_1BINDTYP
TDTTax Declaration Type J_1BTDTCHAR2J_1BTDT
COMSIZECompany Size J_1BCOMSIZECHAR2J_1BCOMSIZE
DECREGPCDeclaration Regimen for PIS/COFINS J_1BDECREGPCCHAR2J_1BDECREGPC
.INCLU--AP 0
/VSO/R_PALHGTMaximum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_BIN_HGTQUAN13(3) MENG13
/VSO/R_PAL_ULUnit of Length for Packaging Material (VSO) /VSO/R_PAL_UNIT_LUNIT3CUNITMEINS
/VSO/R_PK_MATCustomer-Related Packing for Each Packaging Material (VSO) /VSO/M_PACK_BY_MATCHAR1/VSO/M_XFIELD
/VSO/R_MATPALPackaging Material of the Customer in VSO /VSO/M_MATNR_PALCHAR18MATN1MATNR
/VSO/R_I_NO_LYRNumber Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYRNUMC2/VSO/M_IPAL_NO_LYR
/VSO/R_ONE_MATPacking Material-Specific for Each Packaging Material /VSO/M_ONE_MATCHAR1/VSO/M_XFIELD
/VSO/R_ONE_SORTPack Only One Package Type for Each PKM (VSO) /VSO/M_ONE_SORTCHAR1/VSO/M_XFIELD
/VSO/R_ULD_SIDESide Preference of Loading/Unloading (VSO) /VSO/M_UNLOAD_SIDE_PREFNUMC1/VSO/M_SIDE_PREF
/VSO/R_LOAD_PREFFront/Back Preference of Loading/Unloading (VSO) /VSO/M_LOAD_PREFNUMC1/VSO/M_LOAD_PREF
/VSO/R_DPOINTCollective Unloading Point for VSO /VSO/R_DELIVERYPOINTCHAR10/VSO/R_DELIVERYPOINT/VSO/R_SH_DPOINT
.INCLU--AP 0
/XLSO/CUSTOMERData element to differentiate customer /XLSO/E_CUSTOMERCHAR1/XLSO/D_CUSTOMER
/XLSO/SYSIDName of SAP System SYSYSIDCHAR8SYCHAR08
/XLSO/CLIENTClient MANDTCLNT3MANDT
/XLSO/PARTNERBusiness Partner Number BU_PARTNERCHAR10ALPHABU_PARTNERBPABUPA
/XLSO/PREF_PAYVersion Number Component CHAR2CHAR2CHAR2
.INCLU--AP 0
ALCAgency Location Code FMFG_ALCCHAR8FMFG_ALCFMFG_ALC
PMT_OFFICEPayment Office FMFG_PMT_OFFCHAR5FMFG_PMT_OFFFMFG_PMT_OFFICE
FEE_SCHEDULEFee schedule FM_FEE_SCHEDCHAR4FM_FEE_SCHEDFM_FEE_SCHEDULE
DUNSDUNS Number FMCCRDUNSCHAR9
DUNS4DUNS+4 FMCCRDUNS4CHAR4
.INCLU--AP 0
PSOFGProcessor group PSOFGCHAR10PSOFG
PSOISSubledger acct preprocessing procedure PSOISCHAR20CHAR20
PSON1Name 1 NAME1_GPCHAR35NAME
PSON2Name 2 NAME2_GPCHAR35NAME
PSON3Name 3 NAME3_GPCHAR35NAME
PSOVNFirst Name PSOVNCHAR35NAME
PSOTLTitle PSOTLCHAR20FMPSOTL
PSOHSHouse number: is no longer used from Release 4.6B PSOHSCHAR6CHAR06
PSOSTStreet: No longer used from Release 4.6B PSOSTCHAR28PSOST
PSOO1Description PSOO1CHAR50TEXT50
PSOO2Description PSOO1CHAR50TEXT50
PSOO3Description PSOO1CHAR50TEXT50
PSOO4Description PSOO1CHAR50TEXT50
PSOO5Description PSOO1CHAR50TEXT50
.INCLU--AP 0
J_3GETYPRecipient Type J_3GETYPCHAR2J_3GETYP
J_3GREFTYPReference Type for Recipient J_3GREFTYPCHAR2J_3GREFTYP
PSPNRWBS Element PS_POSNRNUMC8ABPSPPS_POSNR
COAUFNROrder Number AUFNRCHAR12ALPHAAUFNRANR
J_3GAGEXTExternal Sold-to Party J_3GAGEXTCHAR10ALPHAKUNNR
J_3GAGINTCustomer Internal Settlement J_3GAGINTCHAR10ALPHAKUNNR
J_3GAGDUMIDummy Recipient J_3GDEMPSTCHAR10ALPHAKUNNR
J_3GAGSTDIStandard Recipient J_3GAGSTDICHAR10ALPHAKUNNR
LGORTStorage Location LGORT_DCHAR4LGORTLAG
KOKRSControlling Area KOKRSCHAR4CACCDCAC
KOSTLCost Center KOSTLCHAR10ALPHAKOSTLKOS
J_3GABGLGRetirement Date Counts for Performance-Based Equipment J_3GABGLGCHAR1X
J_3GABGVGRetirement Date Counts for Time-Based Equipment J_3GABGVGCHAR1X
J_3GABRARTSettlement Type J_3GABRARTCHAR1J_3GABRART
J_3GSTDMONHours per Month J_3GSTDMONDEC5(2) DEC03_2
J_3GSTDTAGHours per Day J_3GSTDTAGDEC5(2) DEC03_2
J_3GTAGMONNumber of Days/Month J_3GTAGMONDEC5(2) DEC3_2
J_3GZUGTAGFunction for Settlement on Acquisition Date/PBE J_3GZUGTAGCHAR1X
J_3GMASCHB'Fill PBE Documents' Indicator J_3GMASCHBCHAR1J_3GMASCHB
J_3GMEINSAIndicator: Take Multiple Usage Periods into Account J_3GMEINSACHAR1X
J_3GKEINSAIndicator - Relevant to Short Operation Periods J_3GKEINSACHAR1X
J_3GBLSPERBlocking Indicator for Document Entry J_3GBLSPERCHAR1X
J_3GKLEIVOIndicator: Calculate PBE as TBE J_3GKLEIVOCHAR1X
J_3GCALIDCalendar ID J_3GCALIDCHAR2WFCID
J_3GVMONATIndicator for Complete Month J_3GVMONATNUMC1J_3GVMONAT
J_3GABRKENSettlement Indicator J_3GABRKENCHAR1J_3GABRKEN
J_3GLABRECHDate of Last Settlement J_3GLABRECHDATS8DATUM
J_3GAABRECHDate of Current Settlement J_3GAABRECHDATS8DATUM
J_3GZUTVHLGInd.: Acquisition Date Counts (as Daily Settlement for PBE) J_3GZUTVHLGCHAR1X
J_3GNEGMENNegative Quantities Allowed Even for Chronolog. Inv. Mgmt J_3GNEGMENCHAR1X
J_3GFRISTLOIndicator: Deadline Logic J_3GFRISTLOCHAR1X
J_3GEMINBEMinimum Usage Period for Restricted Usage (Days) J_3GEMINBENUMC5NUMC
J_3GFMGUERelease Notification Allowance for Unrestricted Usage (Days) J_3GFMGUENUMC5NUMC
J_3GZUSCHUESurcharge for Unrestricted Usage (Days) J_3GZUSCHUENUMC5NUMC
J_3GSCHPRSIndicator: Shift Price J_3GSCHPRSCHAR1X
J_3GINVSTAStatus of Construction Site Inventory J_3GINVSTACHAR1J_3GINVSTA
/SAPCEM/DBERPlanning Area /SAPCEM/DBERCHAR8/SAPCEM/DBER
/SAPCEM/KVMEQIndicator: Settlement Qty Relevant to Equipment /SAPCEM/KVMEQCHAR1/SAPCEM/KVMEQ
.INCLU--AP 0
OIDRCDifferential Reference Code (DRC) OIC_DRCCHAR5NUMCVOIC_DRC
.INCLU--AP 0
OID_POREQDPurchase order required: X = Yes, Blank = No OID_POREQDCHAR1OI0_XFELD
.INCLU--AP 0
OIPBLBusiness location identifier (IS-Oil MRN) OIF_PBLNRCHAR10ALPHAOIF_PBLNROI0OIFB
.INCLU--AP 0
KNB1 0
MANDTClient MANDTCLNT3MANDT
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
BUKRSCompany Code BUKRSCHAR4BUKRSBUKC_T001
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
ERDATDate on which the Record Was Created ERDAT_RFDATS8DATUM
ERNAMName of Person who Created the Object ERNAM_RFCHAR12USNAM
SPERRPosting block for company code SPERB_BCHAR1XFELD
LOEVMDeletion Flag for Master Record (Company Code Level) LOEVM_BCHAR1XFELD
ZUAWAKey for sorting according to assignment numbers DZUAWACHAR3ZUAWA
BUSABAccounting clerk BUSABCHAR2BUSAB
AKONTReconciliation Account in General Ledger AKONTCHAR10ALPHASAKNR
BEGRUAuthorization Group BRGRUCHAR4BRGRU
KNRZEHead office account number (in branch accounts) KNRZECHAR10ALPHAKUNNR
KNRZBAccount number of an alternative payer KNRZBCHAR10ALPHAKUNNR
ZAMIMIndicator: Payment notice to customer (with cleared items)? DZAMIMCHAR1XFELD
ZAMIVIndicator: payment notice to sales department? DZAMIVCHAR1XFELD
ZAMIRIndicator: payment notice to legal department? DZAMIRCHAR1XFELD
ZAMIBIndicator: Payment notice to the accounting department ? DZAMIBCHAR1XFELD
ZAMIOIndicator: payment notice to customer (w/o cleared items)? DZAMIOCHAR1XFELD
ZWELSList of the Payment Methods to be Considered DZWELSCHAR10ZWELS
XVERRIndicator: Clearing between customer and vendor ? XVERR_KNB1CHAR1XFELD
ZAHLSBlock Key for Payment DZAHLSCHAR1ZAHLS
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
WAKONTerms of payment key for bill of exchange charges WAKONCHAR4ZTERM
VZSKZInterest calculation indicator VZSKZCHAR2VZSKZ
ZINDTKey date of the last interest calculation DZINDTDATS8DATUM
ZINRTInterest calculation frequency in months DZINRTNUMC2ZINRT
EIKTOOur account number at customer EIKTO_DCHAR12CHAR12
ZSABEUser at customer DZSABE_DCHAR15TEXT15
KVERMMemo KVERMCHAR30TEXT30
FDGRVPlanning group FDGRVCHAR10ALPHAFDGRP
VRBKZExport credit insurance institution number VRBKZCHAR2VRBKZ
VLIBBAmount Insured VLIBBCURR13(2) WERT7
VRSZLInsurance lead months VRSZLDEC3PACK2
VRSPRDeductible percentage rate VRSPRDEC3PACK2
VRSNRInsurance number VRSNRCHAR10CHAR10
VERDTInsurance validity date VERDTDATS8DATUM
PERKZCollective invoice variant PERKZ_KNB1CHAR1PERKZ_KNB1
XDEZVIndicator: Local processing? XDEZVCHAR1XFELD
XAUSZIndicator for periodic account statements XAUSZCHAR1AUSZG
WEBTRBill of exchange limit (in local currency) WEBTRCURR13(2) WERT7
REMITNext payee REMITCHAR10ALPHAKUNNR
DATLZDate of the last interest calculation run DATLZDATS8DATUM
XZVERIndicator: Record Payment History ? XZVERCHAR1XFELD
TOGRUTolerance group for the business partner/G/L account TOGRUCHAR4TOGRU
KULTGProbable time until check is paid KULTGDEC3PACK2
HBKIDShort Key for a House Bank HBKIDCHAR5HBKID
XPOREIndicator: Pay all items separately ? XPORECHAR1XFELD
BLNKZSubsidy indicator for determining the reduction rates BLNKZCHAR2BLNKZ
ALTKNPrevious Master Record Number ALTKNCHAR10CHAR10
ZGRUPKey for Payment Grouping DZGRUPCHAR2ZGRUP
URLIDShort Key for Known/Negotiated Leave URLIDCHAR4URLID
MGRUPKey for dunning notice grouping MGRUPCHAR2MGRUP
LOCKBKey of the Lockbox to Which the Customer Is To Pay LOCKBCHAR7LCKID
UZAWEPayment Method Supplement UZAWECHAR2UZAWE
EKVBDAccount Number of Buying Group EKVBDCHAR10ALPHAKUNNR
SREGLSelection Rule for Payment Advices SREGLCHAR3SREGL
XEDIPIndicator: Send Payment Advices by EDI XEDIPCHAR1XFELD
FRGRPRelease Approval Group FRGRPCHAR4FRGRP
VRSDGReason Code Conversion Version VRSDGCHAR3VRSDG
TLFXSAccounting clerk's fax number at the customer/vendor TLFXSCHAR31TEXT31
INTADInternet address of partner company clerk INTADCHAR130TXT130
XKNZBIndicator: Alternative payer using account number XKNZBCHAR1XFELD
GUZTEPayment Terms Key for Credit Memos GUZTECHAR4ZTERM
GRICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2J_1AGICD2
GRIDTDistribution Type for Employment Tax J_1ADTYP_DCHAR2J_1ADTYP
WBRSLValue Adjustment Key WBRSLCHAR2WBRSL
CONFSStatus of Change Authorization (Company Code Level) CONFS_BCHAR1CHAR1
UPDATDate on Which the Changes Were Confirmed UPDAT_RFDATS8DATUM
UPTIMTime of Last Change Confirmation UPTIM_RFTIMS6AS4TIME
NODELDeletion bock for master record (company code level) NODEL_BCHAR1XFELD
TLFNSAccounting clerk's telephone number at business partner TLFNSCHAR30CHAR30
CESSION_KZAccounts Receivable Pledging Indicator CESSION_KZCHAR2CESSION_KZ
AVSNDIndicator: Send Payment Advice by XML AVSNDCHAR1AVSND
AD_HASHE-Mail Address for Avis: Hash Value ADHASHCHAR10ADHASH
QLANDWithholding Tax Country Key QLANDCHAR3QLAND
.INCLU--AP 0
GMVKZDCustomer is in execution GMVKZDCHAR1XFELD
KNVV 0
MANDTClient MANDTCLNT3MANDT
KUNNRCustomer Numbers KUNNRCHAR10ALPHAKUNNRKUNC_KUNNR
VKORGSales Organization VKORGCHAR4VKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2VTWEGVTWC_VTWEG
SPARTDivision SPARTCHAR2SPARTSPAC_SPART
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
BEGRUAuthorization Group BEGRUCHAR4BEGRU
LOEVMDeletion flag for customer (sales level) LOEVM_VCHAR1XFELD
VERSGCustomer Statistics Group STGKUCHAR1STGKU
AUFSDCustomer order block (sales area) AUFSD_VCHAR2KAUFS
KALKSPricing procedure assigned to this customer KALKSCHAR1KALKS
KDGRPCustomer group KDGRPCHAR2KDGRPVKD
BZIRKSales district BZIRKCHAR6BZIRKBZI
KONDAPrice group (customer) KONDACHAR2KONDAVKA
PLTYPPrice list type PLTYPCHAR2PLTYPVPL
AWAHROrder probability of the item AWAHRNUMC3AWAHR
INCO1Incoterms (Part 1) INCO1CHAR3INCO1
INCO2Incoterms (Part 2) INCO2CHAR28INCO2
LIFSDCustomer delivery block (sales area) LIFSD_VCHAR2LIFSP
AUTLFComplete delivery defined for each sales order? AUTLFCHAR1XFELD
ANTLFMaximum Number of Partial Deliveries Allowed Per Item ANTLFDEC1ANTLF
KZTLFPartial delivery at item level KZTLFCHAR1KZTLF
KZAZUOrder Combination Indicator KZAZU_DCHAR1XFELD
CHSPLBatch split allowed CHSPLCHAR1XFELD
LPRIODelivery Priority LPRIONUMC2LPRIO
EIKTOShipper's (Our) Account Number at the Customer or Vendor EIKTOCHAR12CHAR12
VSBEDShipping Conditions VSBEDCHAR2VSBED
FAKSDBilling block for customer (sales and distribution) FAKSD_VCHAR2FAKSP
MRNKZManual invoice maintenance MRNKZCHAR1XFELD
PERFKInvoice dates (calendar identification) PERFKCHAR2WFCID
PERRLInvoice list schedule (calendar identification) PERRLCHAR2WFCID
KVAKZCost estimate indicator (inactive) KVAKZCHAR1XFELD
KVAWTValue limit for cost estimate (inactive) KVAWTCURR13(2) WERT7
WAERSCurrency WAERS_V02DCUKY5WAERS
KLABCCustomer classification (ABC analysis) KLABCCHAR2KLABC
KTGRDAccount assignment group for this customer KTGRDCHAR2KTGRD
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
VWERKDelivering Plant (Own or External) DWERK_EXTCHAR4WERKSSH_DWERK_EXTS
VKGRPSales Group VKGRPCHAR3VKGRPVKG
VKBURSales Office VKBURCHAR4VKBURVKB
VSORTItem proposal VSORTCHAR10ALPHAVBELN
KVGR1Customer group 1 KVGR1CHAR3KVGR1
KVGR2Customer group 2 KVGR2CHAR3KVGR2
KVGR3Customer group 3 KVGR3CHAR3KVGR3
KVGR4Customer group 4 KVGR4CHAR3KVGR4
KVGR5Customer group 5 KVGR5CHAR3KVGR5
BOKREIndicator: Customer Is Rebate-Relevant BOKRECHAR1XFELD
BOIDTStart of validity per.for the rebate index for the customer BOIDTDATS8DATUM
KURSTExchange Rate Type KURSTCHAR4KURSTKUT
PRFRERelevant for price determination ID PRFRECHAR1XFELD
PRAT1ID for product attribute 1 KUAT1CHAR1PRATK
PRAT2ID for product attribute 2 KUAT2CHAR1PRATK
PRAT3ID for product attribute 3 KUAT3CHAR1PRATK
PRAT4ID for product attribute 4 KUAT4CHAR1PRATK
PRAT5ID for product attribute 5 KUAT5CHAR1PRATK
PRAT6ID for product attribute 6 KUAT6CHAR1PRATK
PRAT7ID for product attribute 7 KUAT7CHAR1PRATK
PRAT8ID for product attribute 8 KUAT8CHAR1PRATK
PRAT9ID for product attribute 9 KUAT9CHAR1PRATK
PRATAID for product attribute 10 KUATACHAR1PRATK
KABSSCustomer payment guarantee procedure KABSSCH_CMCHAR4KABSSCH_CM
KKBERCredit control area KKBERCHAR4KKBERKKB
CASSDSales block for customer (sales area) CASSD_VCHAR2CASSP
RDOFFSwitch off rounding? RDOFFCHAR1XFELD
AGRELIndicator: Relevant for agency business AGRELCHAR1XFELD
MEGRUUnit of Measure Group MEGRUCHAR4MEGRU
UEBTOOverdelivery Tolerance Limit UEBTODEC3(1) PRZ21
UNTTOUnderdelivery Tolerance Limit UNTTODEC3(1) PRZ21
UEBTKUnlimited overdelivery allowed UEBTK_VCHAR1XFELD
PVKSMCustomer procedure for product proposal PVKSMCHAR2PVKSM
PODKZRelevant for POD processing PODKZCHAR1XFELD
PODTGTimeframe for Confirmation of POD PODTGDEC11TSTRGTSTRDURAG
BLINDIndex Structure Active for Subsequent Settlement (in AB) BLIND_SDCHAR1XFELD
CARRIER_NOTIFCarrier is to be notified /SPE/CARRIER_NOTIFCHAR1XFELD
.INCLU--AP 0
/BEV1/EMLGPFANDDeposit on Empties /BEV1/EMGPFANDCHAR1/BEV1/EMGPFAND
/BEV1/EMLGFORTSIndicator for Empties Update /BEV1/EMGFORTSCHAR1/BEV1/EMGFORTS
.INCLU--AP 0
J_1NBOESLExchange Key for NF Processing /NFM/BOESLCHAR3/NFM/BOESL
.INCLU--AP 0
PROFILEDRM profile /SAPHT/DRM_PROFILECHAR4/SAPHT/DRM_PROFILE
.INCLU--AP 0
FPARTBilling/Invoicing Plan Type FPARTCHAR2FPART
.INCLU--AP 0
/XLSO/CUST_DISRate (condition amount or percentage) where no scale exists KBETR_KONDCURR11(2) WERTV6
/XLSO/COMP_NAMEName 1 NAME1_GPCHAR35NAME
/XLSO/INDUSTRYIndustry key BRSCHCHAR4BRSCH
/XLSO/H_NUMBERHouse Number AD_HSNM1CHAR10TEXT10
/XLSO/STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
/XLSO/POST_CODEPostal Code PSTLZCHAR10PSTLZ
/XLSO/CITYCity ORT01_GPCHAR35TEXT35
/XLSO/REGIONSTATE (State, Province, County) REGIOCHAR3REGIO
/XLSO/COUNTRYCountry Key LAND1_GPCHAR3LAND1C_LAND1
/XLSO/INACTIVESingle-Character Indicator CHAR1CHAR1CHAR1
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 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!