P_JEAPI_LOG_DETAIL_PRE

CDS View
127 Fields 5 CDS Views

a

P_JEAPI_LOG_DETAIL_PRE is a CDS View in S/4HANA. a. It contains 127 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_CnsldtnDataCollTskLg view left_outer COMPOSITE Interface view for data collection
I_CnsldtnDataCollTskLg view union COMPOSITE Interface view for data collection
I_CnsldtnValdtnJrnlTskLg view union_all COMPOSITE Validation of Universal Journal Task Log
P_JEAPI_LOG_DETAIL view left_outer COMPOSITE JEAPI Log Detail
P_JEAPI_LOG_DETAIL view union COMPOSITE JEAPI Log Detail

Fields (127)

KeyField CDS FieldsUsed in Views
KEY CnsldtnTaskLogItemUUID CnsldtnTaskLogItemUUID 3
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID 3
KEY CnsldtnTskLgItmRowNmbr CnsldtnTskLgItmRowNmbr 3
KEY CnsldtnTskLgMsgNmbr CnsldtnTskLgMsgNmbr 3
AMOUNT_GC_DOC AMOUNT_GC_DOC,CnsldtnJrnlEntryAmtInGrpCrcy 3
AMOUNT_GC_TRI AMOUNT_GC_TRI,CnsldtnTriggeringAmtInGrpCrcy 3
AMOUNT_LC_DOC AMOUNT_LC_DOC,CnsldtnJrnlEntryAmtInLoclCrcy 3
AMOUNT_LC_TRI AMOUNT_LC_TRI,CnsldtnTriggeringAmtInLoclCrcy 3
AMOUNT_TC_DOC AMOUNT_TC_DOC,CnsldtnJrnlEntryAmtInTransCrcy 3
AMOUNT_TC_TRI AMOUNT_TC_TRI,CnsldtnTriggeringAmtInTC 3
AssignmentReference AssignmentReference 3
BillingDocumentTypeText BillingDocumentTypeText 3
BillToParty BillToParty 3
BusinessAreaText BusinessAreaText 3
CashLedgerAccount CashLedgerAccount 2
ChartOfAccountsText ChartOfAccountsText 3
CnsldtnCashLedgerChartOfAccts CnsldtnCashLedgerChartOfAccts 2
CnsldtnCustomerText CnsldtnCustomerText 3
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 3
CnsldtnJrnlEntryAmtGrpCrcy CnsldtnJrnlEntryAmtGrpCrcy,GC_DOC_CURRENCY 3
CnsldtnJrnlEntryAmtInGrpCrcy CnsldtnJrnlEntryAmtInGrpCrcy 2
CnsldtnJrnlEntryAmtInLoclCrcy CnsldtnJrnlEntryAmtInLoclCrcy 2
CnsldtnJrnlEntryAmtInTransCrcy CnsldtnJrnlEntryAmtInTransCrcy 2
CnsldtnJrnlEntryAmtLoclCrcy CnsldtnJrnlEntryAmtLoclCrcy,LC_DOC_CURRENCY 3
CnsldtnJrnlEntryAmtTransCrcy CnsldtnJrnlEntryAmtTransCrcy,TC_DOC_CURRENCY 3
CnsldtnJrnlEntryQtyBaseUnit CnsldtnJrnlEntryQtyBaseUnit,DOC_BASEUNIT 3
CnsldtnJrnlEntryQtyInBsUnt CnsldtnJrnlEntryQtyInBsUnt 2
CnsldtnLogHeaderDateTime CnsldtnLogHeaderDateTime 2
CnsldtnMaterialText CnsldtnMaterialText 3
CnsldtnPlantText CnsldtnPlantText 3
CnsldtnProjectText CnsldtnProjectText 2
CnsldtnSegmentText CnsldtnSegmentText 3
CnsldtnTaskLogItemIsLatest CnsldtnTaskLogItemIsLatest 3
CnsldtnTaskLogItemType CnsldtnTaskLogItemType 3
CnsldtnTaskLogItemTypeTxt CnsldtnTaskLogItemTypeTxt 3
CnsldtnTriggeringAmtGrpCrcy CnsldtnTriggeringAmtGrpCrcy,GC_TRI_CURRENCY 3
CnsldtnTriggeringAmtInGrpCrcy CnsldtnTriggeringAmtInGrpCrcy 2
CnsldtnTriggeringAmtInLoclCrcy CnsldtnTriggeringAmtInLoclCrcy 2
CnsldtnTriggeringAmtInTC CnsldtnTriggeringAmtInTC 2
CnsldtnTriggeringAmtLoclCrcy CnsldtnTriggeringAmtLoclCrcy,LC_TRI_CURRENCY 3
CnsldtnTriggeringAmtTransCrcy CnsldtnTriggeringAmtTransCrcy,TC_TRI_CURRENCY 3
CnsldtnTriggeringQtyBaseUnit CnsldtnTriggeringQtyBaseUnit,TRI_BASEUNIT 3
CnsldtnTriggeringQtyInBsUnt CnsldtnTriggeringQtyInBsUnt 2
CnsldtnTskLgMsgID CnsldtnTskLgMsgID 3
CnsldtnTskLgNode CnsldtnTskLgNode 3
CnsldtnTskLgParNode CnsldtnTskLgParNode 3
CompanyCode CompanyCode 3
ConsolidationAcquisitionPeriod ConsolidationAcquisitionPeriod 3
ConsolidationAcquisitionYear ConsolidationAcquisitionYear 3
ConsolidationApportionment ConsolidationApportionment 3
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 3
ConsolidationDimension ConsolidationDimension 3
ConsolidationDocumentNumber ConsolidationDocumentNumber 3
ConsolidationDocumentType ConsolidationDocumentType 3
ConsolidationGroup ConsolidationGroup 3
ConsolidationLedger ConsolidationLedger 3
ConsolidationUnit ConsolidationUnit 3
ConsolidationVersion ConsolidationVersion 3
ControllingAreaText ControllingAreaText 3
CostCenterText CostCenterText 3
CurrencyConversionsDiffType CurrencyConversionsDiffType 3
CustomerGroup CustomerGroup 3
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup 3
CustomerSupplierCountry CustomerSupplierCountry 3
CustomerSupplierIndustry CustomerSupplierIndustry 3
DistributionChannelText DistributionChannelText 3
FinancialDataSource FinancialDataSource 2
FinancialManagementArea FinancialManagementArea 2
FinancialServicesBranch FinancialServicesBranch 2
FinancialServicesProductGroup FinancialServicesProductGroup 2
FinancialStatementItem FinancialStatementItem 1
FinancialTransactionType FinancialTransactionType 3
FiscalYearPeriod FiscalYearPeriod 1
FunctionalAreaText FunctionalAreaText 3
Fund Fund 2
GHGCategory GHGCategory 2
GHGDataQualityCharacteristic GHGDataQualityCharacteristic 2
GHGEnergyClassification GHGEnergyClassification 2
GHGEnergyMix GHGEnergyMix 2
GHGEnergySourcingType GHGEnergySourcingType 2
GHGScope GHGScope 2
GHGScope2CalculationMethod GHGScope2CalculationMethod 2
GHGScope2ContractualInstrument GHGScope2ContractualInstrument 2
GLAccountText GLAccountText 3
GrantID GrantID 2
InvesteeConsolidationUnit InvesteeConsolidationUnit 3
InvestmentActivity InvestmentActivity 2
InvestmentActivityType InvestmentActivityType 2
MaterialGroupName MaterialGroupName 3
OrderID OrderID 3
OrganizationDivisionText OrganizationDivisionText 3
PartnerBusinessAreaText PartnerBusinessAreaText 3
PartnerCompanyText PartnerCompanyText 3
PartnerConsolidationUnit PartnerConsolidationUnit 3
PartnerCostCenter PartnerCostCenter 3
PartnerFunctionalAreaText PartnerFunctionalAreaText 3
PartnerFund PartnerFund 2
PartnerProfitCenterText PartnerProfitCenterText 3
PartnerSegmentText PartnerSegmentText 3
PartnerWBSElementDescription PartnerWBSElementDescription,wbsElement 2
PostingDate PostingDate 2
PostingFiscalPeriod FiscalPeriod,PostingFiscalPeriod 3
PostingFiscalYear PostingFiscalYear 3
PostingLevel PostingLevel 2
ProfitCenterText ProfitCenterText 3
QUANTITY_DOC CnsldtnJrnlEntryQtyInBsUnt,QUANTITY_DOC 3
QUANTITY_TRI CnsldtnTriggeringQtyInBsUnt,QUANTITY_TRI 3
SalesDistrictText SalesDistrictText 3
SalesOrganizationText SalesOrganizationText 3
ShipToParty ShipToParty 3
SoldProduct SoldProduct 3
SoldProductGroup SoldProductGroup 3
SortField SortField 2
SubItem SubItem 3
SubItemCategory SubItemCategory 3
SupplierName SupplierName 3
SustainabilityModeOfTransport SustainabilityModeOfTransport 2
SystemMessageIdentification SystemMessageIdentification 3
SystemMessageNumber SystemMessageNumber 3
SystemMessageType SystemMessageType 3
SystemMessageTypeSortOrder SystemMessageTypeSortOrder 3
SystemMessageVariable1 SystemMessageVariable1 3
SystemMessageVariable2 SystemMessageVariable2 3
SystemMessageVariable3 SystemMessageVariable3 3
SystemMessageVariable4 SystemMessageVariable4 3
WBSElement WBSElement 1
WBSElementInternalID WBSElementInternalID 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.

