P_CNSLDTNRECNCLNITEMSTRCT
Consolidation Reconciliation Item Struct
P_CNSLDTNRECNCLNITEMSTRCT is a CDS View in S/4HANA. Consolidation Reconciliation Item Struct. It contains 147 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| I_CnsldtnRecnclnTskLgSortedItm | view_entity | from | COMPOSITE | Consolidation Reconciliation Item |
Fields (147)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | CnsldtnTaskLogItemUUID | CnsldtnTaskLogItemUUID | 1 |
| KEY | CnsldtnTaskLogUUID | CnsldtnTaskLogUUID | 1 |
| KEY | HierarchyNode | HierarchyNode | 1 |
| AmountInGroupCurrency | AmountInGroupCurrency | 1 | |
| AmountInLocalCurrency | AmountInLocalCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BillingDocumentType | BillingDocumentType | 1 | |
| BillToParty | BillToParty | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessTransactionType | BusinessTransactionType | 1 | |
| CashLedgerAccount | CashLedgerAccount | 1 | |
| ChartOfAccounts | ChartOfAccounts | 1 | |
| CnsldtnAdhocItem | CnsldtnAdhocItem | 1 | |
| CnsldtnAdhocSet | CnsldtnAdhocSet | 1 | |
| CnsldtnAdhocSetItem | CnsldtnAdhocSetItem | 1 | |
| CnsldtnCashLedgerChartOfAccts | CnsldtnCashLedgerChartOfAccts | 1 | |
| CnsldtnCrcyTranslationKey | CnsldtnCrcyTranslationKey | 1 | |
| CnsldtnDiffAmtInTransCrcy | CnsldtnDiffAmtInTransCrcy | 1 | |
| CnsldtnDifferenceAmtInGrpCrcy | CnsldtnDifferenceAmtInGrpCrcy | 1 | |
| CnsldtnDiffQtyInBsUnt | CnsldtnDiffQtyInBsUnt | 1 | |
| CnsldtnExchangeRateType | CnsldtnExchangeRateType | 1 | |
| CnsldtnExchangeRateValue | CnsldtnExchangeRateValue | 1 | |
| CnsldtnFinancialStatementItem | CnsldtnFinancialStatementItem | 1 | |
| CnsldtnGroupJrnlEntry | CnsldtnGroupJrnlEntry | 1 | |
| CnsldtnGroupJrnlEntryBundle | CnsldtnGroupJrnlEntryBundle | 1 | |
| CnsldtnMatchingRuleID | CnsldtnMatchingRuleID | 1 | |
| CnsldtnPrtnUnitReconciliation | CnsldtnPrtnUnitReconciliation | 1 | |
| CnsldtnPrtnUntAmtInGrpCrcy | CnsldtnPrtnUntAmtInGrpCrcy | 1 | |
| CnsldtnPrtnUntAmtInTransCrcy | CnsldtnPrtnUntAmtInTransCrcy | 1 | |
| CnsldtnPrtnUntQtyInBsUnt | CnsldtnPrtnUntQtyInBsUnt | 1 | |
| CnsldtnQuantityInBaseUnit | CnsldtnQuantityInBaseUnit | 1 | |
| CnsldtnRefExchangeRateType | CnsldtnRefExchangeRateType | 1 | |
| CnsldtnRefExchangeRateValue | CnsldtnRefExchangeRateValue | 1 | |
| CnsldtnTaskLogItemType | CnsldtnTaskLogItemType | 1 | |
| CnsldtnTskLgItmRowNmbr | CnsldtnTskLgItmRowNmbr | 1 | |
| CnsldtnUnitReconciliation | CnsldtnUnitReconciliation | 1 | |
| CnsldtnUntAmtInGrpCrcy | CnsldtnUntAmtInGrpCrcy | 1 | |
| CnsldtnUntAmtInTransCrcy | CnsldtnUntAmtInTransCrcy | 1 | |
| CnsldtnUntQtyInBsUnt | CnsldtnUntQtyInBsUnt | 1 | |
| Company | Company | 1 | |
| CompanyCode | CompanyCode | 1 | |
| ConsolidationAcquisitionPeriod | ConsolidationAcquisitionPeriod | 1 | |
| ConsolidationAcquisitionYear | ConsolidationAcquisitionYear | 1 | |
| ConsolidationApportionment | ConsolidationApportionment | 1 | |
| ConsolidationChartOfAccounts | ConsolidationChartOfAccounts | 1 | |
| ConsolidationDisplayGroup | ConsolidationDisplayGroup | 1 | |
| ConsolidationDocumentNumber | ConsolidationDocumentNumber | 1 | |
| ConsolidationDocumentType | ConsolidationDocumentType | 1 | |
| ConsolidationGroup | ConsolidationGroup | 1 | |
| ConsolidationPostgItemAutoFlag | ConsolidationPostgItemAutoFlag | 1 | |
| ConsolidationPostingItem | ConsolidationPostingItem | 1 | |
| ConsolidationSelection | ConsolidationSelection | 1 | |
| ConsolidationTask | ConsolidationTask | 1 | |
| ConsolidationUnit | ConsolidationUnit | 1 | |
| ConsolidationVersion | ConsolidationVersion | 1 | |
| ControllingArea | ControllingArea | 1 | |
| CostCenter | CostCenter | 1 | |
| CreationDate | CreationDate | 1 | |
| CreationDateTime | CreationDateTime | 1 | |
| CreationTime | CreationTime | 1 | |
| CurrencyConversionsDiffType | CurrencyConversionsDiffType | 1 | |
| CurrencyTranslationDate | CurrencyTranslationDate | 1 | |
| Customer | Customer | 1 | |
| CustomerGroup | CustomerGroup | 1 | |
| CustomerSupplierCorporateGroup | CustomerSupplierCorporateGroup | 1 | |
| CustomerSupplierCountry | CustomerSupplierCountry | 1 | |
| CustomerSupplierIndustry | CustomerSupplierIndustry | 1 | |
| DistributionChannel | DistributionChannel | 1 | |
| DocumentCategory | DocumentCategory | 1 | |
| DocumentItemText | DocumentItemText | 1 | |
| DocumentReferenceID | DocumentReferenceID | 1 | |
| FinancialDataSource | FinancialDataSource | 1 | |
| FinancialManagementArea | FinancialManagementArea | 1 | |
| FinancialServicesBranch | FinancialServicesBranch | 1 | |
| FinancialServicesProductGroup | FinancialServicesProductGroup | 1 | |
| FinancialTransactionType | FinancialTransactionType | 1 | |
| FiscalPeriod | FiscalPeriod | 1 | |
| FiscalYearPeriod | FiscalYearPeriod | 1 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| GHGCategory | GHGCategory | 1 | |
| GHGDataQualityCharacteristic | GHGDataQualityCharacteristic | 1 | |
| GHGEnergyClassification | GHGEnergyClassification | 1 | |
| GHGEnergyMix | GHGEnergyMix | 1 | |
| GHGEnergySourcingType | GHGEnergySourcingType | 1 | |
| GHGScope | GHGScope | 1 | |
| GHGScope2CalculationMethod | GHGScope2CalculationMethod | 1 | |
| GHGScope2ContractualInstrument | GHGScope2ContractualInstrument | 1 | |
| GLAccount | GLAccount | 1 | |
| GLRecordType | GLRecordType | 1 | |
| GrantID | GrantID | 1 | |
| GroupCurrency | GroupCurrency | 1 | |
| IntercompanyTransaction | IntercompanyTransaction | 1 | |
| InvesteeConsolidationUnit | InvesteeConsolidationUnit | 1 | |
| InvestmentActivity | InvestmentActivity | 1 | |
| InvestmentActivityType | InvestmentActivityType | 1 | |
| InvestorConsolidationUnit | InvestorConsolidationUnit | 1 | |
| LocalCurrency | LocalCurrency | 1 | |
| LogicalSystem | LogicalSystem | 1 | |
| MatchingMethodID | MatchingMethodID | 1 | |
| MatchingReasonCode | MatchingReasonCode | 1 | |
| Material | Material | 1 | |
| MaterialGroup | MaterialGroup | 1 | |
| OrderID | OrderID | 1 | |
| OrganizationDivision | OrganizationDivision | 1 | |
| OriginReference | OriginReference | 1 | |
| OriginType | OriginType | 1 | |
| PartnerBusinessArea | PartnerBusinessArea | 1 | |
| PartnerCompany | PartnerCompany | 1 | |
| PartnerConsolidationUnit | PartnerConsolidationUnit | 1 | |
| PartnerCostCenter | PartnerCostCenter | 1 | |
| PartnerFunctionalArea | PartnerFunctionalArea | 1 | |
| PartnerFund | PartnerFund | 1 | |
| PartnerProfitCenter | PartnerProfitCenter | 1 | |
| PartnerSegment | PartnerSegment | 1 | |
| Plant | Plant | 1 | |
| PostingDate | PostingDate | 1 | |
| PostingLevel | PostingLevel | 1 | |
| Product | Product | 1 | |
| ProductGroup | ProductGroup | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| Project | Project | 1 | |
| ReconciliationCaseID | ReconciliationCaseID | 1 | |
| RefBusinessTransactionType | RefBusinessTransactionType | 1 | |
| RefConsolidationDocumentNumber | RefConsolidationDocumentNumber | 1 | |
| RefConsolidationDocumentType | RefConsolidationDocumentType | 1 | |
| RefConsolidationPostingItem | RefConsolidationPostingItem | 1 | |
| ReferenceDocumentContext | ReferenceDocumentContext | 1 | |
| ReferenceDocumentType | ReferenceDocumentType | 1 | |
| ReferenceFiscalYear | ReferenceFiscalYear | 1 | |
| SalesDistrict | SalesDistrict | 1 | |
| SalesOrganization | SalesOrganization | 1 | |
| Segment | Segment | 1 | |
| SequenceNumber | SequenceNumber | 1 | |
| ShipToParty | ShipToParty | 1 | |
| SoldMaterial | SoldMaterial | 1 | |
| SoldProduct | SoldProduct | 1 | |
| SoldProductGroup | SoldProductGroup | 1 | |
| SubItem | SubItem | 1 | |
| SubItemCategory | SubItemCategory | 1 | |
| Supplier | Supplier | 1 | |
| SustainabilityModeOfTransport | SustainabilityModeOfTransport | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| WBSElementExternalID | WBSElementExternalID | 1 | |
| 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.
-- Consolidation Reconciliation Item Struct
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_CNSLDTNRECNCLNITEMSTRCT (
CNSLDTNTASKLOGITEMUUID,
CNSLDTNTASKLOGUUID,
HIERARCHYNODE,
AMOUNTINGROUPCURRENCY,
AMOUNTINLOCALCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
ASSIGNMENTREFERENCE,
BASEUNIT,
BILLINGDOCUMENTTYPE,
BILLTOPARTY,
BUSINESSAREA,
BUSINESSTRANSACTIONTYPE,
CASHLEDGERACCOUNT,
CHARTOFACCOUNTS,
CNSLDTNADHOCITEM,
CNSLDTNADHOCSET,
CNSLDTNADHOCSETITEM,
CNSLDTNCASHLEDGERCHARTOFACCTS,
CNSLDTNCRCYTRANSLATIONKEY,
CNSLDTNDIFFAMTINTRANSCRCY,
CNSLDTNDIFFERENCEAMTINGRPCRCY,
CNSLDTNDIFFQTYINBSUNT,
CNSLDTNEXCHANGERATETYPE,
CNSLDTNEXCHANGERATEVALUE,
CNSLDTNFINANCIALSTATEMENTITEM,
CNSLDTNGROUPJRNLENTRY,
CNSLDTNGROUPJRNLENTRYBUNDLE,
CNSLDTNMATCHINGRULEID,
CNSLDTNPRTNUNITRECONCILIATION,
CNSLDTNPRTNUNTAMTINGRPCRCY,
CNSLDTNPRTNUNTAMTINTRANSCRCY,
CNSLDTNPRTNUNTQTYINBSUNT,
CNSLDTNQUANTITYINBASEUNIT,
CNSLDTNREFEXCHANGERATETYPE,
CNSLDTNREFEXCHANGERATEVALUE,
CNSLDTNTASKLOGITEMTYPE,
CNSLDTNTSKLGITMROWNMBR,
CNSLDTNUNITRECONCILIATION,
CNSLDTNUNTAMTINGRPCRCY,
CNSLDTNUNTAMTINTRANSCRCY,
CNSLDTNUNTQTYINBSUNT,
COMPANY,
COMPANYCODE,
CONSOLIDATIONACQUISITIONPERIOD,
CONSOLIDATIONACQUISITIONYEAR,
CONSOLIDATIONAPPORTIONMENT,
CONSOLIDATIONCHARTOFACCOUNTS,
CONSOLIDATIONDISPLAYGROUP,
CONSOLIDATIONDOCUMENTNUMBER,
CONSOLIDATIONDOCUMENTTYPE,
CONSOLIDATIONGROUP,
CONSOLIDATIONPOSTGITEMAUTOFLAG,
CONSOLIDATIONPOSTINGITEM,
CONSOLIDATIONSELECTION,
CONSOLIDATIONTASK,
CONSOLIDATIONUNIT,
CONSOLIDATIONVERSION,
CONTROLLINGAREA,
COSTCENTER,
CREATIONDATE,
CREATIONDATETIME,
CREATIONTIME,
CURRENCYCONVERSIONSDIFFTYPE,
CURRENCYTRANSLATIONDATE,
CUSTOMER,
CUSTOMERGROUP,
CUSTOMERSUPPLIERCORPORATEGROUP,
CUSTOMERSUPPLIERCOUNTRY,
CUSTOMERSUPPLIERINDUSTRY,
DISTRIBUTIONCHANNEL,
DOCUMENTCATEGORY,
DOCUMENTITEMTEXT,
DOCUMENTREFERENCEID,
FINANCIALDATASOURCE,
FINANCIALMANAGEMENTAREA,
FINANCIALSERVICESBRANCH,
FINANCIALSERVICESPRODUCTGROUP,
FINANCIALTRANSACTIONTYPE,
FISCALPERIOD,
FISCALYEARPERIOD,
FUNCTIONALAREA,
FUND,
GHGCATEGORY,
GHGDATAQUALITYCHARACTERISTIC,
GHGENERGYCLASSIFICATION,
GHGENERGYMIX,
GHGENERGYSOURCINGTYPE,
GHGSCOPE,
GHGSCOPE2CALCULATIONMETHOD,
GHGSCOPE2CONTRACTUALINSTRUMENT,
GLACCOUNT,
GLRECORDTYPE,
GRANTID,
GROUPCURRENCY,
INTERCOMPANYTRANSACTION,
INVESTEECONSOLIDATIONUNIT,
INVESTMENTACTIVITY,
INVESTMENTACTIVITYTYPE,
INVESTORCONSOLIDATIONUNIT,
LOCALCURRENCY,
LOGICALSYSTEM,
MATCHINGMETHODID,
MATCHINGREASONCODE,
MATERIAL,
MATERIALGROUP,
ORDERID,
ORGANIZATIONDIVISION,
ORIGINREFERENCE,
ORIGINTYPE,
PARTNERBUSINESSAREA,
PARTNERCOMPANY,
PARTNERCONSOLIDATIONUNIT,
PARTNERCOSTCENTER,
PARTNERFUNCTIONALAREA,
PARTNERFUND,
PARTNERPROFITCENTER,
PARTNERSEGMENT,
PLANT,
POSTINGDATE,
POSTINGLEVEL,
PRODUCT,
PRODUCTGROUP,
PROFITCENTER,
PROJECT,
RECONCILIATIONCASEID,
REFBUSINESSTRANSACTIONTYPE,
REFCONSOLIDATIONDOCUMENTNUMBER,
REFCONSOLIDATIONDOCUMENTTYPE,
REFCONSOLIDATIONPOSTINGITEM,
REFERENCEDOCUMENTCONTEXT,
REFERENCEDOCUMENTTYPE,
REFERENCEFISCALYEAR,
SALESDISTRICT,
SALESORGANIZATION,
SEGMENT,
SEQUENCENUMBER,
SHIPTOPARTY,
SOLDMATERIAL,
SOLDPRODUCT,
SOLDPRODUCTGROUP,
SUBITEM,
SUBITEMCATEGORY,
SUPPLIER,
SUSTAINABILITYMODEOFTRANSPORT,
TRANSACTIONCURRENCY,
WBSELEMENTEXTERNALID,
WBSELEMENTINTERNALID,
PRIMARY KEY (CNSLDTNTASKLOGITEMUUID, CNSLDTNTASKLOGUUID, HIERARCHYNODE)
);Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA