P_ARLineItem_0

Created from DDL srce P_ARLINEITEM_0 | view: PARLINEITEM0 | Extraction: Not supported | Component: Information System
Tables used: SCMG_T_CASE_ATTR, FDM_DCOBJ, VBKPF, VBKPF, VBSEGK, VBKPF, VBSEGD, BSAD_BCK, BSAK_BCK, BKPF, BSEG, BSET, T003, ADCP, ADRC, SCMGSTATPROFS, SCMGSTATPROFST, SCMGATTR_PRIO, SCMGATTR_PRIOT, SCMGATTR_REASON, SCMGATTR_REASONT, T001, TKA02, T005, KNA1, KNB1, KNB5, T053R, T005U, T000, T007A, T016T, USR21, T001A, T005, T880, T001, T014
Column Name Description
CompanyCode Company Code
AccountingDocument Journal Entry
FiscalYear Fiscal Year
AccountingDocumentItem Posting View Item
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
ValuationDiffAmtInCoCodeCrcy Valuation Difference Amount In Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Amount in Company Code Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
WithholdingTaxBaseAmount Withholding Tax Base Amount
CashDiscountBaseAmount Cash Discount Base Amount
CashDiscountAmount Cash Discount Amount
WithholdingTaxAmount Withholding Tax Amount
WithholdingTaxExemptionAmt Withholding Tax-Exemption Amount
HedgedAmount Credit Management: Hedged Amount
PlannedAmtInTransactionCrcy Planned Amount in Transaction Currency
💲 Update Currency for General Ledger Transaction Figures (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount in Balance Transaction Currency
💲 Additional Currency 1 (AdditionalCurrency1):
ValuationDiffAmtInAddlCrcy1 Valuation Difference Amount in Additional Currency 1
AmountInAdditionalCurrency1 Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuationDiffAmtInAddlCrcy2 Valuation Difference Amount in Additional Currency 2
💲 Functional Currency (FunctionalCurrency):
AmountInFunctionalCurrency Amount in Functional Currency
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment Currency
TaxBaseAmountInCoCodeCrcy null
TaxAmountInCoCodeCrcy null
HWBASSTE null
ValuatedAmtInCompanyCodeCrcy null
ValuatedAmtInAdditionalCrcy1 null
ValuatedAmtInAdditionalCrcy2 null
BilledRevenueAmtInCoCodeCrcy null
CashDiscountAmtInTransacCrcy null
Column Name Description
Column Name Description
KEYDT2 null
ClearingDate Clearing Date
TaxReportingDate Tax Reporting Date
ValueDate Value date
DueCalculationBaseDate Due Calculation Base Date
LastDunningDate Date of Last Dunning Notice
SettlementReferenceDate Reference Date for Settlement
PostingDate Posting Date
DocumentDate Journal Entry Date
NetDueDate Due Date for Net Payment
CashDiscount1DueDate Due Date for Cash Discount 1
AccountingDocumentCreationDate Accounting Document Entry Date
CustomerCreationDate Date on which the Record Was Created
InterestCalculationDate Key Date of Last Interest Calculation
KeyDate Open on Key Date
Column Name Description
FinancialAccountType Account Type Show values
DebitCreditCode Debit/Credit Code Show values
IsUsedInPaymentTransaction Is Used In Payment Transaction Show values
FixedCashDiscount Fixed Payment Terms Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
TreasuryContractType Treasury Contract Type Show values
ClearingIsReversed Indicator: Clearing was Reversed Show values
HasPaymentOrder Indicator: Payment Order Exists for this Item Show values
IsSalesRelated Indicator: Sales-Related Item Show values
AccountingDocumentCategory Document Status Show values
OffsettingAccountType Offsetting Account Type Show values
CustomerIsOneTimeAccount Indicator: Is the account a one-time account? Show values
AlternativePayerIsAllowed Indicator: Is an alternative payer allowed in document? Show values
PostingIsBlockedForCustomer Central posting block Show values
IntrstCalcFrequencyInMonths Interest Calculation Frequency in Months Show values
ItemIsToBePaidSeparately Indicator: Pay All Items Separately? Show values
PaytAdviceIsSentbyEDI Indicator: Send Payment Advices by EDI Show values
IsDisputed Indicator: Disputed Item? Show values
Column Name Description Domain name
PaymentDifferenceReason Reason Code for Payments RSTGR
Debtor Customer KUNNR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
ClearingAccountingDocument Clearing Document Number BELNR
PostingKey Posting Key BSCHL
SpecialGLCode Special G/L Indicator UMSKZ
SpecialGLTransactionType Special G/L Transaction Type UMSKS
BusinessArea Business Area GSBER
TaxCode Sales/Purchases Tax Code MWSKZ
TaxCountry Tax Reporting Country/Region LAND1
AlternativeGLAccount Alternative G/L Account Number In Company Code SAKNR
AssignmentReference Assignment Reference ZUONR
DocumentItemText Item Text TEXT50
PartnerCompany Company ID of Trading Partner RCOMP
CostCenter Cost Center KOSTL
OrderID Order ID AUFNR
BillingDocument Billing Document VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Sales Document Item POSNR
ScheduleLine Schedule Line ETENR
MasterFixedAsset Fixed Asset ANLN1
FixedAsset Asset Subnumber ANLN2
GLAccount G/L Account SAKNR
Branch Account Number of the Branch MAXKK
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash Discount Percentage 1 PRZ23
CashDiscount2Percent Cash Discount Percentage 2 PRZ23
PaymentMethod Payment Method ZLSCH
PaymentBlockingReason Payment Block on Item ZAHLS
FollowOnDocumentType Follow-On Document Type REBZT
StateCentralBankPaymentReason State Central Bank Payment Reason LZBKZ
SupplyingCountry Supplying Country/Region LAND1
InvoiceList Collective Invoice List Number SAMNR
DunningKey Dunning Key MSCHL
DunningBlockingReason Dunning Block MANSP
DunningLevel Dunning Level MAHNS
DunningArea Dunning Area MABER
Plant Plant WERKS
PurchasingDocument Purchasing Document Number EBELN
PurchasingDocumentItem Item Number of Purchasing Document EBELP
ProfitCenter Profit Center PRCTR
AssetContract Asset Contract RANL
CashFlowType Flow Type SBEWART
WBSElement WBS Element PS_POSNR
PaymentMethodSupplement Payment Method Supplement UZAWE
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Cards: Settlement Run CCBTC
Reference3IDByBusinessPartner ID of Reference 3 by Business Partner CHAR20
DataExchangeInstruction1 Instruction Key 1 DTWSX
DataExchangeInstruction2 Instruction Key 2 DTWSX
DataExchangeInstruction3 Instruction Key 3 DTWSX
DataExchangeInstruction4 Instruction Key 4 DTWSX
PaymentReference Payment Reference CHAR30
BusinessPlace Business Place J_1BBRANCH
TaxSection Tax Section SECCO
AccountsReceivableIsPledged Accounts Receivable Pledging Indicator CESSION_KZ
RealEstateObject Internal Key for Real Estate Object IMKEY
FundsCenter Funds Management Center FISTL
FiscalPeriod Fiscal Period POPER
AccountingDocumentType Journal Entry Type BLART
SourceCompanyCode null
DocumentReferenceID Document Reference ID XBLNR1
AccountingDocCreatedByUser User that created the journal entry
OffsettingAccount Offsetting Account GKONT
AcctgDocTypeAuthorizationGroup Authorization Group BRGRU
ITEM_TYPE_BRANCH 30 Characters CHAR30
DPNOTDUE null
Creditor Supplier LIFNR
CustomerCounty County TEXT40
CustomerSearchText Sort field CHAR10
CustomerTaxID1 Tax Number 1 STCD1
CustomerTaxID2 Tax Number 2 STCD2
CustomerTaxID3 Tax Number 3 CHAR18
CustomerTaxID4 Tax Number 4 CHAR18
CustomerTaxID5 Tax Number 5 CHAR60
CustomerVATRegistration VAT Registration Number STCEG
CustomerBasicAuthorizationGrp Authorization Group BRGRU
CustomerFinsAuthorizationGrp Authorization Group BRGRU
CustomerCorporateGroup Group key KONZS
CustomerName Name of Customer TEXT80
CustomerCityName City TEXT40
CustomerPOBox PO Box CHAR10
CustomerPOBoxPostalCode PO Box Postal Code CHAR10
CustomerPostalCode City postal code CHAR10
CustomerCreatedByUser Name of Person who Created the Object USNAM
HouseBank House Bank Key HBKID
HouseBankAccount House Bank Account HKTID
CustomerAccountNote Memo TEXT30
CompanyCodeName Name of Company Code or Company TEXT25
CustomerSupplierAccount Account Number of Supplier LIFNR
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
FiscalYearPeriod null
IsCleared null
ReceivableAlternativePayer Alternative Payee/Payer MAXKK
NET_GROSS_RATIO null
CreditControlArea Credit control area KKBER
NetDueArrearsDays null
CashDiscount1ArrearsDays null
DueItemType null
DocumentIsArchived null
BPBankAccountInternalID Business Partner Bank Account Internal ID BVTYP
CustomerIndustryName Description of the Industry Key TEXT20
CustomerRegionName Description TEXT20
CashDiscount1IsDue null
IsClearedAtKeyDate null
IsDueNet null
CashDiscount1DueStatus null
NetDueStatus null
ClearingStatus null
IsNegativePosting null
InterestToBePosted null
CaseID Case ID SCMG_EXT_KEY
DisputeCasePriority Priority of Dispute Case NUM01
DisputeCasePriorityName Priority Text in Dispute Case TEXT40
DisputeCaseTitle Title of Dispute Case TEXT80
DisputeCaseReason Reason for Case SCMG_REASON_CODE
DisputeCaseReasonName Text Field of Length 60 TEXT60
DisputeCaseStatus Case: Status SCMGSTATUSONR
DisputeCaseStatusName Case: Status Description SCMGSTAT_DESCR
DisputeCaseProcessor Processor XUBNAME
DisputeCaseProcessorFullName Description of the Technical User Account SUIDTECHDESC
DisputeCaseUUID UUID in character form SYSUUID_C
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
Accounting Clerk Abbreviation
  • Client
  • ?
  • Accounting Clerk Abbreviation
  • P_ARLINEITEM_0.MANDT == T001S.MANDT
  • P_ARLINEITEM_0.[column in domain "BUKRS"] == T001S.BUKRS
  • P_ARLINEITEM_0.ACCOUNTINGCLERK == T001S.BUSAB
Account number of an alternative payer
  • Client
  • Account number of an alternative payer
  • P_ARLINEITEM_0.MANDT == KNA1.MANDT
  • P_ARLINEITEM_0.ALTERNATIVEPAYERACCOUNT == KNA1.KUNNR
Tolerance Group for Business Partner/G/L Account
  • Client
  • Tolerance Group for Business Partner/G/L Account
  • ?
  • P_ARLINEITEM_0.MANDT == T043G.MANDT
  • P_ARLINEITEM_0.APARTOLERANCEGROUP == T043G.TOGRU
  • P_ARLINEITEM_0.[column in domain "BUKRS"] == T043G.BUKRS
Customer Account Group
  • Client
  • Customer Account Group
  • P_ARLINEITEM_0.MANDT == T077D.MANDT
  • P_ARLINEITEM_0.CUSTOMERACCOUNTGROUP == T077D.KTOKD
City code for city/street file
  • City code for city/street file
  • Country/Region Key
  • Client
  • P_ARLINEITEM_0.CUSTOMERCITYCODE == ADRCITY.CITY_CODE
  • P_ARLINEITEM_0.CUSTOMERCOUNTRY == ADRCITY.COUNTRY
  • P_ARLINEITEM_0.MANDT == ADRCITY.CLIENT
Country key
  • Country/Region Key
  • Client
  • P_ARLINEITEM_0.CUSTOMERCOUNTRY == T005.LAND1
  • P_ARLINEITEM_0.MANDT == T005.MANDT
Head Office Account Number (in branch accounts)
  • Client
  • Head Office Account Number (in branch accounts)
  • P_ARLINEITEM_0.MANDT == KNA1.MANDT
  • P_ARLINEITEM_0.CUSTOMERHEADOFFICE == KNA1.KUNNR
Industry key
  • Industry key
  • Client
  • P_ARLINEITEM_0.CUSTOMERINDUSTRY == T016.BRSCH
  • P_ARLINEITEM_0.MANDT == T016.MANDT
Block Key for Payment
  • Client
  • Block Key for Payment
  • P_ARLINEITEM_0.MANDT == T008.MANDT
  • P_ARLINEITEM_0.CUSTOMERPAYMENTBLOCKINGREASON == T008.ZAHLS
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • P_ARLINEITEM_0.CUSTOMERCOUNTRY == T005S.LAND1
  • P_ARLINEITEM_0.CUSTOMERREGION == T005S.BLAND
  • P_ARLINEITEM_0.MANDT == T005S.MANDT
Tax Jurisdiction
  • Client
  • Tax Jurisdiction
  • ?
  • P_ARLINEITEM_0.MANDT == TTXJ.MANDT
  • P_ARLINEITEM_0.CUSTOMERTAXJURISDICTION == TTXJ.TXJCD
  • P_ARLINEITEM_0.[column in domain "TAX_KALSM"] == TTXJ.KALSM
Central delivery block for the customer
  • Central delivery block for the customer
  • Client
  • P_ARLINEITEM_0.DELIVERYISBLOCKEDFORCUSTOMER == TVLS.LIFSP
  • P_ARLINEITEM_0.MANDT == TVLS.MANDT
Interest Indicator
  • Client
  • Interest Indicator
  • P_ARLINEITEM_0.MANDT == T056.MANDT
  • P_ARLINEITEM_0.INTERESTCALCULATIONCODE == T056.VZSKZ
Reconciliation Account in General Ledger
  • Client
  • Reconciliation Account in General Ledger
  • ?
  • P_ARLINEITEM_0.MANDT == SKB1.MANDT
  • P_ARLINEITEM_0.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • P_ARLINEITEM_0.[column in domain "BUKRS"] == SKB1.BUKRS
Tax Code
  • Client
  • ?
  • Target Tax Code (for Deferred Tax)
  • P_ARLINEITEM_0.MANDT == T007A.MANDT
  • P_ARLINEITEM_0.[column in domain "KALSM_D"] == T007A.KALSM
  • P_ARLINEITEM_0.TARGETTAXCODE == T007A.MWSKZ