I_CNSLDTNTASKLOGITEM01

CDS View
92 Fields 9 CDS Views

Interface for FINCS_LOG_ITEM01

I_CNSLDTNTASKLOGITEM01 is a CDS View in S/4HANA. Interface for FINCS_LOG_ITEM01. It contains 92 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
C_CnsldtnJrnlEntrLgDet view from CONSUMPTION Import Journal Entry Log Detail
I_CnsldtnDataCollTskLg view from COMPOSITE Interface view for data collection
I_CnsldtnMnlJrnlEntrTaskLog view from COMPOSITE Interface view for manual journal entry
I_CnsldtnRelJrnlTskLg view from COMPOSITE Release Universal Journal task log
I_CnsldtnValdtnJrnlTskLg view from COMPOSITE Validation of Universal Journal Task Log
P_JEAPI_LOG_DETAIL view from COMPOSITE
P_JEAPI_LOG_DETAIL_POST_LL view from COMPOSITE
P_JEAPI_LOG_DETAIL_PRE view from COMPOSITE
P_JEAPI_LOG_DETAIL_PRE_LL view from COMPOSITE

Fields (92)

KeyField CDS FieldsUsed in Views
KEY CnsldtnTaskLogItemUUID CnsldtnTaskLogItemUUID 3
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID 3
KEY CnsldtnTskLgItmRowNmbr CnsldtnTskLgItmRowNmbr 4
AssignmentReference AssignmentReference 3
BillingDocumentTypeText BillingDocumentTypeText 3
BillToParty BillToParty 3
BusinessAreaText BusinessAreaText 3
ChartOfAccountsText ChartOfAccountsText 3
CnsldtnCustomerText CnsldtnCustomerText 3
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 4
CnsldtnJrnlEntryAmtGrpCrcy CnsldtnJrnlEntryAmtGrpCrcy 4
CnsldtnJrnlEntryAmtInGrpCrcy AMOUNT_GC_DOC,CnsldtnJrnlEntryAmtInGrpCrcy 3
CnsldtnJrnlEntryAmtInLoclCrcy AMOUNT_LC_DOC,CnsldtnJrnlEntryAmtInLoclCrcy 3
CnsldtnJrnlEntryAmtInTransCrcy AMOUNT_TC_DOC,CnsldtnJrnlEntryAmtInTransCrcy 3
CnsldtnJrnlEntryAmtLoclCrcy CnsldtnJrnlEntryAmtLoclCrcy 4
CnsldtnJrnlEntryAmtTransCrcy CnsldtnJrnlEntryAmtTransCrcy 4
CnsldtnJrnlEntryQtyBaseUnit CnsldtnJrnlEntryQtyBaseUnit 4
CnsldtnJrnlEntryQtyInBsUnt CnsldtnJrnlEntryQtyInBsUnt,QUANTITY_DOC 3
CnsldtnLogHeaderDateTime CnsldtnLogHeaderDateTime 4
CnsldtnMaterialText CnsldtnMaterialText 3
CnsldtnPlantText CnsldtnPlantText 3
CnsldtnProjectText CnsldtnProjectText 3
CnsldtnSegmentText CnsldtnSegmentText 3
CnsldtnTaskLogItemIsLatest CnsldtnTaskLogItemIsLatest 3
CnsldtnTaskLogItemType CnsldtnTaskLogItemType 3
CnsldtnTaskLogItemTypeTxt CnsldtnTaskLogItemTypeTxt 1
CnsldtnTriggeringAmtGrpCrcy CnsldtnTriggeringAmtGrpCrcy 3
CnsldtnTriggeringAmtInGrpCrcy AMOUNT_GC_TRI 2
CnsldtnTriggeringAmtInLoclCrcy AMOUNT_LC_TRI 2
CnsldtnTriggeringAmtInTC AMOUNT_TC_TRI 2
CnsldtnTriggeringAmtLoclCrcy CnsldtnTriggeringAmtLoclCrcy 3
CnsldtnTriggeringAmtTransCrcy CnsldtnTriggeringAmtTransCrcy 3
CnsldtnTriggeringQtyBaseUnit CnsldtnTriggeringQtyBaseUnit 3
CnsldtnTriggeringQtyInBsUnt QUANTITY_TRI 2
CnsldtnTskLgNode CnsldtnTskLgNode 3
CnsldtnTskLgParNode CnsldtnTskLgParNode 3
CompanyCode CompanyCode 3
ConsolidationAcquisitionPeriod ConsolidationAcquisitionPeriod 3
ConsolidationAcquisitionYear ConsolidationAcquisitionYear 3
ConsolidationApportionment ConsolidationApportionment 3
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 4
ConsolidationDimension ConsolidationDimension 1
ConsolidationDocumentNumber ConsolidationDocumentNumber 3
ConsolidationDocumentType ConsolidationDocumentType 3
ConsolidationGroup ConsolidationGroup 3
ConsolidationLedger ConsolidationLedger 4
ConsolidationUnit ConsolidationUnit 4
ConsolidationVersion ConsolidationVersion 4
ControllingAreaText ControllingAreaText 3
CostCenterText CostCenterText 3
CurrencyConversionsDiffType CurrencyConversionsDiffType 3
CurrencyTranslationDate CurrencyTranslationDate 3
CustomerGroup CustomerGroup 3
CustomerSupplierCorporateGroup CustomerSupplierCorporateGroup 3
CustomerSupplierCountry CustomerSupplierCountry 3
CustomerSupplierIndustry CustomerSupplierIndustry 3
DistributionChannelText DistributionChannelText 3
FinancialStatementItem FinancialStatementItem 3
FinancialTransactionType FinancialTransactionType 3
FunctionalAreaText FunctionalAreaText 3
GLAccountText GLAccountText 4
InvesteeConsolidationUnit InvesteeConsolidationUnit 3
InvestmentActivity InvestmentActivity 3
InvestmentActivityType InvestmentActivityType 3
MaterialGroupName MaterialGroupName 3
OrderID OrderID 3
OrganizationDivisionText OrganizationDivisionText 3
PartnerBusinessAreaText PartnerBusinessAreaText 3
PartnerCompanyText PartnerCompanyText 3
PartnerConsolidationUnit PartnerConsolidationUnit 3
PartnerCostCenter PartnerCostCenter 3
PartnerFunctionalAreaText PartnerFunctionalAreaText 3
PartnerProfitCenterText PartnerProfitCenterText 3
PartnerSegmentText PartnerSegmentText 3
PartnerWBSElementDescription PartnerWBSElementDescription 3
PostingDate PostingDate 4
PostingFiscalPeriod FiscalPeriod,PostingFiscalPeriod 4
PostingFiscalYear PostingFiscalYear 4
PostingLevel PostingLevel 3
ProductGroupText ProductGroupText 3
ProfitCenterText ProfitCenterText 3
SalesDistrictText SalesDistrictText 3
SalesOrganizationText SalesOrganizationText 3
ShipToParty ShipToParty 3
SoldMaterial SoldMaterial 3
SoldProduct SoldProduct 3
SoldProductGroup SoldProductGroup 3
SubItem SubItem 3
SubItemCategory SubItemCategory 3
SupplierName SupplierName 3
WBSElement WBSElement 2
WBSElementInternalID WBSElementInternalID 3

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.

