C_RedactedARLineItem

Display Customer Line Items with masked customer data | view: CREDACTEDFIARLI | 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, BUT0ID, BUT000, SCMGSTATPROFS, SCMGSTATPROFST, SCMGATTR_PRIO, SCMGATTR_PRIOT, SCMGATTR_REASON, SCMGATTR_REASONT, T001, TKA02, T005, FINSC_CURTYPET, KNA1, KNB1, KNB5, CVI_CUST_LINK, T053R, TTYPT, T005U, T000, LFA1, LFB1, T007A, FITHA_PBUPL_D, FITHA_PBUPL_D_T, 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
💲 Additional Currency 1 (AdditionalCurrency1):
AmountInAdditionalCurrency1 Amount in Additional Currency 1
ValuatedAmtInAdditionalCrcy1 Valuated Amount in Additional Currency 1
💲 Additional Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Additional Currency 2
ValuatedAmtInAdditionalCrcy2 Valuated Amount in Additional Currency 2
💲 Update Currency for General Ledger Transaction Figures (BalanceTransactionCurrency):
AmountInBalanceTransacCrcy Amount for Updating in General Ledger
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
CashDiscountAmtInCoCodeCrcy Cash Discount Taken (Company Code Currency)
ValuatedAmtInCompanyCodeCrcy Valuated Amount in Company Code Currency
BilledRevenueAmtInCoCodeCrcy Billed Revenue
💲 Currency for Automatic Payment (PaymentCurrency):
AmountInPaymentCurrency Amount in Payment Currency
💲 Transaction Currency (TransactionCurrency):
AmountInTransactionCurrency Amount in Transaction Currency
CashDiscountAmount Cash Discount Taken (Transaction Currency)
CashDiscountBaseAmount Amount Eligible for Cash Discount in Document Currency
WithholdingTaxAmount Withholding Tax
WithholdingTaxBaseAmount Withholding Tax Base Amount
WithholdingTaxExemptionAmt Withholding Tax-Exempt Amount (in Document Currency)
CashDiscountAmtInTransacCrcy Cash Discount Available Now (Transaction Currency)
Column Name Description
Column Name Description
ClearingDate Clearing Date
TaxReportingDate Tax Reporting Date
ValueDate Value date
DueCalculationBaseDate Baseline Date for Due Date Calculation
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
KeyDate Key Date
Column Name Description
FinancialAccountType Account Type Show values
DueItemType Due Item Category for Display Customer Line Items - Redacted Show values
DebitCreditCode Debit/Credit Code Show values
FixedCashDiscount Fixed Payment Terms Show values
BillOfExchangeUsage Bill of Exchange Usage Type Show values
ClearingIsReversed Indicator: Clearing was Reversed Show values
IsSalesRelated Indicator: Sales-Related Item Show values
AccountingDocumentCategory Document Status Show values
CustomerIsOneTimeAccount Indicator: Is the Account a One-Time Account Show values
OffsettingAccountType Offsetting Account Type Show values
CashDiscount1DueStatus Line Item Cash Discount 1 Is Due Show values
IsClearedAtKeyDate Indicator: Has the Item Been Cleared? Show values
ClearingStatus Clearing Status of Item Show values
IsNegativePosting Indicator: Negative Posting Show values
ItmIsOpnAtDayBfrAuditStartDate Item is open at Audit Start Date Show values
Column Name Description Domain name
BPIdentificationNumber Customer External Identifier CHAR60
PaymentDifferenceReason Reason Code for Payments RSTGR
ClearingDocFiscalYear Fiscal Year of Clearing Journal Entry GJAHR
ClearingAccountingDocument Clearing Journal Entry BELNR
PostingKey Posting Key BSCHL
SelectedItemBranch Selected Item Type Branch
SpecialGLCode Special G/L Indicator UMSKZ
SpecialGLTransactionType Special G/L Transaction Type UMSKS
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
CostCenter Cost Center KOSTL
OrderID Order ID AUFNR
BillingDocument Sales and Distribution Document Number VBELN
SalesDocument Sales Document VBELN
SalesDocumentItem Item Number (6 Digits) POSNR
ScheduleLine Delivery Schedule Line Number ETENR
GLAccount G/L Account SAKNR
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash Discount Days 1 ZBDXT
CashDiscount2Days Cash Discount Days 2 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
Plant Plant WERKS
PurchasingDocument Purchasing Document EBELN
PurchasingDocumentItem Item Number of Purchasing Document EBELP
ProfitCenter Profit Center PRCTR
PaymentMethodSupplement Payment Method Supplement UZAWE
Reference1IDByBusinessPartner Business Partner Reference Key 1 CHAR12
Reference2IDByBusinessPartner Business Partner Reference Key 2 CHAR12
Reference3IDByBusinessPartner Reference Key for Line Item CHAR20
PaymentCardItem Payment Card Item NUM03
PaymentCardPaymentSettlement Payment Cards: Settlement Run CCBTC
PaymentReference Payment Reference CHAR30
BusinessPlace Business Place J_1BBRANCH
TaxSection Section Code SECCO
RealEstateObject Internal Key for Real Estate Object IMKEY
FundsCenter Funds Management Center FISTL
FiscalPeriod Fiscal Period POPER
AccountingDocumentType Journal Entry Type BLART
DocumentReferenceID Reference Document Number XBLNR
AccountingDocCreatedByUser User that created the journal entry
CustomerBasicAuthorizationGrp Customer Basic Authorization Group BEGRU
CustomerFinsAuthorizationGrp Authorization Group BRGRU
CustomerCityName City TEXT40
HouseBank House Bank Key HBKID
InvoiceReference Document No. of the Invoice to Which the Transaction Belongs BELNR
CreditControlArea Credit Control Area KKBER
CashDiscount1ArrearsDays Days in Arrears for Cash Discount Terms 1 WRTV3
OffsettingAccount Offsetting Account GKONT
CompanyCodeName Name of Company Code or Company TEXT25
CashDiscount1DueStatusName Short Text for Fixed Values DDTEXT
ClearingStatusName Short Text for Fixed Values DDTEXT
ClearingStatusCriticality null
SenderLogicalSystem Sender Logical System LOGSYS
SenderCompanyCode Company Code in Sender System CHAR4
SenderAccountingDocument Sender Journal Entry BELNR
SenderFiscalYear Fiscal Year in Sender System GJAHR
BranchCode Branch Code BCODE
ReferenceDocumentType Reference Document Type AWTYP
ReferenceDocumentTypeName Reference Document Type Name TEXT20
OriginalReferenceDocument Original Reference Document AWKEY
ReferenceDocumentLogicalSystem Logical System of Reference Document LOGSYS
Master Data Relations Join Conditions
Accounting Clerk
  • Accounting Clerk
  • Client
  • ?
  • C_REDACTEDARLINEITEM.ACCOUNTINGCLERK == T001S.BUSAB
  • C_REDACTEDARLINEITEM.MANDT == T001S.MANDT
  • C_REDACTEDARLINEITEM.[column in domain "BUKRS"] == T001S.BUKRS
