1. Home
  2. Resources
  3. SAP Tables
  4. RJGBUSISM007_ALL_STAT_STR - IS-M: Business Partner BAPI Parameter STAT

SAP Table RJGBUSISM007_ALL_STAT_STR

IS-M: Business Partner BAPI Parameter STAT

RJGBUSISM007_ALL_STAT_STR (IS-M: Business Partner BAPI Parameter STAT) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RJGBUSISM007_ALL_STAT_STR to other SAP tables.

RJGBUSISM007_ALL_STAT_STR table fields

Field Data element Checktable Datatype Length Decimals
SAP RJGBUSISM007_SAP_STAT_STR STRU 0 0
BUT000 BUT000 STRU 0 0
CLIENT Client MANDT CLNT 3 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
TYPE Business partner category BU_TYPE CHAR 1 0
1 Person
2 Organization
3 Group
BPKIND Business Partner Type BU_BPKIND CHAR 4 0
BU_GROUP Business Partner Grouping BU_GROUP CHAR 4 0
BPEXT Business Partner Number in External System BU_BPEXT CHAR 20 0
BU_SORT1 Search term 1 for business partner BU_SORT1 CHAR 20 0
BU_SORT2 Search term 2 for business partner BU_SORT2 CHAR 20 0
SOURCE Data Origin Types BU_SOURCE CHAR 4 0
TITLE Form-of-Address Key AD_TITLE CHAR 4 0
XDELE Central Archiving Flag BU_XDELE CHAR 1 0
X Yes
NULL No
XBLCK Central Block for Business Partner BU_XBLCK CHAR 1 0
X Yes
NULL No
AUGRP Authorization Group BU_AUGRP CHAR 4 0
TITLE_LET Salutation BU_TITLE_LET CHAR 50 0
BU_LOGSYS Logical system LOGSYS CHAR 10 0
CONTACT Business Partner: Contact Permission BU_CONTACT CHAR 1 0
1 Allowed
2 Disallowed
3 Check Permission
NOT_RELEASED Indicator: Not Released BU_XNOT_RELEASED CHAR 1 0
X Yes
NULL No
NOT_LG_COMPETENT Indicator: Not Legally Competent BU_NOT_LEG_COMPETENT CHAR 1 0
X TRUE
NULL FALSE
PRINT_MODE Business Partner Print Format BU_PRINT_MODE CHAR 1 0
1 Braille
2 Large Print
BP_EEW_DUMMY Dummy function in length 1 DUMMY CHAR 1 0
NAPR Business Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSON CHAR 1 0
NULL Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
BBP_IPISP Tax Split BBP_J_1BINDEQU CHAR 1 0
X Yes
NULL No
RATE Cost Rate/Revenue Rate for Project Costing DPR_TV_RATE CHAR 15 0
NAME_ORG1 Name 1 of organization BU_NAMEOR1 CHAR 40 0
NAME_ORG2 Name 2 of organization BU_NAMEOR2 CHAR 40 0
NAME_ORG3 Name 3 of organization BU_NAMEOR3 CHAR 40 0
NAME_ORG4 Name 4 of organization BU_NAMEOR4 CHAR 40 0
LEGAL_ENTY BP: Legal form of organization BU_LEGENTY CHAR 2 0
IND_SECTOR Industry sector BU_INDSECT CHAR 10 0
LEGAL_ORG Legal Entity of Organization BU_LEGAL_ORG CHAR 2 0
FOUND_DAT Date organization founded BU_FOUND_DAT DATS 8 0
LIQUID_DAT Liquidation date of organization BU_LIQUID_DAT DATS 8 0
LOCATION_1 International location number (part 1) BBBNR NUMC 7 0
LOCATION_2 International location number (Part 2) BBSNR NUMC 5 0
LOCATION_3 Check digit for the international location number BUBKZ NUMC 1 0
NAME_LAST Last name of business partner (person) BU_NAMEP_L CHAR 40 0
NAME_FIRST First name of business partner (person) BU_NAMEP_F CHAR 40 0
NAME_LST2 Other Last Name of a Person BU_NAMEPL2 CHAR 40 0
NAME_LAST2 Name at birth of business partner BU_BIRTHNM CHAR 40 0
NAMEMIDDLE Middle name or second forename of a person BU_NAMEMID CHAR 40 0
TITLE_ACA1 Academic Title: Key AD_TITLE1 CHAR 4 0
TITLE_ACA2 Second academic title (key) AD_TITLE2 CHAR 4 0
TITLE_ROYL Name supplement, e.g. noble title (key) AD_TITLES CHAR 4 0
PREFIX1 Name Prefix (Key) AD_PREFIX CHAR 4 0
PREFIX2 2nd name prefix (key) AD_PREFIX2 CHAR 4 0
NAME1_TEXT Full Name BU_NAME1TX CHAR 80 0
NICKNAME Nickname of Business Partner (Person) BU_NICKNAM CHAR 40 0
INITIALS "Middle Initial" or personal initials AD_INITS CHAR 10 0
NAMEFORMAT Name format AD_FORMAT CHAR 2 0
NAMCOUNTRY Country for name format rule AD_NAMCTRY CHAR 3 0
LANGU_CORR Business Partner: Correspondence Language BU_LANGU_CORR LANG 1 0
XSEXM Selection: Business partner is male BU_XSEXM CHAR 1 0
X Yes
NULL No
XSEXF Selection: Business partner is female BU_XSEXF CHAR 1 0
X Yes
NULL No
BIRTHPL Birthplace of business partner BU_BIRTHPL CHAR 40 0
MARST Marital Status of Business Partner BU_MARST CHAR 1 0
EMPLO Name of Employer of a Natural Person BU_EMPLO CHAR 35 0
JOBGR Occupation/group BU_JOBGR CHAR 4 0
NATIO Nationality BU_NATIO CHAR 3 0
CNTAX Obsolete Field BU_CNTAX CHAR 3 0
CNDSC Ctry of Origin: Non-Res. Companies BU_CNDSC CHAR 3 0
PERSNUMBER Person number AD_PERSNUM CHAR 10 0
XSEXU Selection: Sex of business partner is not known BU_XSEXU CHAR 1 0
X Yes
NULL No
XUBNAME Obsolete Field BU_XUBNAME CHAR 12 0
BU_LANGU Business partner: Language BU_LANGU LANG 1 0
BIRTHDT Date of Birth of Business Partner BU_BIRTHDT DATS 8 0
DEATHDT Date of death of business partner BU_DEATHDT DATS 8 0
PERNO Personnel Number BU_PERNO NUMC 8 0
CHILDREN Obsolete Field BU_CHILDREN NUMC 2 0
MEM_HOUSE Obsolete Field BU_MEM_HOUSE DEC 2 0
PARTGRPTYP Group type BU_GRPTYP CHAR 4 0
NAME_GRP1 Name 1 (group) BU_NAMEGR1 CHAR 40 0
NAME_GRP2 Name 2 (group) BU_NAMEGR2 CHAR 40 0
MC_NAME1 Search Help Field 1 (Name 1/Last Name) BU_MCNAME1 CHAR 35 0
MC_NAME2 Search Help Field 2 (Name 2/First Name) BU_MCNAME2 CHAR 35 0
CRUSR User who created the object BU_CRUSR CHAR 12 0
CRDAT Date on which the object was created BU_CRDAT DATS 8 0
CRTIM Time at which the object was created BU_CRTIM TIMS 6 0
CHUSR Last user to change object BU_CHUSR CHAR 12 0
CHDAT Date when object was last changed BU_CHDAT DATS 8 0
CHTIM Time at which object was last changed BU_CHTIM TIMS 6 0
PARTNER_GUID Business Partner GUID BU_PARTNER_GUID RAW 16 0
ADDRCOMM Address Number BU_ADDRCOMM CHAR 10 0
TD_SWITCH Planned Change Documents for Partner Were Converted BU_TD_SWITCH CHAR 1 0
IS_ORG_CENTRE Indicator: Business Partner Is Also an Organizational Center BU_IS_ORG_CENTRE CHAR 1 0
NULL BP Is Not an Organizational Center
1 BP Is Also an Organizational Center - BP Existed First
2 BP Is Also an Organizational Center - Org.Cent.Existed First
DB_KEY UUID in X form (binary) SYSUUID_X RAW 16 0
VALID_FROM Validity Start BUT000 BP Data BU_BP_VALID_FROM DEC 15 0
VALID_TO Validity End BUT000 BP Data BU_BP_VALID_TO DEC 15 0
XPCPT Business Purpose Completed Flag BU_XPCPT CHAR 1 0
X True
NULL False
NATPERS Business Partner Is a Natural Person Under the Tax Laws BU_NATURAL_PERSON CHAR 1 0
NULL Business Person is a Legal Person or Organization
X Business Partner is a Natural Person
PAR_REL Business Partner Released BP_PAR_REL CHAR 1 0
NULL Released
X Not released
BP_SORT Sort Field for Phonetic Search; Obsolete BP_SORT_PH CHAR 20 0
KBANKS Bank country key BANKS CHAR 3 0
KBANKL Bank Keys BANKK CHAR 15 0
BUT100 RJGBUT100_TAB TTYP 0 0
BUT0BK BUT0BK_TAB TTYP 0 0
BUT0CC RJGBUT0CC_TAB TTYP 0 0
ADDRESSES RJGBUSISM007_ADDR_STAT_TAB TTYP 0 0
MEDIA RJGBUSISM007_MEDIA_STAT_STR STRU 0 0
JGTBP00 RJGBP_JGTBP00_STAT_STR STRU 0 0
CLIENT Client MANDT CLNT 3 0
PARTNER Business Partner Number BU_PARTNER CHAR 10 0
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
XVERMSACH IS-M: BP Authorized to Receive Gifts XVERMSACH CHAR 1 0
X Yes
NULL No
XMITARB IS-M: Employee Indicator XMITARB CHAR 1 0
X Yes
NULL No
PERNR IS-M: Personnel Number JPERNR2 CHAR 20 0
XNOWERB IS-M: No Advertising XNOWERB CHAR 1 0
X Yes
NULL No
XVERB IS-M: Association Indicator XVERB CHAR 1 0
X Yes
NULL No
XINTERN IS-M: Internal Business Partner Indicator XINTERN CHAR 1 0
X Yes
NULL No
XSOZIAL IS-M: Social Facility Indicator XSOZIAL CHAR 1 0
X Yes
NULL No
XVERLEIG IS-M: Indicator: Owned By Publisher XVERLEIG CHAR 1 0
X Yes
NULL No
VERLVKORG IS-M: Publisher's Sales Organization VERLVKORG CHAR 4 0
XINSER IS-M: Selection Indicator for Advertiser XINSERENT CHAR 1 0
NULL Evaluation of advertiser will not be performed
X Evaluation of advertiser is being performed
XAGEN IS-M: Agency Indicator XAGENTUR CHAR 1 0
X Yes
NULL No
AGEN_ART IS-M: Creative Boutique Indicator XAGEN_KREA CHAR 1 0
X Yes
NULL No
AGEN_STR IS-M: Distribution Agency Indicator XAGEN_STR CHAR 1 0
X Yes
NULL No
AGEN_PLAN IS-M: Planning Agency Indicator XAGEN_PLAN CHAR 1 0
X Yes
NULL No
AGEN_GRU IS-M: Agency Type AGEN_GRUP CHAR 1 0
GP_DUB IS-M: Credit Query Indicator JDUBIOS CHAR 1 0
BON IS-M: Creditworthiness Indicator JBONITAET CHAR 2 0
WBZKUNNR IS-M: WBZ, VDZ Number of WBZ Company JWBZKUNNR CHAR 6 0
RECHZENTNR IS-M: WBZ, Computer Center Number JWBZRZNR CHAR 2 0
XWBZFIRMA IS-M: Business Partner Is WBZ Company XWBZFIRMA CHAR 1 0
X Yes
NULL No
WBZZLSCH Payment Method for Billing Documents to WBZ Company WBZZLSCH CHAR 1 0
REFBELEG IS-M/SD: Reference Document in Legacy System REMELD_ISP CHAR 20 0
J_SOC_SECU Social Insurance Number J_SOC_SECU CHAR 20 0
AKTDB Activity in database for primary table BUT000 BU_AKTDB CHAR 2 0
JGTGPNR RJGBP_JGTGPNR_STAT_STR STRU 0 0
MANDT Client MANDT CLNT 3 0
GPNR IS-M: Business Partner Key GPNR CHAR 10 0
XGPLOE IS-M: Deletion Flag for General Business Partner JXLV_GP CHAR 1 0
X Yes
NULL No
XGPLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XGPSPE IS-M/SD: Lock Indicator for General Business Partner XGPSPE CHAR 1 0
X Yes
NULL No
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
JKTOKD IS-M: Business Partner Account Group JKTOKD CHAR 4 0
MAILN IS-M: Mail Address JMAILN CHAR 12 0
BEGRU Authorization Group BRGRU CHAR 4 0
BERUFSL IS-M: Occupation BERUFSL CHAR 8 0
GFORM Legal status GFORM CHAR 2 0
BRSCH Industry key BRSCH CHAR 4 0
BRAN1 Industry Code 1 BRAN1_D CHAR 10 0
BRAN2 Industry code 2 BRAN2 CHAR 10 0
BRAN3 Industry code 3 BRAN3 CHAR 10 0
BRAN4 Industry code 4 BRAN4 CHAR 10 0
BRAN5 Industry code 5 BRAN5 CHAR 10 0
JGEBDAT IS-M: Date of Birth of a Business Partner JGEBDAT DATS 8 0
GESCH IS-M: Gender Key JGESCHL CHAR 1 0
1 Male
2 Female
NULL
JFAMST IS-M: Business Partner's Marital Status JFAMST CHAR 1 0
GPHERK IS-M: Business Partner Origin GPHERK CHAR 2 0
XNATUR IS-M: Natural Person Indicator XNATUR CHAR 1 0
X Yes
NULL No
XVERMSACH IS-M: BP Authorized to Receive Gifts XVERMSACH CHAR 1 0
X Yes
NULL No
XOHNE Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
XDEBI IS-M: Indicator: Customer Exists JXDEBI CHAR 1 0
X Yes
NULL No
KUNNR IS-M: Customer Number in Previous System JKUNNR CHAR 10 0
FKUNNR IS-M: Customer Number in Non-SAP System JFKUNNR CHAR 10 0
XKREDI IS-M: Indicator: Vendor Exists XKREDI CHAR 1 0
X Yes
NULL No
LIFNR IS-M: Vendor Number in Previous System JLIFNR CHAR 10 0
FLIFNR IS-M: Vendor Number in Non-SAP System JFLIFNR CHAR 10 0
XMITARB IS-M: Employee Indicator XMITARB CHAR 1 0
X Yes
NULL No
PERNR IS-M: Personnel Number JPERNR2 CHAR 20 0
XNOWERB IS-M: No Advertising XNOWERB CHAR 1 0
X Yes
NULL No
GPKLA1 IS-M: BP Class (Not in Use Yet) GPKLA CHAR 4 0
GPKLA2 IS-M: BP Class 2 GPKLA2 CHAR 4 0
GPKLA3 IS-M: BP Class 3 GPKLA3 CHAR 4 0
GPKLA4 IS-M: BP Class 4 GPKLA4 CHAR 4 0
GPKLA5 IS-M: BP Class 5 GPKLA5 CHAR 4 0
KATR1 Attribute 1 KATR1 CHAR 2 0
KATR2 Attribute 2 KATR2 CHAR 2 0
KATR3 Attribute 3 KATR3 CHAR 2 0
KATR4 Attribute 4 KATR4 CHAR 2 0
KATR5 Attribute 5 KATR5 CHAR 2 0
KATR6 Attribute 6 KATR6 CHAR 3 0
KATR7 Attribute 7 KATR7 CHAR 3 0
KATR8 Attribute 8 KATR8 CHAR 3 0
KATR9 Attribute 9 KATR9 CHAR 3 0
KATR10 Attribute 10 KATR10 CHAR 3 0
XVSRVGES IS-M: Service Company Indicator XVSRVGES CHAR 1 0
X Yes
NULL No
XVSGLOEV IS-M: Deletion Flag for Service Company JXLV_ZG CHAR 1 0
X Yes
NULL No
XVSGLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XVSGSPE IS-M/SD: Lock Indicator for Service Company XZGSPE CHAR 1 0
X Yes
NULL No
XZUST IS-M: Carrier Indicator XZUST CHAR 1 0
X Yes
NULL No
XZUSTLOEV IS-M: Deletion Flag for Carrier JXLV_ZU CHAR 1 0
X Yes
NULL No
XZUSTLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XZUSSPE IS-M/SD: Lock Indicator for Carrier XZUSPE CHAR 1 0
X Yes
NULL No
XVERMPROV IS-M: Sales Agent - Commission Recipient XVERMPROV CHAR 1 0
X Yes
NULL No
XVERMPROVV IS-M: Deletion Flag for Sales Agent/Commission Recipient JXLV_PV CHAR 1 0
X Yes
NULL No
XVERMPROKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XVERSPE IS-M/SD: Lock Indicator for Sales Agent/Commission Recipient XPVSPE CHAR 1 0
X Yes
NULL No
XVERB IS-M: Association Indicator XVERB CHAR 1 0
X Yes
NULL No
XVEBLOEV IS-M: Deletion Flag (Role-Specific) XLOESCH CHAR 1 0
X Yes
NULL No
XVEBSPE IS-M: Lock Indicator (Role-Specific) XSPERR CHAR 1 0
X Yes
NULL No
XINKASSO IS-M: Field Collector Indicator XINKASSO CHAR 1 0
X Yes
NULL No
XINKLOEV IS-M: Deletion Flag for Field Collector JXLV_IK CHAR 1 0
X Yes
NULL No
XINKLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XINKSPE IS-M/SD: Lock Indicator for Field Collector XIKSPE CHAR 1 0
X Yes
NULL No
XRECHER IS-M: Researcher Indicator XRECHER CHAR 1 0
X Yes
NULL No
XRECHLOEV IS-M: Deletion Flag for Researcher JXLV_RC CHAR 1 0
X Yes
NULL No
XRECHLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XRECHSPE IS-M/SD: Lock Indicator for Researcher XRCSPE CHAR 1 0
X Yes
NULL No
MAILNBETR IS-M: Mail Address of User in Charge JMAILNBETR CHAR 12 0
XKAHS IS-M: Customer Pickup Point Indicator XKAHS CHAR 1 0
X Yes
NULL No
XKAHLOEV IS-M: Deletion Flag (Role-Specific) XLOESCH CHAR 1 0
X Yes
NULL No
XKAHSSPE IS-M: Lock Indicator (Role-Specific) XSPERR CHAR 1 0
X Yes
NULL No
XSPEDI IS-M: Forwarding Agent Indicator XSPEDI CHAR 1 0
X Yes
NULL No
XSPEDLOEV IS-M: Deletion Flag for Forwarding Agent JXLV_SP CHAR 1 0
X Yes
NULL No
XSPEDLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XSPESPE IS-M/SD: Lock Indicator for Forwarding Agent XSPSPE CHAR 1 0
X Yes
NULL No
XVERTKUN IS-M: Sales Customer Indicator XVERTKUN CHAR 1 0
X Yes
NULL No
XVKUNLOEV IS-M: Deletion Flag for Sales Customer JXLV_KU CHAR 1 0
X Yes
NULL No
XVKUNLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XVKUNSPE IS-M/SD: Lock Indicator for Sales Customer XKUSPE CHAR 1 0
X Yes
NULL No
XEUW IS-M: Retailer Indicator XEUW CHAR 1 0
X Yes
NULL No
XEUWLOEV IS-M: Deletion Flag for Retailer JXLV_EW CHAR 1 0
X Yes
NULL No
XEUWLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XEUWSPE IS-M/SD: Lock Indicator - Retailer XEWSPE CHAR 1 0
X Yes
NULL No
XINTERN IS-M: Internal Business Partner Indicator XINTERN CHAR 1 0
X Yes
NULL No
XINTLOEV IS-M: Deletion Flag (Role-Specific) XLOESCH CHAR 1 0
X Yes
NULL No
AUFORG Sales Office VKBUR CHAR 4 0
XINTSPE IS-M: Lock Indicator (Role-Specific) XSPERR CHAR 1 0
X Yes
NULL No
XSOZIAL IS-M: Social Facility Indicator XSOZIAL CHAR 1 0
X Yes
NULL No
XSOZLOEV IS-M: Deletion Flag (Role-Specific) XLOESCH CHAR 1 0
X Yes
NULL No
XSOZSPE IS-M: Lock Indicator (Role-Specific) XSPERR CHAR 1 0
X Yes
NULL No
XPOST IS-M: Mail Depot Indicator XPOST CHAR 1 0
X Yes
NULL No
XPOSLOEV IS-M: Deletion Flag for Post JXLV_PO CHAR 1 0
X Yes
NULL No
XPOSLOEKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XPOSSPE IS-M/SD: Lock Indicator - Post XPOSPE CHAR 1 0
X Yes
NULL No
XVERLAG IS-M: Publisher Indicator XVERLAG CHAR 1 0
X Yes
NULL No
XVERLLOEV IS-M: Deletion Flag (Role-Specific) XLOESCH CHAR 1 0
X Yes
NULL No
XVERLSPE IS-M: Lock Indicator (Role-Specific) XSPERR CHAR 1 0
X Yes
NULL No
XVERLEIG IS-M: Indicator: Owned By Publisher XVERLEIG CHAR 1 0
X Yes
NULL No
VERLVKORG Sales Organization VKORG CHAR 4 0
ISPCVERL IS-M: Publisher ISPC Number - Obsolete from Rel. 3.04 ISPVERL CHAR 11 0
XMEDIAK IS-M: Media customer XMEDIAK CHAR 1 0
X Yes
NULL No
XMEDIAKLV IS-M: Deletion Flag for Media Customer XMKLV CHAR 1 0
X Yes
NULL No
XMEDIAKLKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XMEDIAKSP IS-M: Lock Indicator for Media Customer XMKSPE CHAR 1 0
X Yes
NULL No
XINSER IS-M: Selection Indicator for Advertiser XINSERENT CHAR 1 0
NULL Evaluation of advertiser will not be performed
X Evaluation of advertiser is being performed
XINSERLV IS-M: Advertiser Deletion Flag XISLV CHAR 1 0
X Yes
NULL No
XINSERLKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XINSERSP IS-M: Advertiser Lock Indicator XISSPE CHAR 1 0
X Yes
NULL No
XMVERM IS-M: Media Sales Agent Indicator XMVERMITTL CHAR 1 0
X Yes
NULL No
XMVERMLV IS-M: Deletion Flag for Media Sales Agent XMVLV CHAR 1 0
X Yes
NULL No
XMVERMLKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XMVERMSP IS-M: Lock Indicator for Media Sales Agent XMVSPE CHAR 1 0
X Yes
NULL No
XAGEN IS-M: Agency Indicator XAGENTUR CHAR 1 0
X Yes
NULL No
XAGENLV IS-M: Agency Deletion Flag XARLV CHAR 1 0
X Yes
NULL No
XAGENLKZ IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
XAGENLSP IS-M: Agency Lock Indicator XARSPE CHAR 1 0
X Yes
NULL No
AGEN_ART IS-M: Creative Boutique Indicator XAGEN_KREA CHAR 1 0
X Yes
NULL No
AGEN_STR IS-M: Distribution Agency Indicator XAGEN_STR CHAR 1 0
X Yes
NULL No
AGEN_PLAN IS-M: Planning Agency Indicator XAGEN_PLAN CHAR 1 0
X Yes
NULL No
AGEN_GRU IS-M: Agency Type AGEN_GRUP CHAR 1 0
XDUB IS-M: No Longer Used - Credit Query Indicator XDUBIOS CHAR 1 0
X Yes
NULL No
GP_DUB IS-M: Credit Query Indicator JDUBIOS CHAR 1 0
BON IS-M: Creditworthiness Indicator JBONITAET CHAR 2 0
KLIM_EINZ IS-M: Individual Credit Limit JKLIMEINZ CURR 15 2
KLIM_GES IS-M: Total Credit Limit JKLIMGES CURR 15 2
KLIM_WAERS IS-M: Currency Key JWAERS CUKY 5 0
WBZKUNNR IS-M: WBZ, VDZ Number of WBZ Company JWBZKUNNR CHAR 6 0
RECHZENTNR IS-M: WBZ, Computer Center Number JWBZRZNR CHAR 2 0
JWBZKOMART IS-M: Communication Type in WBZ Processing JWBZKOMART CHAR 1 0
1 Data Medium Exchange
2 Telebox 400
XWBZFIRMA IS-M: Business Partner Is WBZ Company XWBZFIRMA CHAR 1 0
X Yes
NULL No
WBZZLSCH Payment Method for Billing Documents to WBZ Company WBZZLSCH CHAR 1 0
REFBELEG IS-M/SD: Reference Document in Legacy System REMELD_ISP CHAR 20 0
ADRNR IS-M: Address Number JADRNR CHAR 10 0
XISPCTEILN IS-M: Indicator: Business Partner Is EDI Participant XISPCTEILN CHAR 1 0
X Yes
NULL No
ISPCTEILN IS-M: EDI Participant Number ISPCTEILN NUMC 8 0
ISPCART IS-M: EDI Participant Type ISPCART NUMC 1 0
J_SOC_SECU Social Insurance Number J_SOC_SECU CHAR 20 0
XHOUSEHOLD IS-M: Household Indicator XHOUSEHOLD CHAR 1 0
X Yes
NULL No
ADDR_CONV Time-Dependent Business Partner Addresses Converted ISM_ADDR_CONV CHAR 1 0
NULL Time Dependency: Addresses Not Yet Converted
X Time Dependency: Addresses Converted
AKTDB Activity in database for primary table BUT000 BU_AKTDB CHAR 2 0
JGTEUWV RJGBP_JGTEUWV_STAT_STR STRU 0 0
MANDT Client MANDT CLNT 3 0
EWKUN IS-M: Retailer EWKUN CHAR 10 0
ERFUSER Created By ERFUSER CHAR 12 0
ERFDATE Created On ERFDATE DATS 8 0
ERFTIME Time Created ERFTIME TIMS 6 0
AENUSER Last Changed By AENUSER CHAR 12 0
AENDATE Date of Last Change AENDATE DATS 8 0
AENTIME Time of Last Change AENTIME TIMS 6 0
XEUWLOE IS-M: Deletion Indicator (Role-Specific) XLOESCHKZ CHAR 1 0
X Yes
NULL No
ANZMIT IS-M: Number of Retail Employees ANZMIT NUMC 5 0
EVKSTART IS-M: Point of Sale Category EVKSTART CHAR 2 0
EVKSTBEZ POS Type EVKSTBEZ CHAR 4 0
SEASON Season Indicator ISMPOSSEASON CHAR 2 0
CHAINCODE Retail Chain to Which POS Belongs ISMPOSCHAINCODE CHAR 10 0
CHAINCHANNEL Distribution Channel of Retail Chain to Which POS Belongs ISMPOSCHAINCHANNEL CHAR 10 0
CHAINID ID of POS in Retail Chain ISMPOSCHAINID CHAR 10 0
SHOPINSHOP IS-M: Shop in Shop Indicator ISMSHOPINSHOP CHAR 1 0
X Yes
NULL No
SHOPINSHOP_AREA POS Shelf Space - Shop-in-Shop ISMPOSSHOPINSHOP_SPACE CHAR 2 0
SHOP_CATEGORY Category of Main Business (Shop-in-Shop) ISMPOSSHOPBEZ CHAR 4 0
EVKFLAECHE IS-M: POS Area Key EVKFLAECHE CHAR 2 0
ISMGEOKATEGORIE Geography Category (Geographical Location) for Point of Sale ISMGEOKATEGORIE CHAR 2 0
NO_OF_POS Number of POS with Same Address ISMPOSCOUNTER INT2 5 0
NO_OF_SUPPLIERS Number of Press Vendors for a Point of Sale ISMPOSSUPPLIER INT2 5 0
PRESS_SALESCAT Type of Press Products ISMPOSPRESSSALESCATEGORY CHAR 5 0
PRESS_SALESVOL Weekly Press Sales ISMPOSPRESSSALESVOLUME CHAR 5 0
IUMSEINFL Internal (Primary) Influencing Factor for POS Sales IUMSEINFL CHAR 2 0
IUMSEINFL2 Internal (Secondary) Influencing Factor for POS Sales IUMSEINFL2 CHAR 2 0
IUMSEINFL3 Internal (Tertiary) Influencing Factor for POS Sales IUMSEINFL3 CHAR 2 0
EUMSEINFL External Sales Influence at POS (Primary) EUMSEINFL CHAR 2 0
EUMSEINFL2 External (Secondary) Influencing Factor for POS Sales EUMSEINFL2 CHAR 2 0
EUMSEINFL3 External (Tertiary) Influencing Factor for POS Sales EUMSEINFL3 CHAR 2 0
EFREQUENZ IS-M: POS Customer Frequency per Week EFREQUENZ CHAR 1 0
EFREQUENCE_ORIG POS: Origin of Customer Frequency ISMPOSEFREQUENZORIGIN CHAR 2 0
CASH_SCANNER Scanner Cash Desk at Point of Sale ISMCASHSCAN CHAR 1 0
SALES_COUNTER Sales Counter at Point of Sale ISMPOSSALESCOUNTER CHAR 1 0
1 Exists, Used for Press Products
2 Exists, Not Used for Press Products
3 Do(es) Not Exist
EBEDIENART Service Type at Point of Sale EBEDIENART CHAR 1 0
ISMNUMBERPOSTERS Number of Advertising Spaces at Point of Sale ISMNUMBERPOSTERS INT2 5 0
ISMPLANCALENDER Planning Calendar for Point of Sale ISMPLANCALENDER CHAR 2 0
BUSINESSHOURS_ID Business Hours ID (Default Number) ISMPOSBUSINESSHOURSID CHAR 3 0
OPEN_MOR_MO Business Hours: Monday Mornings From ISMPOSOPENMO1 TIMS 6 0
CLOSE_MOR_MO Business Hours: Monday Mornings To ISMPOSCLOSEMO1 TIMS 6 0
OPEN_AFT_MO Business Hours: Monday Afternoons From ISMPOSOPENMO2 TIMS 6 0
CLOSE_AFT_MO Business Hours: Monday Afternoons To ISMPOSCLOSEMO2 TIMS 6 0
OPEN_MOR_TU Business Hours: Tuesday Mornings From ISMPOSOPENTU1 TIMS 6 0
CLOSE_MOR_TU Business Hours: Tuesday Mornings To ISMPOSCLOSETU1 TIMS 6 0
OPEN_AFT_TU Business Hours: Tuesday Afternoons From ISMPOSOPENTU2 TIMS 6 0
CLOSE_AFT_TU Business Hours: Tuesday Afternoons To ISMPOSCLOSETU2 TIMS 6 0
OPEN_MOR_WE Business Hours: Wednesday Mornings From ISMPOSOPENWE1 TIMS 6 0
CLOSE_MOR_WE Business Hours: Wednesday Mornings To ISMPOSCLOSEWE1 TIMS 6 0
OPEN_AFT_WE Business Hours: Wednesday Afternoons From ISMPOSOPENWE2 TIMS 6 0
CLOSE_AFT_WE Business Hours: Wednesday Afternoons To ISMPOSCLOSEWE2 TIMS 6 0
OPEN_MOR_TH Business Hours: Thursday Mornings From ISMPOSOPENTH1 TIMS 6 0
CLOSE_MOR_TH Business Hours: Thursday Mornings To ISMPOSCLOSETH1 TIMS 6 0
OPEN_AFT_TH Business Hours: Thursday Afternoons From ISMPOSOPENTH2 TIMS 6 0
CLOSE_AFT_TH Business Hours: Thursday Afternoons To ISMPOSCLOSETH2 TIMS 6 0
OPEN_MOR_FR Business Hours: Friday Mornings From ISMPOSOPENFR1 TIMS 6 0
CLOSE_MOR_FR Business Hours: Friday Mornings To ISMPOSCLOSEFR1 TIMS 6 0
OPEN_AFT_FR Business Hours: Friday Afternoons From ISMPOSOPENFR2 TIMS 6 0
CLOSE_AFT_FR Business Hours: Friday Afternoons To ISMPOSCLOSEFR2 TIMS 6 0
OPEN_MOR_SA Business Hours: Saturday Mornings From ISMPOSOPENSA1 TIMS 6 0
CLOSE_MOR_SA Business Hours: Saturday Mornings To ISMPOSCLOSESA1 TIMS 6 0
OPEN_AFT_SA Business Hours: Saturday Afternoons From ISMPOSOPENSA2 TIMS 6 0
CLOSE_AFT_SA Business Hours: Saturday Afternoons To ISMPOSCLOSESA2 TIMS 6 0
OPEN_MOR_SU Business Hours: Sunday Mornings From ISMPOSOPENSU1 TIMS 6 0
CLOSE_MOR_SU Business Hours: Sunday Mornings To ISMPOSCLOSESU1 TIMS 6 0
OPEN_AFT_SU Business Hours: Sunday Afternoons From ISMPOSOPENSU2 TIMS 6 0
CLOSE_AFT_SU Business Hours: Sunday Afternoons To ISMPOSCLOSESU2 TIMS 6 0
OEFFZT IS-M: Point of Sale Opening Time OEFFZT CHAR 1 0
SCHLZT IS-M: POS Closing Time SCHLZT CHAR 1 0
OEFFMO IS-M: Opening Type Monday OEFFMO CHAR 1 0
OEFFDI IS-M: Opening Type Tuesday OEFFDI CHAR 1 0
OEFFMI IS-M: Opening Type Wednesday OEFFMI CHAR 1 0
OEFFDO IS-M: Opening Type Thursday OEFFDO CHAR 1 0
OEFFFR IS-M: Opening Type Friday OEFFFR CHAR 1 0
OEFFSA IS-M: Opening Type Saturday OEFFSA CHAR 1 0
OEFFSO IS-M: Opening Type Sunday OEFFSO CHAR 1 0
XLOTTO IS-M: Lottery Agent Indicator XLOTTO CHAR 1 0
X Yes
NULL No
MBRSYS IS-M: Automatic Payment System MBRSYS CHAR 2 0
BAGNR IS-M: BAG Transaction Number BAGNR CHAR 5 0
ISPCNR IS-M: ISPC Number ISPCNR CHAR 10 0
XISPCTEILN IS-M: Indicator: Business Partner Is EDI Participant XISPCTEILN CHAR 1 0
X Yes
NULL No
ISPCTEILN IS-M: EDI Participant Number ISPCTEILN NUMC 8 0
ISPCART IS-M: EDI Participant Type ISPCART NUMC 1 0
VDZNR IS-M: VDZ Number VDZNR CHAR 20 0
RECALLCALENDER Recall Calendar ISM_RC_CALENDER CHAR 2 0
RC_ALLOWED_MO Recall Allowed on Monday ISM_RC_ALLOWED_MO CHAR 1 0
X Yes
NULL No
RC_ALLOWED_TU Recall Allowed on Tuesday ISM_RC_ALLOWED_TU CHAR 1 0
X Yes
NULL No
RC_ALLOWED_WD Recall Allowed on Wednesday ISM_RC_ALLOWED_WD CHAR 1 0
X Yes
NULL No
RC_ALLOWED_TH Recall Allowed on Thursday ISM_RC_ALLOWED_TH CHAR 1 0
X Yes
NULL No
RC_ALLOWED_FR Recall Allowed on Friday ISM_RC_ALLOWED_FR CHAR 1 0
X Yes
NULL No
RC_ALLOWED_SA Recall Allowed on Saturday ISM_RC_ALLOWED_SA CHAR 1 0
X Yes
NULL No
RC_ALLOWED_SU Recall Allowed on Sunday ISM_RC_ALLOWED_SU CHAR 1 0
X Yes
NULL No
RECALLGROUP Recall Group JKSDRECALLGROUP CHAR 4 0
VERKGB IS-M: Sales Region VERKGB CHAR 50 0
VGEINW IS-M: Population of Sales Area VGEINW NUMC 10 0
XREMRECHT IS-M: Right of Return XREMRECHT CHAR 1 0
X Yes
NULL No
REMART Return Type REMART CHAR 1 0
1 Single Issue Return
2 Summarized Return
3 Summarized Return with Advance Return
REMWEISE Return Method REMWEISE CHAR 1 0
1 Certificated Return
2 Full-Copy Return
REMSP IS-M: Billing Block for Return Notification REMSP CHAR 1 0
X Yes
NULL No
KOMMENT IS-M: Comment 50 Characters in Length KOMM50 CHAR 50 0
RETURNGPNR IS-M: Retailer EWKUN CHAR 10 0
LAST_CHANGE Time Stamp of Last Change for BI Delta Exchange ISM_BI_DELTA_TIMESTAMP DEC 15 0
AKTDB Activity in database for primary table BUT000 BU_AKTDB CHAR 2 0
JGTEUWVV RJGBP_JGTEUWVV_STAT_TAB TTYP 0 0
JGTPOSAID RJGBP_JGTPOSAID_STAT_TAB TTYP 0 0
JJTVM RJGBP_JJTVM_STAT_TAB TTYP 0 0
JGTADRA RJGBP_JGTADRA_STAT_TAB TTYP 0 0
JGTSADR RJGBP_JGTSADR_STAT_TAB TTYP 0 0
CUST RJGBUSISM007_CUST_STAT_STR STRU 0 0
KNA1 RJGBP_KNA1_STAT_STR STRU 0 0
MANDT Client MANDT CLNT 3 0
KUNNR Customer Number KUNNR CHAR 10 0
LAND1 Country Key LAND1_GP CHAR 3 0
NAME1 Name 1 NAME1_GP CHAR 35 0
NAME2 Name 2 NAME2_GP CHAR 35 0
ORT01 City ORT01_GP CHAR 35 0
PSTLZ Postal Code PSTLZ CHAR 10 0
REGIO Region (State, Province, County) REGIO CHAR 3 0
SORTL Sort field SORTL CHAR 10 0
STRAS House number and street STRAS_GP CHAR 35 0
TELF1 First telephone number TELF1 CHAR 16 0
TELFX Fax Number TELFX CHAR 31 0
XCPDK Indicator: Is the account a one-time account? XCPDK CHAR 1 0
X Yes
NULL No
ADRNR Address ADRNR CHAR 10 0
MCOD1 Search term for matchcode search MCDD1 CHAR 25 0
MCOD2 Search Term for Matchcode Search MCDD2 CHAR 25 0
MCOD3 Search term for matchcode search MCDD3 CHAR 25 0
ANRED Title ANRED CHAR 15 0
AUFSD Central order block for customer AUFSD_X CHAR 2 0
BAHNE Express train station BAHNE CHAR 25 0
BAHNS Train station BAHNS CHAR 25 0
BBBNR International location number (part 1) BBBNR NUMC 7 0
BBSNR International location number (Part 2) BBSNR NUMC 5 0
BEGRU Authorization Group BRGRU CHAR 4 0
BRSCH Industry key BRSCH CHAR 4 0
BUBKZ Check digit for the international location number BUBKZ NUMC 1 0
DATLT Data communication line no. DATLT CHAR 14 0
ERDAT Date on which the Record Was Created ERDAT_RF DATS 8 0
ERNAM Name of Person who Created the Object ERNAM_RF CHAR 12 0
EXABL Indicator: Unloading points exist EXABL CHAR 1 0
X Yes
NULL No
FAKSD Central billing block for customer FAKSD_X CHAR 2 0
FISKN Account number of the master record with the fiscal address FISKN_D CHAR 10 0
KNAZK Working Time Calendar KNAZK CHAR 2 0
KNRZA Account number of an alternative payer KNRZA CHAR 10 0
KONZS Group key KONZS CHAR 10 0
KTOKD Customer Account Group KTOKD CHAR 4 0
KUKLA Customer classification KUKLA CHAR 2 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
LIFSD Central delivery block for the customer LIFSD_X CHAR 2 0
LOCCO City Coordinates LOCCO CHAR 10 0
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
NAME3 Name 3 NAME3_GP CHAR 35 0
NAME4 Name 4 NAME4_GP CHAR 35 0
NIELS Nielsen ID NIELS CHAR 2 0
ORT02 District ORT02_GP CHAR 35 0
PFACH PO Box PFACH CHAR 10 0
PSTL2 P.O. Box Postal Code PSTL2 CHAR 10 0
COUNC County Code COUNC CHAR 3 0
CITYC City Code CITYC CHAR 4 0
RPMKR Regional Market RPMKR CHAR 5 0
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No
SPRAS Language Key SPRAS LANG 1 0
STCD1 Tax Number 1 STCD1 CHAR 16 0
STCD2 Tax Number 2 STCD2 CHAR 11 0
STKZA Indicator: Business Partner Subject to Equalization Tax? STKZA CHAR 1 0
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
TELBX Telebox number TELBX CHAR 15 0
TELF2 Second telephone number TELF2 CHAR 16 0
TELTX Teletex number TELTX CHAR 30 0
TELX1 Telex number TELX1 CHAR 30 0
LZONE Transportation zone to or from which the goods are delivered LZONE CHAR 10 0
XZEMP Indicator: Is an alternative payer allowed in document? XREGU CHAR 1 0
X Yes
NULL No
VBUND Company ID of trading partner RASSC CHAR 6 0
STCEG VAT Registration Number STCEG CHAR 20 0
DEAR1 Indicator: Competitor DEAR1 CHAR 1 0
X Yes
NULL No
DEAR2 Indicator: Sales partner DEAR2 CHAR 1 0
X Yes
NULL No
DEAR3 Indicator: Sales prospect DEAR3 CHAR 1 0
X yes
NULL No
DEAR4 Indicator for customer type 4 DEAR4 CHAR 1 0
X Yes
NULL No
DEAR5 ID for default sold-to party DEAR5 CHAR 1 0
X Yes
NULL No
GFORM Legal status GFORM CHAR 2 0
BRAN1 Industry Code 1 BRAN1_D CHAR 10 0
BRAN2 Industry code 2 BRAN2 CHAR 10 0
BRAN3 Industry code 3 BRAN3 CHAR 10 0
BRAN4 Industry code 4 BRAN4 CHAR 10 0
BRAN5 Industry code 5 BRAN5 CHAR 10 0
EKONT Initial contact EKONT CHAR 10 0
UMSAT Annual sales UMSAT CURR 8 2
UMJAH Year For Which Sales are Given UMJAH NUMC 4 0
UWAER Currency of sales figure UWAER CUKY 5 0
JMZAH Yearly number of employees JMZAH NUMC 6 0
JMJAH Year for which the number of employees is given JMJAH NUMC 4 0
KATR1 Attribute 1 KATR1 CHAR 2 0
KATR2 Attribute 2 KATR2 CHAR 2 0
KATR3 Attribute 3 KATR3 CHAR 2 0
KATR4 Attribute 4 KATR4 CHAR 2 0
KATR5 Attribute 5 KATR5 CHAR 2 0
KATR6 Attribute 6 KATR6 CHAR 3 0
KATR7 Attribute 7 KATR7 CHAR 3 0
KATR8 Attribute 8 KATR8 CHAR 3 0
KATR9 Attribute 9 KATR9 CHAR 3 0
KATR10 Attribute 10 KATR10 CHAR 3 0
STKZN Natural Person STKZN CHAR 1 0
X Natural person
NULL Legal person
UMSA1 Annual sales UMSA1 CURR 15 2
TXJCD Tax Jurisdiction TXJCD CHAR 15 0
PERIV Fiscal Year Variant PERIV CHAR 2 0
ABRVW Usage Indicator ABRVW CHAR 3 0
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) QINSPBYDEB CHAR 1 0
NULL Indicator is not set
X Indicator is set
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery QINSPATDEB CHAR 1 0
NULL Indicator is not set
X Indicator is set
KTOCD Reference Account Group for One-Time Account (Customer) KTOCD CHAR 4 0
PFORT PO Box city PFORT_GP CHAR 35 0
WERKS Plant WERKS_D CHAR 4 0
DTAMS Indicator for Data Medium Exchange DTAMS CHAR 1 0
1 Single data record not to be forwarded to the Bundesbank
0 Single data record can be forwarded to the Bundesbank
NULL Use house bank default value
DTAWS Instruction key for data medium exchange DTAWS CHAR 2 0
DUEFL Status of Data Transfer into Subsequent Release DUEFL_BKPF CHAR 1 0
NULL Not transferred yet
A Transfer taken place, document changed later
X Transfer taken place, document unchanged
HZUOR Assignment to Hierarchy HZUOR NUMC 2 0
SPERZ Payment Block SPERZ CHAR 1 0
X Yes
NULL No
ETIKG IS-R Labeling: customer/plant group ETIKG CHAR 10 0
CIVVE ID for mainly non-military use CIVVE CHAR 1 0
X Yes
NULL No
MILVE ID for mainly military use MILVE CHAR 1 0
X Yes
NULL No
KDKG1 Customer condition group 1 KDKG1 CHAR 2 0
KDKG2 Customer condition group 2 KDKG2 CHAR 2 0
KDKG3 Customer condition group 3 KDKG3 CHAR 2 0
KDKG4 Customer condition group 4 KDKG4 CHAR 2 0
KDKG5 Customer condition group 5 KDKG5 CHAR 2 0
XKNZA Indicator: Alternative payer using account number XKNZA CHAR 1 0
X Yes
NULL No
FITYP Tax type J_1AFITP_D CHAR 2 0
STCDT Tax Number Type J_1ATOID CHAR 2 0
STCD3 Tax Number 3 STCD3 CHAR 18 0
STCD4 Tax Number 4 STCD4 CHAR 18 0
STCD5 Tax Number 5 STCD5 CHAR 60 0
XICMS Customer is ICMS-exempt J_1BTCICMS CHAR 1 0
X Yes
NULL No
XXIPI Customer is IPI-exempt J_1BTCIPI CHAR 1 0
X Yes
NULL No
XSUBT Customer group for Substitui�ao Tribut�ria calculation J_1BTCST CHAR 3 0
CFOPC Customer's CFOP category J_1BINDUS1 CHAR 2 0
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 non-contributing customer
07 agricultural customer
08 trading company
09 producer establishment
TXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 0
TXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 0
CCC01 Indicator for biochemical warfare for legal control CCC01 CHAR 1 0
X Yes
NULL No
CCC02 Indicator for nuclear nonproliferation for legal control CCC02 CHAR 1 0
X Yes
NULL No
CCC03 Indicator for national security for legal control CCC03 CHAR 1 0
X Yes
NULL No
CCC04 Indicator for missile technology for legal control CCC04 CHAR 1 0
X Yes
NULL No
CASSD Central sales block for customer CASSD_X CHAR 2 0
KNURL Uniform Resource Locator URL CHAR 132 0
J_1KFREPRE Name of Representative REPRES CHAR 10 0
J_1KFTBUS Type of Business GESTYP CHAR 30 0
J_1KFTIND Type of Industry INDTYP CHAR 30 0
CONFS Status of Change Authorization (Central) CONFS_X CHAR 1 0
UPDAT Date on Which the Changes Were Confirmed UPDAT_RF DATS 8 0
UPTIM Time of Last Change Confirmation UPTIM_RF TIMS 6 0
NODEL Central deletion block for master record NODEL_X CHAR 1 0
X Yes
NULL No
DEAR6 Indicator: Consumer DEAR6 CHAR 1 0
X Yes
NULL No
SUFRAMA Suframa Code J_1BSUFRAMA CHAR 9 0
RG RG Number J_1BRG CHAR 11 0
EXP Issued by J_1BEXP CHAR 3 0
UF State J_1BUF CHAR 2 0
RGDATE RG Issue Date J_1BRGDATE DATS 8 0
RIC RIC Number J_1BRIC NUMC 11 0
RNE Foreign National Registration J_1BRNE CHAR 10 0
RNEDATE RNE Issue Date J_1BRNEDATE DATS 8 0
CNAE CNAE J_1BCNAE CHAR 7 0
LEGALNAT Legal Nature J_1BLEGALNAT NUMC 4 0
CRTN CRT Number J_1BCRTN CHAR 1 0
1 Simples Nacional
2 Simples Nacional � excesso de sublimite da receita bruta
3 Regime Normal (n�o simples)
ICMSTAXPAY ICMS Taxpayer J_1BICMSTAXPAY CHAR 2 0
INDTYP Industry Main Type J_1BINDTYP CHAR 2 0
TDT Tax Declaration Type J_1BTDT CHAR 2 0
COMSIZE Company Size J_1BCOMSIZE CHAR 2 0
DECREGPC Declaration Regimen for PIS/COFINS J_1BDECREGPC CHAR 2 0
/VSO/R_PALHGT Maximum Stacking Height of the Packaging Material (VSO) /VSO/R_PAL_BIN_HGT QUAN 13 3
/VSO/R_PAL_UL Unit of Length for Packaging Material (VSO) /VSO/R_PAL_UNIT_L UNIT 3 0
/VSO/R_PK_MAT Customer-Related Packing for Each Packaging Material (VSO) /VSO/M_PACK_BY_MAT CHAR 1 0
NULL No
X Yes
/VSO/R_MATPAL Packaging Material of the Customer in VSO /VSO/M_MATNR_PAL CHAR 18 0
/VSO/R_I_NO_LYR Number Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYR NUMC 2 0
/VSO/R_ONE_MAT Packing Material-Specific for Each Packaging Material /VSO/M_ONE_MAT CHAR 1 0
NULL No
X Yes
/VSO/R_ONE_SORT Pack Only One Package Type for Each PKM (VSO) /VSO/M_ONE_SORT CHAR 1 0
NULL No
X Yes
/VSO/R_ULD_SIDE Side Preference of Loading/Unloading (VSO) /VSO/M_UNLOAD_SIDE_PREF NUMC 1 0
0 none
1 Left
2 Right
/VSO/R_LOAD_PREF Front/Back Preference of Loading/Unloading (VSO) /VSO/M_LOAD_PREF NUMC 1 0
0 none
1 Front
2 Back
/VSO/R_DPOINT Collective Unloading Point for VSO /VSO/R_DELIVERYPOINT CHAR 10 0
/XLSO/CUSTOMER Data element to differentiate customer /XLSO/E_CUSTOMER CHAR 1 0
L Learner
C Company Customer
R Reference Customer
/XLSO/SYSID Name of SAP System SYSYSID CHAR 8 0
/XLSO/CLIENT Client MANDT CLNT 3 0
/XLSO/PARTNER Business Partner Number BU_PARTNER CHAR 10 0
/XLSO/PREF_PAY Version Number Component CHAR2 CHAR 2 0
ALC Agency Location Code FMFG_ALC CHAR 8 0
PMT_OFFICE Payment Office FMFG_PMT_OFF CHAR 5 0
FEE_SCHEDULE Fee schedule FM_FEE_SCHED CHAR 4 0
DUNS DUNS Number FMCCRDUNS CHAR 9 0
DUNS4 DUNS+4 FMCCRDUNS4 CHAR 4 0
PSOFG Processor group PSOFG CHAR 10 0
PSOIS Subledger acct preprocessing procedure PSOIS CHAR 20 0
PSON1 Name 1 NAME1_GP CHAR 35 0
PSON2 Name 2 NAME2_GP CHAR 35 0
PSON3 Name 3 NAME3_GP CHAR 35 0
PSOVN First Name PSOVN CHAR 35 0
PSOTL Title PSOTL CHAR 20 0
PSOHS House number: is no longer used from Release 4.6B PSOHS CHAR 6 0
PSOST Street: No longer used from Release 4.6B PSOST CHAR 28 0
PSOO1 Description PSOO1 CHAR 50 0
PSOO2 Description PSOO1 CHAR 50 0
PSOO3 Description PSOO1 CHAR 50 0
PSOO4 Description PSOO1 CHAR 50 0
PSOO5 Description PSOO1 CHAR 50 0
OIDRC Differential Reference Code (DRC) OIC_DRC CHAR 5 0
OID_POREQD Purchase order required: X = Yes, Blank = No OID_POREQD CHAR 1 0
X Yes
NULL No
OIPBL Business location identifier (IS-Oil MRN) OIF_PBLNR CHAR 10 0
RES_CNTRY CHAR 3 0
CCODE CHAR 4 0
AKTDB Activity in database for primary table BUT000 BU_AKTDB CHAR 2 0
KNB1 RJGBP_KNB1_STAT_TAB TTYP 0 0
KNVV RJGBP_KNVV_STAT_TAB TTYP 0 0
KNB5 RJGBP_KNB5_STAT_TAB TTYP 0 0
KNVI RJGBP_KNVI_STAT_TAB TTYP 0 0