/CPD/PWS_MP_CUSTOMER

Customer | #ATTR | Extraction method: V | No Delta | Component: Logistics Master Data
Tables used: KNA1 → show details
Column Name Description
KUNNR Customer Number
Column Name Description
💲 Currency of sales figure (UWAER):
UMSAT Annual sales
UMSA1 Annual sales
Column Name Description
📏 Unit of Length for Packaging Material (VSO) (/VSO/R_PAL_UL):
/VSO/R_PALHGT Maximum Stacking Height of the Packaging Material (VSO)
Column Name Description
ERDAT Date on which the Record Was Created
UPDAT Date on Which the Changes Were Confirmed
UPTIM Time of Last Change Confirmation
RGDATE RG Issuing Date
RNEDATE RNE Issuing Date
AEDAT (Obsolete) Last Changed On – do not use
J_3GLABRECH Date of Last Settlement
J_3GAABRECH Date of Current Settlement
Column Name Description
XCPDK Indicator: Is the account a one-time account? Show values
EXABL Indicator: Unloading points exist Show values
LOEVM Central Deletion Flag for Master Record Show values
SPERR Central posting block Show values
STKZA Indicator: Business Partner Subject to Equalization Tax? Show values
STKZU Liable for VAT Show values
XZEMP Indicator: Is an alternative payer allowed in document? Show values
DEAR1 Indicator: Competitor Show values
DEAR2 Indicator: Sales partner Show values
DEAR3 Indicator: Sales prospect Show values
DEAR4 Indicator for customer type 4 Show values
DEAR5 ID for default sold-to party Show values
STKZN Natural Person Show values
INSPBYDEBI Inspection Carried Out By Customer (No Inspection Lot) Show values
INSPATDEBI Inspection for a Delivery Note After Outbound Delivery Show values
DTAMS Report key for data medium exchange Show values
DUEFL Status of Data Transfer into Subsequent Release Show values
SPERZ Payment Block Show values
CIVVE ID for mainly non-military use Show values
MILVE ID for mainly military use Show values
XKNZA Indicator: Alternative payer using account number Show values
XICMS Customer is ICMS-exempt Show values
XXIPI Customer is IPI-exempt Show values
CFOPC Customer's CFOP category Show values
CCC01 Indicator for biochemical warfare for legal control Show values
CCC02 Indicator for nuclear nonproliferation for legal control Show values
CCC03 Indicator for national security for legal control Show values
CCC04 Indicator for missile technology for legal control Show values
NODEL Central deletion block for master record Show values
DEAR6 Indicator: Consumer Show values
CVP_XBLCK Business Purpose Completed Flag Show values
CRTN CRT Number Show values
/VSO/R_PK_MAT Customer-Related Packing for Each Packaging Material (VSO) Show values
/VSO/R_ONE_MAT Packing Material-Specific for Each Packaging Material Show values
/VSO/R_ONE_SORT Pack Only One Package Type for Each PKM (VSO) Show values
/VSO/R_ULD_SIDE Side Preference of Loading/Unloading (VSO) Show values
/VSO/R_LOAD_PREF Front/Back Preference of Loading/Unloading (VSO) Show values
J_3GREFTYP Reference Type for Recipient Show values
J_3GABGLG Retirement Date Counts for Performance-Based Equipment Show values
J_3GABGVG Retirement Date Counts for Time-Based Equipment Show values
J_3GABRART Settlement Type Show values
J_3GZUGTAG Function for Settlement on Acquisition Date/PBE Show values
J_3GMASCHB "Fill PBE Documents" Indicator Show values
J_3GMEINSA Indicator: Take Multiple Usage Periods into Account Show values
J_3GKEINSA Indicator - Relevant to Short Operation Periods Show values
J_3GBLSPER Blocking Indicator for Document Entry Show values
J_3GKLEIVO Indicator: Calculate PBE as TBE Show values
J_3GVMONAT Indicator for Complete Month Show values
J_3GABRKEN Settlement Indicator Show values
J_3GZUTVHLG Ind.: Acquisition Date Counts (as Daily Settlement for PBE) Show values
J_3GNEGMEN Negative Quantities Allowed Even for Chronolog. Inv. Mgmt Show values
J_3GFRISTLO Indicator: Deadline Logic Show values
J_3GSCHPRS Indicator: Shift Price Show values
J_3GINVSTA Status of Construction Site Inventory Show values
/SAPCEM/KVMEQ Indicator: Settlement Qty Relevant to Equipment Show values
Column Name Description Domain name
NAME1 Name 1 NAME
NAME2 Name 2 NAME
ORT01 City TEXT35
PSTLZ Postal Code PSTLZ
SORTL Sort field CHAR10
STRAS Street and House Number TEXT35
TELF1 First telephone number TEXT16
TELFX Fax Number TEXT31
ADRNR Address ADRNR
MCOD1 Search term for matchcode search CHAR25
MCOD2 Search Term for Matchcode Search CHAR25
MCOD3 Search term for matchcode search CHAR25
ANRED Title TEXT15
BAHNE Express train station BAHNH
BAHNS Train station BAHNH
BBBNR International location number (part 1) NUM07
BBSNR International location number (Part 2) NUM05
BEGRU Authorization Group BRGRU
BUBKZ Check digit for the international location number NUM01
DATLT Data communication line no. TEXT14
ERNAM Name of Person who Created the Object USNAM
KONZS Group key KONZS
LOCCO City Coordinates LOCCO
NAME3 Name 3 NAME
NAME4 Name 4 NAME
ORT02 District TEXT35
PFACH PO Box PFACH
PSTL2 P.O. Box Postal Code PSTLZ
RPMKR Regional market RPMKR
STCD1 Tax Number 1 STCD1
STCD2 Tax Number 2 STCD2
TELBX Telebox number TEXT15
TELF2 Second telephone number TEXT16
TELTX Teletex number TEXT30
TELX1 Telex number TEXT30
STCEG VAT Registration Number STCEG
EKONT Initial contact VBELN
UMJAH Year For Which Sales are Given JAHR
JMZAH Yearly number of employees JMZAH
JMJAH Year for which the number of employees is given JAHR
PFORT PO Box city TEXT35
DTAWS Instruction Key for Data Medium Exchange DTAWS
HZUOR Assignment to Hierarchy HZUOR
STCD3 Tax Number 3 CHAR18
STCD4 Tax Number 4 CHAR18
STCD5 Tax Number 5 CHAR60
CASSD Central sales block for customer CASSP
KNURL Uniform resource locator TEXT132
J_1KFREPRE Name of Representative REPRES
CONFS Status of Change Authorization (Central) CHAR1
SUFRAMA Suframa Code J_1BSUFRAMA
RG RG Number J_1BRG
EXP Issued by J_1BEXP
UF State J_1BUF
RIC RIC Number J_1BRIC
RNE Foreign National Registration J_1BRNE
KNA1_EEW_CUST data element for customer KNA1_EEW_CUST
/VSO/R_I_NO_LYR Number Layers Under an Inter-Pallet (VSO) /VSO/M_IPAL_NO_LYR
J_1IEXCD ECC Number CHAR40
J_1IEXRN Excise Registration Number CHAR40
J_1IEXRG Excise Range CHAR60
J_1IEXDI Excise Division CHAR60
J_1IEXCO Excise Commissionerate CHAR60
J_1ICSTNO Central Sales Tax Number CHAR40
J_1ILSTNO Local Sales Tax Number CHAR40
J_1IPANNO Permanent Account Number CHAR40
USNAM (Obsolete) Changed by the user – do not use CHAR12
J_1ISERN Service Tax Registration Number CHAR40
J_1IPANREF PAN Reference Number CHAR40
J_3GSTDMON Hours per Month DEC03_2
J_3GSTDTAG Hours per Day DEC03_2
J_3GTAGMON Number of Days/Month DEC3_2
J_3GEMINBE Minimum Usage Period for Restricted Usage (Days) NUMC
J_3GFMGUE Release Notification Allowance for Unrestricted Usage (Days) NUMC
J_3GZUSCHUE Surcharge for Unrestricted Usage (Days) NUMC
Master Data Relations | to Other Relations ↓ Join Conditions
Planning Area
  • Client
  • Planning Area
