Skip to main content

Rapid deployment

Rapid deployment

Rapid deployment

This document focuses on the description and analysis of standard SAP S/4HANA extractors used in Crestone to retrieve information from transactional data across various system modules. Specifically, it will cover extractors from the Financial Accounting (FI), Materials Management (MM), Sales and Distribution (SD), Controlling (CO), Production Planning (PP), and Project System (PS) modules.

Details of each available extractor will be provided, including key fields that enable the extraction of specific information such as accounting transactions, material movements, production orders, costs, and project analysis. This document will serve as a technical guide for the proper use of these extractors in generating detailed reports and analysis within SAP S/4HANA, addressing financial, logistics, and operational management aspects.

Step by step to get to the extractors

Once inside Crestone, navigate to the Nodes section. Then, select the "Create New Node" option and click on "New Node."

This will take you to a page where you need to enter the name of the new node and then click the "Next" button. Next, click on "Select a connection for a source" and select the source you previously created with ABAP. Choosing ABAP is ideal because it is specifically designed to handle structured data from SAP modules. If your data comes from SAP's traditional ERP systems, ABAP ensures seamless integration with the existing business logic and processes. It allows you to manage the data more efficiently, leveraging the customizations and rules already implemented in your SAP system, without needing the complex setup required for HANA.

Then, click on "Select type" and choose "Extractor." Finally, search for an available extractor in Crestone, which can be found in this same document.

Modules

Financial Accounting

Materials Management

Sales and Distribution

Production Planning

Project System

Controlling

Financial Accounting

The SAP FI (Financial Accounting) module is a core component of the SAP ERP system that manages financial data and processes within an organization. It provides tools for handling general ledger accounting, accounts payable, accounts receivable, asset accounting, and financial reporting. SAP FI integrates seamlessly with other SAP modules, such as CO (Controlling) and MM (Materials Management), enabling real-time financial data management and supporting compliance with international accounting standards.

FI Master Data Extractors

a

Extractor: 0FI_GL_6 (General Ledger Master Data)

Field NameDescription
HKONTGeneral Ledger Account
BUKRSCompany Code
TXT20G/L Account Short Text
TXT50G/L Account Long Text
XLOEVDeletion Indicator for G/L Account
XSKATAccount Category
SPRASLanguage Key

Extractor: 0FI_GL_14 (General Ledger Balances)

Field NameDescription
HKONTGeneral Ledger Account
BUKRSCompany Code
GJAHRFiscal Year
MONATFiscal Period
DMBTRBalance in Local Currency
WRBTRBalance in Document Currency
WAERSDocument Currency
PRCTRProfit Center

Extractor: 0FI_AP_4 (Accounts Payable Master Data)

Field NameDescription
LIFNRVendor Number
BUKRSCompany Code
NAME1Vendor Name
LAND1Country
KTOKKVendor Account Group
XLOEVDeletion Indicator for Vendor
SPRASLanguage Key

Extractor: 0FI_AR_4 (Accounts Receivable Master Data)

Field NameDescription
KUNNRCustomer Number
BUKRSCompany Code
NAME1Customer Name
LAND1Country
KTOKDCustomer Account Group
XLOEVDeletion Indicator for Customer
SPRASLanguage Key

Extractor: 0FI_ACDOCA_20 (Universal Journal Master Data)

Field NameDescription
ACDOCA_IDUniversal Journal Line Item Identifier
HKONTGeneral Ledger Account
PRCTRProfit Center
SEGMENTSegment
MATNRMaterial Number
AUFNRInternal Order

FI Transactional Data Extractors

a

Extractor: 0FI_GL_4 (General Ledger Line Items)

Field NameDescription
BELNRDocument Number
BUKRSCompany Code
GJAHRFiscal Year
HKONTGeneral Ledger Account
WRBTRAmount in Document Currency
WAERSDocument Currency
DMBTRAmount in Local Currency
ZUONRAssignment
BSCHLPosting Key

Extractor: 0FI_AP_4 (Accounts Payable Line Items)

Field NameDescription
BELNRDocument Number
BUKRSCompany Code
GJAHRFiscal Year
LIFNRVendor Number
WRBTRAmount in Document Currency
WAERSDocument Currency
DMBTRAmount in Local Currency
ZUONRAssignment
BSCHLPosting Key
SGTXTDocument Text

Extractor: 0FI_AR_4 (Accounts Receivable Line Items)

Field NameDescription
BELNRDocument Number
BUKRSCompany Code
GJAHRFiscal Year
KUNNRCustomer Number
WRBTRAmount in Document Currency
WAERSDocument Currency
DMBTRAmount in Local Currency
ZUONRAssignment
BSCHLPosting Key
SGTXTDocument Text

