Select language:

 Line Item

Technical Name: 0EC_PCA_3

Technical Data

Type of DataSource

Transaction Data

Application component

EC-PCA

Available from OLTP Release

6.20

Available from PlugIn Release

2003.1

RemoteCube-Compatible?

Yes

Use

If the transfer structure in the OLAP system does not use the following key fields, the DataSource supplies the corresponding aggregated datasets:

  • DOCNR
  • REFDOCNR
  • CPUTM
  • TIMESTAMP

Delta Update

DataSource 0EC_PCA_3 supports full and Delta uploads.

For delta mode, the timestamp procedure is used. The TIMSTAMP field is used for this. The delta upload works with a security interval on an hour basis, meaning that posted line items can be loaded into the BW after one hour.

This graphic is explained in the accompanying text.

To optimize the performance of data procurement when DataSource 0EC_PCA_3 accesses line item table GLPCA in the OLTP, you should set up an additional secondary index. This should contain the following fields:

RCLNT

CPUDT

CPUTM

This graphic is explained in the accompanying text.

For R/3 Releases 4.0B and 4.5B, you have to install note580273.

Constraints

Data that is created by periodic transfer balance sheet accounts (ACTIV = PRC4) is not transferrred by DataSource 0EC_PCA_3. This data can be transferred using DataSource 0EC_PCA_4 with an extra InfoPackage in full upload.

The extract structure does not contain the BALANCE field. To get the inventory for balance sheet account, 0BALANCE can be filled in BW in den updating rules. For further information, see note 577644.

Noline items are posted for balance carry forward. For this reason, DataSource 0EC_PCA_3 does not provide the values for the balance carryforward.

This graphic is explained in the accompanying text.

Using a further InfoPackage for InfoSource 0EC_PCA_1, carry over the exact balance carryforward from totals table GLPCT. (Restrict the period to = 0)

Origin Fields in the Extract Structure

Field in Extraction Structure

Description of the Field in the Extract Structure

Table of Origin

Field in Table of Origin

RVERS

Version

GLPCA

RVERS

RYEAR

Fiscal year

GLPCA

RYEAR

RTCUR

Currency Key

GLPCA

RTCUR

POPER

Posting period

GLPCA

POPER

DOCCT

Document type

GLPCA

DOCCT

DOCNR

Accounting document number

GLPCA

DOCNR

DOCLN

Posting row

GLPCA

DOCLN

RBUKRS

Company Code

GLPCA

RBUKRS

RPRCTR

Profit center

GLPCA

RPRCTR

RHOART

Type of origin object

GLPCA

RHOART

RFAREA

Functional area

GLPCA

RFAREA

KOKRS

Controlling area

GLPCA

KOKRS

RACCT

Account number

GLPCA

RACCT

HRKFT

Origin group as subdivision of the cost element

GLPCA

HRKFT

RASSC

Company ID of trading partner

GLPCA

RASSC

EPRCTR

Partner profit center for elimination of internal business volume

GLPCA

EPRCTR

ACTIV

Business transaction FI-SL

GLPCA

ACTIV

AFABE

Real depreciation area

GLPCA

AFABE

OCLNT

Original client

GLPCA

OCLNT

SBUKRS

Sender company code

GLPCA

SBUKRS

SPRCTR

Partner profit center

GLPCA

SPRCTR

SHOART

Type of receiver object

GLPCA

SHOART

SFAREA

Partner functional area

GLPCA

SFAREA

CPUDT

Day when accounting document created

GLPCA

CPUDT

CPUTM

Time of creation

GLPCA

CPUTM

USNAM

Name of user

GLPCA

USNAM

SGTXT

Item text

GLPCA

SGTXT

AUTOM

Flag: Automatic posting rows

GLPCA

AUTOM

DOCTY

FI-SL document type

GLPCA

DOCTY

BLDAT

Document date

GLPCA

BLDAT

BUDAT

Posting date in the document

GLPCA

BUDAT

WSDAT

Value date for currency translation

GLPCA

WSDAT

REFDOCNR

Reference document number

GLPCA

REFDOCNR

REFRYEAR

Fiscal year

GLPCA

REFRYEAR

REFDOCLN

Line item number in the accounting document

GLPCA

REFDOCLN

REFDOCCT

Document type

GLPCA

REFDOCCT

REFACTIV

Business transaction FI-SL

GLPCA

REFACTIV

AWTYP

Reference transaction

GLPCA

AWTYP

AWORG

Reference organizational units

GLPCA

AWORG

WERKS

Plant

GLPCA

WERKS

GSBER

Business area

GLPCA

GSBER

KOSTL

Cost center

GLPCA

KOSTL

LSTAR

Activity type

GLPCA

LSTAR