Packaging Material of the Customer in VSO
  • Client
  • Packaging Material of the Customer in VSO
  • /CPD/PWS_MP_CUSTOMER.MANDT == MARA.MANDT
  • /CPD/PWS_MP_CUSTOMER./VSO/R_MATPAL == MARA.MATNR
Unit of Length for Packaging Material (VSO)
  • Client
  • Unit of Length for Packaging Material (VSO)
  • /CPD/PWS_MP_CUSTOMER.MANDT == T006.MANDT
  • /CPD/PWS_MP_CUSTOMER./VSO/R_PAL_UL == T006.MSEHI
Usage Indicator
  • Client
  • Usage Indicator
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVLV.MANDT
  • /CPD/PWS_MP_CUSTOMER.ABRVW == TVLV.ABRVW
Central order block for customer
  • Client
  • ?
  • Central order block for customer
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVAST.MANDT
  • /CPD/PWS_MP_CUSTOMER.[column in domain "SPRAS"] == TVAST.SPRAS
  • /CPD/PWS_MP_CUSTOMER.AUFSD == TVAST.AUFSP
Industry code 1
  • Client
  • Industry code 1
  • /CPD/PWS_MP_CUSTOMER.MANDT == TBRC.MANDT
  • /CPD/PWS_MP_CUSTOMER.BRAN1 == TBRC.BRACO
