SAP ABAP Table OIUCI_PDX (Purchaser DOI Cross Reference)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV-CI (Application Component) Check Input
     ⤷ OIU_CI (Package) Check Input Enhancements for Apache

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUCI_PDX	Table Relationship Diagram
Short Description	Purchaser DOI Cross Reference

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	PU_NO	☑	OIUH_REMITTER_ID	CHAR6	CHAR	6	0	Remitter ID
3	PU_SEQ_NO	☑	OIUCM_SEQ_NO	OIUCM_SEQ_NO	CHAR	2	0	Sequence Number
4	PU_PR_NO	☑	OIUH_REMITTER_PROPERTY	CHAR18	CHAR	18	0	Remitter Property
5	PU_PD_CD	☑	OIUH_REMITTER_PRODUCT	CHAR3	CHAR	3	0	Remitter Product
6	LYT_FL_NO	☑	OIUH_LAYOUT_FIELD	CHAR3	CHAR	3	0	Layout Field
7	LYT_FL_CD	☑	OIUCI_LAYOUT_FIELD_CODE	CHAR18	CHAR	18	0	Layout Field Value
8	EFF_FROM_DT	☑	OIUH_EFFECTIVE_FROM	DATS	DATS	8	0	Effective From Date
9	EFF_TO_DT	☐	OIUH_EFFECTIVE_TO	DATS	DATS	8	0	Effective To Date
10	EFF_TO_DT_CD	☐	OIUCI_EFF_TO_DT_CD	CHAR1	CHAR	1	0	Effective to date code
11	SYS_NO	☐	OIUCI_PDX_SYSTEM_NO	DEC18	DEC	18	0	Purchaser to Property/DOI Xref System Number
12	RCVBL_DECM_PC	☐	OIUH_RECEIVABLE_DECIMAL	OIUH_DEC9_8	DEC	9	8	Receivable Decimal
13	PD_CD	☐	OIUH_PRODUCT	CHAR3	CHAR	3	0	Product
14	AFFIL_ACCT_NO	☐	OIUCI_AFFIL_ACCT_NO	CHAR3	CHAR	3	0	Affiliated Account Number
15	OVRD_PRCS_NO	☐	OIUH_OVERRIDE_PROCESS_NO	CHAR4	CHAR	4	0	Override Process No
16	RCVBL_MP_NO	☐	OIUH_MEASUREMENT_POINT_ID	CHAR6	CHAR	6	0	Measurement Point ID
17	PR_NO	☐	OIUH_PROPERTY_DOI	CHAR8	CHAR	8	0	Property / DOI
18	DOI_NO	☐	OIUH_DOI_NO	CHAR5	CHAR	5	0	Division of Interest (DOI) Number
19	TAX_CALC_FL	☐	OIUH_CALCULATE_SEVERANCE_TAX	CHAR1	CHAR	1	0	Calculate Severance Tax
20	BLN_IND_FL	☐	OIUH_BLANCHARD_XREF	CHAR1	CHAR	1	0	Blanchard Cross Reference
21	CDEX_OVRD_NO	☐	OIUH_CDEX	CHAR4	CHAR	4	0	CDEX Override Process No
22	CT_NO	☐	OIUH_RESELL_CONTRACT	CHAR6	CHAR	6	0	Resell Contract
23	CMT_FL	☐	OIUH_CMT_FL	OIUH_CMT_FL	CHAR	1	0	Extended comment flag
24	VER_NO	☐	OIUCI_VERSION_NO	DEC5	DEC	5	0	Version No
25	SPC_DIST_FL	☐	OIUCI_SPC_DIST_FL	OIUCI_SPC_DIST_FL	CHAR	1	0	Special Distribution Flag
26	USED_FL	☐	OIUH_CHAR1	CHAR1	CHAR	1	0	OIUH_CHAR1
27	UNIT_OF_MEAS_CD	☐	MSEHI	MEINS	UNIT	3	0	Unit of Measurement	T006
28	COST_CENTER	☐	RKOSTL	KOSTL	CHAR	10	0	Template cost center	*
29	OR_LVL_1_NO	☐	OIUH_OR_LVL_1_NO	OIUH_OR_LVL_1_NO	CHAR	3	0	Organization level 1 number (Company Code)	OIUH_CM_OR1
30	.INCLUDE	☐				0	0	Creator and date/time created
31	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
32	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUCI_PDX	OR_LVL_1_NO	OIUH_CM_OR1	OR1_OR_LVL_1_NO
2	OIUCI_PDX	UNIT_OF_MEAS_CD	T006	MSEHI

History

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