SAP ABAP Table ITL_SAFT_BDH (Billing Doc Header extraction table)

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_BDH	Table Relationship Diagram
Short Description	Billing Doc Header extraction table

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	BDH_GUID	☑	BEA_BDH_GUID	SYSUUID	RAW	16	0	Unique Internal ID of a Billing Header
3	BILL_UNIT	☑	BEA_BILL_ORG	BU_PARTNER	CHAR	10	0	Billing Unit	*
4	BILL_DATE	☑	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
5	BILL_DOC_NUM	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
6	OFFDOC	☐	TEXT60	TEXT60	CHAR	60	0	Text Field of Length 60
7	INV_STAT	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
8	HASH	☐	CHAR200	CHAR200	CHAR	200	0	Text field length 200
9	HASH_CTRL	☐	TEXT40	TEXT40	CHAR	40	0	Text, 40 Characters Long
10	PERIOD	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
11	INV_TYPE	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
12	BILL_IND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
13	SYS_ENT_DATE	☐	ITL_DATE_TIME	ITL_DATE_TIME	CHAR	19	0	Date Time in format: YYYY:MM:DDTHH:MM:SS
14	TRANS_ID	☐	CHAR70	CHAR70	CHAR	70	0	Character field, length 70
15	CUST_ID	☐	BEA_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
16	DELIVERY_ID_ST	☐	CHAR30	CHAR30	CHAR	30	0	30 Characters
17	DEL_DATE_ST	☐	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
18	BUILD_NUM_ST	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
19	STREET_NAME_ST	☐	STREET_ADDRESS		CHAR	90	0	Street Name
20	ADD_DETAIL_ST	☐	ADDRESS_DETAIL		CHAR	100	0	Address Detail
21	CITY_ST	☐	AD_CITY1	TEXT40	CHAR	40	0	City
22	POST_CODE_ST	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
23	REGION_ST	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
24	CTY_ST	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
25	DELIVERY_ID_SF	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
26	DEL_DATE_SF	☐	BEA_BILL_DATE	SYDATS	DATS	8	0	Billing Date
27	BUILD_NUM_SF	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
28	STREET_NAME_SF	☐	STREET_ADDRESS		CHAR	90	0	Street Name
29	ADD_DETAIL_SF	☐	ADDRESS_DETAIL		CHAR	100	0	Address Detail
30	CITY_SF	☐	AD_CITY1	TEXT40	CHAR	40	0	City
31	POST_CODE_SF	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
32	REGION_SF	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
33	CTY_SF	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
34	TAX_PAYABLE	☐	BEA_TAX_VALUE	WERTV8	CURR	15	2	Tax Amount in Document Currency
35	NET_TOTAL	☐	BEA_NET_VALUE	WERTV8	CURR	15	2	Net Value in Document Currency
36	GROSS_TOTAL	☐	BEA_GROSS_VALUE	WERTV8	CURR	15	2	Gross Value in Document Currency
37	CNY_CODE	☐	WAERK	WAERS	CUKY	5	0	SD document currency	*
38	CNY_CDT_AMT	☐	BEA_GROSS_VALUE	WERTV8	CURR	15	2	Gross Value in Document Currency
39	CNY_DBT_AMT	☐	BEA_GROSS_VALUE	WERTV8	CURR	15	2	Gross Value in Document Currency
40	SET_DISC_REA	☐	TEXT30	TEXT30	CHAR	30	0	Text (30 Characters)
41	SET_AMT	☐	PRCT_COND_VALUE	WERTV8	CURR	15	2	Price Determination: Condition Value
42	SET_DATE	☐	DATUM	DATUM	DATS	8	0	Date
43	PAY_MECH	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
44	INV_STS_DATE	☐	ITL_DATE_TIME	ITL_DATE_TIME	CHAR	19	0	Date Time in format: YYYY:MM:DDTHH:MM:SS
45	SOURCE_ID_STS	☐	USERNAME	USERNAME	CHAR	12	0	User name
46	SOURCE_ID_DOC	☐	USERNAME	USERNAME	CHAR	12	0	User name
47	EXCHANGE_RATE	☐	BEA_EXCHANGE_RATE	BEA_EXCHANGE_RATE	DEC	9	5	Exchange Rate
48	PAY_TERMS	☐	CRMT_PMNTTRMS_DESC	TEXT50	CHAR	50	0	Explanation of Payment Terms
49	BILL_SOURCE	☐	BILL_SOURCE	BILL_SOURCE	CHAR	1	0	Source system category for billing document
50	EAC_CODE	☐	ITL_EACCODE	CHAR5	CHAR	5	0	EAC Code for SAF-T Report
51	CASH_VAT_IND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
52	TP_BILL_IND	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag

Foreign Keys

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

History

Last changed by/on	SAP	20140117
SAP Release Created in