Industry code 2
  • Client
  • Industry code 2
  • /CPD/PWS_MP_CUSTOMER.MANDT == TBRC.MANDT
  • /CPD/PWS_MP_CUSTOMER.BRAN2 == TBRC.BRACO
Industry code 3
  • Client
  • Industry code 3
  • /CPD/PWS_MP_CUSTOMER.MANDT == TBRC.MANDT
  • /CPD/PWS_MP_CUSTOMER.BRAN3 == TBRC.BRACO
Industry code 4
  • Client
  • Industry code 4
  • /CPD/PWS_MP_CUSTOMER.MANDT == TBRC.MANDT
  • /CPD/PWS_MP_CUSTOMER.BRAN4 == TBRC.BRACO
Industry code 5
  • Client
  • Industry code 5
  • /CPD/PWS_MP_CUSTOMER.MANDT == TBRC.MANDT
  • /CPD/PWS_MP_CUSTOMER.BRAN5 == TBRC.BRACO
Industry key
  • Client
  • Industry key
  • /CPD/PWS_MP_CUSTOMER.MANDT == T016.MANDT
  • /CPD/PWS_MP_CUSTOMER.BRSCH == T016.BRSCH
City Code
  • Client
  • City Code
  • Country/Region Key
  • Region (State, Province, County)
  • /CPD/PWS_MP_CUSTOMER.MANDT == T005G.MANDT
  • /CPD/PWS_MP_CUSTOMER.CITYC == T005G.CITYC
  • /CPD/PWS_MP_CUSTOMER.LAND1 == T005G.LAND1
  • /CPD/PWS_MP_CUSTOMER.REGIO == T005G.REGIO
CNAE
  • Client
  • CNAE
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1BTCNAE.MANDT
  • /CPD/PWS_MP_CUSTOMER.CNAE == J_1BTCNAE.J_1BCNAE
Order Number
  • Client
  • Order Number
  • /CPD/PWS_MP_CUSTOMER.MANDT == AUFK.MANDT
  • /CPD/PWS_MP_CUSTOMER.COAUFNR == AUFK.AUFNR
Company Size
  • Client
  • Company Size
County Code
  • Client
  • County Code
  • Country/Region Key
  • Region (State, Province, County)
  • /CPD/PWS_MP_CUSTOMER.MANDT == T005E.MANDT
  • /CPD/PWS_MP_CUSTOMER.COUNC == T005E.COUNC
  • /CPD/PWS_MP_CUSTOMER.LAND1 == T005E.LAND1
  • /CPD/PWS_MP_CUSTOMER.REGIO == T005E.REGIO
