PNL

66 Fields

PNL is an SAP database table in S/4HANA. It contains 66 fields.

Fields (66)

KeyField CDS FieldsUsed in Views
KEY CommodityExposureCategory CommodityExposureCategory 2
KEY CommodityPriceExposure CommodityPriceExposure 2
KEY CommodityPriceExposureVersion CommodityPriceExposureVersion 2
KEY CommodityPriceSubExposure CommodityPriceSubExposure 2
KEY CompanyCode CompanyCode 2
_CompanyCode _CompanyCode 2
_DerivativeContrSpecification _DerivativeContrSpecification 2
_FinAssetsMgmtProductType _FinAssetsMgmtProductType 2
_MarketIdentifierCode _MarketIdentifierCode 2
_PhysicalCommodity _PhysicalCommodity 2
_PnLEventCategory _PnLEventCategory 2
_PnLEventType _PnLEventType 2
_UnitOfMeasure _UnitOfMeasure 2
CashFlowDirection CashFlowDirection 2
CmmdtyForwardIndexTiming CmmdtyForwardIndexTiming 2
Commodity Commodity 2
CommodityPriceExposureUnit CommodityPriceExposureUnit 2
Currency Currency 2
DeliveryDate DeliveryDate 2
DerivativeContract DerivativeContract 2
DerivativeContractMaturityCode DerivativeContractMaturityCode 2
DerivativeContrSpecification DerivativeContrSpecification 2
DisplayCurrency DisplayCurrency 2
DisplayView DisplayView 2
EvaluationDate EvaluationDate 2
ExposureDueDate ExposureDueDate 2
ExternalKeyFigureValue ExternalKeyFigureValue 2
FinancialAssetsMgmtProductType FinancialAssetsMgmtProductType 2
FinancialInstrActivityCategory FinancialInstrActivityCategory 2
FinancialInstrProductCategory FinancialInstrProductCategory 2
FinancialInstrumentProductType FinancialInstrumentProductType 2
FinancialObject FinancialObject 2
FinInstrExternalReference FinInstrExternalReference 2
FinInstrTransactionCategory FinInstrTransactionCategory 2
HasError HasError 2
HasErrorDescription HasErrorDescription 2
MarketIdentifierCode MarketIdentifierCode 2
MaturityKeyDate MaturityKeyDate 2
MaximumVersion MaximumVersion 2
NumberOfCommodityContracts NumberOfCommodityContracts 1
OptionExerciseType OptionExerciseType 2
OptionPutCallCode OptionPutCallCode 2
OptionStrikeCurrency OptionStrikeCurrency 2
OptionStrikePrice OptionStrikePrice 1
PnLCalculationRelevantQuantity PnLCalculationRelevantQuantity 2
PnLCalculationRelevantValue PnLCalculationRelevantValue 2
PnLEventCategory PnLEventCategory 2
PnLEventType PnLEventType 2
PnLRelevantComparativeTermQty PnLRelevantComparativeTermQty 2
PnLRelevantComparativeTermVal PnLRelevantComparativeTermVal 2
PnLRelevantTermQuantity PnLRelevantTermQuantity 2
PnLRelevantTermValue PnLRelevantTermValue 2
PnLValue PnLValue 2
ReportingDate ReportingDate 2
RiskAnalyzerVersionUUID RiskAnalyzerVersionUUID 2
TermEndDate TermEndDate 2
TermStartDate TermStartDate 2
TimeToMaturity TimeToMaturity 2
TreasuryPositionAccount TreasuryPositionAccount 2
TreasuryPositionLongShortCode TreasuryPositionLongShortCode 2
ValidityEndDate ValidityEndDate 2
ValidityEndDateTime ValidityEndDateTime 2
ValidityEndTime ValidityEndTime 2
ValidityStartDate ValidityStartDate 2
ValidityStartDateTime ValidityStartDateTime 2
ValidityStartTime ValidityStartTime 2

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PNL (
    COMMODITYEXPOSURECATEGORY,
    COMMODITYPRICEEXPOSURE,
    COMMODITYPRICEEXPOSUREVERSION,
    COMMODITYPRICESUBEXPOSURE,
    COMPANYCODE,
    _COMPANYCODE,
    _DERIVATIVECONTRSPECIFICATION,
    _FINASSETSMGMTPRODUCTTYPE,
    _MARKETIDENTIFIERCODE,
    _PHYSICALCOMMODITY,
    _PNLEVENTCATEGORY,
    _PNLEVENTTYPE,
    _UNITOFMEASURE,
    CASHFLOWDIRECTION,
    CMMDTYFORWARDINDEXTIMING,
    COMMODITY,
    COMMODITYPRICEEXPOSUREUNIT,
    CURRENCY,
    DELIVERYDATE,
    DERIVATIVECONTRACT,
    DERIVATIVECONTRACTMATURITYCODE,
    DERIVATIVECONTRSPECIFICATION,
    DISPLAYCURRENCY,
    DISPLAYVIEW,
    EVALUATIONDATE,
    EXPOSUREDUEDATE,
    EXTERNALKEYFIGUREVALUE,
    FINANCIALASSETSMGMTPRODUCTTYPE,
    FINANCIALINSTRACTIVITYCATEGORY,
    FINANCIALINSTRPRODUCTCATEGORY,
    FINANCIALINSTRUMENTPRODUCTTYPE,
    FINANCIALOBJECT,
    FININSTREXTERNALREFERENCE,
    FININSTRTRANSACTIONCATEGORY,
    HASERROR,
    HASERRORDESCRIPTION,
    MARKETIDENTIFIERCODE,
    MATURITYKEYDATE,
    MAXIMUMVERSION,
    NUMBEROFCOMMODITYCONTRACTS,
    OPTIONEXERCISETYPE,
    OPTIONPUTCALLCODE,
    OPTIONSTRIKECURRENCY,
    OPTIONSTRIKEPRICE,
    PNLCALCULATIONRELEVANTQUANTITY,
    PNLCALCULATIONRELEVANTVALUE,
    PNLEVENTCATEGORY,
    PNLEVENTTYPE,
    PNLRELEVANTCOMPARATIVETERMQTY,
    PNLRELEVANTCOMPARATIVETERMVAL,
    PNLRELEVANTTERMQUANTITY,
    PNLRELEVANTTERMVALUE,
    PNLVALUE,
    REPORTINGDATE,
    RISKANALYZERVERSIONUUID,
    TERMENDDATE,
    TERMSTARTDATE,
    TIMETOMATURITY,
    TREASURYPOSITIONACCOUNT,
    TREASURYPOSITIONLONGSHORTCODE,
    VALIDITYENDDATE,
    VALIDITYENDDATETIME,
    VALIDITYENDTIME,
    VALIDITYSTARTDATE,
    VALIDITYSTARTDATETIME,
    VALIDITYSTARTTIME,
    PRIMARY KEY (COMMODITYEXPOSURECATEGORY, COMMODITYPRICEEXPOSURE, COMMODITYPRICEEXPOSUREVERSION, COMMODITYPRICESUBEXPOSURE, COMPANYCODE)
);

Learn More