🦅Mastering SAP BW DataSource Tables [The Definitive Guide]

Welcome!
By Felipe Lamounier, state of Minas Gerais, Brazil – powered by 🙂My Easy B.I.

🏁 Introduction:

Which BW consultant has never asked himself this question:

How to find out if there is already an extractor (datasource) created for a certain transaction or table field?
How to know which fields are available for LBWE 2LIS datasource?
How can I speed up my work of searching and identifying DataSource and its fields and avoid creating redundant objects

In this article I will show the tables related to BW DataSource (extractors) that will guide you to get the answers!

🔭 See also Related Posts:

📚E-book: SAP BW and 2LIS Delta DataSource: How to Enhance without ECC PRD system downtime and Delta lost ↗ [The secret that not even SAP teaches you!]

🚀Go to↗ amazon.com

📑 Index:

Summary of tables
ROOSOURCE – Table Header for SAP BW OLTP Sources
ROOSFIELD – DataSource Fields
RODELTAM – BW Delta Process
TMCEXACT – LO Data Extraction: Activate Data Sources/Update
TMCEXCFS – LO Data Extraction: Field Status of Communication Structures
TMCEXCFZ – LO Data Extraction: Field Status Comm. Structures (Customer)
RSDSSEG – DataSource – Segments
RSDSSEGFD – DataSource – Segment Fields
RSDSSEGFDT – DataSource – Texts for Segment Fields

Anúncios

🔭 See also Pages:
🏠Home Page
💡Blog

🎓🚀Training&Education
🖼️Site Image Gallery

Want to learn more? Access our area 🎓🚀Training&Education↗

📖 Content:

Summary of tables

DataSource (Extractor)	Description (en-us)	Description (pt-br)	System	Comments
ROOSOURCE	Table Header for SAP BW OLTP Sources	Tab.cabeçalho p/OLTPSources BW SAP	ECC	BW DataSource Metadata
ROOSFIELD	DataSource Fields	Campos de uma DataSource	ECC	Find in which DataSource contains the Field
RODELTAM	BW Delta Process	Processo delta BW	ECC	Delta Mode Metadata
TMCEXACT	LO Data Extraction: Activate Data Sources/Update	Extração dados LO: ativação DataSources/atualização	ECC	LBWE Delta DataSource
TMCEXCFS	LO Data Extraction: Field Status of Communication Structures	Extração dados LO: status do campo estruturas de comunicação	ECC	LBWE – Value of ESTRUC and search the DataSource in table TMCEXACT
TMCEXCFZ	LO Data Extraction: Field Status Comm. Structures (Customer)	Extração dados LO: status campo estrs.comunicação (cliente)	ECC	LBWE Delta DataSource
RSDSSEG	DataSource – Segments	DataSource – Segmentos	BW	Table of PSA (DataSource). Concatenate 000 in PSA field
RSDSSEGFD	DataSource – Segment Fields	DataSource – Campos de segmento	BW	Field DS in BW. Text table: RSDSSEGFDT
RSDSSEGFDT	DataSource – Texts for Segment Fields	DataSource – Textos para campos de segmento	BW
RSOSFIELDMAP	Mapping Between OLTP Source Fields and InfoObjects	Mapeamento entre campos OltpSource e InfoObjetos	BW
RSKSFIELDNEW	Fields for New InfoSource	Campos do novo InfoSource	BW

SAP BW and ECC tables related to Extractors (Data Source)

ROOSOURCE – Table Header for SAP BW OLTP Sources

Main Fields	Description (en-us)	Description (pt-br)
🔑OLTPSOURCE	DataSource (OSOA/OSOD)	DataSource (OSOA/OSOD)
🔑OBJVERS	OLTP Source Version	Versão de uma OLTP Source
TYPE	DataSource Type	Categoria de um DataSource
APPLNM	Application Component	Componente de aplicação
DELTA	Delta Process for a DataSource	Procedimento delta de um DataSource
INITSIMU	DataSource Controls the Delta Init Simulation Mode	DataSource domina modo simulação DeltaInit
ZDD_ABLE	Indicator: DataSource Can Post During Delta Init	Código: DataSource pode lançar delta durante inicialização
EXMETHOD	DataSource Extraction Method	Método de extração de uma DataSource
EXTRACTOR	DataSource Extractor	Extrator de uma DataSource
EXSTRUCT	Name of the provider structure for an InfoSource	Nome da estrutura oferente para um InfoSource
GENFLAG	DataSource uses generic interfaces	A DataSource utiliza a interface genérica
TSTPNM	Last Changed By	Último modificador
TSTPDAT	Changed On	Data de modificação
TSTPTIM	Changed at	Hora da modificação
INVFIELD	Field That Transfers Record Mode	Campo que transfere modo de registro

