SAP Tabel V_T077D_V (Generated Table for View)

SAP table V_T077D_V has 2 primary key fields being MANDT,KTOKD.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
KTOKD Customer Account Group CHAR 4 0 KTOKD
FAUSA Customer master record field status def.for general data CHAR 40 0 FAUSA_077D
FAUSF Customer master record field status def.for comp.code data CHAR 40 0 FAUSF_077D
FAUSV Customer master record field status def.for sales fields CHAR 40 0 FAUSV_077D
NUMKR Number Range CHAR 2 0 NUMKR
XCPDS Indicator: Account Group for One-Time Accounts? CHAR 1 0 XCPDS
KALSM Output determination procedure CHAR 6 0 T683 KALSMB
DEAR1 Indicator: Competitor CHAR 1 0 DEAR1
DEAR2 Indicator: Sales partner CHAR 1 0 DEAR2
DEAR3 Indicator: Sales prospect CHAR 1 0 DEAR3
No
X yes
DEAR4 Indicator for customer type 4 CHAR 1 0 DEAR4
DEAR5 ID for default sold-to party CHAR 1 0 DEAR5
TXT30 Account Group Name CHAR 30 0 TXT30_077T
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
KALKS Customer Classification for Pricing Procedure Determination CHAR 2 0 TVKD KALKS
TXTGZ Central text determination procedure CHAR 2 0 TTXG TXTGZ
TXTGF Customer text determination procedure - FI CHAR 2 0 TTXG TXTGF
TXTGV Text determination procedure SD CHAR 2 0 TTXG TXTGV
FAUS1 Customer master record field status def.for general data CHAR 40 0 FAUSA_077D
FAUSG Customer master record field status def.for comp.code data CHAR 40 0 FAUSF_077D
DEAR6 Indicator: Consumer CHAR 1 0 DEAR6
FAUS2 Customer master record field status def.for general data CHAR 40 0 FAUSA_077D
FAUSU Customer master record field status def.for sales fields CHAR 40 0 FAUSV_077D
FAUS3 Customer master record field status def.for general data CHAR 40 0 FAUSA_077D
XCPDADDRCHK Indicator: Skip address check for One-Time Accounts CHAR 1 0 XCPDADDRCHK

V_T077D_V foreign key relationships

Table Field Check Table Check Field
0 V_T077D_V KALKS TVKD Customer classification for pricing procedure determination MANDT
0 V_T077D_V KALKS TVKD Customer classification for pricing procedure determination KALKS
1 V_T077D_V KALSM T683 Pricing procedures KAPPL
1 V_T077D_V KALSM T683 Pricing procedures KALSM
0 V_T077D_V MANDT T000 Clients MANDT
1 V_T077D_V PARGR TVPG Partner Function Groups PARGR
0 V_T077D_V TXTGF TTXG Text Processing: Text ID Groups MANDT
1 V_T077D_V TXTGV TTXG Text Processing: Text ID Groups MANDT
0 V_T077D_V TXTGZ TTXG Text Processing: Text ID Groups MANDT