Tolerance Group for Business Partner/G/L Account
  • Tolerance Group for Business Partner/G/L Account
  • Client
  • ?
  • C_REDACTEDARLINEITEM.APARTOLERANCEGROUP == T043G.TOGRU
  • C_REDACTEDARLINEITEM.MANDT == T043G.MANDT
  • C_REDACTEDARLINEITEM.[column in domain "BUKRS"] == T043G.BUKRS
Identification Type
  • Identification Type
  • Client
  • C_REDACTEDARLINEITEM.BPIDENTIFICATIONTYPE == TB039A.TYPE
  • C_REDACTEDARLINEITEM.MANDT == TB039A.CLIENT
Customer Account Group
  • Customer Account Group
  • Client
  • C_REDACTEDARLINEITEM.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_REDACTEDARLINEITEM.MANDT == T077D.MANDT
Country key
  • Country / Region Key
  • Client
  • C_REDACTEDARLINEITEM.CUSTOMERCOUNTRY == T005.LAND1
  • C_REDACTEDARLINEITEM.MANDT == T005.MANDT
Reconciliation Account in General Ledger
  • Reconciliation Account in General Ledger
  • Client
  • ?
  • C_REDACTEDARLINEITEM.RECONCILIATIONACCOUNT == SKB1.SAKNR
  • C_REDACTEDARLINEITEM.MANDT == SKB1.MANDT
  • C_REDACTEDARLINEITEM.[column in domain "BUKRS"] == SKB1.BUKRS