I_PARKEDOPLACCTGDOCGLITEM
Parked General Ledger Item
I_PARKEDOPLACCTGDOCGLITEM is a CDS View in S/4HANA. Parked General Ledger Item. It contains 98 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_MngJrnlEntrPrkdDocumentItem | view_entity | union_all | COMPOSITE | |
| P_ParkedOplAcctgDocItem | view_entity | from | COMPOSITE | |
| R_MngJrnlEntrPrkdChgDocTblKey | view | union_all | TRANSACTIONAL | Journal Entry - Parked Changed Header Table Key |
Fields (98)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SourceAccountingDocument | SourceAccountingDocument | 1 |
| KEY | SourceAccountingDocumentItem | SourceAccountingDocumentItem | 1 |
| KEY | SourceCompanyCode | SourceCompanyCode | 1 |
| KEY | SourceFiscalYear | SourceFiscalYear | 1 |
| AccountAssignmentNumber | AccountAssignmentNumber | 1 | |
| AdditionalCurrency1 | AdditionalCurrency1 | 1 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 1 | |
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | 1 | |
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | 1 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 1 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 1 | |
| AssetContract | AssetContract | 1 | |
| AssetTransactionType | AssetTransactionType | 1 | |
| AssetValueDate | AssetValueDate | 1 | |
| AssignmentReference | AssignmentReference | 1 | |
| BaseUnit | BaseUnit | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BusinessArea | BusinessArea | 1 | |
| BusinessPlace | BusinessPlace | 1 | |
| BusinessProcess | BusinessProcess | 1 | |
| CashFlowType | CashFlowType | 1 | |
| CommitmentItemShortID | CommitmentItemShortID | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 1 | |
| CompanyCodeCurrencyDetnMethod | CompanyCodeCurrencyDetnMethod | 1 | |
| CostCenter | CostCenter | 1 | |
| CostCtrActivityType | CostCtrActivityType | 1 | |
| CostObject | CostObject | 1 | |
| CostOriginGroup | CostOriginGroup | 1 | |
| DebitCreditCode | DebitCreditCode | 1 | |
| DocumentItemText | DocumentItemText | 1 | |
| DueCalculationBaseDate | DueCalculationBaseDate | 1 | |
| FinancialAccountType | FinancialAccountType | 1 | |
| FixedAsset | FixedAsset | 1 | |
| Fund | Fund | 1 | |
| FundedProgram | FundedProgram | 1 | |
| FundsCenter | FundsCenter | 1 | |
| GLAccount | GLAccount | 1 | |
| GrantID | GrantID | 1 | |
| HouseBank | HouseBank | 1 | |
| HouseBankAccount | HouseBankAccount | 1 | |
| InventoryValuationType | InventoryValuationType | 1 | |
| InvoiceAmountInFrgnCurrency | InvoiceAmountInFrgnCurrency | 1 | |
| InvoiceAmtInCoCodeCrcy | InvoiceAmtInCoCodeCrcy | 1 | |
| IsEUTriangularDeal | IsEUTriangularDeal | 1 | |
| IsNotCashDiscountLiable | IsNotCashDiscountLiable | 1 | |
| IsSalesRelated | IsSalesRelated | 1 | |
| JointVenture | JointVenture | 1 | |
| JointVentureCostRecoveryCode | JointVentureCostRecoveryCode | 1 | |
| JointVentureEquityGroup | JointVentureEquityGroup | 1 | |
| JointVentureEquityType | JointVentureEquityType | 1 | |
| JointVenturePartner | JointVenturePartner | 1 | |
| MasterFixedAsset | MasterFixedAsset | 1 | |
| MaterialPriceControl | MaterialPriceControl | 1 | |
| MaterialPriceUnitQty | MaterialPriceUnitQty | 1 | |
| NetDueDate | NetDueDate | 1 | |
| OrderID | OrderID | 1 | |
| OrderInternalBillOfOperations | OrderInternalBillOfOperations | 1 | |
| PartnerBudgetPeriod | PartnerBudgetPeriod | 1 | |
| PartnerBusinessArea | PartnerBusinessArea | 1 | |
| PartnerFund | PartnerFund | 1 | |
| PartnerGrant | PartnerGrant | 1 | |
| PartnerSegment | PartnerSegment | 1 | |
| PaymentCardPaymentSettlement | PaymentCardPaymentSettlement | 1 | |
| PaymentDifferenceReason | PaymentDifferenceReason | 1 | |
| PaymentMethodSupplement | PaymentMethodSupplement | 1 | |
| PersonnelNumber | PersonnelNumber | 1 | |
| PlannedAmtInTransactionCrcy | PlannedAmtInTransactionCrcy | 1 | |
| PlanningLevel | PlanningLevel | 1 | |
| Plant | Plant | 1 | |
| PostingKey | PostingKey | 1 | |
| Product | Product | 1 | |
| ProfitabilitySegment | ProfitabilitySegment | 1 | |
| ProfitCenter | ProfitCenter | 1 | |
| ProjectNetwork | ProjectNetwork | 1 | |
| PurchasingDocument | PurchasingDocument | 1 | |
| PurchasingDocumentItem | PurchasingDocumentItem | 1 | |
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | 1 | |
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | 1 | |
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | 1 | |
| Region | Region | 1 | |
| REInternalFinNumber | REInternalFinNumber | 1 | |
| Segment | Segment | 1 | |
| SettlementReferenceDate | SettlementReferenceDate | 1 | |
| SpecialGLAccountAssignment | SpecialGLAccountAssignment | 1 | |
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | 1 | |
| SupplyingCountry | SupplyingCountry | 1 | |
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | 1 | |
| TaxBaseAmountInTransCrcy | TaxBaseAmountInTransCrcy | 1 | |
| TaxCode | TaxCode | 1 | |
| TaxJurisdiction | TaxJurisdiction | 1 | |
| TaxType | TaxType | 1 | |
| TransactionCurrency | TransactionCurrency | 1 | |
| TreasuryContractType | TreasuryContractType | 1 | |
| ValuationArea | ValuationArea | 1 | |
| ValueDate | ValueDate | 1 | |
| VATRegistration | VATRegistration | 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.
-- Parked General Ledger Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PARKEDOPLACCTGDOCGLITEM (
SOURCEACCOUNTINGDOCUMENT,
SOURCEACCOUNTINGDOCUMENTITEM,
SOURCECOMPANYCODE,
SOURCEFISCALYEAR,
ACCOUNTASSIGNMENTNUMBER,
ADDITIONALCURRENCY1,
ADDITIONALCURRENCY2,
AMOUNTINADDITIONALCURRENCY1,
AMOUNTINADDITIONALCURRENCY2,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
ASSETCONTRACT,
ASSETTRANSACTIONTYPE,
ASSETVALUEDATE,
ASSIGNMENTREFERENCE,
BASEUNIT,
BUDGETPERIOD,
BUSINESSAREA,
BUSINESSPLACE,
BUSINESSPROCESS,
CASHFLOWTYPE,
COMMITMENTITEMSHORTID,
COMPANYCODE,
COMPANYCODECURRENCY,
COMPANYCODECURRENCYDETNMETHOD,
COSTCENTER,
COSTCTRACTIVITYTYPE,
COSTOBJECT,
COSTORIGINGROUP,
DEBITCREDITCODE,
DOCUMENTITEMTEXT,
DUECALCULATIONBASEDATE,
FINANCIALACCOUNTTYPE,
FIXEDASSET,
FUND,
FUNDEDPROGRAM,
FUNDSCENTER,
GLACCOUNT,
GRANTID,
HOUSEBANK,
HOUSEBANKACCOUNT,
INVENTORYVALUATIONTYPE,
INVOICEAMOUNTINFRGNCURRENCY,
INVOICEAMTINCOCODECRCY,
ISEUTRIANGULARDEAL,
ISNOTCASHDISCOUNTLIABLE,
ISSALESRELATED,
JOINTVENTURE,
JOINTVENTURECOSTRECOVERYCODE,
JOINTVENTUREEQUITYGROUP,
JOINTVENTUREEQUITYTYPE,
JOINTVENTUREPARTNER,
MASTERFIXEDASSET,
MATERIALPRICECONTROL,
MATERIALPRICEUNITQTY,
NETDUEDATE,
ORDERID,
ORDERINTERNALBILLOFOPERATIONS,
PARTNERBUDGETPERIOD,
PARTNERBUSINESSAREA,
PARTNERFUND,
PARTNERGRANT,
PARTNERSEGMENT,
PAYMENTCARDPAYMENTSETTLEMENT,
PAYMENTDIFFERENCEREASON,
PAYMENTMETHODSUPPLEMENT,
PERSONNELNUMBER,
PLANNEDAMTINTRANSACTIONCRCY,
PLANNINGLEVEL,
PLANT,
POSTINGKEY,
PRODUCT,
PROFITABILITYSEGMENT,
PROFITCENTER,
PROJECTNETWORK,
PURCHASINGDOCUMENT,
PURCHASINGDOCUMENTITEM,
REFERENCE1IDBYBUSINESSPARTNER,
REFERENCE2IDBYBUSINESSPARTNER,
REFERENCE3IDBYBUSINESSPARTNER,
REGION,
REINTERNALFINNUMBER,
SEGMENT,
SETTLEMENTREFERENCEDATE,
SPECIALGLACCOUNTASSIGNMENT,
STATECENTRALBANKPAYMENTREASON,
SUPPLYINGCOUNTRY,
TAXBASEAMOUNTINCOCODECRCY,
TAXBASEAMOUNTINTRANSCRCY,
TAXCODE,
TAXJURISDICTION,
TAXTYPE,
TRANSACTIONCURRENCY,
TREASURYCONTRACTTYPE,
VALUATIONAREA,
VALUEDATE,
VATREGISTRATION,
WBSELEMENTINTERNALID,
PRIMARY KEY (SOURCEACCOUNTINGDOCUMENT, SOURCEACCOUNTINGDOCUMENTITEM, SOURCECOMPANYCODE, SOURCEFISCALYEAR)
);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