P_APLineItem_4

Created from DDL source P_APLINEITEM_4 | view: PAPLINEITEM4 | Extraction: Not supported | Component: Information System
Tables used: VBKPF, VBSEGK, VBSEGD, BSAD_BCK, BSAK_BCK, BKPF, BSEG, T001, TKA02, T005, T000, T001A, T880, T014
Column Name Description
CompanyCode FK Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Posting View Item
Column Name Description
💲 Additional Currency 1 (AdditionalCurrency1):
AmountInAdditionalCurrency1 Amount in Additional Currency 1
ValuationDiffAmtInAddlCrcy1 Valuation Difference Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuationDiffAmtInAddlCrcy2 Valuation Difference Amount in Additional Currency 2
💲 Update Currency for General Ledger Transaction Figures (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
CashDiscountAmount Cash Discount Amount
CashDiscountBaseAmount Cash Discount Base Amount
HedgedAmount Credit Management: Hedged Amount
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
WithholdingTaxAmount Withholding Tax Amount
WithholdingTaxBaseAmount Withholding Tax Base Amount
WithholdingTaxExemptionAmt Withholding Tax-Exemption Amount
Column Name Description
Column Name Description
AccountingDocumentCreationDate Accounting Document Entry Date
CashDiscount1DueDate Due Date for Cash Discount 1
ClearingDate Clearing Date
DocumentDate Journal Entry Date
DueCalculationBaseDate Due Calculation Base Date
LastDunningDate Date of Last Dunning Notice
NetDueDate Due Date for Net Payment
PostingDate Posting Date
SettlementReferenceDate Reference Date for Settlement
TaxReportingDate Tax Reporting Date
ValueDate Value date
Column Name Description
AccountingDocumentCategory Document Status Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
ClearingIsReversed Indicator: Clearing was Reversed Show values
DebitCreditCode Debit/Credit Code Show values
FinancialAccountType Account Type Show values
FixedCashDiscount Fixed Payment Terms Show values
HasPaymentOrder Indicator: Payment Order Exists for this Item Show values
IsSalesRelated Indicator: Sales-Related Item Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
OffsettingAccountType Offsetting Account Type Show values
TreasuryContractType Treasury Contract Type Show values
Column Name Description Domain name
AccountingDocCreatedByUser User that created the journal entry
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
AssetContract Asset Contract RANL
AssignmentReference Assignment Reference ZUONR
BillingDocument Billing Document VBELN
Branch Account Number of the Branch MAXKK
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Days Cash Discount Days 2 ZBDXT
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
CashFlowType Flow Type SBEWART
ClearingAccountingDocument Clearing Document Number BELNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
CostCenter Cost Center KOSTL
PayableAlternativePayee Alternative Payee/Payer MAXKK
DataExchangeInstruction1 Instruction Key 1 DTWSX
DataExchangeInstruction2 Instruction Key 2 DTWSX
DataExchangeInstruction3 Instruction Key 3 DTWSX
DataExchangeInstruction4 Instruction Key 4 DTWSX
DocumentIsArchived null
DocumentItemText Item Text TEXT50
DocumentReferenceID Document Reference ID XBLNR1
DunningLevel Dunning Level MAHNS
FiscalPeriod Fiscal Period POPER
FollowOnDocumentType Follow-On Document Type REBZT
FundsCenter Funds Management Center FISTL
InvoiceList Collective Invoice List Number SAMNR
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
ITEM_TYPE_BRANCH 30 Characters CHAR30
NetPaymentDays Net Payment Terms Period ZBDXT
OffsettingAccount Offsetting Account GKONT
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Cards: Settlement Run CCBTC
PaymentReference Payment Reference CHAR30
PaymentTerms Terms of Payment Key ZTERM
ProfitCenter Profit Center PRCTR
RealEstateObject Internal Key for Real Estate Object IMKEY
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
SourceCompanyCode null
SpecialGLTransactionType Special G/L Transaction Type UMSKS
TaxCountry Tax Reporting Country/Region LAND1
WBSElement WBS Element PS_POSNR
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
AdditionalCurrency1Role Additional Currency 1 Role (Currency Type) FINS_CURTYPE
AdditionalCurrency2Role Additional Currency 2 Role (Currency Type) FINS_CURTYPE
BranchCode Branch Code BCODE
ReferenceDocumentType Reference Document Type AWTYP
OriginalReferenceDocument Original Reference Document AWKEY
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_APLINEITEM_4.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_APLINEITEM_4.MANDT == T003.MANDT
Accounts Receivable Pledging Indicator
  • Client
  • Company Code
  • Accounts Receivable Pledging Indicator
  • P_APLINEITEM_4.MANDT == TCESSION.CLIENT
  • P_APLINEITEM_4.COMPANYCODE == TCESSION.COMPANY
  • P_APLINEITEM_4.ACCOUNTSRECEIVABLEISPLEDGED == TCESSION.CESSION_KZ
Update Currency for General Ledger Transaction Figures
  • Update Currency for General Ledger Transaction Figures
  • Client
  • P_APLINEITEM_4.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
  • P_APLINEITEM_4.MANDT == TCURC.MANDT
Business Area
  • Client
  • Business Area
  • P_APLINEITEM_4.MANDT == TGSB.MANDT
  • P_APLINEITEM_4.BUSINESSAREA == TGSB.GSBER
Company Code
  • Client
  • Company Code
  • P_APLINEITEM_4.MANDT == T001.MANDT
  • P_APLINEITEM_4.COMPANYCODE == T001.BUKRS
Credit Control Area
  • Client
  • Credit Control Area
  • P_APLINEITEM_4.MANDT == T014.MANDT
  • P_APLINEITEM_4.CREDITCONTROLAREA == T014.KKBER
Customer
  • Customer
  • Client
  • P_APLINEITEM_4.DEBTOR == KNA1.KUNNR
  • P_APLINEITEM_4.MANDT == KNA1.MANDT
Dunning Area
  • Client
  • Company Code
  • Dunning Area
  • P_APLINEITEM_4.MANDT == T047M.MANDT
  • P_APLINEITEM_4.COMPANYCODE == T047M.BUKRS
  • P_APLINEITEM_4.DUNNINGAREA == T047M.MABER
Dunning Block
  • Dunning Block
  • Client
  • P_APLINEITEM_4.DUNNINGBLOCKINGREASON == T040S.MANSP
  • P_APLINEITEM_4.MANDT == T040S.MANDT
Dunning Key
  • Client
  • Dunning Key
  • P_APLINEITEM_4.MANDT == T040.MANDT
  • P_APLINEITEM_4.DUNNINGKEY == T040.MSCHL
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_APLINEITEM_4.MANDT == SKB1.MANDT
  • P_APLINEITEM_4.COMPANYCODE == SKB1.BUKRS
  • P_APLINEITEM_4.GLACCOUNT == SKB1.SAKNR
House Bank Key
  • ?
  • Client
  • House Bank Key
  • P_APLINEITEM_4.[column in domain "BUKRS"] == T012.BUKRS
  • P_APLINEITEM_4.MANDT == T012.MANDT
  • P_APLINEITEM_4.HOUSEBANK == T012.HBKID
House Bank Account
  • ?
  • Client
  • House Bank Key
  • House Bank Account
  • P_APLINEITEM_4.[column in domain "BUKRS"] == T012K.BUKRS
  • P_APLINEITEM_4.MANDT == T012K.MANDT
  • P_APLINEITEM_4.HOUSEBANK == T012K.HBKID
  • P_APLINEITEM_4.HOUSEBANKACCOUNT == T012K.HKTID
Order ID
  • Client
  • Order ID
  • P_APLINEITEM_4.MANDT == AUFK.MANDT
  • P_APLINEITEM_4.ORDERID == AUFK.AUFNR
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • P_APLINEITEM_4.MANDT == T880.MANDT
  • P_APLINEITEM_4.PARTNERCOMPANY == T880.RCOMP
Payment Block on Item
  • Client
  • Payment Block on Item
  • P_APLINEITEM_4.MANDT == T008.MANDT
  • P_APLINEITEM_4.PAYMENTBLOCKINGREASON == T008.ZAHLS
Currency for Automatic Payment
  • Client
  • Currency for Automatic Payment
  • P_APLINEITEM_4.MANDT == TCURC.MANDT
  • P_APLINEITEM_4.PAYMENTCURRENCY == TCURC.WAERS
Reason Code for Payments
  • Client
  • Company Code
  • Reason Code for Payments
  • P_APLINEITEM_4.MANDT == T053R.MANDT
  • P_APLINEITEM_4.COMPANYCODE == T053R.BUKRS
  • P_APLINEITEM_4.PAYMENTDIFFERENCEREASON == T053R.RSTGR
Payment Method
  • ?
  • Client
  • Payment Method
  • P_APLINEITEM_4.[column in domain "LAND1"] == T042Z.LAND1
  • P_APLINEITEM_4.MANDT == T042Z.MANDT
  • P_APLINEITEM_4.PAYMENTMETHOD == T042Z.ZLSCH
Payment Method Supplement
  • Client
  • Payment Method Supplement
  • P_APLINEITEM_4.MANDT == T042F.MANDT
  • P_APLINEITEM_4.PAYMENTMETHODSUPPLEMENT == T042F.UZAWE
Plant
  • Client
  • Plant
  • P_APLINEITEM_4.MANDT == T001W.MANDT
  • P_APLINEITEM_4.PLANT == T001W.WERKS
Posting Key
  • Client
  • Posting Key
  • P_APLINEITEM_4.MANDT == TBSL.MANDT
  • P_APLINEITEM_4.POSTINGKEY == TBSL.BSCHL
Special G/L Indicator
  • Special G/L Indicator
  • Client
  • ?
  • P_APLINEITEM_4.SPECIALGLCODE == T074U.UMSKZ
  • P_APLINEITEM_4.MANDT == T074U.MANDT
  • P_APLINEITEM_4.[column in domain "KOART"] == T074U.KOART
State Central Bank Payment Reason
  • State Central Bank Payment Reason
  • Client
  • P_APLINEITEM_4.STATECENTRALBANKPAYMENTREASON == T015L.LZBKZ
  • P_APLINEITEM_4.MANDT == T015L.MANDT
Supplier
  • Client
  • Supplier
  • P_APLINEITEM_4.MANDT == LFA1.MANDT
  • P_APLINEITEM_4.SUPPLIER == LFA1.LIFNR
Supplying Country/Region
  • Supplying Country/Region
  • Client
  • P_APLINEITEM_4.SUPPLYINGCOUNTRY == T005.LAND1
  • P_APLINEITEM_4.MANDT == T005.MANDT
Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • Client
  • ?
  • ?
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_APLINEITEM_4.MANDT == T683.MANDT
  • P_APLINEITEM_4.[column in domain "KVEWE"] == T683.KVEWE
  • P_APLINEITEM_4.[column in domain "KAPPL"] == T683.KAPPL
  • P_APLINEITEM_4.TAXCALCULATIONPROCEDURE == T683.KALSM
Sales/Purchases Tax Code
  • Sales/Purchases Tax Code
  • Client
  • Procedure (Pricing, Output Control, Acct. Det., Costing,...)
  • P_APLINEITEM_4.TAXCODE == T007A.MWSKZ
  • P_APLINEITEM_4.MANDT == T007A.MANDT
  • P_APLINEITEM_4.TAXCALCULATIONPROCEDURE == T007A.KALSM
Tax Section
  • Tax Section
  • Client
  • Company Code
  • P_APLINEITEM_4.TAXSECTION == SECCODE.SECCODE
  • P_APLINEITEM_4.MANDT == SECCODE.MANDT
  • P_APLINEITEM_4.COMPANYCODE == SECCODE.BUKRS
Transaction Currency
  • Client
  • Transaction Currency
  • P_APLINEITEM_4.MANDT == TCURC.MANDT
  • P_APLINEITEM_4.TRANSACTIONCURRENCY == TCURC.WAERS