I_PARKEDOPLACCTGDOCPYBLSITEM
Parked Accounts Payable Item
I_PARKEDOPLACCTGDOCPYBLSITEM is a CDS View in S/4HANA. Parked Accounts Payable Item. It contains 103 fields. 4 CDS views read from this table.
CDS Views using this table (4)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_APLineItem_4 | view | union_all | COMPOSITE | |
| P_MngJrnlEntrPrkdDocumentItem | view_entity | union_all | COMPOSITE | |
| P_ParkedOplAcctgDocItem | view_entity | union_all | COMPOSITE | |
| R_MngJrnlEntrPrkdChgDocTblKey | view | union_all | TRANSACTIONAL | Journal Entry - Parked Changed Header Table Key |
Fields (103)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | SourceAccountingDocument | AccountingDocument,SourceAccountingDocument | 2 |
| KEY | SourceAccountingDocumentItem | AccountingDocumentItem,SourceAccountingDocumentItem | 2 |
| KEY | SourceFiscalYear | FiscalYear,SourceFiscalYear | 2 |
| AdditionalCurrency1 | AdditionalCurrency1 | 2 | |
| AdditionalCurrency2 | AdditionalCurrency2 | 2 | |
| AlternativePayeePayer | PayableAlternativePayee | 1 | |
| AmountInAdditionalCurrency1 | AmountInAdditionalCurrency1 | 2 | |
| AmountInAdditionalCurrency2 | AmountInAdditionalCurrency2 | 2 | |
| AmountInCompanyCodeCurrency | AmountInCompanyCodeCurrency | 2 | |
| AmountInPaymentCurrency | AmountInPaymentCurrency | 2 | |
| AmountInTransactionCurrency | AmountInTransactionCurrency | 2 | |
| AssetContract | AssetContract | 2 | |
| AssetTransactionType | AssetTransactionType | 1 | |
| AssignmentReference | AssignmentReference | 2 | |
| BPBankAccountInternalID | BPBankAccountInternalID | 2 | |
| BranchAccount | Branch,BranchAccount | 2 | |
| BranchCode | BranchCode | 1 | |
| BudgetPeriod | BudgetPeriod | 1 | |
| BusinessArea | BusinessArea | 2 | |
| BusinessPlace | BusinessPlace | 2 | |
| CashDiscount1Days | CashDiscount1Days | 2 | |
| CashDiscount1DueDate | CashDiscount1DueDate | 2 | |
| CashDiscount1Percent | CashDiscount1Percent | 2 | |
| CashDiscount2Days | CashDiscount2Days | 2 | |
| CashDiscount2DueDate | CashDiscount2DueDate | 1 | |
| CashDiscount2Percent | CashDiscount2Percent | 2 | |
| CashDiscountAmount | CashDiscountAmount | 2 | |
| CashDiscountAmtInCoCodeCrcy | CashDiscountAmtInCoCodeCrcy | 2 | |
| CashDiscountBaseAmount | CashDiscountBaseAmount | 2 | |
| CashFlowType | CashFlowType | 2 | |
| CommitmentItemShortID | CommitmentItemShortID | 1 | |
| CompanyCode | CompanyCode | 1 | |
| CompanyCodeCurrency | CompanyCodeCurrency | 2 | |
| DataExchangeInstruction1 | DataExchangeInstruction1 | 2 | |
| DataExchangeInstruction2 | DataExchangeInstruction2 | 2 | |
| DataExchangeInstruction3 | DataExchangeInstruction3 | 2 | |
| DataExchangeInstruction4 | DataExchangeInstruction4 | 2 | |
| DebitCreditCode | DebitCreditCode | 2 | |
| DocumentItemText | DocumentItemText | 2 | |
| DueCalculationBaseDate | DueCalculationBaseDate | 2 | |
| DunningArea | DunningArea | 2 | |
| DunningBlockingReason | DunningBlockingReason | 2 | |
| DunningKey | DunningKey | 2 | |
| DunningLevel | DunningLevel | 2 | |
| FinancialAccountType | FinancialAccountType | 1 | |
| FinancialTransactionType | FinancialTransactionType | 1 | |
| FixedCashDiscount | FixedCashDiscount | 2 | |
| FollowOnDocumentType | FollowOnDocumentType | 2 | |
| FunctionalArea | FunctionalArea | 1 | |
| Fund | Fund | 1 | |
| FundsCenter | FundsCenter | 2 | |
| GLAccount | GLAccount | 2 | |
| GrantID | GrantID | 1 | |
| HouseBank | HouseBank | 2 | |
| HouseBankAccount | HouseBankAccount | 2 | |
| InvoiceItemReference | InvoiceItemReference | 1 | |
| InvoiceList | InvoiceList | 2 | |
| InvoiceReference | InvoiceReference | 2 | |
| IsSalesRelated | IsSalesRelated | 2 | |
| JointVenture | JointVenture | 2 | |
| JointVentureBillingType | JointVentureBillingType | 1 | |
| JointVentureEquityGroup | JointVentureEquityGroup | 1 | |
| LastDunningDate | LastDunningDate | 2 | |
| NetDueDate | NetDueDate | 2 | |
| NetPaymentDays | NetPaymentDays | 2 | |
| PartnerBusinessArea | PartnerBusinessArea | 1 | |
| PaymentBlockingReason | PaymentBlockingReason | 2 | |
| PaymentCurrency | PaymentCurrency | 2 | |
| PaymentDifferenceReason | PaymentDifferenceReason | 2 | |
| PaymentMethod | PaymentMethod | 2 | |
| PaymentMethodSupplement | PaymentMethodSupplement | 2 | |
| PaymentReason | PaymentReason | 1 | |
| PaymentReference | PaymentReference | 2 | |
| PaymentTerms | PaymentTerms | 2 | |
| PlannedAmtInTransactionCrcy | PlannedAmtInTransactionCrcy | 2 | |
| PlanningLevel | PlanningLevel | 1 | |
| PostingKey | PostingKey | 2 | |
| Reference1IDByBusinessPartner | Reference1IDByBusinessPartner | 2 | |
| Reference2IDByBusinessPartner | Reference2IDByBusinessPartner | 2 | |
| Reference3IDByBusinessPartner | Reference3IDByBusinessPartner | 2 | |
| SettlementReferenceDate | SettlementReferenceDate | 2 | |
| SourceCompanyCode | SourceCompanyCode | 1 | |
| SpecialGLAccountAssignment | SpecialGLAccountAssignment | 1 | |
| SpecialGLCode | SpecialGLCode | 2 | |
| SpecialGLTransactionType | SpecialGLTransactionType | 2 | |
| StateCentralBankPaymentReason | StateCentralBankPaymentReason | 2 | |
| Supplier | Supplier | 2 | |
| SupplyingCountry | SupplyingCountry | 2 | |
| TaxAmount | TaxAmount | 1 | |
| TaxAmountInCoCodeCrcy | TaxAmountInCoCodeCrcy | 1 | |
| TaxBaseAmountInCoCodeCrcy | TaxBaseAmountInCoCodeCrcy | 1 | |
| TaxBaseAmountInTransCrcy | TaxBaseAmountInTransCrcy | 1 | |
| TaxCode | TaxCode | 2 | |
| TaxCountry | TaxCountry | 1 | |
| TaxSection | TaxSection | 2 | |
| TaxType | TaxType | 1 | |
| TransactionCurrency | TransactionCurrency | 2 | |
| TreasuryContractType | TreasuryContractType | 2 | |
| ValueDate | ValueDate | 2 | |
| VATRegistration | VATRegistration | 1 | |
| WithholdingTaxAmount | WithholdingTaxAmount | 2 | |
| WithholdingTaxBaseAmount | WithholdingTaxBaseAmount | 2 | |
| WithholdingTaxExemptionAmt | WithholdingTaxExemptionAmt | 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 Accounts Payable Item
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_PARKEDOPLACCTGDOCPYBLSITEM (
SOURCEACCOUNTINGDOCUMENT,
SOURCEACCOUNTINGDOCUMENTITEM,
SOURCEFISCALYEAR,
ADDITIONALCURRENCY1,
ADDITIONALCURRENCY2,
ALTERNATIVEPAYEEPAYER,
AMOUNTINADDITIONALCURRENCY1,
AMOUNTINADDITIONALCURRENCY2,
AMOUNTINCOMPANYCODECURRENCY,
AMOUNTINPAYMENTCURRENCY,
AMOUNTINTRANSACTIONCURRENCY,
ASSETCONTRACT,
ASSETTRANSACTIONTYPE,
ASSIGNMENTREFERENCE,
BPBANKACCOUNTINTERNALID,
BRANCHACCOUNT,
BRANCHCODE,
BUDGETPERIOD,
BUSINESSAREA,
BUSINESSPLACE,
CASHDISCOUNT1DAYS,
CASHDISCOUNT1DUEDATE,
CASHDISCOUNT1PERCENT,
CASHDISCOUNT2DAYS,
CASHDISCOUNT2DUEDATE,
CASHDISCOUNT2PERCENT,
CASHDISCOUNTAMOUNT,
CASHDISCOUNTAMTINCOCODECRCY,
CASHDISCOUNTBASEAMOUNT,
CASHFLOWTYPE,
COMMITMENTITEMSHORTID,
COMPANYCODE,
COMPANYCODECURRENCY,
DATAEXCHANGEINSTRUCTION1,
DATAEXCHANGEINSTRUCTION2,
DATAEXCHANGEINSTRUCTION3,
DATAEXCHANGEINSTRUCTION4,
DEBITCREDITCODE,
DOCUMENTITEMTEXT,
DUECALCULATIONBASEDATE,
DUNNINGAREA,
DUNNINGBLOCKINGREASON,
DUNNINGKEY,
DUNNINGLEVEL,
FINANCIALACCOUNTTYPE,
FINANCIALTRANSACTIONTYPE,
FIXEDCASHDISCOUNT,
FOLLOWONDOCUMENTTYPE,
FUNCTIONALAREA,
FUND,
FUNDSCENTER,
GLACCOUNT,
GRANTID,
HOUSEBANK,
HOUSEBANKACCOUNT,
INVOICEITEMREFERENCE,
INVOICELIST,
INVOICEREFERENCE,
ISSALESRELATED,
JOINTVENTURE,
JOINTVENTUREBILLINGTYPE,
JOINTVENTUREEQUITYGROUP,
LASTDUNNINGDATE,
NETDUEDATE,
NETPAYMENTDAYS,
PARTNERBUSINESSAREA,
PAYMENTBLOCKINGREASON,
PAYMENTCURRENCY,
PAYMENTDIFFERENCEREASON,
PAYMENTMETHOD,
PAYMENTMETHODSUPPLEMENT,
PAYMENTREASON,
PAYMENTREFERENCE,
PAYMENTTERMS,
PLANNEDAMTINTRANSACTIONCRCY,
PLANNINGLEVEL,
POSTINGKEY,
REFERENCE1IDBYBUSINESSPARTNER,
REFERENCE2IDBYBUSINESSPARTNER,
REFERENCE3IDBYBUSINESSPARTNER,
SETTLEMENTREFERENCEDATE,
SOURCECOMPANYCODE,
SPECIALGLACCOUNTASSIGNMENT,
SPECIALGLCODE,
SPECIALGLTRANSACTIONTYPE,
STATECENTRALBANKPAYMENTREASON,
SUPPLIER,
SUPPLYINGCOUNTRY,
TAXAMOUNT,
TAXAMOUNTINCOCODECRCY,
TAXBASEAMOUNTINCOCODECRCY,
TAXBASEAMOUNTINTRANSCRCY,
TAXCODE,
TAXCOUNTRY,
TAXSECTION,
TAXTYPE,
TRANSACTIONCURRENCY,
TREASURYCONTRACTTYPE,
VALUEDATE,
VATREGISTRATION,
WITHHOLDINGTAXAMOUNT,
WITHHOLDINGTAXBASEAMOUNT,
WITHHOLDINGTAXEXEMPTIONAMT,
PRIMARY KEY (SOURCEACCOUNTINGDOCUMENT, SOURCEACCOUNTINGDOCUMENTITEM, 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