SLDRILL FILE
Profitability Ledger Drill
The Strategic Ledger Drill Around (SLDRILL) file store drill around
information.
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SLX-LEDGER Alpha 15
Ledger The name that identifies the strategic
ledger.
The Ledger information is used to post
Strategic ledger data using SL190
(Strategic Ledger Posting) or used for
reporting in the OLAP environment using
SL87 (Strategic Ledger Data Mart Setup).
SLX-SLAMOUNTS-ID Numeric 12
Amounts ID The identifier of the amounts record.
SLX-SLTRANS-ID Numeric 12
Transaction ID The identifier of the transaction
record.
SLDRILL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
SLXSET1 LEDGER
SLAMOUNTS-ID
SLTRANS-ID
SLXSET2 SLTRANS-ID
LEDGER
SLAMOUNTS-ID
SLDRILL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Slaccount SLACCOUNT Required
SLX-LEDGER -> SLA-LEDGER (SLASET1)
SAM-LEDGER-ACCOUNT -> SLA-LEDGER-ACCOUNT
Slamounts SLAMOUNTS Required
SLX-LEDGER -> SAM-LEDGER
SLX-SLAMOUNTS-ID -> SAM-SLAMOUNTS-ID
Sltrans SLTRANS Required
SLX-SLTRANS-ID -> SLT-OBJ-ID
|