Declaration Regimen for PIS/COFINS
  • Client
  • Declaration Regimen for PIS/COFINS
IS-R Labeling: customer/plant group
  • Client
  • IS-R Labeling: customer/plant group
  • /CPD/PWS_MP_CUSTOMER.MANDT == TWEK.MANDT
  • /CPD/PWS_MP_CUSTOMER.ETIKG == TWEK.KUNGR
Central billing block for customer
  • Client
  • Central billing block for customer
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVFS.MANDT
  • /CPD/PWS_MP_CUSTOMER.FAKSD == TVFS.FAKSP
Account number of the master record with the fiscal address
  • Client
  • Account number of the master record with the fiscal address
  • /CPD/PWS_MP_CUSTOMER.MANDT == KNA1.MANDT
  • /CPD/PWS_MP_CUSTOMER.FISKN == KNA1.KUNNR
Tax Type
  • ?
  • Client
  • Tax type
  • /CPD/PWS_MP_CUSTOMER.[column in domain "KOART"] == J_1AFITP.KOART
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1AFITP.MANDT
  • /CPD/PWS_MP_CUSTOMER.FITYP == J_1AFITP.J_1AFITP
Legal status
  • Client
  • Legal status
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVGF.MANDT
  • /CPD/PWS_MP_CUSTOMER.GFORM == TVGF.GFORM
ICMS Taxpayer
  • Client
  • ICMS Taxpayer
Industry Main Type
  • Client
  • Industry Main Type
Excise tax indicator for customer
  • ?
  • Client
  • Excise tax indicator for customer
  • /CPD/PWS_MP_CUSTOMER.[column in domain "CHAR30"] == J_1ITAXIND.J_1IINDDES
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1ITAXIND.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_1IEXCICU == J_1ITAXIND.J_1IINDTAX
Dummy Recipient
  • Client
  • Dummy Recipient
  • /CPD/PWS_MP_CUSTOMER.MANDT == KNA1.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_3GAGDUMI == KNA1.KUNNR
External Sold-to Party
  • Client
  • External Sold-to Party
  • /CPD/PWS_MP_CUSTOMER.MANDT == KNA1.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_3GAGEXT == KNA1.KUNNR
Customer Internal Settlement
  • Client
  • Customer Internal Settlement
  • /CPD/PWS_MP_CUSTOMER.MANDT == KNA1.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_3GAGINT == KNA1.KUNNR
Standard Recipient
  • Client
  • Standard Recipient
  • /CPD/PWS_MP_CUSTOMER.MANDT == KNA1.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_3GAGSTDI == KNA1.KUNNR
Calendar ID /CPD/PWS_MP_CUSTOMER.J_3GCALID == TFACD.IDENT
Recipient Type
  • Client
  • Recipient Type
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_3GZUETYP.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_3GETYP == J_3GZUETYP.J_3GETYP
Attribute 1
  • Client
  • Attribute 1
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK1.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR1 == TVK1.KATR1
Attribute 10
  • Client
  • Attribute 10
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK0.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR10 == TVK0.KATR10
Attribute 2
  • Client
  • Attribute 2
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK2.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR2 == TVK2.KATR2
Attribute 3
  • Client
  • Attribute 3
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK3.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR3 == TVK3.KATR3
Attribute 4
  • Client
  • Attribute 4
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK4.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR4 == TVK4.KATR4
Attribute 5
  • Client
  • Attribute 5
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK5.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR5 == TVK5.KATR5
Attribute 6
  • Client
  • Attribute 6
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK6.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR6 == TVK6.KATR6
Attribute 7
  • Client
  • Attribute 7
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK7.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR7 == TVK7.KATR7
Attribute 8
  • Client
  • Attribute 8
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK8.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR8 == TVK8.KATR8
Attribute 9
  • Client
  • Attribute 9
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVK9.MANDT
  • /CPD/PWS_MP_CUSTOMER.KATR9 == TVK9.KATR9