Extractor: 0FI_ACDOCA_10 (Universal Journal Line Items)

Field NameDescription
BELNRDocument Number
BUKRSCompany Code
GJAHRFiscal Year
HKONTGeneral Ledger Account
WRBTRAmount in Document Currency
WAERSDocument Currency
DMBTRAmount in Local Currency
PRCTRProfit Center
SEGMENTSegment
MATNRMaterial Number
AUFNRInternal Order

Materials Management

The SAP MM (Materials Management) module is a core part of the SAP ERP system designed to manage procurement and inventory processes efficiently. It supports functions like purchasing, inventory management, material requirements planning (MRP), and invoice verification. SAP MM integrates with other modules, such as FI (Financial Accounting), SD (Sales and Distribution), and PP (Production Planning), to ensure smooth operations across the supply chain. This module helps organizations optimize procurement, manage stock levels, and streamline material-related workflows.

Master Data Extractors

a

Extractor: 0MATERIAL_ATTR (Material Master Attributes)

Field NameDescription
MATNRMaterial Number
MTARTMaterial Type
MATKLMaterial Group
MEINSBase Unit of Measure
MBRSHIndustry Sector
WERKSPlant
DISMMMRP Type
DISPOMRP Controller
XCHPFBatch Management Indicator
MAKTXMaterial Description
SPRASLanguage Key
NTGEWNet Weight
BRGEWGross Weight
GEWEIWeight Unit

Extractor: 0MATERIAL_TEXT (Material Master Texts)

Field NameDescription
MATNRMaterial Number
SPRASLanguage Key
MAKTXMaterial Description

Extractor: 0PLANT_ATTR (Plant Attributes)

Field NameDescription
WERKSPlant
NAME1Plant Name
BWKEYValuation Area
KOKRSControlling Area
BUKRSCompany Code
SPRASLanguage Key

Extractor: 0VENDOR_ATTR (Vendor Master Attributes)

Field NameDescription
LIFNRVendor Number
NAME1Vendor Name
LAND1Country
ORT01City
PSTLZPostal Code
REGIORegion
STRASStreet
KTOKKAccount Group
SPRASLanguage Key
LOEVMDeletion Indicator

MM Transactional Data Extractors

a

Extractor: 2LIS_02_ITM (Purchasing Data - Item Level)

Field NameDescription
EBELNPurchase Document Number
EBELPItem Number of Purchase Document
MATNRMaterial Number
WERKSPlant
LIFNRVendor Number
MEINSOrder Unit
MENGEPurchase Order Quantity
NETWRNet Order Value
WAERSDocument Currency
DATUMDocument Date

Extractor: 2LIS_02_HDR (Purchasing Data - Header Level)

Field NameDescription
EBELNPurchase Document Number
BSTYPDocument Type
BUKRSCompany Code
EKORGPurchasing Organization
EKGRPPurchasing Group
LIFNRVendor Number
DATUMDocument Date
WAERSDocument Currency

Extractor: 2LIS_03_BF (Goods Movement - Material Documents)

Field NameDescription
MATNRMaterial Number
WERKSPlant
LGORTStorage Location
BWARTMovement Type
MBLNRMaterial Document Number
MENGEQuantity
MEINSUnit of Measure
BUDATPosting Date
WAERSDocument Currency
DMBTRAmount in Local Currency

Extractor: 2LIS_03_UM (Stock Revaluation Data)

Field NameDescription
MATNRMaterial Number
WERKSPlant
LGORTStorage Location
BUDATPosting Date
BWARTMovement Type
MENGEQuantity
DMBTRAmount in Local Currency
WAERSDocument Currency

Extractor: 2LIS_03_MATNR (Stock Overview)

Field NameDescription
MATNRMaterial Number
WERKSPlant
LGORTStorage Location
LABSTUnrestricted Stock
SPEMESpecial Stock
DMBTRValue of Stock in Local Currency
WAERSDocument Currency

These extractors provide comprehensive data for MM master and transactional data, supporting reporting and analytics for purchasing, inventory, and goods movement processes.

Sales and Distribution

The SAP SD (Sales and Distribution) module is a key component of the SAP ERP system focused on managing sales, customer relationships, and distribution processes. It handles functions such as order management, pricing, shipping, billing, and credit management. SAP SD integrates seamlessly with other modules like MM (Materials Management), FI (Financial Accounting), and PP (Production Planning) to ensure efficient sales and delivery operations. This module enables organizations to streamline their sales processes, enhance customer satisfaction, and achieve better control over distribution networks.

