I_CNSLDTNTASKLOGITEM

CDS View
103 Fields 8 CDS Views

Interface for FINCS_LOG_ITEM

I_CNSLDTNTASKLOGITEM is a CDS View in S/4HANA. Interface for FINCS_LOG_ITEM. It contains 103 fields. 8 CDS views read from this table.

CDS Views using this table (8)

ViewTypeJoinVDMDescription
C_CnsldtnCrcyTrnsltnLgDet view from CONSUMPTION Currency Translation Log Detail
I_CnsldtnCrcyTrnsltnTskLg view from COMPOSITE Interface view for currency translation
I_CnsldtnReclassificationTskLg view from COMPOSITE Interface view for reclassification
I_CnsldtnTaskLogDetail view from BASIC Interface for Task Log Detail
I_CnsldtnTskLgDetIntmd view from COMPOSITE Log Detail Interface
I_CnsldtnTskLgDetPrep view from BASIC Task Log Detail Preparation
P_GEN_LOG_DETAIL_Pre view from BASIC
P_GEN_LOG_DETAIL_Pre view union BASIC

Fields (103)

KeyField CDS FieldsUsed in Views
KEY CnsldtnTaskLogItemUUID CnsldtnTaskLogItemUUID 4
KEY CnsldtnTaskLogUUID CnsldtnTaskLogUUID 4
AssignmentReference AssignmentReference 3
BillingDocumentTypeText BillingDocumentTypeText 3
BillToParty BillToParty 3
BusinessAreaText BusinessAreaText 3
CashLedgerAccount CashLedgerAccount 2
CnsldtnCashLedgerChartOfAccts CnsldtnCashLedgerChartOfAccts 2
CnsldtnCrcyTranslationKey CnsldtnCrcyTranslationKey 2
CnsldtnCrcyTrnsltnDiffFSItem CnsldtnCrcyTrnsltnDiffFSItem 2
CnsldtnCrcyTrnsltnDiffSubitem CnsldtnCrcyTrnsltnDiffSubitem 2
CnsldtnCustomerText CnsldtnCustomerText 3
CnsldtnExchangeRate CnsldtnExchangeRate 1
CnsldtnExchangeRateType CnsldtnExchangeRateType 2
CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem 4
CnsldtnGroupJrnlEntry CnsldtnGroupJrnlEntry 1
CnsldtnJrnlEntryAmtGrpCrcy CnsldtnJrnlEntryAmtGrpCrcy 3
CnsldtnJrnlEntryAmtInGrpCrcy CnsldtnJrnlEntryAmtInGrpCrcy 2
CnsldtnJrnlEntryAmtLoclCrcy CnsldtnJrnlEntryAmtLoclCrcy 3
CnsldtnJrnlEntryAmtTransCrcy CnsldtnJrnlEntryAmtTransCrcy 1
CnsldtnJrnlEntryQtyBaseUnit CnsldtnJrnlEntryQtyBaseUnit 1
CnsldtnMaterialText CnsldtnMaterialText 3
CnsldtnPercent CnsldtnPercent 2
CnsldtnPlantText CnsldtnPlantText 3
CnsldtnProjectText CnsldtnProjectText 1
CnsldtnRclassfctnRecdType CnsldtnRclassfctnRecdType 1
CnsldtnRefExchangeRate CnsldtnRefExchangeRate 1
CnsldtnRefExchangeRateType CnsldtnRefExchangeRateType 2
CnsldtnSegmentText CnsldtnSegmentText 3
CnsldtnTaskLogItemType CnsldtnTaskLogItemType 3
CnsldtnTaskLogItemTypeTxt CnsldtnTaskLogItemTypeTxt 2
CnsldtnTriggeringAmtGrpCrcy CnsldtnTriggeringAmtGrpCrcy 3
CnsldtnTriggeringAmtInGrpCrcy CnsldtnTriggeringAmtInGrpCrcy 2
CnsldtnTriggeringAmtInLoclCrcy CnsldtnTriggeringAmtInLoclCrcy 1
CnsldtnTriggeringAmtInTC CnsldtnTriggeringAmtInTC 1
CnsldtnTriggeringAmtLoclCrcy CnsldtnTriggeringAmtLoclCrcy 3
CnsldtnTriggeringAmtTransCrcy CnsldtnTriggeringAmtTransCrcy 2
CnsldtnTriggeringQtyBaseUnit CnsldtnTriggeringQtyBaseUnit 2
CnsldtnTriggeringQtyInBsUnt CnsldtnTriggeringQtyInBsUnt 1
CnsldtnTskLgNode CnsldtnTskLgNode 4
CnsldtnTskLgParNode CnsldtnTskLgParNode 4
ConsolidationAcquisitionPeriod ConsolidationAcquisitionPeriod 2
ConsolidationAcquisitionYear ConsolidationAcquisitionYear 2
ConsolidationApportionment ConsolidationApportionment 2
ConsolidationCurrencySetIdn ConsolidationCurrencySetIdn 2
ConsolidationDocumentNumber ConsolidationDocumentNumber 2
ConsolidationGroup ConsolidationGroup 4
ConsolidationMethod CnsldtnCrcyTranslationMethod,ConsolidationMethod 4
ConsolidationPostgItemAutoFlag ConsolidationPostgItemAutoFlag 2
ConsolidationPostingItem ConsolidationPostingItem 2
ConsolidationUnit ConsolidationUnit 4
ControllingAreaText ControllingAreaText 3
CostCenterText CostCenterText 3
CurrencyConversionsDiffType CurrencyConversionsDiffType 2
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 2
FinancialTransactionType FinancialTransactionType 3
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
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 1
ProductGroupText ProductGroupText 3
ProfitCenterText ProfitCenterText 3
SalesDistrictText SalesDistrictText 3
SalesOrganizationText SalesOrganizationText 3
SequenceNumber SequenceNumber 2
ShipToParty ShipToParty 3
SoldMaterial SoldMaterial 3
SoldProduct SoldProduct 3
SoldProductGroup SoldProductGroup 3
SubItem SubItem 4
SubItemCategory SubItemCategory 4
SupplierName SupplierName 3
SustainabilityModeOfTransport SustainabilityModeOfTransport 2
WBSElementInternalID WBSElementInternalID 1

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_ITEM
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_CNSLDTNTASKLOGITEM (
    CNSLDTNTASKLOGITEMUUID,
    CNSLDTNTASKLOGUUID,
    ASSIGNMENTREFERENCE,
    BILLINGDOCUMENTTYPETEXT,
    BILLTOPARTY,
    BUSINESSAREATEXT,
    CASHLEDGERACCOUNT,
    CNSLDTNCASHLEDGERCHARTOFACCTS,
    CNSLDTNCRCYTRANSLATIONKEY,
    CNSLDTNCRCYTRNSLTNDIFFFSITEM,
    CNSLDTNCRCYTRNSLTNDIFFSUBITEM,
    CNSLDTNCUSTOMERTEXT,
    CNSLDTNEXCHANGERATE,
    CNSLDTNEXCHANGERATETYPE,
    CNSLDTNFINANCIALSTATEMENTITEM,
    CNSLDTNGROUPJRNLENTRY,
    CNSLDTNJRNLENTRYAMTGRPCRCY,
    CNSLDTNJRNLENTRYAMTINGRPCRCY,
    CNSLDTNJRNLENTRYAMTLOCLCRCY,
    CNSLDTNJRNLENTRYAMTTRANSCRCY,
    CNSLDTNJRNLENTRYQTYBASEUNIT,
    CNSLDTNMATERIALTEXT,
    CNSLDTNPERCENT,
    CNSLDTNPLANTTEXT,
    CNSLDTNPROJECTTEXT,
    CNSLDTNRCLASSFCTNRECDTYPE,
    CNSLDTNREFEXCHANGERATE,
    CNSLDTNREFEXCHANGERATETYPE,
    CNSLDTNSEGMENTTEXT,
    CNSLDTNTASKLOGITEMTYPE,
    CNSLDTNTASKLOGITEMTYPETXT,
    CNSLDTNTRIGGERINGAMTGRPCRCY,
    CNSLDTNTRIGGERINGAMTINGRPCRCY,
    CNSLDTNTRIGGERINGAMTINLOCLCRCY,
    CNSLDTNTRIGGERINGAMTINTC,
    CNSLDTNTRIGGERINGAMTLOCLCRCY,
    CNSLDTNTRIGGERINGAMTTRANSCRCY,
    CNSLDTNTRIGGERINGQTYBASEUNIT,
    CNSLDTNTRIGGERINGQTYINBSUNT,
    CNSLDTNTSKLGNODE,
    CNSLDTNTSKLGPARNODE,
    CONSOLIDATIONACQUISITIONPERIOD,
    CONSOLIDATIONACQUISITIONYEAR,
    CONSOLIDATIONAPPORTIONMENT,
    CONSOLIDATIONCURRENCYSETIDN,
    CONSOLIDATIONDOCUMENTNUMBER,
    CONSOLIDATIONGROUP,
    CONSOLIDATIONMETHOD,
    CONSOLIDATIONPOSTGITEMAUTOFLAG,
    CONSOLIDATIONPOSTINGITEM,
    CONSOLIDATIONUNIT,
    CONTROLLINGAREATEXT,
    COSTCENTERTEXT,
    CURRENCYCONVERSIONSDIFFTYPE,
    CUSTOMERGROUP,
    CUSTOMERSUPPLIERCORPORATEGROUP,
    CUSTOMERSUPPLIERCOUNTRY,
    CUSTOMERSUPPLIERINDUSTRY,
    DISTRIBUTIONCHANNELTEXT,
    FINANCIALDATASOURCE,
    FINANCIALMANAGEMENTAREA,
    FINANCIALSERVICESBRANCH,
    FINANCIALSERVICESPRODUCTGROUP,
    FINANCIALSTATEMENTITEM,
    FINANCIALTRANSACTIONTYPE,
    FUNCTIONALAREATEXT,
    FUND,
    GHGCATEGORY,
    GHGDATAQUALITYCHARACTERISTIC,
    GHGENERGYCLASSIFICATION,
    GHGENERGYMIX,
    GHGENERGYSOURCINGTYPE,
    GHGSCOPE,
    GHGSCOPE2CALCULATIONMETHOD,
    GHGSCOPE2CONTRACTUALINSTRUMENT,
    GLACCOUNTTEXT,
    GRANTID,
    MATERIALGROUPNAME,
    ORDERID,
    ORGANIZATIONDIVISIONTEXT,
    PARTNERBUSINESSAREATEXT,
    PARTNERCOMPANYTEXT,
    PARTNERCONSOLIDATIONUNIT,
    PARTNERCOSTCENTER,
    PARTNERFUNCTIONALAREATEXT,
    PARTNERFUND,
    PARTNERPROFITCENTERTEXT,
    PARTNERSEGMENTTEXT,
    PARTNERWBSELEMENTDESCRIPTION,
    PRODUCTGROUPTEXT,
    PROFITCENTERTEXT,
    SALESDISTRICTTEXT,
    SALESORGANIZATIONTEXT,
    SEQUENCENUMBER,
    SHIPTOPARTY,
    SOLDMATERIAL,
    SOLDPRODUCT,
    SOLDPRODUCTGROUP,
    SUBITEM,
    SUBITEMCATEGORY,
    SUPPLIERNAME,
    SUSTAINABILITYMODEOFTRANSPORT,
    WBSELEMENTINTERNALID,
    PRIMARY KEY (CNSLDTNTASKLOGITEMUUID, CNSLDTNTASKLOGUUID)
);

Learn More