SAP Table SPROVIDER

ISU-deregulation: transfer structure for service provider

SPROVIDER (ISU-deregulation: transfer structure for service provider) 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 SPROVIDER to other SAP tables.

SPROVIDER table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
SERVICEID Service Provider SERVICE_PROV CHAR 10 0
PROV_BUKRS Company Code of Service Provider BUKRS_PR CHAR 4 0
SERVICE Service Type SERCODE CHAR 4 0
EXTERNALID External Number DUNSNR CHAR 20 0
OWN_LOG_SYS Service Provider is Managed in Own System OWN_LOG_SYS CHAR 1 0
NULL Field not active
X Field active
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
BEGRU Authorization Group BEGRU CHAR 4 0
LOEVM Deletion Indicator LOEVM CHAR 1 0
X Yes
NULL No
SEC_EXT_ID Second External Number E_EDMIDEEXTNUM CHAR 20 0
SEC_EXT_IDTYP Category of External Number E_EDMIDEEXTNUMTYP NUMC 2 0
EXTERNALIDTYP Category of External Number E_EDMIDEEXTNUMTYP NUMC 2 0
LIFNR Account Number of Vendor or Creditor LIFNR LFA1 CHAR 10 0
BPART Business Partner Number BU_PARTNER CHAR 10 0
SERVICETEXT Text (30 Characters) TEXT30 CHAR 30 0
SERVICETYPETEXT Text length 25 TEXT25 CHAR 25 0
DIVISION Division SPARTE CHAR 2 0
INTCODE Service Category INTCODE CHAR 2 0
01 Distribution
02 Supply
03 Clearing House
04 Settlement Coordination
05 Technical Service Provider
NULL Not Specified
SEND_RECEIVE IDE: indicator for communication - sender/recipient SEND_RECEIVE CHAR 2 0
EXTERNAL_COMM External communication active EXTERNAL_COMM CHAR 1 0
NULL Field not active
X Field active

SPROVIDER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SPROVIDER LIFNR SPROVIDER MANDT LFA1 Vendor Master (General Section) MANDT
SPROVIDER LIFNR SPROVIDER LIFNR LFA1 Vendor Master (General Section) LIFNR
SPROVIDER MANDT SPROVIDER MANDT T000 Clients MANDT