SAP ABAP View DB_WCOCOA_JEST (WCB: Selection of All Fields in Tables WCOCOH Plus Status)

Hierarchy

☛ EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   ⤷ LO-GT-CHB (Application Component) Chargeback
     ⤷ WCB_CC_PERS (Package) Condition Contract Persistence Layer

Basic Data

View Type	D	Database View
Database View	DB_WCOCOA_JEST
Short Description	WCB: Selection of All Fields in Tables WCOCOH Plus Status
Root table	WCOCOH	Condition Contract: Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	WCOCOH	WCOCOH
2	CRM_JEST
3	CRM_JSTO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	WCOCOH	CLIENT	JL	EQ				0	0
2	CRM_JEST	MANDT	JR	EQ			AND	0	0
3	WCOCOH	GUID	JL	EQ				0	0
4	CRM_JEST	OBJNR	JR	EQ			AND	0	0
5	CRM_JEST	MANDT	JL	EQ				0	0
6	CRM_JSTO	MANDT	JR	EQ			AND	0	0
7	CRM_JEST	OBJNR	JL	EQ				0	0
8	CRM_JSTO	OBJNR	JR	EQ			AND	0	0
9	CRM_JSTO	OBTYP		EQ	'WCO'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	WCOCOH	*		☐		☐
2	CLIENT	WCOCOH	CLIENT		☐	MANDT	☐	Client
3	NUM	WCOCOH	NUM		☐	WCB_COCO_NUM	☐	Condition Contract Number
4	CONTRACT_TYPE	WCOCOH	CONTRACT_TYPE		☐	WCB_CONTRACT_TYPE	☐	Condition Contract Type
5	VEND_OWNER	WCOCOH	VEND_OWNER		☐	WCB_VEND_OWNER	☐	Condition Contract: Owner Vendor
6	CUST_OWNER	WCOCOH	CUST_OWNER		☐	WCB_CUST_OWNER	☐	Condition Contract: Customer Owner
7	REFERENCE	WCOCOH	REFERENCE		☐	WCB_REFERENCE	☐	Condition Contract: Reference
8	ASSIGNMENT	WCOCOH	ASSIGNMENT		☐	WCB_ASSIGNMENT	☐	Condition Contract: Assignment
9	EXT_PARTNER	WCOCOH	EXT_PARTNER		☐	WCB_EXTERNAL_PARTNER	☐	Condition Contract: External Partner
10	CREATED_BY	WCOCOH	CREATED_BY		☐	WCB_CREATED_BY	☐	Condition Contract: Name of Processor
11	CREATED_ON	WCOCOH	CREATED_ON		☐	WCB_CREATED_ON	☐	Condition Contract: Date on Which Record Was Added
12	REC_TIME	WCOCOH	REC_TIME		☐	WCB_REC_TIME	☐	Condition Contr.: Time at Which Record Was Added
13	EKORG	WCOCOH	EKORG		☐	EKORG	☐	Purchasing organization
14	EKGRP	WCOCOH	EKGRP		☐	EKGRP	☐	Purchasing group
15	VKORG	WCOCOH	VKORG		☐	VKORG	☐	Sales Organization
16	VTWEG	WCOCOH	VTWEG		☐	VTWEG	☐	Distribution Channel
17	SPART	WCOCOH	SPART		☐	SPART	☐	Division
18	ZTERM	WCOCOH	ZTERM		☐	DZTERM	☐	Terms of payment key
19	ZBD1T	WCOCOH	ZBD1T		☐	DZBDET	☐	Cash (Prompt Payment) Discount Days
20	ZBD1P	WCOCOH	ZBD1P		☐	DZBD1P	☐	Cash discount percentage 1
21	ZBD2T	WCOCOH	ZBD2T		☐	DZBD2T	☐	Cash discount days 2
22	ZBD2P	WCOCOH	ZBD2P		☐	DZBD2P	☐	Cash Discount Percentage 2
23	ZBD3T	WCOCOH	ZBD3T		☐	DZBD3T	☐	Net Payment Terms Period
24	ZLSCH	WCOCOH	ZLSCH		☐	DZLSCH	☐	Payment method
25	GUID	WCOCOH	GUID		☐	WCB_GUID	☐	Condition Contract GUID
26	DEACT	WCOCOH	DEACT		☐	WCB_DEACTIVATED	☐	Deactivated
27	DATE_FROM	WCOCOH	DATE_FROM		☐	WCB_DATE_FROM	☐	Valid from
28	DATE_TO	WCOCOH	DATE_TO		☐	WCB_DATE_TO	☐	Valid to
29	ZONLO	WCOCOH	ZONLO		☐	SYSTZONLO	☐	Time Zone
30	EXT_NUM	WCOCOH	EXT_NUM		☐	WCB_EXTERNAL_NUMBER	☐	External Number of Document
31	CC_CURR	WCOCOH	CC_CURR		☐	WCB_CC_CURR	☐	Currency of Condition Contract
32	RATE	WCOCOH	RATE		☐	WCB_WKURS	☐	Exchange Rate
33	RATE_DATE	WCOCOH	RATE_DATE		☐	WCB_WWERT_D	☐	Conversion Date
34	RATE_TYPE	WCOCOH	RATE_TYPE		☐	KURST	☐	Exchange Rate Type
35	VKGRP	WCOCOH	VKGRP		☐	VKGRP	☐	Sales group
36	VKBUR	WCOCOH	VKBUR		☐	VKBUR	☐	Sales office
37	ACCESS_TYPE	WCOCOH	ACCESS_TYPE		☐	WCB_ACCESS_TYPE	☐	Access Type
38	*	CRM_JEST	*		☐		☐
39	MANDT	CRM_JEST	MANDT		☐	MANDT	☐	Client
40	OBJNR	CRM_JEST	OBJNR		☐	CRMT_OBJECT_GUID	☐	GUID of a CRM Order Object
41	STAT	CRM_JEST	STAT		☐	CRM_J_STATUS	☐	Object Status
42	INACT	CRM_JEST	INACT		☐	CRM_J_INACT	☐	Indicator: Status Is Inactive
43	CHGNR	CRM_JEST	CHGNR		☐	CRM_J_CHGNR	☐	Change Number

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	600