Customer Condition Group
  • Client
  • Customer condition group 1
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVKGG.MANDT
  • /CPD/PWS_MP_CUSTOMER.KDKG1 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 2
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVKGG.MANDT
  • /CPD/PWS_MP_CUSTOMER.KDKG2 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 3
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVKGG.MANDT
  • /CPD/PWS_MP_CUSTOMER.KDKG3 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 4
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVKGG.MANDT
  • /CPD/PWS_MP_CUSTOMER.KDKG4 == TVKGG.KDKGR
Customer Condition Group
  • Client
  • Customer condition group 5
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVKGG.MANDT
  • /CPD/PWS_MP_CUSTOMER.KDKG5 == TVKGG.KDKGR
Working Time Calendar /CPD/PWS_MP_CUSTOMER.KNAZK == TFACD.IDENT
Account Number of an Alternative Payer
  • Client
  • Account Number of an Alternative Payer
  • /CPD/PWS_MP_CUSTOMER.MANDT == KNA1.MANDT
  • /CPD/PWS_MP_CUSTOMER.KNRZA == KNA1.KUNNR
Controlling Area
  • Client
  • Controlling Area
  • /CPD/PWS_MP_CUSTOMER.MANDT == TKA01.MANDT
  • /CPD/PWS_MP_CUSTOMER.KOKRS == TKA01.KOKRS
Cost Center
  • ?
  • Client
  • Controlling Area
  • Cost Center
  • /CPD/PWS_MP_CUSTOMER.[column in domain "DATBI"] == CSKS.DATBI
  • /CPD/PWS_MP_CUSTOMER.MANDT == CSKS.MANDT
  • /CPD/PWS_MP_CUSTOMER.KOKRS == CSKS.KOKRS
  • /CPD/PWS_MP_CUSTOMER.KOSTL == CSKS.KOSTL
Reference Account Group for One-Time Account (Customer)
  • Client
  • Reference Account Group for One-Time Account (Customer)
  • /CPD/PWS_MP_CUSTOMER.MANDT == T077D.MANDT
  • /CPD/PWS_MP_CUSTOMER.KTOCD == T077D.KTOKD
Customer Account Group
  • Client
  • Customer Account Group
  • /CPD/PWS_MP_CUSTOMER.MANDT == T077D.MANDT
  • /CPD/PWS_MP_CUSTOMER.KTOKD == T077D.KTOKD
Customer Classification
  • Client
  • Customer Classification
  • /CPD/PWS_MP_CUSTOMER.MANDT == TKUKL.MANDT
  • /CPD/PWS_MP_CUSTOMER.KUKLA == TKUKL.KUKLA
Country/Region Key
  • Client
  • Country/Region Key
  • /CPD/PWS_MP_CUSTOMER.MANDT == T005.MANDT
  • /CPD/PWS_MP_CUSTOMER.LAND1 == T005.LAND1
Legal Nature
  • Client
  • Legal Nature
Storage location
  • Client
  • Storage location
  • Plant
  • /CPD/PWS_MP_CUSTOMER.MANDT == T001L.MANDT
  • /CPD/PWS_MP_CUSTOMER.LGORT == T001L.LGORT
  • /CPD/PWS_MP_CUSTOMER.WERKS == T001L.WERKS
Account Number of Supplier
  • Client
  • Account Number of Supplier
  • /CPD/PWS_MP_CUSTOMER.MANDT == LFA1.MANDT
  • /CPD/PWS_MP_CUSTOMER.LIFNR == LFA1.LIFNR
Central delivery block for the customer
  • Client
  • Central delivery block for the customer
  • /CPD/PWS_MP_CUSTOMER.MANDT == TVLS.MANDT
  • /CPD/PWS_MP_CUSTOMER.LIFSD == TVLS.LIFSP
