SAP ABAP Table ITL_SAFT_BDI (Billing Doc Item extraction)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC (Application Component) Localization
     ⤷ BEA_INTERNATIONAL (Package) Billing International

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ITL_SAFT_BDI	Table Relationship Diagram
Short Description	Billing Doc Item extraction

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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	BILL_UNIT	☑	BEA_BILL_ORG	BU_PARTNER	CHAR	10	0	Billing Unit	*
3	BDI_GUID	☑	BEA_BDI_GUID	SYSUUID	RAW	16	0	GUID of Billing Item
4	BDH_GUID	☑	BEA_BDH_GUID	SYSUUID	RAW	16	0	Unique Internal ID of a Billing Header
5	BILL_DATE	☑	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
6	LINE_NUM	☐	BEA_ITEMNO_EXT	NUMC10	NUMC	10	0	Billing Item (External Identifier)
7	ORGINATING_ON	☐	SRC_DOC_NUM		CHAR	60	0	Source Document Number
8	ORD_DATE	☐	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
9	PRD_CODE	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
10	PRD_DESC	☐	PROD_DESC		CHAR	200	0	Product Description
11	QTY	☐	BEA_QUANTITY	MENGV13	QUAN	13	3	Quantity
12	UNIT_MSR	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
13	UNIT_PRC	☐	CRMT_NET_VALUE_MAN	WERTV8	CURR	15	2	Total Expected Net Value Products in Document Currency
14	TAX_POINT_DATE	☐	BEA_RENDERED_DATE	SYDATS	DATS	8	0	Date of Services Rendered
15	CREDIT_REF	☐	TEXT10	TEXT10	CHAR	10	0	Text (10 Characters)
16	CREDIT_REASON	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
17	DESCP	☐	PROD_DESC		CHAR	200	0	Product Description
18	DBT_AMT	☐	BEA_NET_VALUE	WERTV8	CURR	15	2	Net Value in Document Currency
19	CDT_AMT	☐	BEA_NET_VALUE	WERTV8	CURR	15	2	Net Value in Document Currency
20	TAX_TYP	☐	CHAR40	CHAR40	CHAR	40	0	Character field of length 40
21	TAX_CTY_REG	☐	CHAR5	CHAR5	CHAR	5	0	R/2 table
22	TAX_CODE	☐	CHAR3	CHAR3	CHAR	3	0	3-Byte field
23	TAX_PER	☐	PRCT_COND_RATE	WERTV8	CURR	15	2	Condition Rate
24	TAX_AMT	☐	BEA_TAX_VALUE	WERTV8	CURR	15	2	Tax Amount in Document Currency
25	TAX_EXP_REASON	☐	CHAR60	CHAR60	CHAR	60	0	Char 60
26	SETTLEMENT_AMT_L	☐	BEA_NET_VALUE	WERTV8	CURR	15	2	Net Value in Document Currency
27	DELIVERY_ID_ST	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
28	DEL_DATE_ST	☐	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
29	BUILD_NUM_ST	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
30	STREET_NAME_ST	☐	AD_STREET	TEXT60	CHAR	60	0	Street
31	ADD_DETAIL_ST	☐	CHAR60	CHAR60	CHAR	60	0	Char 60
32	CITY_ST	☐	AD_CITY1	TEXT40	CHAR	40	0	City
33	POST_CODE_ST	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
34	REGION_ST	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
35	CTY_ST	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
36	PRODUCT_GUID	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ITL_SAFT_BDI	CLIENT	T000	MANDT

History

Last changed by/on	SAP	20131122
SAP Release Created in