SD Master Data Extractors

a

Extractor: 0CUSTOMER_ATTR (Customer Master Attributes)

Field NameDescription
KUNNRCustomer Number
BUKRSCompany Code
VKORGSales Organization
VTWEGDistribution Channel
SPARTDivision
NAME1Customer Name
ORT01City
PSTLZPostal Code
LAND1Country
REGIORegion
STRASStreet
KTOKDCustomer Account Group
SPRASLanguage Key

Extractor: 0CUSTOMER_TEXT (Customer Master Texts)

Field NameDescription
KUNNRCustomer Number
SPRASLanguage Key
NAME1Customer Name

Extractor: 0MATERIAL_ATTR (Material Master Attributes for SD)

Field NameDescription
MATNRMaterial Number
VKORGSales Organization
VTWEGDistribution Channel
SPARTDivision
MATKLMaterial Group
MEINSBase Unit of Measure
MTARTMaterial Type
NTGEWNet Weight
GEWEIWeight Unit
BRGEWGross Weight

SD Transactional Data Extractors

a

Extractor: 2LIS_11_VAITM (Sales Order Item Data)

Field NameDescription
VBELNSales Document
POSNRSales Document Item
MATNRMaterial Number
WERKSPlant
KUNNRCustomer Number
NETWRNet Value
WAERKCurrency
KWMENGCumulative Order Quantity
VRKMESales Unit
SPARTDivision
PSTYVItem Category

Extractor: 2LIS_11_VAHDR (Sales Order Header Data)

Field NameDescription
VBELNSales Document
VKORGSales Organization
VTWEGDistribution Channel
SPARTDivision
AUARTSales Document Type
KUNNRSold-to Party
NETWRNet Value
WAERKCurrency
ERDATDocument Creation Date
VKBURSales Office

Extractor: 2LIS_12_VCITM (Delivery Item Data)

Field NameDescription
VBELNDelivery Document
POSNRDelivery Item
MATNRMaterial Number
WERKSPlant
LFIMGDelivered Quantity
VRKMESales Unit
VSTELShipping Point
KUNNRShip-to Party
SPARTDivision

Extractor: 2LIS_12_VCHDR (Delivery Header Data)

Field NameDescription
VBELNDelivery Document
VKORGSales Organization
VTWEGDistribution Channel
SPARTDivision
VSTELShipping Point
KUNNRShip-to Party
ERDATDocument Creation Date

Extractor: 2LIS_13_VDITM (Billing Document Item Data)

Field NameDescription
VBELNBilling Document
POSNRBilling Item
MATNRMaterial Number
WERKSPlant
FKIMGBilling Quantity
VRKMESales Unit
NETWRNet Value
WAERKCurrency
KUNNRPayer

Extractor: 2LIS_13_VDHDR (Billing Document Header Data)

Field NameDescription
VBELNBilling Document
VKORGSales Organization
VTWEGDistribution Channel
SPARTDivision
NETWRNet Value
WAERKCurrency
KUNNRPayer
ERDATDocument Creation Date

Production Planning

The SAP PP (Production Planning) module is a vital part of the SAP ERP system, designed to manage manufacturing processes efficiently. It covers areas such as production planning, scheduling, material requirements planning (MRP), capacity planning, and shop floor execution. SAP PP integrates with modules like MM (Materials Management), SD (Sales and Distribution), and FI/CO (Financial Accounting/Controlling) to ensure seamless coordination across supply chain and production activities. This module helps organizations optimize production workflows, reduce lead times, and align manufacturing processes with business goals.

PP Master Data Extractors

a

xtractor: 0MATERIAL_ATTR (Material Master Attributes for PP)

Field NameDescription
MATNRMaterial Number
MTARTMaterial Type
MATKLMaterial Group
MEINSBase Unit of Measure
DISMMMRP Type
DISPOMRP Controller
WERKSPlant
XCHPFBatch Management Indicator
NTGEWNet Weight
GEWEIWeight Unit

Extractor: 0PLANT_ATTR (Plant Attributes)

Field NameDescription
WERKSPlant
NAME1Plant Name
BWKEYValuation Area
SPRASLanguage Key
KOKRSControlling Area

Extractor: 0WORKCENTER_ATTR (Work Center Attributes)

Field NameDescription
ARBPLWork Center
WERKSPlant
ARBPLNAMEWork Center Name
KAPAZCapacity Category
PERSKPerson Responsible

Extractor: 0BOM_ATTR (Bill of Materials)

Field NameDescription
MATNRMaterial Number
WERKSPlant
STLNRBOM Number
STLALBOM Usage
STLSTBOM Status
IDNRKComponent Number
MENGEComponent Quantity

