vendor table in sap: everything about lfa1, lfb1 and the business partner migration
lfa1 is the sap vendor table for general data, lfb1 holds company code data. learn the fields, join logic, and how both tables are replaced by sap business partner (but000) in s/4hana.
sap customer table (kna1/knb1): fields, joins, and s/4hana changes explained
kna1 is the sap customer master table for general data, knb1 for company code data. see all key fields, how to join them, and how both migrate to sap business partner in s/4hana.
sap s/4hana migration: which tables changed and how to query acdoca
bseg becomes acdoca, mseg becomes matdoc, and lfa1/kna1 become but000. a complete guide to the sap s/4hana migration table changes and how to query the new universal journal.
sap material master table (mara): fields, relationships, stock data and bom joins
mara stores sap material master general data, marc holds plant data, and mard holds stock levels. learn all the joins, key fields, and how to query material stock and valuation.
sap abap select statement: generate production-ready queries for any sap table
how to write sap abap select statements with proper mandt handling, deletion indicator filters, for all entries in, and select single. with copy-paste ready examples.
sap purchase order tables (ekko/ekpo): complete field and join reference
ekko is the sap purchase order header table, ekpo holds the items. learn all key fields, how to join them with ekbe for gr/ir status, and get a production-ready sql query.
sap sales order tables (vbak/vbap): order to delivery to billing flow
vbak is the sap sales order header, vbap holds line items. learn how to trace the complete order-to-cash flow through vbak → vbap → likp → lips → vbrk → vbrp.
sap stock tables: mard, mseg, mkpf and the s/4hana matdoc migration
mard holds current stock levels, mseg records every goods movement, mkpf is the document header. in sap s/4hana, mseg and mkpf are replaced by matdoc.