P_RblsItmForKeyDteDuePerd5A

Open Accounts Receivables for Smart Business Apps 1 | view: PRBLSKDATDUE5A | Extraction: Not supported | Component: Information System
Tables used: SCAL_TT_DATE, BSEG, T001, TKA02, KNA1, KNB1, KNB5, TBSL, T001, T014, FINSC_FISC_DATE
Column Name Description
CompanyCode FK Company Code
Customer FK Customer
Column Name Description
💲 null (DisplayCurrency):
PartialPaymentAmtInDspCrcy null
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency null
Column Name Description
Column Name Description
ReportingPeriodStartDate Reporting Period Start Date
ReportingPeriodEndDate Reporting Period End Date
Column Name Description
FinancialAccountType Account Type Show values
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
CustomerName Name of Customer TEXT80
ReportingYear Reported Year GJAHR
ReportingPeriod Reporting Period POPER
Master Data Relations Join Conditions
Accounting Clerk
  • Accounting Clerk
  • Client
  • Company Code
  • P_RBLSITMFORKEYDTEDUEPERD5A.ACCOUNTINGCLERK == T001S.BUSAB
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == T001S.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.COMPANYCODE == T001S.BUKRS
Business Area
  • Client
  • Business Area
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == TGSB.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.BUSINESSAREA == TGSB.GSBER
Chart of Accounts
  • Client
  • Chart of Accounts
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == T004.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == T001.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.COMPANYCODE == T001.BUKRS
Customer
  • Client
  • Customer
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == KNA1.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.CUSTOMER == KNA1.KUNNR
Country/Region Key
  • Client
  • Country/Region Key
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == T005.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.CUSTOMERCOUNTRY == T005.LAND1
G/L Account
  • Client
  • Company Code
  • G/L Account
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == SKB1.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.COMPANYCODE == SKB1.BUKRS
  • P_RBLSITMFORKEYDTEDUEPERD5A.GLACCOUNT == SKB1.SAKNR
Reconciliation Account in General Ledger
  • Client
  • Reconciliation Account in General Ledger
  • Company Code
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == SKB1.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • P_RBLSITMFORKEYDTEDUEPERD5A.COMPANYCODE == SKB1.BUKRS
Special G/L Indicator
  • ?
  • Client
  • Special G/L Indicator
  • P_RBLSITMFORKEYDTEDUEPERD5A.[column in domain "KOART"] == T074U.KOART
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == T074U.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.SPECIALGLCODE == T074U.UMSKZ
Transaction Currency
  • Client
  • Transaction Currency
  • P_RBLSITMFORKEYDTEDUEPERD5A.MANDT == TCURC.MANDT
  • P_RBLSITMFORKEYDTEDUEPERD5A.TRANSACTIONCURRENCY == TCURC.WAERS