Vendor Line Items - SAP Documentation

Vendor Line Items

: 0FIN_AP_T30

This search and analytics model provides vendor line items (tables BSIK (open items) and BSAK (cleared items) of subledger accounting.

Technical Data
Model Usage	Application Model
Software Component for Search and Analytics	SAP_APPL

Root Node: Vendor Line Items

Technical Name of Root Node	`0FI_AP_30`
Data Source	`0FI_AP_30`

Attribute	Technical Name	Key
Account Number of Vendor or Creditor	`LIFNR`	Yes
Company Code	`BUKRS`	Yes
Chart of Accounts	`KTOPL`	Yes
G/L Account Number	`SAKNR`	Yes
Document Status	`BSTAT`	Yes
Account Type	`KOART`	Yes
Special G/L Indicator	`UMSKZ`	Yes
Document Type	`BLART`	Yes
Reason Code for Payments	`RSTGR`	Yes
Dunning Block	`MANSP`	Yes
Dunning Key	`MSCHL`	Yes
Country Key	`LAND1`	Yes
Payment Method	`ZLSCH`	Yes
Payment Block Key	`ZLSPR`	Yes
Status of FI Item	`STATUSPS`	Yes
Credit Control Area	`KKBER`	Yes
Dunning Area	`MABER`	Yes
Reference Transaction	`AWTYP`	Yes

Operational Data Provider: Vendor Line Items

Technical Name	`0FIN_AP_T30`
ODP Semantics	Transaction data
Direct Access Enabled	Yes

Attribute	Technical Name	Mapped to InfoObject	Description
Account Number of Vendor or Creditor	`LIFNR`	`LIFNR`	Account Number of Vendor or Creditor
Company Code	`BUKRS`	`0COMP_CODE`	Main Asset Number
Chart of Accounts	`KTOPL`	`KTOPL`	Chart of Accounts
G/L Account Number	`SAKNR`	`SAKNR`	G/L Account Number
Document Status	`BSTAT`	`BSTAT`	Document Status
Account Type	`KOART`	`KOART`	Account Type
Special G/L Indicator	`UMSKZ`	`UMSKZ`	Special G/L Indicator
Document Type	`BLART`	`BLART`	Document Type
Reason Code for Payments	`RSTGR`	`RSTGR`	Reason Code for Payments
Dunning Block	`MANSP`	`MANSP`	Dunning Block
Dunning Key	`MSCHL`	`MSCHL`	Dunning Key
Country Key	`LAND1`	`LAND1`	Country Key
Payment Method	`ZLSCH`	`ZLSCH`	Payment Method
Payment Block Key	`ZLSPR`	`ZLSPR`	Payment Block Key
Status of FI Item	`STATUSPS`	`STATUSPS`	Status of FI Item
Credit Control Area	`KKBER`	`KKBER`	Credit Control Area
Dunning Area	`MABER`	`MABER`	Dunning Area
Reference Transaction	`AWTYP`	`AWTYP`	Reference Transaction

Authorization Checks

Check ID	ABAP Authorization Object	Description
`0FIN_AP_T30_C1`	`F_LFA1_BUK`	Vendor: Authorization for Company Codes
`0FIN_AP_T30_C2`	`F_KNA1_BUK`	Customer: Authorization for Company Codes
`0FIN_AP_T30_C3`	`F_BKPF_BUK`	Accounting Document: Authorization for Company Codes

Logical Conjunction
Authorization Type	Logical Conjunction
Type Search	`0FIN_AP_T30_C1` and `0FIN_AP_T30_C2` and `0FIN_AP_T30_C3`
Analytics	`0FIN_AP_T30_C1` and `0FIN_AP_T30_C2` and `0FIN_AP_T30_C3`

Node Relationship: G/L Account Number

Node	`0GL_ACCOUNT.0GL_ACCOUNT_ATTR`
Association	`0FI_AP_3020GL_ACCOUNT_ATTR`
Cardinality	Exactly One
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`SAKNR`	n/a	`SAKNR`	n/a	Equal
`KTOPL`	n/a	`KTOPL`	n/a	Equal

Node Relationship: Document Status

Node	`0AC_DOCSTAT.0AC_DOCSTAT_TEXT`
Association	`0FI_AP_3020AC_DOCSTAT_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`BSTAT`	n/a	`KEY1`	n/a	Equal

Node Relationship: Vendor Number

Node	`0VENDOR.0VENDOR_ATTR`
Association	`0FI_AP_3020VENDOR_ATTR`
Cardinality	Exactly One
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`LIFNR`	n/a	`LIFNR`	n/a	Equal

Node Relationship: Account Type

Node	`0ACCT_TYPE.0ACCT_TYPE_TEXT`
Association	`0FI_AP_3020ACCT_TYPE_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`KOART`	n/a	`KEY1`	n/a	Equal

Node Relationship: Special G/L Indicator

Node	`0SP_GL_IND.0SP_GL_IND_TEXT`
Association	`0FI_AP_3020SP_GL_IND_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`UMSKZ`	n/a	`KOART`	n/a	Equal

Node Relationship: Document Type

Node	`0AC_DOC_TYP.0AC_DOC_TYP_TEXT`
Association	`0FI_AP_3020AC_DOC_TYP_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`BLART`	n/a	`BLART`	n/a	Equal

Node Relationship: Reason Code for Payments

Node	`0REASON_CDE.0REASON_CDE_TEXT`
Association	`0FI_AP_3020REASON_CDE_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`BUKRS`	n/a	`BUKRS`	n/a	Equal
`RSTGR`	n/a	`RSTGR`	n/a	Equal

Node Relationship: Dunning Block

Node	`0DUNN_BLOCK.0DUNN_BLOCK_TEXT`
Association	`0FI_AP_3020DUNN_BLOCK_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`MANSP`	n/a	`MANSP`	n/a	Equal

Node Relationship: Dunning Keys

Node	`0DUNN_KEY.0DUNN_KEY_TEXT`
Association	`0FI_AP_3020DUNN_KEY_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`MSCHL`	n/a	`MSCHL`	n/a	Equal

Node Relationship: Payment Method

Node	`0PYMT_METH.0PYMT_METH_TEXT`
Association	`0FI_AP_3020PYMT_METH_TEXT`
Cardinality	Exactly One
Reverse Cardinality	Arbitrary
Sub-query	No

*Foreign Key*
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`LAND1`	n/a	`LAND1`	n/a	Equal
`ZLSCH`	n/a	`ZLSCH`	n/a	Equal

Node Relationship: Payment Block Key

Node	`0PMNT_BLOCK.0PMNT_BLOCK_TEXT`
Association	`0FI_AP_3020PMNT_BLOCK_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`ZLSPR`	n/a	`ZLSPR`	n/a	Equal

Node Relationship: Text Item Status

Node	`0FI_DOCSTAT.0FI_DOCSTAT_TEXT`
Association	`0FI_AP_3020FI_DOCSTAT_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`STATUSPS`	n/a	`KEY1`	n/a	Equal

Node Relationship: Credit Control Area Attribute

Node	`0C_CTR_AREA.0C_CTR_AREA_ATTR`
Association	`0FI_AP_3020C_CTR_AREA_ATTR`
Cardinality	Exactly One
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
KKBER	n/a	KKBER	n/a	Equal

Node Relationship: Dunning Area

Node	`0DUNN_AREA.0DUNN_AREA_TEXT`
Association	`0FI_AP_3020DUNN_AREA_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`BUKRS`	n/a	`BUKRS`	n/a	Equal
`MABER`	n/a	`MABER`	n/a	Equal

Node Relationship: Reference Transaction

Node	`0FI_AWTYP.0FI_AWTYP_TEXT`
Association	`0FI_AP_3020FI_AWTYP_TEXT`
Cardinality	Arbitrary
Reverse Cardinality	Arbitrary
Sub-query	No

Foreign Key
Attribute of Parent Node	Value	Attribute of Child Node	Value	Join-Operator
`AWTYP`	n/a	`AWTYP`	n/a	Equal