S170 - Payment document data

Payment document data information is stored in SAP table S170.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".

Fields for table S170

Field Name
Description
Is Key
Data Element
Data Type
Length
Check Table
MANDTClientXMANDTCLNT6T000
SSOURStatistic(s) originXSSOURCHAR8
VRSIOVersion number in the information structureXVRSIOCHAR6
SPMONPeriod to analyze - monthXSPMONNUMC12
SPTAGPeriod to analyze - current dateXSPTAGDATS16
SPWOCPeriod to analyze - weekXSPWOCNUMC12
SPBUPPeriod to analyze - posting periodXSPBUPNUMC12
EKORGPurchasing organizationXEKORGCHAR8T024E
EKGRPPurchasing GroupXEKGRPCHAR6T024
VKORGSales OrganizationXVKORGCHAR8TVKO
VTWEGDistribution ChannelXVTWEGCHAR4TVTW
SPARTDivisionXSPARTCHAR4TSPA
BUKRSCompany CodeXBUKRSCHAR8T001
LNRZBPayeeXW_LIFZECHAR20LFA1
KUNRGPayerXKUNRGCHAR20KNA1
LFTYPSettlement Document CategoryXWFTYPCHAR4
PERIVFiscal Year VariantPERIVCHAR4
VWDATPointer to administrative dataVWDATNUMC20
WSTWAEStatistics CurrencyWSTWAECUKY10TCURC
BRTWR_RGKey figure: Gross value of payment request (vendor)MC_BRTWRRGCURR9
NETWR_RGKey figure: Net value of payment request to vendorMC_NETWRRGCURR9
BRTWR_RGRLKey Fig.: Final Amt of Remuneration List, Payment: CustomerMC_BRTRGRLCURR9
NETWR_RGRLKey Figure: Net Value of Remuneration List, Payment: VendorMC_NETRGRLCURR9
KZWI2_P_RGKey Figure: Payment based on Remuneration List ConditionsMC_DELKRRGCURR9
KWERT_RGRLKey figure: Value of Remuneration List Conditions, PaymentMC_KWERTRGCURR9
MWSRL_RGRLKey figure: Tax invoice list cond. (del credere), paymentMC_MWSRLRGCURR9
MWSBP_RGRLKey Figure: Tax Amount Remuneration List, PaymentMC_MWSBPRGCURR9
KZWI1_P_RGKey figure: condition subtotal 1, payment: vendorMC_KZWI1RGCURR9
KZWI3_P_RGKey figure: condition subtotal 3, paymentMC_KZWI3RGCURR9
KZWI4_P_RGKey figure: condition subtotal 4, paymentMC_KZWI4RGCURR9
KZWI5_P_RGKey figure: condition subtotal 5, paymentMC_KZWI5RGCURR9
KZWI6_P_RGKey figure: Condition subtotal 6, paymentMC_KZWI6RGCURR9
BONBA_P_RGKey fig: Rebate basis (condition subtotal 7), payt: vendorMC_BONBARGCURR9
KZWIS_P_RGKey figure: Effective value of payment (vendor)MC_EFFEKRGCURR9
AWBRK_RGKey figure: Number of payment requestsMC_AWBRKRGDEC5
AWBRP_RGKey figure: Number of payment request itemsMC_AWBRPRGDEC5
AWBRK_RLRGKey Figure: Number of Remuneration Lists (Payment)MC_ARLRKRGDEC5
AWBRL_RLRGKey Figure: No. of Documents in Remuneration Lists (Payment)MC_ARLRPRGDEC5
Privacy Policy