P_PT_DocItemPartner

View to select all partner and customer line item | view: PTDOCITEMPARTER | Extraction: Not supported | Component: Financials Portugal
Tables used: BKPFBSEGKNA1LFA1T001T014
Column Name Description
CompanyCode FK Company Code
FiscalYear Fiscal Year
AccountingDocument Journal Entry
AccountingDocumentItem Journal Entry Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
AmountInCompanyCodeCurrency null
WithholdingTaxAmount null
CashDiscountAmount null
Column Name Description
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
DebitCreditCode Debit/Credit Code Show values
IsSalesRelated Is Sales Related Show values
FinancialAccountType Account Type Show values
OneTimeVendor Indicator: Is the account a one-time account? Show values
OneTimeCustomer Indicator: Is the account a one-time account? Show values
Column Name Description Domain name
VATRegistration VAT Registration STCEG
ExchangeRate Exchange Rate UKURS
SupplierVATRegistration VAT Registration Number STCEG
CustomerVATRegistration VAT Registration Number STCEG
VATRegistrationCountry null
SupplierVATRegistrationCountry null
CustomerVATRegistrationCountry null
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_PT_DOCITEMPARTNER.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_PT_DOCITEMPARTNER.MANDT == T003.MANDT
Balance Transaction Currency
  • Client
  • Balance Transaction Currency
  • P_PT_DOCITEMPARTNER.MANDT == TCURC.MANDT
  • P_PT_DOCITEMPARTNER.BALANCETRANSACTIONCURRENCY == TCURC.WAERS
Company Code
  • Company Code
  • Client
  • P_PT_DOCITEMPARTNER.COMPANYCODE == T001.BUKRS
  • P_PT_DOCITEMPARTNER.MANDT == T001.MANDT
Customer Number
  • Client
  • Customer Number
  • P_PT_DOCITEMPARTNER.MANDT == KNA1.MANDT
  • P_PT_DOCITEMPARTNER.CUSTOMER == KNA1.KUNNR
Supplier
  • Supplier
  • Client
  • P_PT_DOCITEMPARTNER.SUPPLIER == LFA1.LIFNR
  • P_PT_DOCITEMPARTNER.MANDT == LFA1.MANDT
Transaction Currency
  • Client
  • Transaction Currency
  • P_PT_DOCITEMPARTNER.MANDT == TCURC.MANDT
  • P_PT_DOCITEMPARTNER.TRANSACTIONCURRENCY == TCURC.WAERS
Withholding Tax Code
  • Client
  • Withholding Tax Code
  • ?
  • P_PT_DOCITEMPARTNER.MANDT == T059Q.MANDT
  • P_PT_DOCITEMPARTNER.WITHHOLDINGTAXCODE == T059Q.QSSKZ
  • P_PT_DOCITEMPARTNER.[column in domain "LAND1"] == T059Q.LAND1