Transportation zone to or from which the goods are delivered
  • Client
  • Country/Region Key
  • Transportation zone to or from which the goods are delivered
  • /CPD/PWS_MP_CUSTOMER.MANDT == TZONE.MANDT
  • /CPD/PWS_MP_CUSTOMER.LAND1 == TZONE.LAND1
  • /CPD/PWS_MP_CUSTOMER.LZONE == TZONE.ZONE1
Nielsen ID
  • Client
  • Nielsen ID
  • /CPD/PWS_MP_CUSTOMER.MANDT == TNLS.MANDT
  • /CPD/PWS_MP_CUSTOMER.NIELS == TNLS.NIELS
Fiscal Year Variant
  • Client
  • Fiscal Year Variant
  • /CPD/PWS_MP_CUSTOMER.MANDT == T009.MANDT
  • /CPD/PWS_MP_CUSTOMER.PERIV == T009.PERIV
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • /CPD/PWS_MP_CUSTOMER.MANDT == T005S.MANDT
  • /CPD/PWS_MP_CUSTOMER.LAND1 == T005S.LAND1
  • /CPD/PWS_MP_CUSTOMER.REGIO == T005S.BLAND
Language Key /CPD/PWS_MP_CUSTOMER.SPRAS == T002.SPRAS
J_1ATODC
  • Client
  • Tax Number Type
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1ATODC.MANDT
  • /CPD/PWS_MP_CUSTOMER.STCDT == J_1ATODC.J_1ATODC
Tax Declaration Type
  • Client
  • Tax Declaration Type
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1BTTDT.MANDT
  • /CPD/PWS_MP_CUSTOMER.TDT == J_1BTTDT.J_1BTDT
Tax Jurisdiction
  • ?
  • Client
  • Tax Jurisdiction
  • /CPD/PWS_MP_CUSTOMER.[column in domain "TAX_KALSM"] == TTXJ.KALSM
  • /CPD/PWS_MP_CUSTOMER.MANDT == TTXJ.MANDT
  • /CPD/PWS_MP_CUSTOMER.TXJCD == TTXJ.TXJCD
Tax Law 1
  • Client
  • Tax law: ICMS
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1BATL1.MANDT
  • /CPD/PWS_MP_CUSTOMER.TXLW1 == J_1BATL1.TAXLAW
Tax Law 2
  • Client
  • Tax law: IPI
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1BATL2.MANDT
  • /CPD/PWS_MP_CUSTOMER.TXLW2 == J_1BATL2.TAXLAW
Currency of sales figure
  • Client
  • Currency of sales figure
  • /CPD/PWS_MP_CUSTOMER.MANDT == TCURC.MANDT
  • /CPD/PWS_MP_CUSTOMER.UWAER == TCURC.WAERS
Company ID of Trading Partner
  • Client
  • Company ID of Trading Partner
  • /CPD/PWS_MP_CUSTOMER.MANDT == T880.MANDT
  • /CPD/PWS_MP_CUSTOMER.VBUND == T880.RCOMP
Plant
  • Client
  • Plant
  • /CPD/PWS_MP_CUSTOMER.MANDT == T001W.MANDT
  • /CPD/PWS_MP_CUSTOMER.WERKS == T001W.WERKS
Customer group for Substituiçao Tributária calculation
  • Client
  • Customer group for Substituiçao Tributária calculation
  • /CPD/PWS_MP_CUSTOMER.MANDT == J_1BTXSTG.MANDT
  • /CPD/PWS_MP_CUSTOMER.XSUBT == J_1BTXSTG.STGRP
Other Relations | to Master Data Relations ↑ Join Conditions
Collective Unloading Point for VSO
  • Client
  • Collective Unloading Point for VSO
Type of Business
  • Client
  • Type of Business
  • /CPD/PWS_MP_CUSTOMER.MANDT == BUSTYPE.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_1KFTBUS == BUSTYPE.GESTYP
Type of Industry
  • Client
  • Type of Industry
  • /CPD/PWS_MP_CUSTOMER.MANDT == INDUSTYPE.MANDT
  • /CPD/PWS_MP_CUSTOMER.J_1KFTIND == INDUSTYPE.INDTYPE