AUFNR

Order Number

GLPCA

AUFNR

AUFPL

Plan number for transactions in order

GLPCA

AUFPL

ANLN1

Asset main number

GLPCA

ANLN1

ANLN2

Asset sub-number

GLPCA

ANLN2

MATNR

Material Number

GLPCA

MATNR

BWKEY

Valuation Area

GLPCA

BWKEY

BWTAR

Valuation type

GLPCA

BWTAR

ANBWA

Asset transaction type

GLPCA

ANBWA

KUNNR

Customer Number 1

GLPCA

KUNNR

LIFNR

Account number of the vendor or creditor

GLPCA

LIFNR

RMVCT

Transaction type

GLPCA

RMVCT

EBELN

Document number of the purchase document

GLPCA

EBELN

EBELP

Item number of the purchase document

GLPCA

EBELP

KSTRG

Cost Object

GLPCA

KSTRG

ERKRS

Operating concern

GLPCA

ERKRS

PAOBJNR

Number for profitability segments (CO-PA)

GLPCA

PAOBJNR

PASUBNR

Change history for profitability segments (CO-PA)

GLPCA

PASUBNR

PS_PSP_PNR

Work Breakdown Structure element (WBS element)

GLPCA

PS_PSP_PNR

KDAUF

Sales Order Number

GLPCA

KDAUF

KDPOS

Item number in sales order

GLPCA

KDPOS

FKART

Billing type

GLPCA

FKART

FKART

Billing type

GLPCA

FKART

VKORG

Sales organization

GLPCA

VKORG

VTWEG

Distribution Channel

GLPCA

VTWEG

AUBEL

Sales Document

GLPCA

AUBEL

AUPOS

Sales Document Item

GLPCA

AUPOS

SPART

Division

GLPCA

SPART

VBELN

S&D document

GLPCA

VBELN

POSNR

Item number of the S&D document

GLPCA

POSNR

VKGRP

Sales group

GLPCA

VKGRP

VKBUR

Sales office

GLPCA

VKBUR

VBUND

Company ID of trading partner

GLPCA

VBUND

LOGSYS

Logical system

GLPCA

LOGSYS

ALEBN

With ALE: PCA document number in the generating system

GLPCA

ALEBN

AWSYS

Logical system of the origin document

GLPCA

AWSYS

VERSA

Results analysis version

GLPCA

VERSA

STFLG

Flag: ‘Document is reversal document’

GLPCA

STFLG

STOKZ

Flag: ‘Document reversed’

GLPCA

STOKZ

REP_MATNR

Representative Material for Profit Center Accounting

GLPCA

REP_MATNR

CO_PRZNR

Business Process

GLPCA

CO_PRZNR

IMKEY

Internal Key for Real Estate Object

GLPCA

IMKEY

DABRZ

Reference Date for settlement

GLPCA

DABRZ

VALUT

Value Date

GLPCA

VALUT

RSCOPE

Object class

GLPCA

RSCOPE

AWREF_REV

Reversal: Reference document number of the document to be reversed

GLPCA

AWREF_REV

AWORG_REV

Reversal: Reference organization of the document to be reversed

GLPCA

AWORG_REV

BWART

Transaction type (Inventory)

GLPCA

BWART

BLART

Document type

GLPCA

BLART

TIMESTAMP

Timestamp in abbreviated form (YYYYMMDDHHMMSS)

GLPCA

CPUPT and CPUTM

QUANUNIT

Unit of measure

 

MEINS

VALUETYPE

Value type for reporting

 

VALUETYPE (conversion of the record type (GLPCA-RRCTY) Record types 0 and 2 are converted to value type 10, record types 1 and 3 are converted to value type 20)

CURTYPE

Currency Type

 

CURTYPE (from customizing settings in Profit Center Accounting and name of the value field used With value field TSL, currency type 0 is set, wiht HSL, currency type 10 is set, with KSL,currency type 20, 30 or 90 is set.

FISCPER

Fiscal year/period

 

POPER and RYEAR

FISCVAR

Fiscal year variant

 

 

CHARTACCTS

Chart of Accounts

 

 

UPMOD

BW delta method:update mode

 

 

VALUTYP

Valuation View

 

VALUTYP (Customizing settings)

CURRUNIT

Currency Key

GLPCA

RUNIT

DEBIT

Total debit postings

GLPCA

TSL, HSl, KSL and DRCRK

CREDIT

Total credit postings

GLPCA

TSL, HSl, KSL and DRCRK

TURNOVER

Sales of the period

GLPCA

TSL, HSl, KSL and DRCRK

Special Features of the Extractor

Extraction method: F1

Extractor: ECPCA_BIW_GET_DATA

Extractions structure: GLPCW