-- Interface for FINCS_LOG_ITEM01
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNTASKLOGITEM01 (
    CNSLDTNTASKLOGITEMUUID,
    CNSLDTNTASKLOGUUID,
    CNSLDTNTSKLGITMROWNMBR,
    ASSIGNMENTREFERENCE,
    BILLINGDOCUMENTTYPETEXT,
    BILLTOPARTY,
    BUSINESSAREATEXT,
    CHARTOFACCOUNTSTEXT,
    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,
    CNSLDTNTSKLGNODE,
    CNSLDTNTSKLGPARNODE,
    COMPANYCODE,
    CONSOLIDATIONACQUISITIONPERIOD,
    CONSOLIDATIONACQUISITIONYEAR,
    CONSOLIDATIONAPPORTIONMENT,
    CONSOLIDATIONCHARTOFACCOUNTS,
    CONSOLIDATIONDIMENSION,
    CONSOLIDATIONDOCUMENTNUMBER,
    CONSOLIDATIONDOCUMENTTYPE,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONLEDGER,
    CONSOLIDATIONUNIT,
    CONSOLIDATIONVERSION,
    CONTROLLINGAREATEXT,
    COSTCENTERTEXT,
    CURRENCYCONVERSIONSDIFFTYPE,
    CURRENCYTRANSLATIONDATE,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNELTEXT,
    FINANCIALSTATEMENTITEM,
    FINANCIALTRANSACTIONTYPE,
    FUNCTIONALAREATEXT,
    GLACCOUNTTEXT,
    INVESTEECONSOLIDATIONUNIT,
    INVESTMENTACTIVITY,
    INVESTMENTACTIVITYTYPE,
    MATERIALGROUPNAME,
    ORDERID,
    ORGANIZATIONDIVISIONTEXT,
    PARTNERBUSINESSAREATEXT,
    PARTNERCOMPANYTEXT,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREATEXT,
    PARTNERPROFITCENTERTEXT,
    PARTNERSEGMENTTEXT,
    PARTNERWBSELEMENTDESCRIPTION,
    POSTINGDATE,
    POSTINGFISCALPERIOD,
    POSTINGFISCALYEAR,
    POSTINGLEVEL,
    PRODUCTGROUPTEXT,
    PROFITCENTERTEXT,
    SALESDISTRICTTEXT,
    SALESORGANIZATIONTEXT,
    SHIPTOPARTY,
    SOLDMATERIAL,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUBITEM,
    SUBITEMCATEGORY,
    SUPPLIERNAME,
    WBSELEMENT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (CNSLDTNTASKLOGITEMUUID, CNSLDTNTASKLOGUUID, CNSLDTNTSKLGITMROWNMBR)
);

Learn More