ROOSOURCE table structure: main fields

Anúncios

table ROOSOURCE data preview sample in SAP with table fields OLTPSOURCE, TYPE, APPLNM, DELTA, EXMETHOD, EXTRACTOR, EXSTRUCT — ROOSOURCE data preview sample

ROOSFIELD – DataSource Fields

Main Fields	Description (en-us)	Description (pt-br)
🔑OLTPSOURCE	DataSource (OSOA/OSOD)	DataSource (OSOA/OSOD)
🔑OBJVERS	OLTP Source Version	Versão de uma OLTP Source
🔑FIELD	Field Name	Nome do campo
SELECTION	Properties of a DataSource Field

ROOSFIELD table structure: main fields

transaction SE16 in SAP, table ROOSFIELD data preview sample with table fields OLTPSOURCE, FIELD, F4EXTRAKT, KEYFLAG_DS and SELOPTS — ROOSFIELD data preview sample

RODELTAM – BW Delta Process

Fields	Description (en-us)	Description (pt-br)
🔑DELTA	Delta Process for a DataSource	Procedimento delta de um DataSource
ONLYFULL	BW Delta Process: Using Full Update Only	Procedimento delta: somente via atualização completa
UPDM_NIM	BW Data Process: Create with New Image	Procedimento delta BW: criar com New-Image
UPDM_BIM	BW Delta Process: Delivering Before-Image	Processo delta BW: Before-Image sendo fornecida
UPDM_AIM	BW Delta Process: Delivering After-Image	Processo delta BW: After-Image sendo fornecida
UPDM_ADD	BW Delta Process: Additive	Procedimento delta BW: adicional
UPDM_DEL	BW Delta Process: Delivering Deletion ID	Procedimento delta BW: código eliminação sendo fornecido
UPDM_RIM	BW Delta Process: Deletion with Reverse-Image	Processo delta BW: eliminação c/Reverse-Image
DREQSER	BW Delta Process: Serialization Request	Processo delta BW: solicitação de serialização
DELTATYPE	BW Delta Process: Process Type	Procedimento delta BW: tipo de procedimento

RODELTAM table structure: fields

transaction SE16 in SAP, table RODELTAM data preview with table fields DELTA, ONLYFULL, UPDM_NIM, UPDM_BIM, UPDM_AIM, UPDM_ADD, DREQSER, DELTATYPE and TXTLG — RODELTAM data preview

TMCEXACT – LO Data Extraction: Activate Data Sources/Update

Fields	Description (en-us)	Description (pt-br)
🔑ESTRUC	Field name in the generated DDIC structure	Nome do campo gerado na estrutura DDIC
ISOURCE	DataSource (OSOA/OSOD)	DataSource (OSOA/OSOD)
ISGEN	Flag: InfoSource was generated	Flag: InfoSource gerado
UPDACT	Indicator: Extraction structure updated	Código: estrutura de extração é atualizada
ADDHEADER	Additional header entry	Entrada adicional de cabeçalho
MCAPP	Number of application	Nº aplicação

TMCEXACT table structure: fields

transaction SE16 in SAP, table TMCEXACT data preview with table fields ESTRUC, ISOURCE, ISGEN, UPDACT, ADDHEADER and MCAPP — TMCEXACT data preview

TMCEXCFS – LO Data Extraction: Field Status of Communication Structures

Fields	Description (en-us)	Description (pt-br)
🔑CSTRUC	Source table	Tabela de origem
🔑FIELDNAME	Field Name	Nome do campo
🔑ESTRUC	Table Name	Nome da tabela
STATE	LO data extraction: Field status ‘Usage’	Extração de dados LO: status do campo ‘Utilização’
MCAPP	Number of application	Nº aplicação

TMCEXCFS table structure: fields

transaction SE16 in SAP, table TMCEXCFS data preview with table fields CSTRUC, FIDLNAME, ESTRUC, STATE and MCAPP — TMCEXCFS data preview

Anúncios

TMCEXCFZ – LO Data Extraction: Field Status Comm. Structures (Customer)

Fields	Description (en-us)	Description (pt-br)
🔑CSTRUC	Source table	Tabela de origem
🔑FIELDNAME	Field Name	Nome do campo
🔑ESTRUC	Table Name	Nome da tabela

TMCEXCFZ table structure: fields

transaction SE16 in SAP, table TMCEXCFZ data preview with table fields CSTRUC, FIELDNAME and ESTRUC — TMCEXCFZ data preview

RSDSSEG – DataSource – Segments