Extractor: 0ROUTING_ATTR (Routing Data)

Field NameDescription
PLNNRRouting Number
WERKSPlant
MATNRMaterial Number
VORNROperation/Activity Number
ARBIDWork Center

PP Transactional Data Extractors

a

Extractor: 2LIS_04_P_ARBPL (Work Center Load)

Field NameDescription
ARBPLWork Center
WERKSPlant
MATNRMaterial Number
PLNNRRouting Number
VORNROperation/Activity Number
MENGEQuantity
START_DATEStart Date
END_DATEEnd Date

Extractor: 2LIS_04_P_COMP (Production Order Components)

Field NameDescription
AUFNRProduction Order
MATNRMaterial Number
WERKSPlant
IDNRKComponent Number
MENGEComponent Quantity
MEINSUnit of Measure
RSNUMReservation Number

Extractor: 2LIS_04_P_MATNR (Production Order - Material Data)

Field NameDescription
AUFNRProduction Order
MATNRMaterial Number
WERKSPlant
GAMNGOrder Quantity
MEINSUnit of Measure
FTRMIFinal Confirmation Date

Extractor: 2LIS_04_P_ORDER (Production Order Header)

Field NameDescription
AUFNRProduction Order
WERKSPlant
MATNRMaterial Number
GAMNGOrder Quantity
AUARTOrder Type
ERDATCreation Date

Extractor: 2LIS_04_PTDOC (Production Document Data)

Field NameDescription
AUFNRProduction Order
MATNRMaterial Number
WERKSPlant
IDNRKComponent Number
RSNUMReservation Number
MEINSUnit of Measure
MENGEComponent Quantity

Extractor: 2LIS_04_PRC (Production Confirmation)

Field NameDescription
AUFNRProduction Order
MATNRMaterial Number
WERKSPlant
VORNROperation/Activity Number
GAMNGConfirmed Quantity
MEINSUnit of Measure
END_DATEConfirmation Date

Project System

The SAP PS (Project System) module is a comprehensive tool within the SAP ERP system designed to manage projects across their entire lifecycle. It supports project planning, scheduling, budgeting, execution, and monitoring. SAP PS is ideal for industries where project management is critical, such as construction, engineering, and professional services.

Key features include work breakdown structures (WBS), project cost and revenue tracking, milestone management, and integration with other SAP modules like FI (Financial Accounting), CO (Controlling), MM (Materials Management), and HR (Human Resources). This integration enables real-time data visibility, resource allocation, and efficient project execution while ensuring adherence to timelines and budgets.

PS Master Data Extractors

a

Extractor: 0PROJECT_ATTR (Project Attributes)

Field NameDescription
PSPNRProject Definition
BUKRSCompany Code
PRARTProject Type
KOKRSControlling Area
PROFLProject Profile
PSPIDProject ID
KTEXTProject Description
DATBIValid To Date
GJAHRFiscal Year

Extractor: 0WBS_ATTR (WBS Element Attributes)

Field NameDescription
PSPNRProject Definition
POSIDWBS Element
PRARTProject Type
KOKRSControlling Area
AUFNROrder Number (if assigned)
OBJNRObject Number
POSKIWBS Element Hierarchy Level
DATBIValid To Date
KTEXTWBS Element Description

Extractor: 0WBS_TEXT (WBS Element Texts)

Field NameDescription
PSPNRProject Definition
POSIDWBS Element
SPRASLanguage Key
KTEXTWBS Element Description

Extractor: 0NETWORK_ATTR (Network Attributes)

Field NameDescription
AUFNRNetwork Number
PSPNRProject Definition
KOKRSControlling Area
OBJNRObject Number
GSTRPStart Date
GLTRPEnd Date
KTEXTNetwork Description

Extractor: 0ACTIVITY_ATTR (Activity Attributes)

Field NameDescription
AUFNRNetwork Number
VORNRActivity Number
WERKSPlant
ARBIDWork Center
GSTRPStart Date
GLTRPFinish Date
KTEXTActivity Description

PS Transactional Data Extractors

a

Extractor: 2LIS_13_VDITM (PS Billing: Line Item Data)

Field NameDescription
BELNRBilling Document
BUKRSCompany Code
POSNRItem Number
PSPNRProject Definition
POSIDWBS Element
MATNRMaterial Number
WRBTRBilling Amount
WAERSCurrency

Extractor: 0CO_OM_OPA_6 (Actual Costs on Internal Orders)

Field NameDescription
AUFNRInternal Order or Network
PSPNRProject Definition
POSIDWBS Element
KSTARCost Element
WERT1Actual Amount in Local Currency
WAERSCurrency