-- a
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_JEAPI_LOG_DETAIL_PRE (
    CNSLDTNTASKLOGITEMUUID,
    CNSLDTNTASKLOGUUID,
    CNSLDTNTSKLGITMROWNMBR,
    CNSLDTNTSKLGMSGNMBR,
    AMOUNT_GC_DOC,
    AMOUNT_GC_TRI,
    AMOUNT_LC_DOC,
    AMOUNT_LC_TRI,
    AMOUNT_TC_DOC,
    AMOUNT_TC_TRI,
    ASSIGNMENTREFERENCE,
    BILLINGDOCUMENTTYPETEXT,
    BILLTOPARTY,
    BUSINESSAREATEXT,
    CASHLEDGERACCOUNT,
    CHARTOFACCOUNTSTEXT,
    CNSLDTNCASHLEDGERCHARTOFACCTS,
    CNSLDTNCUSTOMERTEXT,
    CNSLDTNFINANCIALSTATEMENTITEM,
    CNSLDTNJRNLENTRYAMTGRPCRCY,
    CNSLDTNJRNLENTRYAMTINGRPCRCY,
    CNSLDTNJRNLENTRYAMTINLOCLCRCY,
    CNSLDTNJRNLENTRYAMTINTRANSCRCY,
    CNSLDTNJRNLENTRYAMTLOCLCRCY,
    CNSLDTNJRNLENTRYAMTTRANSCRCY,
    CNSLDTNJRNLENTRYQTYBASEUNIT,
    CNSLDTNJRNLENTRYQTYINBSUNT,
    CNSLDTNLOGHEADERDATETIME,
    CNSLDTNMATERIALTEXT,
    CNSLDTNPLANTTEXT,
    CNSLDTNPROJECTTEXT,
    CNSLDTNSEGMENTTEXT,
    CNSLDTNTASKLOGITEMISLATEST,
    CNSLDTNTASKLOGITEMTYPE,
    CNSLDTNTASKLOGITEMTYPETXT,
    CNSLDTNTRIGGERINGAMTGRPCRCY,
    CNSLDTNTRIGGERINGAMTINGRPCRCY,
    CNSLDTNTRIGGERINGAMTINLOCLCRCY,
    CNSLDTNTRIGGERINGAMTINTC,
    CNSLDTNTRIGGERINGAMTLOCLCRCY,
    CNSLDTNTRIGGERINGAMTTRANSCRCY,
    CNSLDTNTRIGGERINGQTYBASEUNIT,
    CNSLDTNTRIGGERINGQTYINBSUNT,
    CNSLDTNTSKLGMSGID,
    CNSLDTNTSKLGNODE,
    CNSLDTNTSKLGPARNODE,
    COMPANYCODE,
    CONSOLIDATIONACQUISITIONPERIOD,
    CONSOLIDATIONACQUISITIONYEAR,
    CONSOLIDATIONAPPORTIONMENT,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONDOCUMENTNUMBER,
    CONSOLIDATIONDOCUMENTTYPE,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONLEDGER,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONVERSION,
    CONTROLLINGAREATEXT,
    COSTCENTERTEXT,
    CURRENCYCONVERSIONSDIFFTYPE,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNELTEXT,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALSTATEMENTITEM,
    FINANCIALTRANSACTIONTYPE,
    FISCALYEARPERIOD,
    FUNCTIONALAREATEXT,
    FUND,
    GHGCATEGORY,
    GHGDATAQUALITYCHARACTERISTIC,
    GHGENERGYCLASSIFICATION,
    GHGENERGYMIX,
    GHGENERGYSOURCINGTYPE,
    GHGSCOPE,
    GHGSCOPE2CALCULATIONMETHOD,
    GHGSCOPE2CONTRACTUALINSTRUMENT,
    GLACCOUNTTEXT,
    GRANTID,
    INVESTEECONSOLIDATIONUNIT,
    INVESTMENTACTIVITY,
    INVESTMENTACTIVITYTYPE,
    MATERIALGROUPNAME,
    ORDERID,
    ORGANIZATIONDIVISIONTEXT,
    PARTNERBUSINESSAREATEXT,
    PARTNERCOMPANYTEXT,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREATEXT,
    PARTNERFUND,
    PARTNERPROFITCENTERTEXT,
    PARTNERSEGMENTTEXT,
    PARTNERWBSELEMENTDESCRIPTION,
    POSTINGDATE,
    POSTINGFISCALPERIOD,
    POSTINGFISCALYEAR,
    POSTINGLEVEL,
    PROFITCENTERTEXT,
    QUANTITY_DOC,
    QUANTITY_TRI,
    SALESDISTRICTTEXT,
    SALESORGANIZATIONTEXT,
    SHIPTOPARTY,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SORTFIELD,
    SUBITEM,
    SUBITEMCATEGORY,
    SUPPLIERNAME,
    SUSTAINABILITYMODEOFTRANSPORT,
    SYSTEMMESSAGEIDENTIFICATION,
    SYSTEMMESSAGENUMBER,
    SYSTEMMESSAGETYPE,
    SYSTEMMESSAGETYPESORTORDER,
    SYSTEMMESSAGEVARIABLE1,
    SYSTEMMESSAGEVARIABLE2,
    SYSTEMMESSAGEVARIABLE3,
    SYSTEMMESSAGEVARIABLE4,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (CNSLDTNTASKLOGITEMUUID, CNSLDTNTASKLOGUUID, CNSLDTNTSKLGITMROWNMBR, CNSLDTNTSKLGMSGNMBR)
);

Learn More