Fields	Description (en-us)	Description (pt-br)
🔑DATASOURCE	DataSource (OSOA/OSOD)	DataSource (OSOA/OSOD)
🔑LOGSYS	Source system	Sistema fonte
🔑OBJVERS	Object version	Versão de objeto
🔑SEGID	Segment	Segmento
LANGUFD	Field Name: Language Key	Nome do campo: código de idioma
DATEFROMFD	Field Name: Lower Limit of Validity	Nome de campo: limite inferior da validade
DATETOFD	Field Name: Upper Limit of Validity	Nome de campo: limite superior da validade
TRANSTRU_APPL	Table Name	Nome da tabela
TRANSTRU_CHAR	Table Name	Nome da tabela
PSA	Name of the Persistent Staging Area	Nome de Persistent Staging Area
PSAVERS	Version	Versão

RSDSSEG table structure: fields

transaction SE16 in SAP, table RSDSSEG data preview with table fields DATASOURCE, LOGSYS, SEGID, TRANSTRU_APPL, TRANSTRU_CHAR and PSA — RSDSSEG data preview

RSDSSEGFD – DataSource – Segment Fields

Fields	Description (en-us)	Description (pt-br)
🔑DATASOURCE	DataSource (OSOA/OSOD)	DataSource (OSOA/OSOD)
🔑LOGSYS	Source system	Sistema fonte
🔑OBJVERS	Object version	Versão de objeto
🔑SEGID	Segment	Segmento
🔑POSIT	Position of the Field in the Structure / Table	Posição do campo na estrutura / tabela
FIELDNM	Field name	Nome do campo
DATATYPE	Data type	Categoria de dados
LENG	Length (No. of Characters)	Comprimento (nº de caracteres)
SELECTION	Selection	Seleção
SELOPTS	Selection Options	Opções de seleção

RSDSSEGFD table structure: main fields

transaction SE16 in SAP, table RSDSSEGFD data preview with table fields DATASOURCE, LOGSYS, SEGID, POSIT, FIELDNM, DATATYPE and LENG — RSDSSEGFD data preview

RSDSSEGFDT – DataSource – Texts for Segment Fields

Fields	Description (en-us)	Description (pt-br)
🔑LANGU	Language Key
🔑DATASOURCE	DataSource (OSOA/OSOD)	DataSource (OSOA/OSOD)
🔑LOGSYS	Source system	Sistema fonte
🔑OBJVERS	Object version	Versão de objeto
🔑SEGID	Segment	Segmento
🔑POSIT	Position of the Field in the Structure / Table	Posição do campo na estrutura / tabela
FIELDNM	Field name	Nome do campo
TXTSH	Short description	Descrição breve
TXTMD	Medium description	Descrição média
TXTLG	Long description	Descrição longa

RSDSSEGFDT table structure: fields

Anúncios

transaction SE16 in SAP, table RSDSSEGFDT data preview with table fields LANGU, DATASOURCE, LOGSYS, SEGID, POSIT, FIELDNM, TXTSH, TXTMD and TXTLG — RSDSSEGFDT data preview

✅ Conclusion:

In this article we find out how to find the Where-used list of fields in DataSource looking for information in some key tables relationed to extractors process. Use these tables to search and Data Source identification in source system in order to speed up your Job!

Keywords: SAP BW; BW Data Source; BW DataSource; Mastering SAP BW Data Source Tables; Mastering SAP BW Extractors Tables; Search DataSource and fields; Search and identify SAP BW DataSource extractors; Mastering SAP BW DataSource Tables; Tabelas de DataSource BW

Did you like the content? Want to get more tips? Subscribe ↗ for free!

📚E-book: SAP BW and 2LIS Delta DataSource: How to Enhance without ECC PRD system downtime and Delta lost

🚀Go to↗ amazon.com

Follow on social media:

🕖 TIMESTAMP field in SAP BW: How to insert into Transformation routine
por felipelamounier
Learn how to add a TIMESTAMP field in SAP BW using an ABAP routine.
[SAP BW] Step-by-Step: Finding a BW Load Request from an SM37 Job
por felipelamounier
Learn how to find a load request from a job in SAP BW using SM37. Guide to identifying load requests in SAP BW jobs through the SM37 transaction. Understanding the process to find load requests in SAP BW using job transaction SM37.
💭Old and Current BI Paradigms: a brief reflection
por felipelamounier
In this brief reflection, we delve into the transformation of BI concepts, examining its roots and current trends. Follow this journey to understand how changes impact our strategies and decisions

🦅Mastering SAP BW DataSource Tables [The Definitive Guide]

🏁 Introduction:

📑 Index: