SAP ABAP Table OIFSMCADDR (Link Table Between OIFSPBL and ADRC for Matchcode)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIF (Package) MRN Marketing Retail Networks

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIFSMCADDR	Table Relationship Diagram
Short Description	Link Table Between OIFSPBL and ADRC for Matchcode

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	T000
2	PBLNR	☑	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
3	ADDRNUM	☑	OIF_ADNUM	AD_ADDRNUM	CHAR	10	0	Address No. in ADRC	ADRC
4	DATE_FROM	☐	AD_DATE_FR	DATUM	DATS	8	0	Valid-from date - in current Release only 00010101 possible
5	NATION	☐	AD_NATION	AD_NATION	CHAR	1	0	Version ID for International Addresses	ADRC

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIFSMCADDR	ADDRNUM	ADRC	ADDRNUMBER
2	OIFSMCADDR	MANDT	T000	MANDT	KEY	C	CN
3	OIFSMCADDR	NATION	ADRC	NATION
4	OIFSMCADDR	PBLNR	OIFSPBL	PBLNR	KEY	C	CN

History

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