SAP ABAP Table RJH_OP_PARTNER_SALESAREA (IS-M: Object Provider Attributes for BP Sales Area Segment)
Hierarchy
IS-M (Software Component) SAP MEDIA
   IS-M (Application Component) SAP Media
     JAS (Package) Application development R/3 Publishing Advertising System***
Basic Data
Table Category INTTAB    Structure 
Structure RJH_OP_PARTNER_SALESAREA   Table Relationship Diagram
Short Description IS-M: Object Provider Attributes for BP Sales Area Segment    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 .INCLUDE       0   0   Customer Master Sales Data  
2 MANDT MANDT MANDT CLNT 3   0   Client T000
3 KUNNR KUNNR KUNNR CHAR 10   0   Customer Number KNA1
4 VKORG VKORG VKORG CHAR 4   0   Sales Organization TVKO
5 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel TVTW
6 SPART SPART SPART CHAR 2   0   Division TSPA
7 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
8 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
9 BEGRU BEGRU BEGRU CHAR 4   0   Authorization Group  
10 LOEVM LOEVM_V XFELD CHAR 1   0   Deletion flag for customer (sales level)  
11 VERSG STGKU STGKU CHAR 1   0   Customer Statistics Group TVSD
12 AUFSD AUFSD_V KAUFS CHAR 2   0   Customer order block (sales area) TVAST
13 KALKS KALKS KALKS CHAR 1   0   Pricing procedure assigned to this customer TVKD
14 KDGRP KDGRP KDGRP CHAR 2   0   Customer group T151
15 BZIRK BZIRK BZIRK CHAR 6   0   Sales district T171
16 KONDA KONDA KONDA CHAR 2   0   Price Group (Customer) T188
17 PLTYP PLTYP PLTYP CHAR 2   0   Price list type T189
18 AWAHR AWAHR AWAHR NUMC 3   0   Order probability of the item  
19 INCO1 INCO1 INCO1 CHAR 3   0   Incoterms (part 1) TINC
20 INCO2 INCO2 INCO2 CHAR 28   0   Incoterms (part 2)  
21 LIFSD LIFSD_V LIFSP CHAR 2   0   Customer delivery block (sales area) TVLS
22 AUTLF AUTLF XFELD CHAR 1   0   Complete delivery defined for each sales order?  
23 ANTLF ANTLF ANTLF DEC 1   0   Maximum number of partial deliveries allowed per item  
24 KZTLF KZTLF KZTLF CHAR 1   0   Partial delivery at item level  
25 KZAZU KZAZU_D XFELD CHAR 1   0   Order combination indicator  
26 CHSPL CHSPL XFELD CHAR 1   0   Batch split allowed  
27 LPRIO LPRIO LPRIO NUMC 2   0   Delivery priority TPRIO
28 EIKTO EIKTO CHAR12 CHAR 12   0   Shipper's (Our) Account Number at the Customer or Vendor  
29 VSBED VSBED VSBED CHAR 2   0   Shipping conditions TVSB
30 FAKSD FAKSD_V FAKSP CHAR 2   0   Billing block for customer (sales and distribution) TVFS
31 MRNKZ MRNKZ XFELD CHAR 1   0   Manual invoice maintenance  
32 PERFK PERFK WFCID CHAR 2   0   Invoice dates (calendar identification) TFACD
33 PERRL PERRL WFCID CHAR 2   0   Invoice list schedule (calendar identification) TFACD
34 KVAKZ KVAKZ XFELD CHAR 1   0   Cost estimate indicator (inactive)  
35 KVAWT KVAWT WERT7 CURR 13   2   Value limit for cost estimate (inactive)  
36 WAERS WAERS_V02D WAERS CUKY 5   0   Currency TCURC
37 KLABC KLABC KLABC CHAR 2   0   Customer classification (ABC analysis)  
38 KTGRD KTGRD KTGRD CHAR 2   0   Account assignment group for this customer TVKT
39 ZTERM DZTERM ZTERM CHAR 4   0   Terms of payment key  
40 VWERK DWERK_EXT WERKS CHAR 4   0   Delivering Plant (Own or External) TVKWZ
41 VKGRP VKGRP VKGRP CHAR 3   0   Sales group TVBVK
42 VKBUR VKBUR VKBUR CHAR 4   0   Sales office TVBUR
43 VSORT VSORT VBELN CHAR 10   0   Item proposal VBUK
44 KVGR1 KVGR1 KVGR1 CHAR 3   0   Customer group 1 TVV1
45 KVGR2 KVGR2 KVGR2 CHAR 3   0   Customer group 2 TVV2
46 KVGR3 KVGR3 KVGR3 CHAR 3   0   Customer group 3 TVV3
47 KVGR4 KVGR4 KVGR4 CHAR 3   0   Customer group 4 TVV4
48 KVGR5 KVGR5 KVGR5 CHAR 3   0   Customer group 5 TVV5
49 BOKRE BOKRE XFELD CHAR 1   0   ID: Customer is to receive rebates  
50 BOIDT BOIDT DATUM DATS 8   0   Start of validity per.for the rebate index for the customer  
51 KURST KURST KURST CHAR 4   0   Exchange Rate Type TCURV
52 PRFRE PRFRE XFELD CHAR 1   0   Relevant for Pricing ID  
53 PRAT1 KUAT1 PRATK CHAR 1   0   ID for product attribute 1  
54 PRAT2 KUAT2 PRATK CHAR 1   0   ID for product attribute 2  
55 PRAT3 KUAT3 PRATK CHAR 1   0   ID for product attribute 3  
56 PRAT4 KUAT4 PRATK CHAR 1   0   ID for product attribute 4  
57 PRAT5 KUAT5 PRATK CHAR 1   0   ID for product attribute 5  
58 PRAT6 KUAT6 PRATK CHAR 1   0   ID for product attribute 6  
59 PRAT7 KUAT7 PRATK CHAR 1   0   ID for product attribute 7  
60 PRAT8 KUAT8 PRATK CHAR 1   0   ID for product attribute 8  
61 PRAT9 KUAT9 PRATK CHAR 1   0   ID for product attribute 9  
62 PRATA KUATA PRATK CHAR 1   0   ID for product attribute 10  
63 KABSS KABSSCH_CM KABSSCH_CM CHAR 4   0   Customer payment guarantee procedure T691P
64 KKBER KKBER KKBER CHAR 4   0   Credit control area T014
65 CASSD CASSD_V CASSP CHAR 2   0   Sales block for customer (sales area)  
66 RDOFF RDOFF XFELD CHAR 1   0   Switch off rounding?  
67 AGREL AGREL XFELD CHAR 1   0   Indicator: Relevant for agency business  
68 MEGRU MEGRU MEGRU CHAR 4   0   Unit of Measure Group TWMEG
69 UEBTO UEBTO PRZ21 DEC 3   1   Overdelivery Tolerance Limit  
70 UNTTO UNTTO PRZ21 DEC 3   1   Underdelivery Tolerance Limit  
71 UEBTK UEBTK_V XFELD CHAR 1   0   Unlimited overdelivery allowed  
72 PVKSM PVKSM PVKSM CHAR 2   0   Customer procedure for product proposal TPVD
73 PODKZ PODKZ XFELD CHAR 1   0   Relevant for POD processing  
74 PODTG PODTG TSTRDURAG DEC 11   0   Timeframe for Confirmation of POD  
75 BLIND BLIND_SD XFELD CHAR 1   0   Index Structure Active for Subsequent Settlement (in AB)  
76 CARRIER_NOTIF /SPE/CARRIER_NOTIF XFELD CHAR 1   0   Carrier is to be notified  
77 .INCLU--AP       0   0   Append for Empties  
78 .INCLUDE       0   0   Include for Empties  
79 /BEV1/EMLGPFAND /BEV1/EMGPFAND /BEV1/EMGPFAND CHAR 1   0   Deposit on Empties  
80 /BEV1/EMLGFORTS /BEV1/EMGFORTS /BEV1/EMGFORTS CHAR 1   0   Indicator for Empties Update  
81 .INCLUDE       0   0   IS-PAM: Media sales area customer (data part)  
82 MK_LOEVM LOEVM_ISP XFELD CHAR 1   0   Deletion Flag for Master Data in Media Sales & Distribution  
83 MK_LOEKZ LOEKZ_ISP XFELD CHAR 1   0   Deletion Indicator for Master Data in Media Sales & Dist.  
84 .INCLUDE       0   0   Created-By Data (Medium Scope)  
85 ERFUSER ERFUSER USNAM CHAR 12   0   Created By  
86 ERFDATE ERFDATE DATUM DATS 8   0   Created On  
87 ERFTIME ERFTIME UZEIT TIMS 6   0   Time Created  
88 AENUSER AENUSER USNAM CHAR 12   0   Last Changed By  
89 AENDATE AENDATE DATUM DATS 8   0   Date of Last Change  
90 AENTIME AENTIME UZEIT TIMS 6   0   Time of Last Change  
91 XNK XNEUKUNDE XFELD CHAR 1   0   IS-M: New customer indicator  
92 KUKARR JKUKARR JKUKARR CHAR 2   0   IS-M: Customer Profile TJJ95
93 KONKAUS KONKAUS KONKAUS CHAR 2   0   IS-M: Competitor exclusion TJH89
94 MK_XAGEN XAGENTUR XFELD CHAR 1   0   IS-M: Agency Indicator  
95 MK_XSTR XAGEN_STR XFELD CHAR 1   0   IS-M: Distribution Agency Indicator  
96 MK_XPLAN XAGEN_PLAN XFELD CHAR 1   0   IS-M: Planning Agency Indicator  
97 MK_XART XAGEN_KREA XFELD CHAR 1   0   IS-M: Creative Boutique Indicator  
98 MK_ABRKAG JABRKALAG WFCID CHAR 2   0   IS-M: Agency Billing Schedule (Calendar Identification) TJG61
99 MKAGEN_GRU AGEN_GRUP AGEN_GRUP CHAR 1   0   IS-M: Agency Type TJGJ4
100 AE AGEN_AE AGEN_AE CHAR 1   0   IS-M: Agency Commission Entitlement  
101 MK_DUB JDUBIOS JDUBIOS CHAR 1   0   IS-M: Credit Query Indicator TJGJ0
102 MK_BON JBONITAET JBONITAET CHAR 2   0   IS-M: Creditworthiness Indicator TJGJ2
103 XMAN XMANUSKRIP XFELD CHAR 1   0   IS-M: Processing of Ad Booking Details Requested Indicator  
104 ZTEGR GR_ZTERM GR_ZTERM CHAR 2   0   IS-M: Terms of Payment Group TJJB7
105 TOL SIZE_TOL CHAR03 CHAR 3   0   IS-M: Deviation tolerance as a percentage value  
106 RE_STELL RE_STELL RE_STELL CHAR 1   0   IS-M: Billing split TJJB3
107 DRSTS JHDRSTS JHDRSTS CHAR 2   0   IS-M: Print Control Procedure TJJB5
108 XORTSPR XORTSPREIS XFELD CHAR 1   0   IS-M/AM: Local Customer Indicator  
109 VKBOF JVKBUR_OFF VKBUR CHAR 4   0   IS-M: Alternative sales office for collecting responses TVKBZ
110 BLART PAM_BELART PAM_BELART CHAR 4   0   IS-M: Voucher Type (Proof) TJJB1
111 BLANZ PAM_BELANZ NUMC5 NUMC 5   0   IS-M: Number of Voucher Copies  
112 ZLSCHB JHZLSCHB ZLSCH CHAR 1   0   IS-M/AM: Payment Method for Customer Bonus Settlement T042Z
113 K_ANZ KARENZANZ JKARENZ NUMC 4   0   IS-M/AM: Grace Period for Changes to Ad Prices  
114 K_ANZ_ME JJMEINS MEINS UNIT 3   0   IS-M: Basic Unit of Measure for Time T006
115 K_DL KARENZDL JKARENZ NUMC 4   0   IS-M: Grace Period for Changes to Service Prices  
116 K_DL_ME JJMEINS MEINS UNIT 3   0   IS-M: Basic Unit of Measure for Time T006
117 K_SI KARENZSI JKARENZ NUMC 4   0   IS-M: Grace Period for Changes to Prices of Ad Inserts  
118 K_SI_ME JJMEINS MEINS UNIT 3   0   IS-M: Basic Unit of Measure for Time T006
119 K_VER KARENZVER JKARENZ NUMC 4   0   IS-M: Grace Period for Changes to Distribution Prices  
120 K_VER_ME JJMEINS MEINS UNIT 3   0   IS-M: Basic Unit of Measure for Time T006
121 K_WSP KARENZWSP JKARENZ NUMC 4   0   IS-M: Grace Period for Changes to Commercial Prices  
122 K_WSP_ME JJMEINS MEINS UNIT 3   0   IS-M: Basic Unit of Measure for Time T006
123 K_OL KARENZOL JKARENZ NUMC 4   0   IS-M: Grace Period for Price Changes in Online Advertising  
124 K_OL_ME JJMEINS MEINS UNIT 3   0   IS-M: Basic Unit of Measure for Time T006
125 .INCLUDE       0   0   IS-PAM: Media sales area customer - COA data  
126 XABSCHL XABSCHLUSS XFELD CHAR 1   0   IS-M: Contract Customer Indicator  
127 ABE ABSCH_ERN JNFELD CHAR 1   0   IS-M: Indicator: Automatic Contract Renewal  
128 MAX_UNT MAX_UNT NUMC2 NUMC 2   0   IS-M: Maximum Interruption in Validity Period (in Months)  
129 MAX_RDAT MAX_RDAT SYNUM02 NUMC 2   0   IS-M: Maximum Backdating Start of Validity Period (Months)  
130 MENGA ANPASS JNFELD CHAR 1   0   Quantity Adjustment for Contract Validity Period Change  
131 ARAB ARABATT JNFELD CHAR 1   0   IS-M: Qualifies for Contract Indicator  
132 RABA RABATTANP JH_XRABANP CHAR 1   0   IS-M: Disc./Price Adjustment During Contract Validity Period  
133 RABSPERR RABSPERR JNFELD CHAR 1   0   IS-M: Block higher-level discounts indicator  
134 RANPASS RANPASS JNFELD CHAR 1   0   IS-M: Increase Discount in the Case of Over-Fulfillment Ind.  
135 RANPASSL RANPASSL JNFELD CHAR 1   0   IS-M: Reduce Discount in the Case of Non-Fulfillment Ind.  
136 QABR QABR QABR CHAR 1   0   IS-M: Define Settlement for System Contracts  
137 B_AUSR ABSCHL_BEG ABSCHL_BEG CHAR 1   0   IS-M: Rule for Contract Start TJJV14
138 E_AUSR ABSCHL_END ABSCHL_END CHAR 1   0   IS-M: Rule for Contract End TJJV15
139 REG_DAU ABSCHLZEIT SYNUM02 NUMC 2   0   IS-M: Standard Validity Period for Contracts (in Months)  
140 AB_TOL ABSCHL_TOL NUMC03 NUMC 3   0   IS-M: Contract Tolerance Quantity for Non-Fulfillment (in %)  
141 ZLSCHA JHZLSCHA ZLSCH CHAR 1   0   IS-M: Payment Method for Contract Settlement T042Z
142 FAKSA PAM_FAKSP FAKSP CHAR 2   0   IS-M: Billing Block TVFS
143 EABR_NACHL EABR_NACHL SYNUM02 NUMC 2   0   IS-M: Time of Final Settlement After Runtime (in Months)  
144 BEST_PR BEST_PR JNFELD CHAR 1   0   IS-M: Apply Best Conditions to Number / Quantity  
145 PAR_ABS PAR_ABS JNFELD CHAR 1   0   IS-M: Work with Parallel Contracts Indicator  
146 AB_VOR AB_VOR JNFELD CHAR 1   0   IS-M: Advance Bonus Indicator  
147 TO_WARN TO_WARN JNFELD CHAR 1   0   IS-M: Generate Advance Warning Automatically  
148 MIN_GUT MIN_GUTSCH ISPBETR07 CURR 7   2   IS-M: De Minimis Limitation for Contract Credit Memo  
149 MIN_LAST MIN_LAST ISPBETR07 CURR 7   2   IS-M/AM: De Minimis Limitation for Contract Debit Memo  
150 SALESAREA ISM_SALESAREA CHAR10 CHAR 10   0   IS-M/AM: Sales Area (SOrg/DstChan/Division)  
151 XMEDIAK XMEDIAK XFELD CHAR 1   0   IS-M: Media customer  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RJH_OP_PARTNER_SALESAREA AUFSD TVAST AUFSP REF C CN
2 RJH_OP_PARTNER_SALESAREA BLART TJJB1 BLART REF 1 CN
3 RJH_OP_PARTNER_SALESAREA BZIRK T171 BZIRK REF C CN
4 RJH_OP_PARTNER_SALESAREA B_AUSR TJJV14 B_AUSR REF C CN
5 RJH_OP_PARTNER_SALESAREA DRSTS TJJB5 DRSTS REF 1 CN
6 RJH_OP_PARTNER_SALESAREA E_AUSR TJJV15 E_AUSR REF C CN
7 RJH_OP_PARTNER_SALESAREA FAKSA TVFS FAKSP REF 1 CN
8 RJH_OP_PARTNER_SALESAREA FAKSD TVFS FAKSP REF C CN
9 RJH_OP_PARTNER_SALESAREA INCO1 TINC INCO1 REF C CN
10 RJH_OP_PARTNER_SALESAREA KABSS T691P KABSS REF C CN
11 RJH_OP_PARTNER_SALESAREA KALKS TVKD KALKS REF C CN
12 RJH_OP_PARTNER_SALESAREA KDGRP T151 KDGRP REF C CN
13 RJH_OP_PARTNER_SALESAREA KKBER T014 KKBER C CN
14 RJH_OP_PARTNER_SALESAREA KONDA T188 KONDA REF C CN
15 RJH_OP_PARTNER_SALESAREA KONKAUS TJH89 KONKAUS REF C CN
16 RJH_OP_PARTNER_SALESAREA KTGRD TVKT KTGRD REF C CN
17 RJH_OP_PARTNER_SALESAREA KUKARR TJJ95 KUKARR REF C CN
18 RJH_OP_PARTNER_SALESAREA KUNNR KNA1 KUNNR KEY 1 CN
19 RJH_OP_PARTNER_SALESAREA KURST TCURV KURST REF C CN
20 RJH_OP_PARTNER_SALESAREA KVGR1 TVV1 KVGR1 REF C CN
21 RJH_OP_PARTNER_SALESAREA KVGR2 TVV2 KVGR2 REF C CN
22 RJH_OP_PARTNER_SALESAREA KVGR3 TVV3 KVGR3 REF C CN
23 RJH_OP_PARTNER_SALESAREA KVGR4 TVV4 KVGR4 REF C CN
24 RJH_OP_PARTNER_SALESAREA KVGR5 TVV5 KVGR5 REF C CN
25 RJH_OP_PARTNER_SALESAREA K_ANZ_ME T006 MSEHI REF C CN
26 RJH_OP_PARTNER_SALESAREA K_DL_ME T006 MSEHI REF C CN
27 RJH_OP_PARTNER_SALESAREA K_OL_ME T006 MSEHI REF C CN
28 RJH_OP_PARTNER_SALESAREA K_SI_ME T006 MSEHI REF C CN
29 RJH_OP_PARTNER_SALESAREA K_VER_ME T006 MSEHI REF C CN
30 RJH_OP_PARTNER_SALESAREA K_WSP_ME T006 MSEHI REF C CN
31 RJH_OP_PARTNER_SALESAREA LIFSD TVLS LIFSP REF C CN
32 RJH_OP_PARTNER_SALESAREA LPRIO TPRIO LPRIO REF C CN
33 RJH_OP_PARTNER_SALESAREA MANDT T000 MANDT KEY 1 CN
34 RJH_OP_PARTNER_SALESAREA MEGRU TWMEG MEGRU 1 N
35 RJH_OP_PARTNER_SALESAREA MKAGEN_GRU TJGJ4 AGEN_GRU REF 1 N
36 RJH_OP_PARTNER_SALESAREA MK_ABRKAG TJG61 IDENT REF 1 CN
37 RJH_OP_PARTNER_SALESAREA MK_BON TJGJ2 BONITAET KEY 1 CN
38 RJH_OP_PARTNER_SALESAREA MK_DUB TJGJ0 DUBIOS KEY 1 CN
39 RJH_OP_PARTNER_SALESAREA PERFK TFACD IDENT REF C CN
40 RJH_OP_PARTNER_SALESAREA PERRL TFACD IDENT REF C CN
41 RJH_OP_PARTNER_SALESAREA PLTYP T189 PLTYP REF C CN
42 RJH_OP_PARTNER_SALESAREA PVKSM TPVD PVKSM KEY 1 1
43 RJH_OP_PARTNER_SALESAREA RE_STELL TJJB3 RE_STELL REF 1 CN
44 RJH_OP_PARTNER_SALESAREA SPART TSPA SPART KEY 1 CN
45 RJH_OP_PARTNER_SALESAREA VERSG TVSD STGKU REF C CN
46 RJH_OP_PARTNER_SALESAREA VKBOF TVKBZ VKBUR REF 1 CN
47 RJH_OP_PARTNER_SALESAREA VKBUR TVBUR VKBUR REF C CN
48 RJH_OP_PARTNER_SALESAREA VKGRP TVBVK VKGRP REF C CN
49 RJH_OP_PARTNER_SALESAREA VKORG TVKO VKORG KEY 1 CN
50 RJH_OP_PARTNER_SALESAREA VSBED TVSB VSBED REF C CN
51 RJH_OP_PARTNER_SALESAREA VSORT VBUK VBELN REF C CN
52 RJH_OP_PARTNER_SALESAREA VTWEG TVTW VTWEG KEY 1 CN
53 RJH_OP_PARTNER_SALESAREA VWERK TVKWZ WERKS REF C CN
54 RJH_OP_PARTNER_SALESAREA WAERS TCURC WAERS REF C CN
55 RJH_OP_PARTNER_SALESAREA ZLSCHA T042Z ZLSCH KEY 1 CN
56 RJH_OP_PARTNER_SALESAREA ZLSCHB T042Z ZLSCH REF 1 CN
57 RJH_OP_PARTNER_SALESAREA ZTEGR TJJB7 ZTEGR REF 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in 463