Extractor: 2LIS_13_VDKON (PS Contract Conditions)

Field NameDescription
KONNRContract Number
BUKRSCompany Code
POSIDWBS Element
MATNRMaterial Number
WRBTRCondition Amount
WAERSCurrency

Extractor: 0CO_OM_CCA_1 (Cost Center Accounting: Actual Costs)

Field NameDescription
KOSTLCost Center
PSPNRProject Definition
POSIDWBS Element
KSTARCost Element
WERT1Actual Amount in Local Currency
WAERSCurrency

Extractor: 0PS_C04 (Plan vs Actual Costs)

Field NameDescription
PSPNRProject Definition
POSIDWBS Element
KSTARCost Element
GJAHRFiscal Year
PLAN_VALUEPlanned Cost
ACTUAL_VALUEActual Cost
WAERSCurrency

Extractor: 2LIS_13_VDHDR (PS Billing: Header Data)

Field NameDescription
BELNRBilling Document
BUKRSCompany Code
PSPNRProject Definition
POSIDWBS Element
FKDATBilling Date
NETWRNet Billing Amount
WAERSCurrency

Controlling

The SAP CO (Controlling) module is a core component of the SAP ERP system, focused on managing and analyzing internal costs and financial performance. It supports processes like cost center accounting, profit center accounting, activity-based costing, product costing, and profitability analysis (CO-PA).

SAP CO helps organizations monitor costs, allocate resources effectively, and assess profitability at various levels of the business. It integrates seamlessly with other modules like FI (Financial Accounting), MM (Materials Management), and PP (Production Planning), enabling real-time cost tracking and financial insights. This module is essential for supporting strategic decision-making and optimizing cost efficiency across operations.

CO Master Data Extractors

a

Extractor: 0COSTCENTER_ATTR (Cost Center Attributes)

Field NameDescription
KOSTLCost Center
BUKRSCompany Code
KOKRSControlling Area
WERKSPlant
PRCTRProfit Center
GSBERBusiness Area
VERAKResponsible Person
KOSARCost Center Category
DATBIValid To Date
KTEXTCost Center Name

Extractor: 0COSTCENTER_TEXT (Cost Center Texts)

Field NameDescription
KOSTLCost Center
SPRASLanguage Key
KTEXTCost Center Name

Extractor: 0PROFIT_CTR_ATTR (Profit Center Attributes)

Field NameDescription
PRCTRProfit Center
KOKRSControlling Area
BUKRSCompany Code
DATBIValid To Date
PTEXTProfit Center Name

Extractor: 0PROFIT_CTR_TEXT (Profit Center Texts)

Field NameDescription
PRCTRProfit Center
SPRASLanguage Key
PTEXTProfit Center Name

Extractor: 0COSTELMNT_ATTR (Cost Element Attributes)

Field NameDescription
KSTARCost Element
LIFNRVendor (if applicable)
KOKRSControlling Area
MEINSUnit of Measure
KTEXTCost Element Name

CO Transactional Data Extractors

a

Extractor: 0CO_OM_CCA_1 (Cost Center Accounting: Actual Costs)

Field NameDescription
KOKRSControlling Area
KOSTLCost Center
GJAHRFiscal Year
BUKRSCompany Code
LSTARActivity Type
KSTARCost Element
MEGEBQuantity
WKGEBTotal Actual Costs
WAERSCurrency

Extractor: 0CO_OM_CCA_9 (Cost Center Accounting: Planned Costs)

Field NameDescription
KOKRSControlling Area
KOSTLCost Center
GJAHRFiscal Year
KSTARCost Element
MEGEBPlanned Quantity
WKGEBTotal Planned Costs
WAERSCurrency

Extractor: 0CO_PC_ACT_01 (Product Costing: Actual Costs)

Field NameDescription
KOKRSControlling Area
MATNRMaterial Number
WERKSPlant
KSTARCost Element
MEGEBActual Quantity
WKGEBTotal Actual Costs
WAERSCurrency

Extractor: 0CO_PC_PL_01 (Product Costing: Planned Costs)

Field NameDescription
KOKRSControlling Area
MATNRMaterial Number
WERKSPlant
KSTARCost Element
MEGEBPlanned Quantity
WKGEBTotal Planned Costs
WAERSCurrency

Extractor: 0CO_OM_OPA_6 (Internal Orders: Actual Costs)

Field NameDescription
AUFNRInternal Order
KOKRSControlling Area
BUKRSCompany Code
KSTARCost Element
WERT1Actual Amount in Local Currency
MEGEBActual Quantity
WAERSCurrency